…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 to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…database server will continue to function, however, because the file isn’t really deleted. The MySQL server keeps an open…connections all trying to open or close tables can indicate LOCK_open…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…connections for MySQL there will be ether not started state if there is no active Innodb transaction for this connection… size 262144 Free buffers 0 Database pages 258053 Modified db pages …shows innodb thread queue status – how many threads are waiting and being active. How many read views are open…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH…you can skip this step. 2) While holding connection open run: lvcreate -L16G -s -n dbbackup /dev/Main/…them – you just need to use SHOW SLAVE STATUS instead of SHOW MASTER STATUS to find out …
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… use it, you create a table (in any database you choose), like this: CREATE TABLE innodb_…contents of the Data dictionary to the mysql error log, which looks something like this: …SHOW PROCESSLIST connections stuck in ‘Opening Tables’ were waiting for the dict_sys->mutex, which is required for opening…
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: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…database. The first step is to find out what MySQL… | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk… mysql> show global variables like ‘%table_size%’; …openings in chess — the great chess players study openings…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
… the database we will see the following MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | …:11 [ERROR] Cannot find or open table test/test_innodb …MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: 5.1.30-community-log MySQL…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance resulting in very long execution times for even simplest queries, or a huge deadlock. In such rare cases SHOW… no longer open by any process). First be sure to run SHOW ENGINE InnoDB STATUS at least once. Then see what MySQL process…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
… Today I am going to show you how to take almost… honesty, and integrity, truth and openness. I believe in all of …as run by the native database interface (MySQL): mysql> select word, md5(word), md5…connected to my bus, and because I chose to create six hash “buckets” in the table. This allows MySQL…
