… 10; In-memory workload Now let’s see how effective are the join optimizations when the workload fits entirely in memory. For the…_size and both of these buffers should be increased appropriately for the best possible performance gain. This is not entirely visible in… need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance, and BKA uses…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…-memory workload Now let’s see how effective is MRR when the workload fits entirely in memory. For the purpose of benchmarking in-memory… increased numbers for the counter Handler_read_key. This is because of how status counter values are incremented when index lookup is performed…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
One common question I guess is how much should I see performance improved in case I increase memory say from 16GB to 32GB. The… hot latches and performance go down. Now back to original question – how do we predict the benefit from increasing the memory and so cache… not expect to gain much by increasing the memory. This however have to be watched carefully. Performance does not always stays the same…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…. Running small queries might only barely increase memory consumption for given thread, however if table will perform complex operations such as full table… get in practice and how memory consumption reacts to changing various variables. For example you may find out increasing sort_buffer_size from…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… a challenge faced by almost everyone how do you maintain your performance in the face of increasing data size? Here is where people… a challenge faced by almost everyone how do you maintain your performance in the face of increasing data size? Here is where people… data in memory. let’s look at the 1GB Setting: What, a performance regression? But we threw more memory at it!! How can that…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…it causing problems every so often. Q16: How Innodb decided how many pages to flush at each …patch that makes InnoDB’s flushes smoother and increase performance substantially. I assume there is lots of room…buying 40 8-core boxes with 32G of memory. Have any specific thoughts here? INNODB was …
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
…). This comes from the fact that MySQL performs changes in memory at a faster rate than it can…’s general recommendation for this case is to increase innodb_io_capacity and decrease innodb_max_…as a result of how it works, instead of performing 1 random write, InnoDB will perform 8 random writes. …
Post: Predicting how long data load would take
May 24, 2007 By 12 Comments
… data quick do it on decent hardware. Especially memory size is important. If you need database on…_size increase. Innodb typically needs large innodb_buffer_pool_size and large innodb_log_file_size to perform… -sh” in the database data directory to see how much data is loaded per hour (assuming your…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
…records which only have been applied in memory and do not exist in tablespace. …records mean more records for same sized logs), how random were data modifications (random updates …is any performance benefit. After certain size increasing log file size do not dramatically increase performance, however …
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
… IO bound or may be just because amount of queries increased dramatically or may be because queries changed their plans. Do…_method=O_DIRECT) and see how performance depends on buffer size so you get and understanding what Memory-To-Disk ratio is optimal for your application, or at which point performance drops dramatically. It is…
