…of internal Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of Innodb performance counters … number of threads allowed by innodb_thread_concurrency. For certain workloads it may help to decrease the time thread waits …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… when the workload is IO bound, the query time is decreased from ~11min to under a minute. The query time is… were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w… MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers for Innodb_rows…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… values by PK column and then performing the lookup, and then there are other possibilities like InnoDB doing read_ahead by noticing… as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query time decreases when the join_buffer… for the best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you need…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on a micro instance, simply decrease the values…. The extra data will not impact performance because it will never be accessed. Since both InnoDB and ICE versions of the data…=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…workloads. At first,
Post: How to decrease InnoDB shutdown times
April 15, 2009 By 20 Comments
… even slower in stock InnoDB than the shutdown process, for a variety of reasons. One way to decrease the shutdown time is to pre-flush the dirty pages, like this: mysql> set global innodb_max_dirty_pages… get to zero.) Once it’s pretty low, you can perform the shutdown and there’ll be a lot less unfinished…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… immediately a question arises how much logging impacts on performance. When we do performance audit often we log every query to find… query; MySQL was run with default settings except following: [mysqld] user=root max_connections=3000 innodb_log_file_size=128M innodb_flush_log… 0.94 We see here that logging all queries decreases MySQL’s performance on 6-20% depending on a number of connections…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used… cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb format you see just 1% slow down…-Lock patch is best in this case. It shows increased performance while decreased CPU usage. Note when I say CPU usage drop…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… thinking time, no keying time), it uses MySQL C API and the server side prepared… settings innodb_buffer_pool_size = 2048M innodb_thread_concurrency = 0 innodb_max_dirty_pages_pct = 70 innodb_flush_… using fast RAID storage, and/or observe performance decrease caused by shortage of free buffers you…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally… key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, … requirements with current settings and increase/decrease values appropriately. Some may say, Hey …
