…INNODB_OPEN_FILES | 300 | 2000 | | INNODB_DATA_FILE_PATH | ibdata1:10M:autoextend | ibdata1:12M:autoextend | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE… 5000 by default now vs 1024. innodb_auto_extend_increment is …trying to create Innodb table but getting MyISAM because Innodb was disabled …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… off your primary server so you can perform point in time recovery. Store your …mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped….possible. Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we upload …
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
… partitions 52, 100 partitions 72, 1000 partitions 290 seconds. The performance loss with large number of partitions is about 6 times…. Both MyISAM and Innodb are affected by this issue. The Update path for MyISAM without indexes took 10 seconds for 1 partition vs 52… for future use may cost you. From this benchmarks the performance remains reasonable with about 100 partitions (which is reasonable number…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
December 22, 2007 By 117 Comments
[...] InnoDB vs MyISAM vs Falcon benchmarks – part 1 Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. [...]
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… got to pick either long recovery time or further degraded performance. In the large databases I run in production relaying on… storage engines you’re using – DRBD does not work with MyISAM (check required) so you need to have processes to ensure…. First – hot vs cold. If you’re using decent hardware and care about performance you use O_DIRECT with Innodb which makes it…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
November 7, 2007 By 117 Comments
…, I measured the performance of InnoDB vs MyISAM for insertion queries for up to 100 threads (see presentation “Measuring MySQL Server Performance for the Sensor… (less than 200 bytes) MyISAM outpreforms InnoDB for insertion speed. For the recird sizes between 1KB and 10MB MyISAM is about twice faster.
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
September 11, 2009 By 117 Comments
[...] InnoDB vs MyISAM vs Falcon benchmarks – part 1 | MySQL Performance Blog (tags: performance innodb falcon mysql scalability) [...]
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
… pointer” which can be primary key value (for Innodb tables) physical file offset (for MyISAM tables) or something else. It is important… 50 times more rows are scanned. This reflects very large performance difference between full table scan and access through the index… columns in where clause. Index merge does helps performance but it is far from performance of combined index in this case. In…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… InnoDB. Performance vs. MySQL was horrible, even after tuning. SELECT performance is crucial and it just did not hold up. Management of the massive InnoDB binary file was daunting unlike MyISAM which…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as… use Mat Keep’s data for this. The modeling I performed is Universal Scalability Law modeling, which can predict both software… done great work in the last couple of years making InnoDB scale and perform better on modern hardware.
