… might be due to the “innodb_flush_log_at_trx_commit=2″ into the config file. The “innodb_buffer_pool_size” is set… you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30… = /mnt/log_mysql innodb_log_file_size=1G innodb_log_buffer_size=64M innodb_flush_log_at_trx_commit=2 [mysql.server] user=mysql basedir=/var…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 21, 2008 By 34 Comments
… think there is a difference between “better than default my.cnf” and “optimal my.cnf” – It is indeed possible to automate things, often by… be better than default my.cnf in 99% cases. However it is not possible to get the most optimal config file automatically. This… answer. For example recovery time (smaller innodb_log_file_size than optimal), fast warmup after MySQL Restarts (so you need double buffering…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql…innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
… param for InnoDB are [root@ng-lg-mdb1 ~]# cat /etc/my.cnf|grep innodb innodb_data_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool… sec) Please help to improve performance and suggest if any config changes are to be made. Thanks
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… config (my.cnf) were all disabled from 20 servers: # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb…
Comment: MySQL versions shootout
October 12, 2011 By 6 Comments
… thread. I remember number of people saw regressions going to MySQL 4.1 and there might be a lot of reasons… on MySQL 5.5 and above ? Also I’m not sure the config file posted (my.cnf) is correct at all. It contains: innodb_log_file_size = 4000M #innodb_log_file_size = 1024M #innodb_log_file_size = 256M innodb…
Comment: Should MySQL update the default innodb_log_file_size?
November 22, 2011 By 37 Comments
… my.cnf variants. Even Amazon RDS has some undersized defaults (the log file size is 128MB and it’s not configurable; also innodb… out-of-the-box config that overwhelms the user’s hardware could hurt the XAMPPiness of MySQL. (b) All MySQL instances are on… I wanted to make the point. (c) Everyone uses the InnoDB plugin, and enjoys its 10x recovery time relative to non…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
…. So what you can do ? Use Innodb Table Instead Innodb is quite fast when it fits …in your my.cnf; run SLAVE STOP; dump all your memory tables using MySQLDump; Restart the MySQL As planned; Load Dumped tables; run SLAVE START; Remove skip-slave-start from config file…
