… them from the OS cache, which is another advantage of InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is… MyISAM than InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB…_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary … is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue can…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage… the fix for the upstream bug #65077 from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a… drive, instead of crashing InnoDB, it will be caught by ZFS and the data will be read from the other drive in… disk usage On purpose, I allocated mirror pairs using drives from different controllers. That way, if a controller dies, the storage…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… 4? Two of those NICs should be directly connected from one machine to another and configured with Linux …quite like that in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with …-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… MISLEADING. So we see that InnoDB performance steadily declines from 24000 tps to 18000 tps, but InnoDB can’t make 5h run. After 3h the disk is full, and InnoDB data…_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… I am using wordpress and drupal, and i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…=none innodb_max_dirty_pages_pct = 60 And then finally, a fourth test (configuration D) which combined the parameter changes from tests…: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method…_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… the cluster. Also, at the time of this writing, from async stream, MyISAM is not being replicated at all which I reported… PXC, wsrep_replicate_myisam allows you to do so. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM nowadays i.e. if you…
Comment: Should you move from MyISAM to Innodb ?
March 27, 2013 By 59 Comments
… and awakened. I can confirm that my ‘choice’ in using MyISAM was because it was the default MySQL engine. So far… need a good DBA to help me past MyISAM. Along with MySQL’s InnoDB, I also have PostgreSQL on my radar for future more critical web applications. I’ll be following mysqlperformanceblog.com from…
