…with systems that are at any level of tuning, from completely untuned to a system that’… to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how …mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… Percona Server 5.5.30 and 3 allocators – stock glibc 2.13, jemalloc-3.1.0, the … I believe that both allocators can be tuned to handle such cases better – for instance…MySQL. # Test: POINT_SELECT:throughput, QPS # # Set 1 – 5.5.30pre-jemalloc-3.0.0 # Set 2 – 5.5.30pre-jemalloc-3.1.0 # Set 3 – 5.5…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…-29c3ac1f4b32 Filesystem magic number: 0xEF53 Filesystem revision #: 1 (dynamic) Filesystem features: has_journal ext_attr …MySQL/Innodb it will assert and restart. Now lets look at couple of other options you might want to tune… it to be back in 5 minutes yet it takes 30+ because it has to check file…
Comment: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…-rw-rw- 1 root root 186641309 Jan 16 21:04 mysql-5.5.30-linux2.6-x86_64.tar.gz -rw-rw-rw- 1 root root 303263359 Jan 23 03:55 mysql-5.6.10-linux-glibc2.5… in the post this is not about testing the best tuned 5.5 vs 5.6 but rather to see how out of the…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…if it takes you 30 seconds to generate …now HTML takes 0.5 seconds to generates …type=’search’ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | mysql_… queries, cache them, tune them so they are…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…tuning couple of MySQL settings. When low hanging fruits are fixed you end up with either fine tuning… single user CPU bound query takes 30 seconds you unlikely will be able…) rented server which would usually have 1-2GB of memory may be couple…good IO subsystem which would cost $5-10K or some $500 a …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… MySQL server. I am not an expert, I am doing some tuning …constant, sometime he is lower to 5% and sometime it’s upper …var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30 … Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file_per_table=1…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… bound, while to understand if MySQL goes through more rows than …innodb_flush_log_at_trx_commit=1 (default) this will be synchronous… 2.2 vs 5.5ms which is 2.5 times difference – This …not be able to get over 30-50% from the second hard drive…. So as you might see tuning IO subsystem can indeed be fun …
