… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool… via /proc, I’d vote in the other direction. Stay tuned for part two of this series, wherein we’ll take…
Post: Online MySQL Configuration Wizard from Percona
December 23, 2011 By 24 Comments
… your MySQL servers. Our online MySQL Configuration Wizard can help you generate a good basic configuration file for a server. This MySQL tuning wizard…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… I’ve seen lots of customers trying to tune the thread concurrency inside MySQL with the variable thread_concurrency. Our advice is… tuning parameters provide the most benefit to your workload. thread_concurrency is causing lot of confusion and there are hundred of MySQL tuning howtos that explain how to tune the variable to get better performance. If…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…’t something you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its performance significantly… cases, so keep in mind that the vast majority of MySQL installations don’t suffer from the variety and severity of… configuration alone. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done endlessly, with…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… MySQL Consulting Team and MySQL Support Team can work together to audit your current system; assess how to re-architect, develop, and tune… MySQL versions to MySQL 5.6, and other issues. Our MySQL Remote DBA Team is ready to monitor, maintain, and fine tune our customers’ MySQL 5.6 test and production environments, and address any performance issues that might arise. Our MySQL Training team…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… be doing fine tuning for our Percona Server for MySQL version 5.6 release. Another thing to remember about MySQL 5.6 is…_5_6_10# sysbench –test=oltp –mysql-socket=/tmp/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-size=1000000 –num…. Granted I have not tuned MySQL 5.6 for best performance going with defaults outside of few variables MySQL Sandbox sets explicitly but…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… workings of one of the nicest features of the newer MySQL optimizer: the Index Condition Pushdown Optimization, or ICP, which we… query faster, which means you need more manual care and tuning now. MySQL is conservative about “Using index” -in most cases it…-party, independent and technical opinion about the new features of MySQL query planner? Are you not yet familiar with terms like…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… to have a single separate dedicated purge thread and in MySQL 5.6.2 one can have multiple dedicated purge threads… to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important… by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve…
Post: MySQL and SSD | Percona XtraDB Cluster talks
September 13, 2012 By Leave a Comment
… talks “Percona XtraDB Cluster: HA solution for MySQL“. I will give introduction in MySQL clustering and show how Percona XtraDB Cluster solves HA and scalability problems. MySQL and SSD: usage and tuning. If you… Rate prices end this Saturday. If you are working with MySQL and you are in New York on 1-2 Sep…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many cases. Whatever powerful and well tuned system…
