… better than I do, and this can be only checked by comparing performance with your own optimized settings and one database engine would… to most storage engines, it certainly can be applied for MyISAM and Innodb. I remember there were plans to implement such handler interface… see how this one will compare to transparent gzip page compression which is being implemented for Innodb right now. [-] Tablespace per database…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or RAID controller crashes and all data is lost… fast for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… multi versioning and row level locks so it is question of architecture implementation details of how it would compare to Innodb storage engine… time figuring out between MyISAM and Innodb and if they do they use some generic (and very wrong) ideas such as “MyISAM is always faster for…
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
…(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY(c) ) ENGINE=InnoDB PARTITION BY RANGE(id) ( PARTITION p100000 VALUES LESS THAN(100001… we go from 100 to 1000 partitions – about 4 times compared to only 1.5 times slow down for the same… partition and 250 for 1000 partitions – which is over 10x difference. Both MyISAM and Innodb are affected by this issue. The Update path for MyISAM…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… down compared to MySQL 5.5 default values. Such as performance_schema auto scales to count up to 445 tables and 224… which is good change as trying to create Innodb table but getting MyISAM because Innodb was disabled for some reason was very error… 5000. If you’re using innodb_thread_concurrency this will reduce overhead associated with grabbing and releasing innodb_thread_concurrency slot but will…
Comment: Testing MySQL column stores
August 16, 2010 By 15 Comments
The big question (at least for me) is how does these storage engines compare to MyISAM and InnoDB/ExtraDB performance and size wise?
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… rare MySQL bug and some pages in Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page… page in clustered key index is corrupted. It is worse compared to having data corrupted in secondary indexes, in which case… MyISAM table so all you have to do is to drop old table and convert new table back to Innodb after restarting without innodb…
Comment: Should you move from MyISAM to Innodb ?
March 9, 2012 By 59 Comments
… out on innodb though mainly because of row locking and no overhead as compare to MyIsam. I change 90% of my tables to innodb and currently going into queries and db optimization…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… all tables changed to Innodb and character set set to utf8? No. MySQL 5.5 continues to support MyISAM tables, so you can… also MyISAM tables are essentially at the state they were in MySQL 4.1 while Innodb storage engine got dramatic performance improvements and… packages (most typically used in production) which adds the difference compared to your production use. If resources allow I prefer to…
Comment: PBXT benchmarks
April 9, 2007 By 14 Comments
… re. speed of INSERTs to compare InnoDB, PBXT, MyISAM (and Archive and CSV). These were all single thread tests and I don’t dare to claim… slower than MyISAM, PBXT was in all cases relatively very close as compared to InnoDB. Also, whereas the difference between PBXT and MyISAM remained quite…
