…Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does not have to keep open file…optimizations in this space. To keep test alligned to my previous experiments I was running with table_open_cache=64 and tried innodb…
Post: Spreading .ibd files across multiple disks; the optimization that isn't
December 25, 2010 By 22 Comments
… – “If you enable innodb_file_per_table, each table is it’s own .ibd file. You can then relocate the heavy hit tables to a different… the temporary table is renamed. Your “optimization” is lost. Striping (with RAID) is usually a far better optimization. Striping a table across…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…tables locked by transactions. Innodb does not lock tables for normal operation so number of tables locked normally stays 0, unless it is ALTER TABLE…innodb_file…innodb_log_buffer_size is optimal…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
…optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal…may suffer. innodb_file_per_table – If you do not have too many tables use this option, so you will not have uncontrolled innodb main …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_doublewriteblogpercona.commanual innodb_fast_shutdownblogpercona.commanual innodb_file_formatblogpercona.commanual innodb_file_format_checkblogpercona.commanual innodb_file_format_maxblogpercona.commanual innodb_file_per_tableblogpercona.commanual innodb…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb… better for operations. innodb_log_file_size = 1600M – another Benchmark optimization. Such large …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…1 (1-0-0) 2 2-2 64 Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== ==== ======= ====== ======= …innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log-at-trx-commit=1 innodb-flush-method=O_DIRECT innodb…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… InnoDB settings for the initial run. Later I will change them in searching for optimal values. innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log…
