…Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_table_size…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL…innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign-key constraint checking or duplicate-key checking…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… INNODB is pretty useless. For my manually corrupted table I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table… skip exactly to recover as much data as possible. Row size can be good help to you. In this case we…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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 much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…Check out files (using Innodb File Per Table) -rw-rw—- 1 mysql mysql 8578 Dec 16 20:33 test_innodb.frm -rw-rw—- 1 mysql mysql…size for table with one row: mysql> show table status like “test_innodb” \G *************************** 1. row *************************** Name: test_innodb Engine: InnoDB…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… The 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…connections problems (the use of fixed-size connection pooling, for example, which can…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: InnoDB free: 6144 kB *************************** 2. row *************************** Name: cbool Engine: InnoDB…tables: mysql> show table…Innodb tables…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
…innodb-tables…check mysql> select count(*) from order_line; +———-+ | count(*) | +———-+ | 32093604 | +———-+ 1 row in set (3 min 29.32 sec) New table…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…table-size=5000000 –oltp-read-only=on –rand-init=on –num-threads=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql…tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables…
