… and master-password settings in my.cnf, this may cause huge problems (it’s anyway no longer supported from MySQL 5.5). If you… my.cnf [...] master-user=rsandbox master-password=rsandbox master-host=127.0.0.1 master-port=35301 [...] Let’s disconnect the slave: mysql… want. So never set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… 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 MySQL…
Comment: Falcon Storage Engine Design Review
January 13, 2007 By 19 Comments
… same time we can see that the current configurations of mysql is not good either. For example take the case of… be interresting if some auto settings could be developed within mysql so we could get the best from each world… in… is included mysql (my-huge.cnf etc) seems a bit outdated regarding how the memory is being used in today versions of mysql 5.x…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…; you may not be able to run your huge-buffer-pool under Valgrind without it complaining quickly…. instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to… ->84.91% (349,404,796B) 0x7A3CB0: my_malloc (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld) | …
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… really isn’t something you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its performance… cases, so keep in mind that the vast majority of MySQL installations don’t suffer from the variety and severity of… 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… an hour for core dump to complete and when having huge file to work with is not very convenient. The alternative…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way… OS. Examining MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here… during query analysis, and also might show me things like huge tables that should be archived, tables that I should be…
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… the limited MySQL command output. First one is that you can have innodb-status-file option set in your my.cnf. This will… MySQL process ID is: garfield ~ # ps ax | grep [m]ysqld 11886 ? Ssl 0:01 /usr/sbin/mysqld –defaults-file=/etc/mysql/my.cnf In my…
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… also put the parameter larges-pages in the my.cnf and when I check in mysql I saw the following: show variables like… see that mysql use this huge pages. Information about the server that I use: Linux DL585 2.6.15.1-huge-page #1…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… data in them otherwise there will be a huge waste of space. I used MySQL 5.4.2 for tests which should… 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…
