June 19, 2013

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

May 22, 2013 By Leave a Comment

… 12GB of data in the largest table. You can find the individual SSB query definitions in my previous blog post. Test environment These… buffer. I used ALTER TABLE DISABLE KEYS and built the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size…

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

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

… a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.*EDIT… sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation…

Filed Under: MySQL

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

… a machine that’s dedicated to MyISAM tables. Consider your mixture of storage engines (some …key cache hit ratio.” This is a shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so definite, mathematical, and authoritative,…

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

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 Comments

…my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table…table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table… though it would definitely be interesting to …

Filed Under: MySQL

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

February 26, 2013 By 1 Comment

…my DIR data. So, with all of that out of the way, let’s get to it. Here is our basic table definition…98304 Feb 20 16:09 FTS_00000000000000ad_BEING_DELETED_CACHE.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20…the few people that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse…

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

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

December 29, 2008 By 6 Comments

…_pool (split_buffer_pool_mutex patch). my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len…_table_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… than InnoDB, but nothing special to be proud of. We definitely we will look how to fix it as next step…

Filed Under: Benchmarks Tagged With: ,

Post: What's required to tune MySQL?

July 27, 2011 By 4 Comments

…what happens when you have query cache contention, DNS problems, or very slow…at your my.cnf file. It’s sometimes possible to look at the my.cnf … The queries The schema design (table design, data types, indexing, etc) …can be done endlessly, with little definition or quantification of results. I …

Filed Under: Insight for DBAs, MySQL