… anything suspicious in the /var/log/mysqld.log file which i believe is the error log you are talking about? 120502 11… MySQL could be using any other conf file other than /etc/my.cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I set to 128M, which does…move them). The end result was: I could only use mysqldump to import all the data into a …
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… of my mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per_table directive set in the my.cnf configuration file. I have the backup folder which contains xtrabackup log files, xtrabackup checkpoint file and a folder for my database… the InnoDB tables. Is there something which I am missing? Do I have to set any directive in the my.cnf file to access…
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: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
… hints regarding my.cnf tuning, only some trolling on how bad “automated scripts” are and how superior the writer is into tuning my.cnf (but… tool for generating optimal my.cnf files for MySQL” ? 
The meaning of tuning my.cnf is not do to some magic (which cannot be said too… my.cnf can bring performance down even if you have correct design, index and optimized queries. Innodb on the other hand (when used…
Comment: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… parameter which tells me exactly which my.cnf files are being used by the server (I hate hunting them down). Is it /etc/my.cnf? /etc/mysql/my.cnf? /usr/local/mysql/data/my.cnf…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… the my.cnf file. Remember that Pacemaker will start MySQL, not the regular init.d script pid: The pid file. This is use by Pacemaker to know if MySQL is already running. It should match the my.cnf pid_file setting. socket… slaves. The only thing that may change here is clone-max=”3″ which should match the number of database nodes you have…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… values which are more self explanatory so at least you can’t mix what do you currently have set in your my.cnf… innodb_autoinc_lock_mode freshly added in 5.1.22 (which is what motivated me to write this post) – looking at the…,2 which have to be translated to “traditional”, “consecutive” and “interleaved” ? Using string values would make things much more friendly with my.cnf and…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…as in this benchmark. Could you post the my.cnf file used and the computer hardware specs that produced this benchmark…arrose in how fast the data was coming in which was no more than 3000 packets of data …data to be inserted faster than it is coming in. Please post the my.cnf file that you were able …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… 5.1 or aren’t using RBR, then it is possible to set up a dedicated MySQL slave which has log_slave_updates…_format=1) unique server_id in the my.cnf log_slave_updates=1, if this is a MySQL slave transaction_isolation=READ-COMMITTED… localhost. It is possible to read from and/or write to remote servers, but this example uses the local machine which is the usual…
