… NULL, PRIMARY KEY (id), KEY state (state) ) ENGINE=MyISAM; 2) Table with VARCHAR: CREATE TABLE cities_varchar ( id…be larger. It is also interesting to note performance of Innodb tables in this case: for VARCHAR it…case but this is other story. To avoid part of this problem we of course arrange state…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…Even that doesn’t help, though. Problem 2: Counters don’t measure time… takes. If you approach application performance optimization from the standpoint of … very slow relative to other parts of the computer. And here… to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM,…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… index header (most complex part of opening and closing MyISAM table) can happen by … rate. Interesting enough it dropped just 2 times and was about same for…performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well) – Innodb…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference… for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method… disk) 2. Run each query for 1, 4, 16, 64, 128, 256, 512 concurrent threads. 3. For each thread perform a warm…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB…InnoDB in both performance and features. The early version of PBXT was not fully durable (equivalent to innodb_flush_log_at_trx_commit=2… avoid modifying any part of MySQL to…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… forget about it especially if running only Innodb tables so you may think there is…547160 0 0 5 44 96 103 2 0 94 3 0 0 3 116…means I will have to postpone this part of test to another time. Summary: If… would hope, at least on Linux Performance of Disk MyISAM tables may not scale proportionally with …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…Zabbix, but general InnoDB tuning recommendations apply here…use asynchrounous replication between 2 PXC clusters, with… addressed, if not part of the presentation…MyISAM support is experimental. Apart from some very special, edge cases, I would not recommend using MyISAM. Q: How does write performance…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…part of upgrade, you still need to keep into account possible query changes, replication etc. Q: Is it possible to move MyISAM…MyISAM tables are essentially at the state they were in MySQL 4.1 while Innodb storage engine got dramatic performance…Q: What is about running 2 instances of MySQL with …
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…part. Benchmark date: Oct-2012 Benchmark goal: Test how MySQL 5.6.7 performs…2 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_io_capacity = 20000 innodb_io_capacity_max = 40000 #not innodb…
Post: Redundant index is not always bad
August 28, 2007 By 7 Comments
… leave two indexes, even one is first part of another. I’m speaking about BTREE … KEY state_id, ADD KEY `state_id_2` (state_id, city, address) And now for…MyISAM, for InnoDB difference will be less. MyISAM uses key-compression for VARCHAR columns, so makes things worse). So to have good performance…
