June 20, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

… post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine… 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…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

… readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and bug… 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…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m…_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size… = 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…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… cache device, vCache shines. Compared to a deployment with …innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

January 8, 2007 By 117 Comments

…=128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread… query to retrieve value from PK. The results for InnoDB and MyISAM are comparable and I think this shows both engines are maximally…

Filed Under: Benchmarks Tagged With: ,

Post: Fix of InnoDB/XtraDB scalability of rollback segment

January 18, 2009 By 9 Comments

… Xeon, 32GB of RAM, RAID 10 on 8 disks) to compare mysql-5.1.30-XtraDB-1.0.2-pre-release3…=MYISAM innodb_buffer_pool_size=6G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb…-user user –mysql-password –mysql-db sbtest –mysql-table-engine innodb –myisam-max-rows 1000000 run

Filed Under: Benchmarks, Percona Software Tagged With: ,

Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1

January 19, 2008 By 117 Comments

[...] to use InnoDB, the best reason is the performance difference. I was reading an article by the MySQL Performance Blog which compared MyISAM, InnoDB and Falcon. First of all, I have never heard of Falcon, so I [...]

Filed Under: Benchmarks Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was… InnoDB and some observations that I’ve made while getting it configured. The second part will compare query results between MyISAM FTS and InnoDB… how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to traditional MyISAM FTS. We…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE `innodb_myisam_stopword` ( `value` varchar(18) NOT NULL DEFAULT ” ) ENGINE=InnoDB DEFAULT… a look at performance. How does the speed of InnoDB FTS compare to its MyISAM counterpart, and what kinds of tricks can we…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

… Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk or a failed InnoDB… page in clustered key index is corrupted. It is worse compared to having data corrupted in secondary indexes, in which case… in MyISAM table so all you have to do is to drop old table and convert new table back to Innodb after…

Filed Under: Insight for DBAs Tagged With:
« Older Posts