5 Replies Latest reply on Jan 4, 2016 1:14 PM by slominskir

    How to allow DPA to use performance_schema in MySQL

    slominskir

      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>

        • Re: How to allow DPA to use performance_schema in MySQL
          mandevil

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

            • Re: How to allow DPA to use performance_schema in MySQL
              slominskir

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

                • Re: How to allow DPA to use performance_schema in MySQL
                  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