… concurrency in another blog post in this series. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least… ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… a performance audit (it’s our most popular service). I thought I should write a blog …/var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file…all of which we can frequently help customers set up much more efficiently and with better results…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…MySQL is actually badly configured, you can hurt its performance significantly. Correcting these mistakes can correspondingly improve performance…blog‘s articles often illustrate extreme cases, so keep in mind that the vast majority of MySQL…my.cnf file. It’s sometimes possible to look at the my.cnf…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… not be in date_id order’; /*!40101 SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_…573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock…verify the numbers in my next blog post. I will compare performance of various cluster sizes on…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they…-id in my.cnf. You change the server-id interactively, this is an action you should never perform on a slave. “SET GLOBAL server… !! There was a hidden character in my.cnf that was unvalidating the value and then it was set to 1. How to identify…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…change on my.cnf or schema change can affect the overall performance …my.cnf changes replaying a slow query log. The service starts with an empty my.cnf configuration so all parameters are set…playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_…the buffer pool. This blog post is not a …
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…now. This topic deserves an entire blog post, because there are many …heuristic for how big your working set is. Set the key_buffer_size to…MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance… you are new to MySQL, trying to configure my.cnf, and you have heard …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA…not ZFS ? The ZFS MySQL success story is all over across Sun’s blogs, so why benchmarks …nice features which are worth a bit of performance overhead. My best wishes to the Tom Daly and…
Post: Why not make a tool to improve existing configurations?
February 10, 2012 By 4 Comments
… our very popular MySQL Configuration Wizard have submitted feedback such as “I’d love to input my existing server settings and get suggestions… so it performs worse than before. So in the end, although our tool is excellent for creating a starting my.cnf, my old blog post about the ultimate my.cnf tuner tool, which claims that an expert…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
…MySQL, Pacemaker invokes a script to start (or restart) the EC2 instance running MySQL. This blog…perform (the full script is given below). Kill the MySQL EC2 instance if running Make sure the MySQL… missing configuration settings of the …/mysql/my.cnf sudo service mysql restart sleep 5 /usr/bin/mysql…
