…in trouble) or “OS file reads”, “OS file writes” from SHOW INNODB STATUS for Innodb tables. In MySQL 5.0+ you can also use Innodb_data_reads, and Innodb…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…innodb_file_per_table – If you do not have too many tables use this option, so you will not have uncontrolled innodb…in locking in 5.0 and even more to come with MySQL 5…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
…how…have been reused many times (including for two of these bugs!) This brings us to our first bug: mysql process crashes after setting innodb…to ensure that the server used –innodb_file_per_table and that we used Xtrabackup’s –parallel option. I also wanted to…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
…how data was lost: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table…partition was scanned in like 5 minutes and all 4G of innodb pages were successfully written to a …if you happen to have a lot of data to scan and you have to choose between matching text…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…MySQL With innodb_file_per_table option but your ibdata1 file which holds main (or system) tablespace have …INNODB STATUS this is how you can see Insert Buffer Size: Ibuf: size 108931, free list len 64619, seg size 173551, In…even 5 minute transaction may be considered long as it will be enough to…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…MySQL-5.1.30 with InnoDB…innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb…InnoDB, but nothing special to be proud of. We definitely we will look how to…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…In MySQL 5 number of Innodb performance counters were exported and now available in…Innodb has written in log files since system tablespace creation. You can also see up to which point logs have been flushed – so how…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…MySQL flavors. MySQL 5.5.24 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…MySQL 5.0 vs 4.1 has a lot of performance differences and not all of them are Innodb…table, but how long will this take? Is there a facility we can run to show any table / index fragmentation, without having to…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to use InnoDB/XtraDB tables… Optimize For I/O It is pretty much inevitable: if you do this kind of data processing in MySQL…files and use the CSV engine so you have an SQL interface to it (the meta-tables…have to think about how to avoid enormous tables that are hard to…
