… a user with SUPER will always be able to connect, and that may not accurately report what your application… there are plenty of other MySQL and OS-level status variables that you might want to keep an …number of long-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… the replication topology when using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is…. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the slave to the correct master with master_auto_position…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 35301 Connect_Retry…> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 18675 Connect_Retry…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the more general descriptors optimization in Percona Server showed fairly close results in our tests. In…Server Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1…_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…show_privilegesblogpercona.commanual Com_show_procedure_codeblogpercona.commanual Com_show_procedure_statusblogpercona.commanual Com_show_processlistblogpercona.commanual Com_show_profileblogpercona.commanual Com_show_profilesblogpercona.commanual Com_show…commanual connect_…innodb_status_…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… and now available in SHOW STATUS output. Most of them are same as you previously could find in SHOW INNODB STATUS, there are however… have large number of connections Innodb will only print number of them, cutting the list so SHOW INNODB STATUS output will not grow….05 non-hash searches/s This section shows insert buffer and adaptive hash status. First line shows status of insert buffer – segment size and…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
… try to connect again. Here is the SHOW SLAVE STATUS output after an error: mysql_slave > show slave status\G [...] Slave_IO_Running: Connecting Slave_SQL… 
What status variables do I have? The heartbeat check period time and the number of beats received. mysql_slave > SHOW STATUS LIKE ‘%heartbeat…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… application connects to the database using persistent connection technique to avoid creating new connections for every request so it just recycle old connections. The… those temporary files are not visible on the EXPLAIN or SHOW STATUS output. Therefore, the best solution is to monitor your system…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… states that we often hit the “max_connections” threshold (650) connections. Cpu is fine (about 100% of 400% …show_slave_hosts’, ’61′ ‘Com_show_slave_status‘, ’13834′ ‘Com_show_status‘, ’194766′ ‘Com_show_storage_engines’, ’0′ ‘Com_show_tables’, ’2842′ ‘Com_show_variables’, ’176825′ ‘Com_show…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…show status like ‘Open%tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_tables | 1 | +—————+——-+ 2 rows in set (0.00 sec) session10 > show…the MySQL server or causing all the connections to get depleted. There are some …
