… MyISAM than InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB… to work with. MyISAM does not maintain checksum consistency during regular operations and is not ACID compliant. MyISAM and InnoDB may perform differently…_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush…
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… bug #65077 from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes…
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… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue can…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… anything quite like that in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…#####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… = 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
… Inconsistencies and May Not Even Work! MyISAM tables are supported within Percona XtraDB Cluster, however, MyISAM has only basic support, primarily because… 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…
Comment: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
and one more question “how many tables (MYISAM or INNODB) mysqld can create, the maximum number ?”
