… expensive in the MySQL world, yet Oracle and to some extent SQL Server handle better. JOIN has long been something MySQL has done… stop using major benchmarks for their tuning, so why not make them dance to our tune instead, become the Puppeteer and not… board? With the increasing emergence of drop-in replacements for MySQL like Percona and MariaDB which are either tweaking or flat…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… 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…
Page: Consulting for MySQL
July 31, 2006 By
… replication, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL Upgrades, Backup… flawed there is only limited gain you can achieve by MySQL Server tuning. Working with us on architecture design or refactoring will ensure…
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: 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: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… can work with systems that are at any level of tuning, from completely untuned to a system that’s already had… to look at MySQL Assuming I don’t see anything noteworthy here, I’ll move on to the MySQL server. I mean, let… in the stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has the…
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: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
Even though multiple fixes have been implemented in Percona Server and MySQL 5.5, there are still workloads in which case mutex… bit more time while you’re upgrading to Percona Server or newer MySQL version or doing application/architecture changes. Reducing number of…) as well as adjusting innodb_thread_concurrency and doing other server tuning should be first on your list. I also wanted to…
