…30 top mutex is &doublewrite->mutex: trx0sys….max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…schema_max_cond_instancesblogpercona.commanual performance_schema_max_file_classesblogpercona.commanual performance_schema_max_file_handlesblogpercona.commanual performance_schema_max_file_instancesblogpercona.commanual performance_schema_max_mutex_classesblogpercona.commanual performance_schema_max…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 | | PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES | 1000000 | 3282 | | OLD_PASSWORDS | OFF | 0 | | INNODB_STATS_ON_METADATA | ON | OFF | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10 | 5 | | PERFORMANCE_SCHEMA…
