…interesting investigation of the fact read_buffer_size variable affects connection speed. This is …are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes while …. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for other large…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…innodb_concurrency_tickets too high can have startlingly negative performance…innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We … with systems that are at any level of tuning, from completely untuned to a system that’s …in big units, so it’s hard to read. If the InnoDB buffer pool is set to 22GB, it’s much …
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
…innodb_buffer_pool_size, 1G innodb_log_file_size), MySQL 5.5.10 with innodb…innodb_io_capacity and decrease innodb_max_dirty_pages_pct so as to have fewer dirty pages. But I call that tuning…of performing 1 random write, InnoDB will perform …read “impossible”), and this is one of the reasons why innodb…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… tuning gets it wrong. Q10: When Innodb decides to schedule sequential read-ahead, random read ahead ? HT: InnoDB schedules a sequential read-…buffer pool flush. I think Yasufumi Kinoshita talked at Users’ Conference 2007 about his patch that makes InnoDB‘s flushes smoother and increase performance…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… performance optimization method. I’ve shown that if we make some assumptions that are hard to prove, we can compare Key_reads… it? What about InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size setting? This…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…tuning ideas or try to read…innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log_buffer_size = 16M innodb…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…performed. Innodb uses fuzzy checkpointing so this line hold log sequence, all changes up to which has been flushed from buffer pool…buffer pool for new data – when previous page content was not read to the buffer pool. Finally you can see buffer pool hit ratio which measures buffer pool…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…adaptive checkpointing algorithm innodb_adaptive_checkpoint=keep_average Disabled read-ahead logic: innodb_read_ahead=none Buffer pool scalability fixes (different from innodb_buffer_pool_instances) …for if you are looking for high MySQL performance, and we tune Percona Server to get the most from …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… some performance issue sine at least 10 months on a MySQL server. I am not an expert, I am doing some tuning reading… innodb_file_per_table=1 innodb_doublewrite=0 # Set buffer pool size to 50-80% of your computer’s memory innodb_buffer_pool_size=4G innodb_additional_mem_pool…
