… blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as… on another machine, instead of taking 12 cores away from MySQL and giving them to sysbench. That way we could test… done great work in the last couple of years making InnoDB scale and perform better on modern hardware.
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…slave. So you may want to: relax InnoDB durability (innodb_flush_log_at_trx_commit) disable binary … have a recommendation on when to use ENUM vs. CHAR? Especially for one character values? Let’…: Are these recommendations true of all versions of MySQL? If not which versions? The recommendations I …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) … / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb …
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… something obvious in MySQL settings as well as to let them know the fix is now out for Innodb scalability bug and… any difference. Recently Tweakers.net published comparison of MySQL 5.0.20a vs 5.0.32bk as well as matching PostgreSQL 8… Innodb scalability patch. 2) Speedup for 5.0.32 for large number of CPUs (2x quad line) is significant – 350 tps vs…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 9, 2007 By 117 Comments
…InnoDB vs. MyISAM vs. Falcon in MySQL MySQL Performance Blog — InnoDB vs MyISAM vs Falcon benchmarks. Great test and lots of figures and graphs. … InnoDB in read performance is a myth. InnoDB rules for now with low concurrency. Eagerly waiting for part II. Tagged in Linky, MySQL…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… other possibilities like InnoDB doing read_ahead by noticing the sequential access pattern. BKA is available in both MySQL 5.6 and…, and the only difference in query time is 48.78s vs 48.91s, so I don’t see Hash Join and… 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…: 38530 InnoDB_IO_r_bytes: 631275520 InnoDB_IO_r_wait: 0.204893 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages… min 8.92 sec) mysql> SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | Value | +——————————+——-+ | Innodb_scan_pages_contiguous | 45 | | Innodb_scan_pages_jumpy | 35904…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log…_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files… slightly lower, the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important metric for…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or RAID controller crashes… logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are… as painless as possible. Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we upload mydumper backups to s3…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
…. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous… It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does… another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it…
