… usage Innodb tables may increase in size significantly due to fragmentation. Usage Differences What works well for MyISAM may not work for Innodb… 3 most important values to check are innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log_file_size. There are a lot more options…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
… with 16 running threads. MySQL params are: innodb_buffer_pool_size=16G innodb_log_files_in_group=3 innodb_log_file_size=512M So let’s take standard MySQL 5.4.1, it starts: 090706 15:39:47 InnoDB…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…/mysql- –with-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency…=pOIo5aX59b6Z8eWjePZU-JQ or on our page http://www.mysqlperformanceblog.com/files/benchmarks/innodb_scale.html (Note: This benchmark is synthetic micro benchmarks…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual innodb_log_buffer_sizeblogpercona.commanual innodb_log_file_sizeblogpercona.commanual innodb_log_files_in_groupblogpercona.commanual innodb_log_group_home_dirblogpercona.commanual Innodb_log_waitsblogpercona.commanual Innodb_log_write_requestsblogpercona.commanual Innodb_log…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… Log section provides information about log subsystem of Innodb. You can see current log sequence number – which is amount of bytes Innodb has written in log files… in log files. By monitoring log sequence number and value up to which logs have been flushed you can check if your innodb_log_buffer_size is…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…=1 innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048…=1 innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 64M innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=16 innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_read_io_threads = 16 innodb_write_io…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_HISTORY_LONG_SIZE | 10000 | 100 | | PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | 1000000 | 1724 | | PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | 100000 | 2223 | | INNODB_LOG_FILE_SIZE | 5242880 | 50331648 | | BASEDIR | /mnt/nfs/dist/5.5.30 | /mnt/nfs/dist/5.6.10 | | BACK_LOG | 50 | 80 | | OPEN_FILES_LIMIT…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… innodb_data_file_path=ibdata1:10M:autoextend 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=4G innodb_log_block_size=4096 innodb_thread_concurrency=0 innodb…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… too high innodb_buffer_pool_size = 8000M #innodb_additional_mem_pool_size = 80M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb…
