…: MySQL Performance Optimization and Scaling – All aspects of MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL Server Configuration, Schema, Queries, Application Architecture, Caching etc. MySQL… for MySQL Need choosing Hardware and OS for MySQL ? Performing configuration and troubleshooting platform related issues ? We can help you designing optimal hardware configuration and…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… intensive workload will do a lot better on MySQL 5.6 with default configuration back_log Minor increase 50 to 80 does… sense in my opinion. MySQL 5.6 adds a lot more optimizer switches which you can play with: mysql [localhost] {msandbox} (test) > select… set (0.00 sec) Summary: MySQL 5.6 comes with quite a few changes to default configurations which are mostly for good…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
… example, one option would be to simply adjust the optimizer_switch configuration setting and disable index_merge_intersection. It’s a dynamically… mucking about with server configuration, altering the table structure, or creating messy sub-selects. In cases where the optimizer just can’t… a few possibilities: A new version of MySQL is released that has some new optimizer functionality that you end up missing out…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…that server configuration itself really isn’t something you should expect to deliver huge wins. If MySQL is actually badly configured, you …or quantification of results. I prefer to speak specifically of configuring, or of performance optimization, or something more descriptive and concrete instead.
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one… post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory and cause the server… or log this error appropriately. The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections… situation before it becomes a problem. This check requires careful configuration, or it too can become a noise generator. However, if…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… useful but leaves impression it does not need to be configured. sort_buffer_size = 256K Good choice for very small sorts… have in the phones these days, I made in my Optimizing MySQL Configuration Webinar were heard 
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… questions, we have customers backing up and restoring MySQL 5.6 databases in standard configuration successfully with the current version. The largest… and optimizations. Learn More About MySQL 5.6 If you’re interested in learning more about MySQL 5.6, the Percona Live MySQL Conference…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
….bz2 cd valgrind-3.8.1 ./configure make sudo make install valgrind –version # …[generally available] packages may contain optimized or stripped binaries, which are optimized for speed rather than …::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
…. You should not panic and go change all kind of configuration options in case you get lucky. Sometimes you do but… faster plan may be wrong plan from optimizer standpoint and updating stats may cause old MySQL Version to get slower plan instead… binary or differently optimized binaries. When you’re about to file a bug or report the problem through MySQL support channel if…
