May 22, 2013

MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query:

Lets go over to see what are the most important changes [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

thread_concurrency doesn’t do what you expect

June 4, 2012 By 3 Comments

Over the last months I’ve seen lots of customers trying to tune the thread concurrency inside MySQL with the variable thread_concurrency. Our advice is: stop wasting your time, it does nothing on GNU/Linux Some of the biggest GNU/Linux distributions includes the variable thread_concurrency in their my.cnf file by default. One example is Debian and its [...]

Filed Under: MySQL

Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables, or look for content in the Percona documentation or forums. So I present to you what is now my newest Firefox toolbar bookmark: an option and [...]

Filed Under: Insight for DBAs, MySQL

Webinar: Introduction to Percona Server, XtraDB and Xtrabackup

November 26, 2010 By 2 Comments

We’ve had such a large number of signups to our Migrating MyISAM to InnoDB webinar, that we decided to hold one more before the year is out: December, 8th 9AM PST: Introduction to Percona Server, XtraDB and Xtrabackup.

Filed Under: Events and Announcements, MySQL Tagged With: , , ,

Tuning InnoDB Concurrency Tickets

May 24, 2010 By 5 Comments

InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency variable. A thread is placed in a queue when it tries to enter InnoDB if the number of threads has already reached the concurrency limit. When a thread [...]

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , ,

SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

Many people asked me to publish a walk through SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW INNODB STATUS is command which prints out a lot of internal Innodb performance counters, statistics, information about [...]

Filed Under: Insight for DBAs Tagged With:

InnoDB thread concurrency

June 5, 2006 By 4 Comments

InnoDB has a mechanism to regulate count of threads working inside InnoDB. innodb_thread_concurrency is variable which set this count, and there are two friendly variables innodb_thread_sleep_delay and innodb_concurrency_tickets. I’ll try to explain how it works. MySQL has pluginable architecture which divides work between mysql common code (parser, optimizer) and storage engine. From storage engine’s point [...]

Filed Under: Insight for DBAs Tagged With: , , ,