… an optimal my.cnf is not a tool. It’s a human with many years of experience, deep knowledge of MySQL and the… 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: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order …->84.91% (349,404,796B) 0x7A3CB0: my_malloc (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld) |…you’ll likely find that the default options will perform well in most scenario’s. For the technically…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… huge wins. If MySQL is actually badly configured, you can hurt its performance significantly. Correcting these mistakes can correspondingly improve performance. But such… more than simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see something wrong…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… files. First you need “core-file” option to my.cnf which will instruct MySQL to dump core on crash. This alone will unlikely… could not really get core dumped to /var/lib/mysql (datadir) on my system (Ubuntu). You might be lucky and it might… if you expect to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it is very helpful…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… tests were performed on Percona’s R900 machine. The scripts and results are on Benchmark Wiki and the relevant my.cnf settings were… to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important… I am sure that next MySQL 5.6 versions will contain a fixed and much better performing implementation, which I am looking…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 User correctly authenticated: 121227 8:31… is that it will log everything so it can cause performance degradation and you will have to deal with very large… in my.cnf: 5.5 userstat = 1 5.1 userstat_running = 1 Then we get the information about a particular user: mysql> select…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… my.cnf file by default. One example is Debian and its variants. Furthermore the default my.cnf files of MySQL like my-large.cnf, my-innodb-heavy-4G.cnf… in some workloads limiting the value can give use some performance benefits. As we always say, set up benchmark tests to… of MySQL tuning howtos that explain how to tune the variable to get better performance. If you have the variable in your my.cnf…
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… event with the wrong server-id are performed on the two slaves (mysql 3 and mysql 4) and the new events (with server… returned by SHOW MASTER STATUS on mysql 4 (this position will increase every time writes are performed on the active master, so…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… bit instances. MySQL will fail to start on a micro instance, simply decrease the values in the /etc/my.cnf file if you…,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine… way you can verify the numbers in my next blog post. I will compare performance of various cluster sizes on both storage…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
….bootstrap=true’. Q: Can you quickly show the my.cnf settings again? A: Sure, see this post …split. Q: How does latency and bandwidth affect performance? Is it practical to buildthe cluster over … on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: …
