{"id":3388,"date":"2021-10-05T00:50:33","date_gmt":"2021-10-05T00:50:33","guid":{"rendered":"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/"},"modified":"2021-11-15T21:44:50","modified_gmt":"2021-11-15T21:44:50","slug":"monitoring-mysql-database-performance-with-new-relic","status":"publish","type":"post","link":"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/","title":{"rendered":"Monitoring MySQL Database Performance with New Relic"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3388\" class=\"elementor elementor-3388\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-786f59a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default qodef-elementor-content-no\" data-id=\"786f59a8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4fb24bf3\" data-id=\"4fb24bf3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0e7d593 elementor-widget elementor-widget-text-editor\" data-id=\"0e7d593\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 25-04-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>MySQL is an open source relational database system that, like Linux, started its history as a personal side project. Over its 25 years of history,\u00a0<a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL<\/a>\u00a0has gained significant traction, and today a broad range of companies, such as\u00a0<a href=\"https:\/\/www.mysql.com\/customers\/view\/?id=642\" target=\"_blank\" rel=\"noopener noreferrer\">Sony<\/a>\u00a0and\u00a0<a href=\"https:\/\/www.mysql.com\/customers\/view\/?id=1269\" target=\"_blank\" rel=\"noopener noreferrer\">Uber<\/a>, use it to run their\u00a0<a href=\"https:\/\/eng.uber.com\/uber-big-data-platform\/\" target=\"_blank\" rel=\"noopener noreferrer\">multi-petabyte<\/a>\u00a0mission-critical databases.<\/p><p>In a way, MySQL has been a victim of its own success. It\u2019s easy enough to run that developers may take it for granted and assume it doesn\u2019t need supervision. In reality, MySQL is a complex system with a delicate balance you must monitor closely. It exposes a lot of useful metrics you can\u2019t afford to miss because they highlight where bottlenecks are, when it\u2019s time to upgrade, and what queries you should optimize.<\/p><p>Like most relational databases, MySQL organizes data using databases (also called\u00a0<em>schemas<\/em>) and tables. However, MySQL has a unique modular architecture that lets you choose the best low-level storage engine for the job. MySQL exposes its inner workings in all these levels through dozens of metrics.<\/p><p>MySQL is also extremely flexible. You can run it as a single instance, as a primary-secondary cluster, thank to replication, or in\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/mysql-cluster-replication-multi-master.html\" target=\"_blank\" rel=\"noopener noreferrer\">multi-master mode<\/a>. And third-party solutions like\u00a0<a href=\"https:\/\/vitess.io\/\" target=\"_blank\" rel=\"noopener noreferrer\">Vitess<\/a>\u00a0allow you to create horizontally-scaled clusters.<\/p><h3>Key MySQL Metrics to Monitor<\/h3><p>Let\u2019s start by reviewing some of the most important metrics to monitor in any MySQL instance. To view all available metrics, check out our\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/integrations\/host-integrations\/host-integrations-list\/mysql-monitoring-integration#metrics\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL integration docs<\/a>\u00a0(which we\u2019ll walk through setting up below).<\/p><h4 style=\"font-family: Sailec, sans-serif;\">Uptime<\/h4><p>It may sound self-evident, but many teams set alerts for server downtime while forgetting to monitor the MySQL process itself. When the database is down, you want to get notified immediately.<\/p><h4 style=\"font-family: Sailec, sans-serif;\">Connections<\/h4><p><a href=\"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/\">MySQL<\/a>\u00a0sets a hard limit on the number of simultaneous connections. When you reach it, new connections\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/too-many-connections.html\" target=\"_blank\" rel=\"noopener noreferrer\">are blocked<\/a>\u00a0until someone disconnects.<\/p><p>MySQL allows\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/server-system-variables.html#sysvar_max_connections\" target=\"_blank\" rel=\"noopener noreferrer\">151 connections<\/a>\u00a0by default. Changing the limit is simple:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cfd5fd7 elementor-widget elementor-widget-code-highlight\" data-id=\"cfd5fd7\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SET GLOBAL max_connections = 200;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f01a04b elementor-widget elementor-widget-text-editor\" data-id=\"f01a04b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Bear in mind that each connection needs at least 3MB, so always try to keep the number of connections as small as possible.<\/p><p>To determine the optimum number of connections to set, monitor three metrics:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\"><code>net.maxUsedConnections<\/code>: The maximum number of connections recorded since the database started. Use this value as a reference to set\u00a0<code>max_connections<\/code>.<\/li><li style=\"font-size: 16px;\"><code>net.threadsConnected<\/code>: The current number of active connections.<\/li><li style=\"font-size: 16px;\"><code>net.connectionErrorsMaxConnectionsPerSecond<\/code>: The number of connections failed per second due to the\u00a0<code>max_connections<\/code>\u00a0limit being reached. If the value is higher than zero, you need to either raise the limit, set up\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/connector-j\/8.0\/en\/connector-j-usagenotes-j2ee-concepts-connection-pooling.html\" target=\"_blank\" rel=\"noopener noreferrer\">connection pools<\/a>\u00a0for your applications, or consider installing a load balancer like\u00a0<a href=\"https:\/\/proxysql.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">ProxySQL<\/a>.<\/li><\/ul><p>Network issues and buggy clients can also affect MySQL connections. Watch\u00a0<code>net.abortedClientsPerSecond<\/code>\u00a0to detect applications not closing connections properly. A high rate usually indicates problems in the network.<\/p><h4 style=\"font-family: Sailec, sans-serif;\">Memory usage<\/h4><p><a href=\"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/\">Databases<\/a>\u00a0need a lot of memory to work well, so monitoring memory is vital to keep your MySQL in top shape.<\/p><p>First, set up monitoring for the\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/infrastructure\/manage-your-data\/data-instrumentation\/default-infrastructure-events\" target=\"_blank\" rel=\"noopener noreferrer\">server<\/a>\u00a0to ensure it has enough RAM:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\"><code>memoryFreeByes<\/code><\/li><li style=\"font-size: 16px;\"><code>memoryUsedBytes<\/code><\/li><li style=\"font-size: 16px;\"><code>memoryTotalByes<\/code><\/li><\/ul><p>Then, on the MySQL side, monitor these metrics:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\"><code>db.innodb.bufferPoolPagesTotal<\/code>: The number of pages in-memory holding data. You want this number to be as high as possible to reduce disk activity and increase performance.<\/li><li style=\"font-size: 16px;\"><code>db.innodb.bufferPoolReadsPerSecond<\/code>: The number of pages not found in-memory that need to be retrieved from disk. If the value is more than 5-15% of\u00a0<code>db.innodb.bufferPoolPagesTotal<\/code>, the database needs more memory. In that case, check the server RAM and increase the\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-buffer-pool-resize.html\" target=\"_blank\" rel=\"noopener noreferrer\"><code>db.innodb_buffer_pool_size<\/code><\/a>\u00a0setting on MySQL.<\/li><li style=\"font-size: 16px;\"><code>db.innodb.logWaitsPerSecond<\/code>: If this value is consistently high, it means that the\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-redo-log-buffer.html\" target=\"_blank\" rel=\"noopener noreferrer\">log buffer<\/a>\u00a0is set too low. In that case, increase\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-parameters.html#sysvar_innodb_log_buffer_size\" target=\"_blank\" rel=\"noopener noreferrer\"><code>innodb_log_buffer_size<\/code><\/a>\u00a0until the problem goes away.<\/li><\/ul><h4 style=\"font-family: Sailec, sans-serif;\">Storage speed<\/h4><p>After memory, disk I\/O speed is the most crucial factor for database performance. Even if the system has enough RAM to allocate the complete database, it\u2019ll still need disk I\/O to ensure transaction consistency.<\/p><p>The main database workload shapes disk activity. For Online Transaction Processing (OLTP) systems (e.g., systems used for online purchase processing), the following metrics should be smooth and steady. Peaks indicate possible bottlenecks and latency for your users. On the other hand, for Online Analytical Processing (OLAP) systems (e.g., systems used for budgeting and forecasting), uneven activity is a lot more common and should be expected.<\/p><p>To keep an eye on workload, monitor the following:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\"><code>db.innodb.dataReadsPerSecond<\/code>: The number of reads per second.<\/li><li style=\"font-size: 16px;\"><code>db.innodb.dataWritesPerSecond<\/code>: The number of writes per second.<\/li><li style=\"font-size: 16px;\"><code>db.innodb.osLogWrittenBytesPerSecond<\/code>: The transaction log throughput. This value is proportional to how much the data changes over time.<\/li><\/ul><h4 style=\"font-family: Sailec, sans-serif;\">Query speed<\/h4><p>Watch these metrics to monitor query speed and capture a baseline for your database:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\"><code>query.questionsPerSecond<\/code>: The number of queries sent by clients.<\/li><li style=\"font-size: 16px;\"><code>query.queriesPerSecond<\/code>: The total number of queries per second (QPS), including administrative commands and stored procedures. It measures the raw capacity of the database.<\/li><li style=\"font-size: 16px;\"><code>query.maxExecutionTimeExceededPerSecond<\/code>: The number of SELECT statements timed out per second. For OLTP workloads, you never want this value to exceed zero. If you find that your queries are timing out, optimize them.<\/li><\/ul><h3>Query optimization metrics<\/h3><p>Query optimization is where you can make the most significant impact on MySQL performance.<\/p><p>To identify long-running queries, activate the MySQL\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/slow-query-log.html\" target=\"_blank\" rel=\"noopener noreferrer\">slow query log<\/a>:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ced5f63 elementor-widget elementor-widget-code-highlight\" data-id=\"ced5f63\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SET GLOBAL slow_query_log = 1;\r\nSET GLOBAL slow_query_log_file = '\/var\/log\/mysql\/mysql-slow.log';<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ca00f9e elementor-widget elementor-widget-text-editor\" data-id=\"ca00f9e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Then set a reasonable query time to capture the worst-behaving queries on a first pass:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-34b4740 elementor-widget elementor-widget-code-highlight\" data-id=\"34b4740\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>\/\/ 3 seconds threshold\r\nSET GLOBAL long_query_time = 3;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-948b546 elementor-widget elementor-widget-text-editor\" data-id=\"948b546\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre style=\"font-size: 16px;\"><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); font-size: 1rem;\">As performance improves, you can reduce the query time and repeat the process.<\/span><\/pre><p>Once the feature is active, monitor\u00a0<code>query.slowQueriesPerSecond<\/code>, analyze the log, and use an\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/using-explain.html\" target=\"_blank\" rel=\"noopener noreferrer\"><code>EXPLAIN<\/code><\/a>\u00a0statement to find which queries do worse. Depending on the case, you may need to rewrite them, add or modify indexes, or restructure your tables.<\/p><p>Here are some additional metrics to monitor while optimizing queries.<\/p><h4 style=\"font-family: Sailec, sans-serif;\">Temporary Files and Tables<\/h4><p>MySQL creates temporary files and tables on disk for operations such as\u00a0<code>GROUP BY<\/code>,\u00a0<code>ORDER BY<\/code>, or\u00a0<code>UNION<\/code>\u00a0that don\u2019t fit in-memory. Since these can cause excessive disk I\/O, keep a close watch on these metrics:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\"><code>db.createdTmpDiskTablesPerSecond<\/code>\u00a0measures tables.<\/li><li style=\"font-size: 16px;\"><code>db.createdTmpFilesPerSecond<\/code>\u00a0measures temporary files.<\/li><\/ul><p>While it\u2019s not always possible to reduce these values to zero, you can minimize temporary disk activity by adjusting\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/server-system-variables.html#sysvar_sort_buffer_size\" target=\"_blank\" rel=\"noopener noreferrer\"><code>sort_buffer_size<\/code><\/a>\u00a0and\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/server-system-variables.html#sysvar_join_buffer_size\" target=\"_blank\" rel=\"noopener noreferrer\"><code>join_buffer_size<\/code><\/a>, and rewriting queries.<\/p><h4 style=\"font-family: Sailec, sans-serif;\">Locks<\/h4><p>MySQL uses table- and row-level locks to ensure data consistency. Poorly written queries and some administrative tasks can lead to long-running locks that block other clients. The main metrics for lock activity are\u00a0<code>db.tablesLocksWaitedPerSecond<\/code>\u00a0for tables, and\u00a0<code>db.innodb.rowLockTimeAvg<\/code>\u00a0and\u00a0<code>db.innodb.rowLockWaitsPerSecond<\/code>\u00a0for rows.<\/p><h4 style=\"font-family: Sailec, sans-serif;\">Missing indexes<\/h4><p>MySQL uses indexes for filtering, sorting, and joining tables. When queries and table structures don\u2019t line up, MySQL is forced to scan the whole table. This situation uses up a lot of extra memory and causes heavy disk I\/O.<\/p><p>Monitor these metrics for details:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\"><code>db.selectFullJoinPerSecond<\/code>\u00a0and\u00a0<code>db.selectFullJoinRangePerSecond<\/code>\u00a0indicate whether your tables need additional indexes.<\/li><li style=\"font-size: 16px;\"><code>db.innodb.bufferPoolReadAheadRndPerSecond<\/code>\u00a0helps detect inefficient table-level reads.<\/li><\/ul><h3>Monitoring MySQL with New Relic<\/h3><p>Our\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/integrations\/host-integrations\/host-integrations-list\/mysql-monitoring-integration\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL integration<\/a>\u00a0uses the New Relic\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/infrastructure\/install-infrastructure-agent\/get-started\/install-infrastructure-agent-new-relic\" target=\"_blank\" rel=\"noopener noreferrer\">Infrastructure agent<\/a>\u00a0to collect and send performance metrics from your MySQL database to our platform. You can see your database server\u2019s health and analyze metric data so that you can easily find the source of any problems<\/p><p>The integration is compatible with MySQL version 5.6 or higher.<\/p><p>In the following example, we\u2019ll show you how to set up Infrastructure Monitoring for an Ubuntu server running MySQL. If you have a different host OS, check the\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/infrastructure\/install-configure-manage-infrastructure\" target=\"_blank\" rel=\"noopener noreferrer\">agent documentation<\/a>\u00a0for alternative instructions.<\/p><p><span style=\"font-weight: bolder;\"><em>Note:<\/em><\/span><em>\u00a0You can also monitor MySQL as a service running in\u00a0<\/em><a href=\"https:\/\/docs.newrelic.com\/docs\/integrations\/kubernetes-integration\/link-apps-services\/monitor-services-running-kubernetes\" target=\"_blank\" rel=\"noopener noreferrer\"><em>Kubernetes<\/em><\/a><em>\u00a0or\u00a0<\/em><a href=\"https:\/\/docs.newrelic.com\/docs\/integrations\/host-integrations\/host-integrations-list\/monitor-services-running-amazon-ecs\" target=\"_blank\" rel=\"noopener noreferrer\"><em>ECS<\/em><\/a><em>.<\/em><\/p><h4 style=\"font-family: Sailec, sans-serif;\">Install the agent and integration on an Ubuntu server<\/h4><ol style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\">From\u00a0<a href=\"http:\/\/one.newrelic.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">New Relic One<\/a>, navigate to your account drop-down (in the top-right corner) and select\u00a0<span style=\"font-weight: bolder;\">Add more data<\/span>.<\/li><li style=\"font-size: 16px;\">Select your operating system (in this case Ubuntu), and follow the prompts to get your license key and select your Ubuntu version.<\/li><li style=\"font-size: 16px;\">To deploy the Infrastructure agent and the MySQL integration, run the following commands on your server:<ul style=\"font-size: 16px;\"><li style=\"font-size: 16px;\">Import Infrastructure agent GPG Key.<pre>curl -s https:\/\/download.newrelic.com\/infrastructure_agent\/gpg\/newrelic-infra.gpg <span style=\"font-weight: bolder;\">|<\/span> sudo apt-key add -<\/pre><\/li><li style=\"font-size: 16px;\">Add the New Relic repository (view all distributions\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/infrastructure\/install-configure-manage-infrastructure\/linux-installation\/install-infrastructure-linux-using-package-manager\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>).<pre>printf \"deb [arch=amd64] https:\/\/download.newrelic.com\/infrastructure_agent\/linux\/apt bionic main\" <span style=\"font-weight: bolder;\">|<\/span> sudo tee -a \/etc\/apt\/sources.list.d\/newrelic-infra.list<\/pre><\/li><li style=\"font-size: 16px;\">Install the infrastructure agent (<code>newrelic-infra<\/code>) and MySQL integration (<code>nri-mysql<\/code>).<pre>sudo apt-get update <span style=\"font-weight: bolder;\">&amp;&amp;<\/span> sudo apt-get install -y newrelic-infra nri-mysql<\/pre><\/li><\/ul><\/li><\/ol><h4 style=\"font-family: Sailec, sans-serif;\">Configure the MySQL integration<\/h4><ol style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\">Add a monitoring user in MySQL.<pre>mysql -e \"CREATE USER 'newrelic'@'localhost' IDENTIFIED BY 'MONITOR_USER_PASSWORD';\"\nmysql -e \"GRANT REPLICATION CLIENT ON *.* TO 'newrelic'@'localhost';\"<\/pre><\/li><li style=\"font-size: 16px;\">Configure the MySQL integration.<pre>cd \/etc\/newrelic-infra\/integrations.d\nsudo cp mysql-config.yml.sample mysql-config.yml\nsudo nano mysql-config.yml<\/pre><\/li><li style=\"font-size: 16px;\">Fill in the password.hostname:<pre>hostname: localhost\nport<span style=\"font-weight: bolder;\">:<\/span> 3306\nusername<span style=\"font-weight: bolder;\">:<\/span> newrelic\npassword<span style=\"font-weight: bolder;\">:<\/span> MONITOR_USER_PASSWORD<\/pre><\/li><li style=\"font-size: 16px;\">Set\u00a0<code>remote_monitoring<\/code>\u00a0to\u00a0<code>true<\/code>.<\/li><li style=\"font-size: 16px;\">Capture\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/integrations\/host-integrations\/host-integrations-list\/mysql-monitoring-integration#extended\" target=\"_blank\" rel=\"noopener noreferrer\"><code>extended_metrics<\/code><\/a>\u00a0and\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/integrations\/host-integrations\/host-integrations-list\/mysql-monitoring-integration#extended_innodb\" target=\"_blank\" rel=\"noopener noreferrer\"><code>extended_innodb_metrics<\/code><\/a>.<pre>extended_metrics<span style=\"font-weight: bolder;\">:<\/span> 1\nextended_innodb_metrics<span style=\"font-weight: bolder;\">:<\/span> 1<\/pre><\/li><li style=\"font-size: 16px;\">If you have MyISAM tables, also set\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/integrations\/host-integrations\/host-integrations-list\/mysql-monitoring-integration#extended_myisam\" target=\"_blank\" rel=\"noopener noreferrer\"><code>extended_myisam_metrics<\/code><\/a>:<pre>extended_myisam_metrics: 1<\/pre><\/li><li style=\"font-size: 16px;\">Restart the infrastructure agent to complete the setup.systemctl restart newrelic-infra<\/li><\/ol><p>A full list of configuration options is available in our\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/integrations\/host-integrations\/host-integrations-list\/mysql-monitoring-integration#config\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL integration documentation<\/a>.<\/p><h4 style=\"font-family: Sailec, sans-serif;\">View MySQL data in New Relic<\/h4><p>From New Relic One, navigate to\u00a0<a href=\"https:\/\/infrastructure.newrelic.com\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"font-weight: bolder;\">Infrastructure<\/span><\/a>\u00a0to see the incoming data about your servers.<\/p><p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-4213\" src=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql1.png\" alt=\"\" width=\"936\" height=\"272\" srcset=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql1.png 936w, https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql1-300x87.png 300w, https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql1-768x223.png 768w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/p><p>To start monitoring your MySQL databases, navigate to\u00a0<span style=\"font-weight: bolder;\">Infrastructure &gt;<\/span>\u00a0<span style=\"font-weight: bolder;\">Third-party Services &gt; MySQL Dashboard<\/span>.<\/p><p>Here are a few example charts created based on our integration\u2019s configuration:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\">A QPS graph measures the raw efficiency of your database<br \/><img decoding=\"async\" class=\"alignnone size-full wp-image-4214\" src=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql2.png\" alt=\"\" width=\"598\" height=\"302\" srcset=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql2.png 598w, https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql2-300x152.png 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/li><li style=\"font-size: 16px;\">The Slow Queries chart lets you know when it\u2019s time to optimize your database<br \/><img decoding=\"async\" class=\"alignnone size-full wp-image-4215\" src=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql3.png\" alt=\"\" width=\"638\" height=\"305\" srcset=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql3.png 638w, https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql3-300x143.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/li><li style=\"font-size: 16px;\">Use the Max Connections graph to fine tune\u00a0<code>max_connections<\/code><br \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4216\" src=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql4.png\" alt=\"\" width=\"628\" height=\"301\" srcset=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql4.png 628w, https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql4-300x144.png 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/li><li style=\"font-size: 16px;\">Use the I\/O activity for the network and disk to find bottlenecks in your system<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4217\" src=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql5.png\" alt=\"\" width=\"628\" height=\"306\" srcset=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql5.png 628w, https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql5-300x146.png 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><br \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4218\" src=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql6.png\" alt=\"\" width=\"630\" height=\"306\" srcset=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql6.png 630w, https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/mysql6-300x146.png 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/li><\/ul><p>To create more advanced charts and custom dashboards, check out\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/query-your-data\/explore-query-data\/data-explorer\/introduction-data-explorer\" target=\"_blank\" rel=\"noopener noreferrer\">the data explorer<\/a>.<\/p><h3>From integration to observability<\/h3><p>If data is the application\u2019s lifeblood, then the database is its heart. Reliable database performance is vital in any business. By monitoring a few key metrics, you can better understand how your MySQL servers are functioning.<\/p><p>The MySQL integration is open source software. That means you can\u00a0<a href=\"https:\/\/github.com\/newrelic\/nri-mysql\" target=\"_blank\" rel=\"noopener noreferrer\">browse its source code<\/a>\u00a0and\u00a0<a href=\"https:\/\/github.com\/newrelic\/nri-mysql\/blob\/master\/CONTRIBUTING.md\" target=\"_blank\" rel=\"noopener noreferrer\">send improvements<\/a>, or create your own fork and build it.<\/p><p>Make our MySQL integration an essential part of your observability stack.<\/p><p>Check out our\u00a0<a href=\"https:\/\/docs.newrelic.com\/docs\/integrations\/host-integrations\/host-integrations-list\" target=\"_blank\" rel=\"noopener noreferrer\">full list of on-host integrations<\/a>\u00a0for more.<\/p><p><em>This article was originally published on\u00a0<a href=\"https:\/\/blog.newrelic.com\/engineering\/how-to-monitor-mysql\/\">New Relic&#8217;s blog<\/a><\/em>.<br \/><em><span class=\"TextRun SCXW156001673 BCX2\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW156001673 BCX2\"><br \/>If you\u2019re interested in developing expert technical content that performs,\u00a0<\/span><\/span><a class=\"Hyperlink SCXW156001673 BCX2\" href=\"https:\/\/contentlab.com\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined SCXW156001673 BCX2\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW156001673 BCX2\" data-ccp-charstyle=\"Hyperlink\">let\u2019s have a conversation<\/span><\/span><\/a><span class=\"TextRun SCXW156001673 BCX2\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW156001673 BCX2\">\u00a0today.<\/span><\/span><\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>MySQL is an open source relational database system that, like Linux, started its history as a personal side project. Over its 25 years of history,\u00a0MySQL\u00a0has gained significant traction, and today a broad range of companies, such as\u00a0Sony\u00a0and\u00a0Uber, use it to run their\u00a0multi-petabyte\u00a0mission-critical databases. In a way, MySQL has been a victim of its own success. [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":4855,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[276,278,18],"tags":[286],"hashtags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Monitoring MySQL Database Performance with New Relic &#183; Technical Content Marketing | ContentLab<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Monitoring MySQL Database Performance with New Relic &#183; Technical Content Marketing | ContentLab\" \/>\n<meta property=\"og:description\" content=\"MySQL is an open source relational database system that, like Linux, started its history as a personal side project. Over its 25 years of history,\u00a0MySQL\u00a0has gained significant traction, and today a broad range of companies, such as\u00a0Sony\u00a0and\u00a0Uber, use it to run their\u00a0multi-petabyte\u00a0mission-critical databases. In a way, MySQL has been a victim of its own success. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql\" \/>\n<meta property=\"og:site_name\" content=\"Technical Content Marketing | ContentLab\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-05T00:50:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-15T21:44:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1746\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"ContentLab\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ContentLabIO\" \/>\n<meta name=\"twitter:site\" content=\"@ContentLabIO\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ContentLab\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#article\",\"isPartOf\":{\"@id\":\"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/\"},\"author\":{\"name\":\"ContentLab\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532\"},\"headline\":\"Monitoring MySQL Database Performance with New Relic\",\"datePublished\":\"2021-10-05T00:50:33+00:00\",\"dateModified\":\"2021-11-15T21:44:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/\"},\"wordCount\":1530,\"publisher\":{\"@id\":\"https:\/\/contentlab.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png\",\"keywords\":[\"MySQL\"],\"articleSection\":[\"Databases\",\"Hands-on Tutorial\",\"Portfolio\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/\",\"url\":\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql\",\"name\":\"Monitoring MySQL Database Performance with New Relic &#183; Technical Content Marketing | ContentLab\",\"isPartOf\":{\"@id\":\"https:\/\/contentlab.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#primaryimage\"},\"image\":{\"@id\":\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png\",\"datePublished\":\"2021-10-05T00:50:33+00:00\",\"dateModified\":\"2021-11-15T21:44:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#primaryimage\",\"url\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png\",\"contentUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png\",\"width\":1746,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/contentlab.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Monitoring MySQL Database Performance with New Relic\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/contentlab.com\/#website\",\"url\":\"https:\/\/contentlab.com\/\",\"name\":\"Technical Content Marketing | ContentLab\",\"description\":\"Technical Content Marketing Done Right.\",\"publisher\":{\"@id\":\"https:\/\/contentlab.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/contentlab.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/contentlab.com\/#organization\",\"name\":\"ContentLab.io\",\"url\":\"https:\/\/contentlab.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png\",\"contentUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png\",\"width\":768,\"height\":768,\"caption\":\"ContentLab.io\"},\"image\":{\"@id\":\"https:\/\/contentlab.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/ContentLabIO\",\"https:\/\/www.linkedin.com\/company\/17893315\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532\",\"name\":\"ContentLab\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g\",\"caption\":\"ContentLab\"},\"description\":\"ContentLab provides high-quality written articles, tutorials, courses, and other technical marketing materials to industry leaders. We create no-nonsense tech content that\u2019s purpose-built to attract, educate, and engage your technical audience.\",\"sameAs\":[\"https:\/\/contentlab.op\"],\"url\":\"https:\/\/contentlab.com\/author\/contentlab\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Monitoring MySQL Database Performance with New Relic &#183; Technical Content Marketing | ContentLab","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql","og_locale":"en_US","og_type":"article","og_title":"Monitoring MySQL Database Performance with New Relic &#183; Technical Content Marketing | ContentLab","og_description":"MySQL is an open source relational database system that, like Linux, started its history as a personal side project. Over its 25 years of history,\u00a0MySQL\u00a0has gained significant traction, and today a broad range of companies, such as\u00a0Sony\u00a0and\u00a0Uber, use it to run their\u00a0multi-petabyte\u00a0mission-critical databases. In a way, MySQL has been a victim of its own success. [&hellip;]","og_url":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql","og_site_name":"Technical Content Marketing | ContentLab","article_published_time":"2021-10-05T00:50:33+00:00","article_modified_time":"2021-11-15T21:44:50+00:00","og_image":[{"width":1746,"height":530,"url":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png","type":"image\/png"}],"author":"ContentLab","twitter_card":"summary_large_image","twitter_creator":"@ContentLabIO","twitter_site":"@ContentLabIO","twitter_misc":{"Written by":"ContentLab","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#article","isPartOf":{"@id":"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/"},"author":{"name":"ContentLab","@id":"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532"},"headline":"Monitoring MySQL Database Performance with New Relic","datePublished":"2021-10-05T00:50:33+00:00","dateModified":"2021-11-15T21:44:50+00:00","mainEntityOfPage":{"@id":"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/"},"wordCount":1530,"publisher":{"@id":"https:\/\/contentlab.com\/#organization"},"image":{"@id":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#primaryimage"},"thumbnailUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png","keywords":["MySQL"],"articleSection":["Databases","Hands-on Tutorial","Portfolio"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/contentlab.com\/monitoring-mysql-database-performance-with-new-relic\/","url":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql","name":"Monitoring MySQL Database Performance with New Relic &#183; Technical Content Marketing | ContentLab","isPartOf":{"@id":"https:\/\/contentlab.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#primaryimage"},"image":{"@id":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#primaryimage"},"thumbnailUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png","datePublished":"2021-10-05T00:50:33+00:00","dateModified":"2021-11-15T21:44:50+00:00","breadcrumb":{"@id":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#primaryimage","url":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png","contentUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png","width":1746,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/newrelic.com\/blog\/how-to-relic\/how-to-monitor-mysql#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/contentlab.com\/"},{"@type":"ListItem","position":2,"name":"Monitoring MySQL Database Performance with New Relic"}]},{"@type":"WebSite","@id":"https:\/\/contentlab.com\/#website","url":"https:\/\/contentlab.com\/","name":"Technical Content Marketing | ContentLab","description":"Technical Content Marketing Done Right.","publisher":{"@id":"https:\/\/contentlab.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/contentlab.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/contentlab.com\/#organization","name":"ContentLab.io","url":"https:\/\/contentlab.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/contentlab.com\/#\/schema\/logo\/image\/","url":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png","contentUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png","width":768,"height":768,"caption":"ContentLab.io"},"image":{"@id":"https:\/\/contentlab.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/ContentLabIO","https:\/\/www.linkedin.com\/company\/17893315\/"]},{"@type":"Person","@id":"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532","name":"ContentLab","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/contentlab.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g","caption":"ContentLab"},"description":"ContentLab provides high-quality written articles, tutorials, courses, and other technical marketing materials to industry leaders. We create no-nonsense tech content that\u2019s purpose-built to attract, educate, and engage your technical audience.","sameAs":["https:\/\/contentlab.op"],"url":"https:\/\/contentlab.com\/author\/contentlab\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/10\/portfoliofeature47df.png","_links":{"self":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts\/3388"}],"collection":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/comments?post=3388"}],"version-history":[{"count":6,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts\/3388\/revisions"}],"predecessor-version":[{"id":5327,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts\/3388\/revisions\/5327"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/media\/4855"}],"wp:attachment":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/media?parent=3388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/categories?post=3388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/tags?post=3388"},{"taxonomy":"hashtags","embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/hashtags?post=3388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}