June 19, 2013

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

… the checkpoint information to the first file. Q31: How often or…cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf, to…_buffer_pool_size Q36: There have been several MySQL bugs opened …searches/s HT: Strange, primary key equality searches should work …

Filed Under: Insight for Developers Tagged With:

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

February 26, 2013 By 1 Comment

…to find out how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to…to the default InnoDB settings for MySQL 5.6, and that was to change innodb_ft_min_token_size from the default of 3 to…

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

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

June 9, 2011 By 13 Comments

…cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size…how to align files properly. 4. Partition table and file system properly aligned; sunit/swidth set…

Filed Under: MySQL

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set…

Filed Under: MySQL

Post: How much memory can MySQL use in the worst case?

February 12, 2009 By 17 Comments

…cache and the table cache and the size needed for each thread (thread stack, etc)? Those take memory too. The query cache…keys for user locks! I set my max_allowed_packet bigger and ran the following on my laptop: mysql> set…

Filed Under: Insight for DBAs Tagged With:

Post: MySQL Server Memory Usage

May 17, 2006 By 21 Comments

…key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL to…

Filed Under: Insight for DBAs Tagged With: , ,

Post: To pack or not to pack - MyISAM Key compression

May 13, 2006 By 4 Comments

…to work and MySQL will need to scan keyblock from the start uncompressing keys to find matching key…set index block size for the keys. So you can’t look at your index and say “OK. This is going to…to have keys packed so cache…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

March 12, 2012 By 12 Comments

… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take… for filtering records. For example, suppose you have a key defined as: KEY `i_l_partkey` (`l_partkey`,`l_quantity`,`l_shipmode…

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

Post: Choosing innodb_buffer_pool_size

November 3, 2007 By 39 Comments

…size you would not loose much anyway. You also may choose to set buffer pool as if your database size…to leave space for other MySQL needs while factoring this in. The next step would be to decide How…also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, …

Filed Under: Insight for DBAs Tagged With:

Post: Innodb Caching (part 2)

May 10, 2011 By 7 Comments

…cache any more. For 16K pages we see over 10x drop from 7630 qps to 580 qps as number of keys…size without recompiling the server, though I expect results for 16K and 16K Compressed to be very similar on MySQL…

Filed Under: MySQL
« Older Posts
Newer Posts »