… the result is taken only for last 2000 sec to remove warm-up phase. Measurements are taken every second. Parameters to… big log files. MySQL configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
…from the number of indexes 7 defined in the MySQL This customer was running Percona Server 5.1 and…the entire Innodb Data dictionary to the mysqld error log file. If I had to do it over again, I…whole table based on the .frm table definition and removes the existing index in Innodb, which might not be…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… settings were innodb_buffer_pool_size=16G innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1 innodb… to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve made a tiny change along… have major issues and just removing the purge sleeps is not enough to solve them. However, MySQL 5.6.2 is experimental…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there …? innodb_file_per_table =1 Great! We found it is better choice in 95%+ of installations innodb_log_file_…_files_limit = 5000 strangely enough this is where the smart selection of variable default seems to be removed…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… using innodb_file_per_table. Implementation Before going into showing how Lazy Drop Table and the new DROP Table in MySQL >= 5… Oracle MySQL >= 5.5.23 The main function that is responsible for cleaning the bufferpool is buf_LRU_flush_or_remove_pages…_dirty_pages_pct was set at 90, while the InnoDB log files were sized at 4G. The configuration and dataset sizes were…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…mysql-data-201202230157″ successfully removed [root@sb logs]# mount /mysql/data [root@sb logs]# /etc/init.d/mysql start Starting MySQL (Percona Server) [ OK ] You should shutdown MySQL…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… master log files up to which replication was done: InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position 0 115, file… of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA… back on recovery was not, so it prints you some log file name and position but they have nothing to do with…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 …innodb_log_file_size. I won’t give you a full rundown over every option in the file. But …client’s developers are in the process of removing from the application completely. That’s all! …
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…. The annoying thing about .ibd files you can’t easily copy the an .ibd file to another MySQL server. If you try to very often you’ll get an error in the log: InnoDB: Error… the .ibd file to an alien ibdata1. There are several situation when you have to: 1. ibdata1 is erroneously removed 2. ibdata1…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… it and removes it, then re-creates it and keeps printing more lines. If you ‘cat’ the fifo file, you…the entire 4GB file in one chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set… a quick Perl script on the vmstat and mysqladmin log files to grab out the disk activity and rows-per…
