… tool for generating optimal my.cnf files for MySQL” ? 
The meaning of tuning my.cnf is not do to …memory (mainly due to lack of any form of autotuning). Not to mention that a very bad my.cnf…myisam files (since today MySQL let the operating system use its diskcache before the MySQL engine access …
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql…=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB’…I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…my server can’t load all indexes in memory and this is slowing it down. I can tell because when I launch my…this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections…default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=8M # …
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…my.cnf,i add wsrep_cluster_address=gcomm:// to fill it ,the mysql server will not running [root@mysql1 ~]# vi /etc/my.cnf… [Note] WSREP: Read nil XID from storage engines, skipping position init 130221 17:59:05 [Note…_buffer_size)*max_threads = 329809 K bytes of memory Hope that’s ok; if not, decrease…
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… have problem with mysql server. here of my server detail : DELL R710, Memory :16GB, OS : Ubuntu server 11.04. I use Mysql server version 5.5. some table using engine… user active. here of my.cnf setting : [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] user = mysql port = 3306 socket = /var…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… mask: xtrabackup –defaults-file=/etc/my.reg.cnf –backup –tables=tpcc.order_line* –target-dir=/data/vadim/mysql/export/ xtrabackup: tables regcomp(): Success… “export” xtrabackup –defaults-file=/etc/my.reg.cnf –prepare –export –use-memory=8G –target-dir=/data/vadim/mysql/export/ xtrabackup Ver 0.8.1rc…. Now on remote server you have to run MySQL server ® with XtraDB6 storage engine, you can take one of our binary builds…
