… work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight… servers are where in wild which are running with default settings. Even though you can tune quite a lot of variables in MySQL Servers… less secure as you can lose transactions even in case MySQL Server crashes. Value 2 only cause data loss with full OS…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… know is that server configuration itself really isn’t something you should expect to deliver huge wins. If MySQL is actually badly… at several important factors, including the following: The hardware The server configuration The workload The queries The schema design (table design… configuration alone. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done endlessly, with…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… dedicated purge thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple… by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve… the moment seems to be the one in Percona Server 5.1. MySQL 5.6.2 multiple purge threads have major issues…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… for MySQL Server code and various small static buffers. This is memory which you can consider used when you just start MySQL Server. The rest of memory is available for connections. For exampe with 8GB server you might have everything… which are not tuned as buffers. Watch for these especially now with many storage engines being released for MySQL by various parties…
Post: Online MySQL Configuration Wizard from Percona
December 23, 2011 By 23 Comments
… manage your MySQL servers. Our online MySQL Configuration Wizard can help you generate a good basic configuration file for a server. This MySQL tuning wizard is our answer to the commonly asked question, “what is a good default configuration file for my server…
Post: MySQL Connection Timeouts
April 19, 2011 By 2 Comments
Sometimes on very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If… LISTEN socket is overflow – MySQL is not accepting connections as quickly as it needs. There are 2 tuning places you need to…. If you’re creating 1000 of connections a second to MySQL Server you might be pushing your luck and at very least…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and…. It may be as simple as adding few indexes and tuning MySQL Server settings. It is more the question of knowing there to… – it is very hard to find people with good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching for…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…. I claim that somewhere around of 99% of advice about tuning MySQL‘s key cache hit ratio is wrong, even when you…’t know enough about the servers. OK, I’ll give you more information. Both servers are real production servers, with powerful hardware and…. The reality is that this server setting is very subjective, and there is no good instrumentation in MySQL to guide your decisions…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
…: MySQL: 3746 tps Percona Server: 3704 tps And for comparison, average throughput for 4 tables: MySQL: 3882 tps Percona Server: 6735 tps The Percona Server… that with a proper tuning, Percona Server/XtraDB outperforms MySQL, and provides a more stable throughput. Of course if a tuning is too hard…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… a human with many years of experience, deep knowledge of MySQL and the full application stack, and familiarity with your application… quite a few of the servers I take a look at have been “optimized” with some tuning primer or question-and-answer…-all and end-all of performance. Tuning your server settings has far less impact on performance than tuning your schema, indexing, queries and…
