… systems that are at any level of tuning, from completely untuned to a system that’…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…I run the following: wget http://hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/…
Post: High availability for MySQL on Amazon EC2 - Part 1 - Intro
June 17, 2010 By 8 Comments
… to have a truly highly available solution for MySQL on EC2. If a MySQL instance fails, here are some challenges that we… resources Part 4 – The instance restart script Part 5 – The instance monitoring script Part 6 – Publishing the MySQL server location Part 7 – Pitfalls…, I don’t have much control over my workload. Stay tuned!
Post: Percona Server and XtraBackup weekly news, March 28th
March 27, 2011 By Leave a Comment
… downloaded over 200,000 times. But when we changed the script to separate out the downloads for our 5.5 release…. We haven’t had the chance to vet the analysis script yet, but we should be able to do that shortly… ideas about how we could make the flushing algorithm self-tuning in more cases. We will keep you posted. In XtraBackup…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… the Virident tachIOn 400G card The raw results, config, and script are in our Benchmarks Wiki. Here are the graphs: 13G… the difference between different settings of innodb_io_capacity for MySQL 5.5.8. Small innodb_io_capacity values are really… good choice for if you are looking for high MySQL performance, and we tune Percona Server to get the most from such…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
…. The problem with the default my.cnf which comes with mysql is that those figures doesnt seem to reflect recommendations from… 99% of the installations still can be obtained using optimization scripts. The problem is that some people tend to claim they… in mysql so you as an admin only have to care for lets say keybuff + max mem usage and then let mysql tune…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…on asynchronous replication, galera and built-in mysql replication are independent from each other. Q… recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments… it is backed up by the wrapper script called innobackupex, and not xtrabackup itself …
Comment: Why you should ignore MySQL's key cache hit ratio
December 2, 2010 By 28 Comments
Hi, I am not an expert at mysql. Can you help me optimize my server? (Might give me a conf file example?) 
Thies are te informations I have about mysql: [Ed: deleted output of a tuning script]
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
… for storing and manipulating with other programs and scripts. By default, tcprstat works just like vmstat: it…. For many simple protocols such as HTTP and MySQL, this is the moral equivalent of a query…be very appreciated — libpcap allows the user to tune this exchange, so if you have suggestions on…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
… regarding my.cnf tuning, only some trolling on how bad “automated scripts” are and how superior the writer is into tuning my.cnf… ultimate tool for generating optimal my.cnf files for MySQL” ? 
The meaning of tuning my.cnf is not do to some magic… better utilize myisam files (since today MySQL let the operating system use its diskcache before the MySQL engine access the myisam tables)?
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 30, 2008 By 34 Comments
… to a badly performing application that depends on MySQL. You can run a script, hire a DBA, and improve your hardware, but… each step. I’ve talked to many customers who ran scripts and noticed a performance gain. I’ve talked to many… I know the limitations of the script. There’s no way that my script can perfectly tune a server, but I hope that…
