…MySQL…show_open_tablesblogpercona.commanual Com_show_pluginsblogpercona.commanual Com_show_privilegesblogpercona.commanual Com_show_procedure_codeblogpercona.commanual Com_show_procedure_statusblogpercona.commanual Com_show_processlistblogpercona.commanual Com_show…commanual connect_timeoutblogpercona…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use… in mysql> show global variables like ‘%table_size%’; +———————+———–+ |…openings in chess — the great chess players study openings…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…connections all trying to open or close tables can indicate LOCK_open…mysql-status plugin can be configured to alert when Threads_connected approaches max_connections…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…long-running transaction. If a transaction remains open for a very long time without …port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date…your server to find idle-in-transaction connections that are just sitting there doing nothing…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…. If we look at the gain system shows from performance at 1 thread to the …p cur_open_with_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,…mysql_select,handle_select,execu te_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_connection…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… dumps the contents of the Data dictionary to the mysql error log, which looks something like this: =========================================== 090420 12:… and the SHOW PROCESSLIST connections stuck in ‘Opening Tables’ were waiting for the dict_sys->mutex, which is required for opening tables in …
Post: Rare evil MySQL Bug
November 20, 2009 By 7 Comments
… on the case you may be able to connect to MySQL through Unix Socket or TCP/IP or neither… so we had to restart MySQL quickly currently I have a test MySQL showing some behavior. Here is what … high socket number – probably because of large innodb_open_files I tested with in this case – which …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…show_open_tables’, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave_status’, ’13834′ ‘Com_show_status’, ’194766′ ‘Com_show…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… you have large number of connections Innodb will only print number of them, cutting the list so SHOW INNODB STATUS output will… each of connections for MySQL there will be ether not started state if there is no active Innodb transaction for this connection, or…. It shows innodb thread queue status – how many threads are waiting and being active. How many read views are open inside Innodb…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
…MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue | | test_innodb | +—————-+ 2 rows in set (0.00 sec) mysql> show…
