June 19, 2013

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

May 22, 2013 By Leave a Comment

… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6…instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/…flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted …

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

Comment: Database problems in MySQL/PHP Applications

November 6, 2006 By 13 Comments

…size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for_sort_data=2048 max_sort…

Filed Under: Insight for Developers Tagged With: , ,

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

February 26, 2013 By 1 Comment

…in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in… buffer pool for my 5.6 instance is 128MB – smaller than the size…also do something to provide some sort of sequence value for that column…, I might have a hard time recommending this feature to my customers, …

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

Post: MySQL: what read_buffer_size value is optimal ?

September 17, 2007 By 25 Comments

… results with sort performance and today I’ve discovered even read_buffer_size selection may …cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some …MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) Populated it with 75M of rows to reach 4G in size…

Filed Under: Benchmarks, Insight for DBAs Tagged With:

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

…in MySQL…MyISAM table you should use K(id2,id1) in…buffer will not be able to be used, which can be important for large, heavily written tables. Q: in…in-lists). There were the times when when it would make a difference though. Q: Would you recommend creating an index in…

Filed Under: Insight for DBAs, MySQL

Post: Choosing innodb_buffer_pool_size

November 3, 2007 By 39 Comments

…size you need to check if there are any restrictions on Innodb Buffer Size…MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer…in the innodb buffer pool. I guess these clarifications work better than 70-80% recommendation…

Filed Under: Insight for DBAs Tagged With:

Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server

December 29, 2008 By 6 Comments

…size=64M max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size…recommendation to fit at least active dataset in…

Filed Under: Benchmarks Tagged With: ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…in. Maybe you want us to analyze and present recommendations…in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size…

Filed Under: Insight for Developers Tagged With:

Comment: How fast can you sort data with MySQL ?

August 19, 2007 By 26 Comments

…between 100-256k were fastest while a sort_buffer_size of 512k or larger showed a … (look in the comments for http://www.mysqlperformanceblog.com/2006/06/06/are-larger-buffers-always-…mysql 5.x) recommended by you look for a Q6600 cpu system with 4 gig ram and using only myisam (aswell as myisam…

Filed Under: Benchmarks, Insight for DBAs Tagged With: