…MySQL will allocate a lot of memory for table cache, especially if you’re using large blobs. It is easy to check though. Run “FLUSH TABLES…in set (0.00 sec) Innodb Memory Usage Finally it is often helpful to check how much memory Innodb has allocated. In…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in… limitations in cases such as range scans, where index parts after the part on which range condition is applied cannot be used…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…to other sessions. How to troubleshoot gap locks? Is possible to detect those gap locks using SHOW ENGINE INNODB…MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 localhost msandbox TABLE LOCK table…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…InnoDB Table Monitor The index information can also be taken directly from MySQL using the InnoDB…to remove the innodb_table_monitor. C) Check the size on disk of every indes This is very dependent of the table…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many people fail to…innodb_buffer_pool_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much more sensitive to buffer size compared to…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…to monitor in MySQL. Those are only suggestions; any given deployment might want to monitor only some of them, as appropriate, and might need to include others as well. Here’s how you can use our new monitoring plugins to check…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…in this example. Another hint – you may want to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not corrupted. So we looked at how to get your data back from simple Innodb Table…
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 7 Comments
…using InnoDB tables on MySQL version 5.1.22 or newer? If so, you probably have gaps in…to mimic the INSERT IGNORE behaviour without losing auto increment values. Let’s start! Why do we have gaps? InnoDB checks…TABLE to change the auto incremental column size…
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…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…MySQL Box and you’re only using Innodb tables you will want to give all memory you do not need for other needs for Innodb…size you need to check if there are any restrictions on Innodb Buffer Size you can use…
