…innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… see a pretty extensive list of suggestions for what to monitor in MySQL. Those are only… pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as…-table-checksum tool from Percona Toolkit can generate table checksums, and the pmp-check-pt-table-…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… database at all (use mysql -A in this case, to prevent it from getting field list from all tables) Reads though would not… no MYISAM like table lock priority problem with pending WRITE query blocks any READ queries to execute on the table. mysql> show processlist…’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
So you’re running MySQL With innodb_file_per_table option but your ibdata1 file which holds main (or system) … undo tablespace for 2 reasons. First it is re History list length 4000567 In this case the History Length is about…’re running Percona Server the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_size | page_no…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…/06/when-does-innodb-update-table-statistics-and… ANALYZE TABLE: mysql> analyze table t; +——–+———+———-+———-+ | Table | Op | Msg_type | Msg_text | …tables“, “Waiting for table” and “Waiting for table flush”. Conclusion Before running an ANALYZE table or any other command listed…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… (`TABLE_ID`,`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Please note field SPACE. For table actor it is equal to 15: mysql> select * from `INNODB_SYS_TABLES…_PAGE_UNDO_LOG, FIL_PAGE_INODE, FIL_PAGE_IBUF_FREE_LIST FIL_PAGE_FILE_FLUSH_LSN 8 “the file has been… from sakila database taken from some MySQL server. 0. Create empty InnoDB tablespace. 1. Create the table: mysql>CREATE TABLE actor ( actor_id SMALLINT UNSIGNED…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…–mysql…tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables…list_mutex’ Apparently using compressed tables we have very strong contention in LRU_list_mutex. I should check how compressed tables…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… INSERT BUFFER AND ADAPTIVE HASH INDEX ————————————- Ibuf: size 1, free list len 398, seg size 400, Another thread writing in…lib/mysql# And restart MySQL: root@localhost:/var/lib/mysql# /etc/init.d/mysql restart After the restart all InnoDB tables are reachable: mysql> select…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… software was not available for MySQL. Change Data Capture can be used to: Monitor a database table, or tables for changes. Improve ETL…: mysql> create table > test.demo ( > c1 int auto_increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql… with FlexCDC called ‘add_table.php’. This script automates the process of adding a table to the list of tables to changelog. It does…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…the outline of improvements available in MySQL 5.6 which I thought …of areas. I’m sure the list is not complete so If …Tables – - INNODB_METRICS – - Meta Data Information Tables – - Buffer Pool Information Tables – Improved PERFORMANCE_SCHEMA – - Reduced Overhead – - Simplified Configuration – - Table…
