… master-user, master-host and master-password settings in my.cnf, this may cause huge problems (it’s anyway no longer supported from…, master-password, master-host and master-port in the my.cnf file? # cat my.cnf [...] master-user=rsandbox master-password=rsandbox master-host=127… what you want. So never set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 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… during query analysis, and also might show me things like huge tables that should be archived, tables that I should be…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… sizes used. sync_master_info = 10000 Quite useless change in my opinion. Syncing master info every 10000 events is no better… also promises updated sample my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes about my-huge my-large etc referring to amounts of memory we have in the phones these days, I made in my Optimizing…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… other words; you may not be able to run your huge-buffer-pool under Valgrind without it complaining quickly. If you… user mysqld will now run under (check ‘user’ setting in my.cnf also) (see here if this is not clear) Now, before…}’ could for instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to point mysqld…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… itself really isn’t something you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt… more than simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see something wrong… improvement in your database’s performance. Conclusion Don’t expect huge improvements from a review of your server’s configuration, unless…
Comment: FreeBSD tests
August 3, 2006 By 15 Comments
Which my.cnf was used ? There is big difference between default my.cnf and my-huge.cnf when benchmarking with super-smack and myisam
Comment: MySQL Server Variables - SQL layer or Storage Engine specific.
December 1, 2006 By 14 Comments
Vadim, I configured already a kernel to enable huge pages. I can use huge pages with a size of 2MB. I made… total I also put the parameter larges-pages in the my.cnf and when I check in mysql I saw the following… me is: How can i see that mysql use this huge pages. Information about the server that I use: Linux DL585…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… store some data in them otherwise there will be a huge waste of space. I used MySQL 5.4.2 for… 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: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… very long execution times for even simplest queries, or a huge deadlock. In such rare cases SHOW ENGINE InnoDB STATUS often… you can have innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output… 0:01 /usr/sbin/mysqld –defaults-file=/etc/mysql/my.cnf In my case the process ID is 11886, so I will be…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
….h patching file scripts/mysqldumpslow.sh patching file sql-common/my_time.c patching file sql/filesort.cc patching file sql… enables the logging. If you don’t specify it in my.cnf file, the remaining part of the configuration will not matter… a lot of IO bandwidth and the file may grow huge very quickly when logging all the queries. This parameter allows…
