…” string) This works on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I set… 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT…
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: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 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…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…MySQL. Change Data Capture can be used to: Monitor a database table, or tables for changes. Improve ETL performance…Setting up FlexCDC FlexCDC has some basic requirements: MySQL 5.1+ row based logging (binlog_format=1) unique server_id in the my.cnf…
