…MyISAM than InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB performs…InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… wanted to compare InnoDB performance vs TokuDB. I …on this dataset. We can easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance on…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…vs. FlashCache – dirty page threshold Finally, we examine the impact of a couple of different dirty-page ratios on device performance…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… value and having value mapping done on application level. So, first of all… It is also interesting to note performance of Innodb tables in this case: for…MyISAM. This is great example of the case when Innodb is much faster than MyISAM …in the alphabetical order and do sort by state_id, though join …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…INNODB_STATS_ON_METADATA | ON | OFF | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10 | 5 | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | 10000 | 100 | | PERFORMANCE…Innodb table but getting MyISAM because Innodb…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… on top of that and the performance …innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam… — 909 iops unaligned -vs- 1049 aligned. …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… available when some sort of data loss or…server so you can perform point in time recovery… myisam and innodb tables. Global read lock only held until myisam…vs compressed xtrabackup Typically we upload mydumper backups to s3 vs xtrabackup given the time needed to upload/download. Though it depends on…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…on each benchmark (I noticed 100 rows on SQL and 20 on Sphinx). Also Sphinx does the relevance sorting by default, adding relevance sorting…InnoDB FT index, I made sure to increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM…performed on…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
… lookup the data on any its prefix and traversing ranges between values in sorted order. For … can be primary key value (for Innodb tables) physical file offset (for MyISAM tables) or something else. … clause. Index merge does helps performance but it is far from performance of combined index in this…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…performs in tpcc-mysql workload from both performance…innodb_buffer_pool_instances=8 makes a big difference on small buffer_pool sizes, while on bigger buffer_pool, innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
