Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

How to allow DPA to use performance_schema in MySQL

I'm trying to add a MySQL 5.6.8 database instance to DPA. The interface is advising me that DPA does not have access to the MySQL performance schema, but provides no clues as to how to correct this issue (see attached screen shot). I have confirmed that the performance schema is ON:

mysql> show variables like 'performance_schema';

+--------------------+-------+

| Variable_name | Value |

+--------------------+-------+

| performance_schema | ON |

+--------------------+-------+

1 row in set (0.00 sec)

mysql>

performance_schema_disallowed.png

Find more posts tagged with

mysql

Accepted answers

jaminsql

">slominskir

So after looking into this one and looking at the logs the MySQL Version here was 5.6.8 and DPA for MySQL was tested a GA to support 5.6.10 Our documentation may need to have this update as it only read 5.6. I sent this on the the Product managers.

All comments

mandevil

Can you submit a support ticket on this one? We'll be wanting logs to get the full error stack.

slominskir

Yup, already did: Case # 912091 (it was submitted under lead System Admin's name, Anthony)

slominskir

Here is what the setup_consumers table looks like in MySQL:

mysql> select * from setup_consumers;

+--------------------------------+---------+

| NAME | ENABLED |

+--------------------------------+---------+

| events_stages_current | NO |

| events_stages_history | NO |

| events_stages_history_long | NO |

| events_statements_current | YES |

| events_statements_history | NO |

| events_statements_history_long | YES |

| events_waits_current | NO |

| events_waits_history | NO |

| events_waits_history_long | NO |

| global_instrumentation | YES |

| thread_instrumentation | YES |

| statements_digest | YES |

+--------------------------------+---------+

12 rows in set (0.00 sec)

mysql>

I'm not very familiar with the performance_schema and it looks like there are tons of options in various tables. Do I need to enable some of these options? Maybe I need to add something to the my.cnf configuration file? Here is what my configuration file looks like:

[client]

socket=/var/lib/mysql/mysql.sock

[mysqld]

user=mysqladm

basedir=/app/mysqld/pro

datadir=/cs/mysql

socket=/var/lib/mysql/mysql.sock

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

max_allowed_packet = 16M

innodb_buffer_pool_size = 6G

innodb_flush_log_at_trx_commit = 2

innodb_log_buffer_size = 16M

innodb_log_file_size = 256M

innodb_locks_unsafe_for_binlog = 1

character-set-server = utf8

collation-server = utf8_unicode_ci

query-cache-type = 1

query-cache-size = 20M

server-id = 1

log-bin = mysql-bin

sync_binlog = 1

expire_logs_days = 7

binlog_format = mixed

slow_query_log = 1

tmp_table_size = 32M

max_heap_table_size = 32M

event_scheduler=ON

jaminsql

">slominskir

slominskir

I've upgraded to MySQL 5.6.28 and the issue with access to the performance schema appears to be resolved. However, the CPU information is still unavailable (as seen in the original screenshot represented as a gray circle). I suppose this should be a separate thread?