… pool). This however allows us to see the best possible scenario for SSD running under MySQL, the final result will show the best possible gain. I do measurements every 10 sec to see stability of results. Graphical result… see, on the big datasizes we have 5-6x improvement. However on 32 tables (375GB of data), the result became unstable. There…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and variable…_clientsblogpercona.commanual Aborted_connectsblogpercona.commanual allow_suspicious_udfsblogpercona.commanual ansiblogpercona.commanual…is_nullblogpercona.commanual sql_big_selectsblogpercona.commanual sql_big_tablesblogpercona.commanual sql…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… committee. We created a conference website that allows people to create an account and submit … Officer, Terry Erisman, who has experience running big events at his previous employers such as …least interesting) results, how to do super-advanced and extreme things with MySQL, how to use MySQL for …
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… which result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL… and when dumped to binary log as one big chunk which can’t be interleaved by any… and run update in chunks if application allows it. In MySQL 5.1 with row level replication you…
Post: MySQL Session variables and Hints
December 28, 2006 By 2 Comments
MySQL has two ways to find tune execution of particular query. First is MySQL Hints, such as SQL_BIG_RESULT, STRAIGHT_JOIN, FORCE INDEX… it is not created dynamically some complex way) – adding extra MySQL calls with possibly their own error control is more complicated… own code. The great solution I think would be to allow per session variables to be changed only for single query…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… I can get with MySQL 5.5.8. The 15-minute average result is 37235.06 NOTPM. This allows me to draw a… the maximum checkpoint age is. Okay, here are the results: Success! With a big log file, we are getting stable throughput. Checkpoint… space. And, the Percona Server result is ~2x better than the best result I received with MySQL 5.5.8 (with innodb_doublewrite…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…; a difference from the FusionIO case, it gives better results for MySQL 5.5.8. For both servers I used: innodb… the following results: 13GB: MySQL 5.5.8 – 23,513 NOTPM, Percona Server – 30,436 NOTPM, advantage: 1.29x 52GB: MySQL 5.5… tpcc-mysql workload with 1000W. The main factors that allow us to get a 1.4x improvement in Percona Server are: Big log…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 12 Comments
… | +———+ 1 row in set (18.71 sec) This allows us to get results in about 40 seconds and as we can see… to do is maintain an extra count. So if MySQL does not allow us to use ORDER BY together with GROUP BY… forced FileSort execution method for GROUP BY by using SQL_BIG_RESULT hint I can see GROUP BY executing about same time…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like …significant amount of data. One big reason for this is the… pivot_results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot_results & [1] 12359…log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…results each 10 sec, and when we graph it, it looks like: Basically there two stages: MySQL handles traffic and MySQL…data. With widely adoption of MySQL 5.5 and servers with big memory configuration I expect we …InnoDB flushing may kick-in faster, and do not allow to have a lot of modified pages in…
