… was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D Prabhu). Donor node….4 are available in our online documentation. We did our best to eliminate bugs and problems, but this is a software…
Comment: Innodb Performance Optimization Basics
March 21, 2013 By 75 Comments
Hello Peter, Could you help me to come out with a best my.cnf for my cpanel server which makes use of innodb engine which has got 32G and quad core? Thanks, Riyaz
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… course, we will also tell you what we think is best for you, which is our job). After the kickoff call… way here — we focus on far more than my.cnf files. In fact my.cnf files are usually one of the smallest levers we… look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
… Sort_merge_passes 18 k Sort_rows 12 M — Actual my.cnf: [mysqld] datadir = /var/lib/mysql socket = /var/lib/mysql/mysql… change mysql vars and restart server, my configs are not applied, defautl mysql applied, and my.cnf are not modified. Why? Where are…, how to configure InnoDB for best performance?) – what parameters i need to insert manually in my.cnf for best performance & low disk usage? – may…
Comment: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… two are easy to lay side by side. And the best is, you get to know the value of the dynamically… exactly which my.cnf files are being used by the server (I hate hunting them down). Is it /etc/my.cnf? /etc/mysql/my.cnf? /usr/local/mysql/data/my.cnf? /var/lib/mysql/my.cnf?
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.*EDIT… your favorite storage engine or database About the cluster For best performance, there should be an even data distribution in the….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… tools just run random queries against random generated data. The best way to run a benchmark is replaying the load of… tool you can measure how a database upgrade, change on my.cnf or schema change can affect the overall performance of your… meassure the impact of my.cnf changes replaying a slow query log. The service starts with an empty my.cnf configuration so all parameters…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
… other requirements configured. I knew from experience that it was best to ensure SSL was working properly from the command line… the relevant config options in the ‘mysqld’ section of the my.cnf: [mysqld] ssl-key=/etc/mysql/ssl/server-key.pem ssl… openssl and ssl, and it had my SSL files correctly) Checking grants Double-checking the my.cnf for misspellings Restarting mysql Checking file…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… faced: 1. After I got (what I thought was) the best configuration, I added LVM on top of that and the… a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld… set during mounting but not during mkfs. This is your best option if you have a proper alignment in partition table…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… which showed larger table cache does not always provides the best performance. So I decided to look at yet another similar… raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18… raise the value of innodb_max_files_open in InnoDB: my.cnf So we can see Innodb may with to have so…
