… | 23.59G … Locator Size Speed Form Factor Type Type Detail ========= ======== …mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory… to repeat and test – just run Innodb from the RAM drive 
Next I tested MyISAM which is well known for its simplicity… from MyISAM (double of Innodb already) which scaled to 70.000 queries/sec peaking out at 16 threads. However even with MyISAM we…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb…Furthermore besides MySQL table_cache Innodb maintains …innodb_open_files=16384 I got about same crash recovery speed though with no warnings. So it looks like innodb…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…are, both in terms of size and spindle speed. I need to know how many physical …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.)…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… but writes still have to happen at full speed. It also really hurts if you choose replication (…or if you use MyISAM tables you would not have the problem, if you have innodb_flush_log_at_… counters very efficiently pushing few updates back to MySQL server. If you rather use existing solutions you …
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…sorting by default, adding relevance sorting to the MySQL queries would make them even slower, I’m…InnoDB FT index, I made sure to increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM… database, you can get a lot of speed improvement because you’re searching data without …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…packed rows – quite possible scenario for MyISAM tables. Now if we take…may affect index scan/range scan speed dramatically. The rows referenced by… are also clustered keys in Innodb which combine index access with …MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL…
Post: 3 ways MySQL uses indexes
September 12, 2009 By 28 Comments
… on the first place. Most popular index type in MySQL – BTREE can speed up equality and prefix range matches. So if you… though. Using index to read data Some storage engines (MyISAM and Innodb included) can also use index to read the data, hence… the reason covering indexes help to speed up queries even if data is in memory. If MySQL is only reading index and…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-…MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb…result is dropping down with the same speed as it grew, and with 128 …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…mounted same as original file system Why snapshot based MySQL backups are great ? There are number of reasons: …all local disk based storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid… form so it is hard to beat in speed. Low Overhead It is simply file copy so …
