…This bug was introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL. Bug fixed #915814 …). A crash could leave behind an InnoDB temporary table with temporary indexes resulting in an unbootable server. Bug… LRU list, we could end up with a partially written dump file in case of a crash,…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… MySQL behavior due to this) – it will be corrupted by unproper shutdown, it will fail with partial statement… billions of rows in tens of thousands tables) Innodb was better choice mainly because of thouse other … Lack of row cache. MyISAM tables only have indexes cached in key_buffer while data is …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… with you on this completely because InnoDB uses a clustered index based on (in order) …traditional database background. > Things are different with MySQL. Good design will help dictate how …> we’re here to help. Partial agreement: “Use Indexes smartly.” Indexing columns that have very low cardinality…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…mysql-patch/mytools What makes fractal indexes so interesting is the amount of IO operations to update index… is only partially the problem of storage engine. The biggest problem is that MySQL does not … mysqld binary does not contain InnoDB. Tokutek tells me that InnoDB will be included in a future…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… bound or CPU bound, while to understand if MySQL goes through more rows than it needs to …need to fetch clustered index page at least to do it. These reads are issues by Innodb one by one … disk which has the data (even keeping aside partial “border” IO request which will require reading both drives…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
…MySQL official marketing never position MySQL as such per say (for obvious reasons) but it is indeed set as replacement for Innodb…and not being able to use covering indexes means there is no way to get… and speed, including rare cases such as partial page writes etc. This is where knowledge…
Post: Small things are better
October 8, 2006 By 15 Comments
… happen with Innodb tables. They are designed to never crash, surviving power failures and even partial page writes but still they can get corrupted because of MySQL bugs, OS …will be much faster this way as whole indexes will well fit in memory for such small…
