This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In … the buffer pool is cold. Please don’t take away that you should be using MyISAM for everything!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with. MyISAM does…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… for InnoDB, and in it we have random inserts into SECONDARY KEYS (k), which is not so good for InnoDB. So let’s see what results we have. The results are in TPS (more is better) and… = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… rows in the table for many decisions but this is computed live (maintained for MyISAM and estimated during query execution for Innodb). This basic information… what ? What really matters is not how accurate stats are but how good plans you’re getting for your queries. If you’re getting as good…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… storage engine so must use on disk MyISAM temporary table. What i decided to do is to see how much overhead do on… performing group by which is overhead we’re not looking to measure. This is actually good trick to use for cases when you do… this was too many details for you to read through here is the summary: key_buffer_size is important for MyISAM temporary tables performance to…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… view on using MyISAM in production. For me it is not only about table locks. Table locks is only one of MyISAM limitations you need… selects running. Fragmentation. This is common problem for pretty much all storage engines. It is however also different. MyISAM has in-row fragmentation which… sets or crashes. Here is my list what I think MyISAM tables are good to be used for. This list is not inclusive and every system…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring for all the above Philosophy on backups It is a good…myisam tables Built in compression Each table is dumped to a separate file. This is…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… big one is COUNT(*) without where clause which is often the show stopper for them move until it is worked around. Operations What is good for MyISAM kills Innodb, such as copying binary tables between the servers. It is important…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…for your Innodb tables but there are other things you need OS cache for – MyISAM… good estimates for this number. Eliminate Double Buffering – This is again very important for buffer…what is more important Innodb algorithms are finely tuned with consideration what is in memory and what is on disk, for…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
…What cache hit rate is good for optimal MySQL Performance” is typical question I’m asked. It could by MyISAM key_buffer or Innodb innodb_buffer… ratio 99% for what would be 0% in many peoples mind. But what is even more important is hit ratio is not directly relevant for performance. Take…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what…more sensitive to buffer size compared to MyISAM. MyISAM may work kind of OK with default…some memory but for modern hardware it is typically not the problem. 1024 is good value for applications with…
