… quite stable, that is why I also show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better throughput…/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… time; the remaining 3600 seconds were averaged into 10-second intervals. All tests … produce the most optimal results, I moved on to reviewing FlashCache performance versus …requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… average is is 3 numbers which correspond to “load average” calculated for one five and 15 minutes. It is computed as exponential moving average so most recent load have more weight in the value than old one. What does Load Average corresponds to… if you run single batch job on the server with MySQL, Load Average is likely to be close to 1 even if…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… let’s move on! How to determine which MySQL High-Availability solution is best? What is really tricky with MySQL is the …table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good, average MySQL DBA + good Sysadmin skills…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… what processes are running, but it also shows me load average, memory sizes, and a bunch of other stuff. In this…). Starting to look at MySQL Assuming I don’t see anything noteworthy here, I’ll move on to the MySQL server. I mean…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise …is explained here at this link. Now before we move forward, I would like to point out that …such as the total query execution time and the average query execution time, the number of tmp tables …
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
… they experienced mysql crazy cpu loads since more than one year which lead every now and then(once a week average) real deadlocks with up to 120 load average, mysql master restart needed and apache servers… the meantime the bedtime moved later and later and the investigation was moving on two tracks: FreeBSD bugs, MySQL bugs. One of the…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… For me IO is IO bound workload – disks are moving and CPU sits idle. With such terminology there …IO bound or CPU bound, while to understand if MySQL goes through more rows than it needs to …second (4ms per rotation) which gives us 2ms of average latency – exactly what you can see in the specs….
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…normal working set from OS cache. Operation Systems and MySQL Itself employs various strategies to attempt to minimize …disk at once. In some cases I’ve seen average time requests spends in the queue to be … prepare summary tables on the slave and when move them to the master using mysqldump, or even …
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… benchmarks I made it 3GB. Raw results and rest of mysql parameters are here http://spreadsheets.google.com/ccc?key=tOWmcwiHDD6…, results during run: And averaged final result: As you see XtraDB, 5.0.83-percona and MySQL 5.4 are almost equal… benefits like FAST INDEX CREATION, table compression – XtraDB will support moving tables between servers – XtraDB will be released with fast recovery…
