MySQL 5.6.7 RC is there, so I decided to test how it performs in tpcc-mysql workload from both performance and stability…_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… check out MySQL Performance on “Memory Appliance” by … Using 16K read sizes (matches Innodb page size) I could …normal case is to allocate cache memory to buffer …queries/sec from MyISAM (double of Innodb already) which scaled to 70.000 queries/sec peaking out at 16 threads. However even with MyISAM…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… MySQL common sense however does not always works – we’ve seen performance issues with large query_cache_size also sort_buffer_size and read_buffer_size may… for MyISAM tables table header has to be modified each time the table is opened. In this case the performance was so…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…, with powerful hardware and heavy query workloads. Both have a key_buffer_size of 4GB. Now can you …? Let’s trust MyISAM‘s creators on this one, because they designed a cache hit to be faster … in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance, …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… : 1995.004 cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1… see bad performance. We hope the performance of LIMIT queries will be fixed before release. MyISAM shows stable result. InnoDB is better than MyISAM by…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be done by key_cache… queries to get into trouble. Just one is enough. Lock priorities. By default MySQL …cache. MyISAM tables only have indexes cached in key_buffer while data is cached in OS cache. It is performance…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
MySQL Server has tons of variables which may be adjusted to change behavior or for performance…MyISAM and Innodb. Some SQL level items as Query Cache…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… different tables ? This can be offset by keeping myisam_sort_buffer_size low, but then performance would suffer. Prepared Statements Number – Happily now… IO system and wipe off both MySQL and OS caches which can cause other users queries to perform order of magnitude slower than in…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…performance sort_buffer_size = 8M read_buffer_size = 2M query_prealloc_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size…have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads,…cache. You want to bypass cache for your Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql…
