….6 innodb_file_per_table is now ON by default. This is very big change and is good one. We have been running innodb_file_per_table=1 for most of workloads for years now. The exceptions have been when you have large number of tables or if you do many create/drop of innodb tables. optimizer_switch is the catch all variable for a lot of optimizer options…
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: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…file…innodb_buffer_page_lru where table_name like ‘%ssb%’ group by 1,2 ) sq order by pct_buffer_pool desc; +——————-+——————+——-+——+——+———+—————–+ | table…PER_THOUSAND_GETS: 0 NOT_YOUNG_MAKE_PER_THOUSAND_GETS: 0 *NOT_YOUNG_MAKE_PER… | | 8 | optimizing …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 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: Predicting how long data load would take
May 24, 2007 By 14 Comments
… is important to load data in primary key order into Innodb tables for optimal performance, but effect does not end here. If indexes… much data is loaded per hour (assuming your Innodb tablespace did not have free space or you’re using innodb_file_per_table=1). Do not… almost 1TB of Innodb data within 24 hours. It was decent speed because we had tables partitioned and so no table was more…
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…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…. A few passes per second or tens of passes per second at high query rates is likely to be optimal until full benchmarking…. innodb_open_files is now dynamic at startup, based on the table_open_cache setting because we expect most tables to be InnoDB and use innodb_file_per_table…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…files, binary log, FRM files, MySQL MyISAM system tables…table which was not optimized for prolonged period of time, so it reflect natural state of the table…table status like “post_channel” \G *************************** 1. row *************************** Name: post_channel Engine: InnoDB…
