…. I used ALTER TABLE DISABLE KEYS and built the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/…user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_…
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… of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18:47:44 InnoDB: Warning: too many (68) files …
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…or alter the schema of the table after the backup has been taken. The variable innodb_file_per_table must be enabled. Then, our first… # 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 –…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… 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_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb_thread…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… innodb_file_format=BARRACUDA (don’t forget to set it in my.cnf!): SET GLOBAL innodb_file_format=BARRACUDA; One caveat: you must be running with innodb_file_per_table=1 as the InnoDB system tablespace cannot…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_mutex patch). my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem… 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…
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: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock 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: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status.
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE …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…
