…) 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… when I need more “power”. Not sure what the MySQLDB performance cracks like Baron recommend you to be on the safe…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… param for InnoDB are [root@ng-lg-mdb1 ~]# cat /etc/my.cnf|grep innodb innodb_data_home_dir = innodb_data_file_path… approx 3 million records is taking too long and all my transactions are locked. select count(1),field1 from Table where… set (15 min 54.29 sec) Please help to improve performance and suggest if any config changes are to be made…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… far from optimal. Sometimes the my.cnf parameters are extremely wrong, to the point of causing a severe performance penalty. If it were… on my.cnf. It is not the be-all and end-all of performance. Tuning your server settings has far less impact on performance… my.cnf files I see only need minor tweaks, which give only so-so performance improvements. Tuning my.cnf only helps a lot when my.cnf has…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… your concerns are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We also want… 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…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable… 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…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… the server-id in my.cnf. You change the server-id interactively, this is an action you should never perform on a slave… on the slaves. And recently I saw a weird problem, my.cnf was correct on all the machines, but the value was…… it was always 1 !! There was a hidden character in my.cnf that was unvalidating the value and then it was set…
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 (but… “The ultimate tool for generating optimal my.cnf files for MySQL” ? 
The meaning of tuning my.cnf is not do to some magic (which… of autotuning). Not to mention that a very bad my.cnf can bring performance down even if you have correct design, index and…
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….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket… way you can verify the numbers in my next blog post. I will compare performance of various cluster sizes on both storage…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 139 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… to configure InnoDB for best performance?) – what parameters i need to insert manually in my.cnf for best performance & low disk usage? – may i…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… actually badly configured, you can hurt its performance significantly. Correcting these mistakes can correspondingly improve performance. But such mistakes are relatively few… more than simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see something wrong…
