… InnoDB: buffer… 120502 11:51:16 InnoDB: Started; log sequence number 119 647537164 1120502 11:51:17 [Note] /usr/libexec/mysqld: ready for… 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 # Set .._log_file_size to 25 % of buffer pool size innodb_log…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… works on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system… 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… imp 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…
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…? Do I have to set any directive in the my.cnf file to access the InnoDB table? Please help. Thanks in advance. Abhilasj
Comment: What to tune in MySQL Server after installation
April 15, 2012 By 116 Comments
… for your tips. BUT: Please add a big warning that just changing “innodb_log_file_size” is not enough (see other comments for more info)! Since this post still ranks very high it would be important. Otherwise people like me will update their my.cnf…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… by hand. But for most workloads with a complex access pattern, we’ll need to estimate or wait for InnoDB to expose this… has the potential to block other queries for a significant amount of time. Setting innodb_concurrency_tickets too high can have startlingly….sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… set of empty tables which is about 10 times smaller for MyISAM. I found no significant difference whatever limit of open… the maximum InnoDB: allowed value would be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18:47:44 InnoDB: Warning: too…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… can have innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status.
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 139 Comments
… my.cnf: [mysqld] datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility… applied, and my.cnf are not modified. Why? Where are written this configs? – do i switch table from MyISAM to InnoDB (if yes, how to configure InnoDB for best performance?) – what parameters i need to insert manually in my.cnf for best performance…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults-file=/etc/my.cnf –export /tmp/ Then apply the logs to get a consistent backup: # innobackupex –defaults-file=/etc/my.cnf –apply-log… is not stored in .ibd file. innodb_import_table_from_xtrabackup=1 should be enabled for such advanced import process to work…
