…/shm 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=10G # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
Does Percona have improvements to keep the InnoDB insert buffer from getting full (as in do background reads for ibuf merges when it is getting full)? That is the key to sustaining good throughput for InnoDB on iibench.
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… covered in the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside… innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb… 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… in mind that the entire data set fits into the buffer pool, so there are no reads from disk. However, there…, here are the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06…% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM memcached.container WHERE id=’key_id…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…not process query traffic except for replication. The buffer pool and adaptive hash index on the …-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs…no rows or insert statements that have duplicate key errors may be faster than an actual database…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… use key buffer, key_buffer, and key cache interchangeably. However, I will be careful about the difference between “rate” and “ratio”. In this article, the key… the key_buffer_size until, when the buffer is full, Key_reads/Uptime reduces to a number you’re comfortable with. Set key_buffer_size really…? What about InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… fails for table `test/child`: , CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE Trying to… can check if your innodb_log_buffer_size is optimal – if you see more than 30% of log buffer size being unflushed you… Buffer pool hit rate 999 / 1000 This section shows Buffer pool activity and memory usage. You can see total memory allocated by Innodb…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer pool… you have inserted in an ascending order of the PRIMARY KEY, then InnoDB should have placed the rows in contiguous blocks of… innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987, used cells 1, node heap has 1 buffer…
