… buffer file was used instead of one made during the prepare stage. Bug fixed #1068470 (Sergei Glushchenko). XtraBackup now accepts the –innodb… message during the prepare stage about innodb_file_io_threads being deprecated, even if the variable wasn’t set. Bug fixed #1068485 (Alexey Kopytov). XtraBackup…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…innodb_log_file_size = 8000M innodb_log_files_in_group = 2 innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_io_capacity=500 innodb_max_dirty_pages_pct = 60 innodb_purge_threads=1 innodb…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-log-file-size=128M innodb-open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 innodb…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
…), it uses MySQL C …settings innodb_buffer_pool_size = 2048M innodb_thread_concurrency = 0 innodb_max_dirty_pages_pct = 70 innodb…thread. With innodb_file_io_threads InnoDB will use 1 insert buffer thread, 1 log thread, N/2-1 read thread, N/2-1 write thread. You can start from “innodb_file_io_threads…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE…set of installations innodb…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…mysql (srv0start.c:1514) ==9090== by 0x6B48855: innobase_init(void*) (ha_innodb…waiters and mutex_set_waiters. Interestingly, there…_monitor_thread and srv_error_monitor_thread InnoDB threads storing …thread #1 ==9090== at 0x6B77778: os_file_write (os0file.c:2172) ==9090== by 0x6B35B5E: fil_io…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql…
Comment: xtrabackup-1.2
May 10, 2010 By 2 Comments
… backup, have a error.how to resovle it? OS: centos , MYSQL :MYSQL 5.1.30 ./bin/xtrabackup Ver 1.2 Rev undefined… pool (set by –use-memory parameter) InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use InnoDB‘s own implementation InnoDB: Warning: innodb_file_io_threads is…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G … you set this too high. innodb_write_io_threads: Controls how many threads …file by more than one thread (particularly if you have relatively few tables and/or use the global tablespaces) *cough ext3 cough*. innodb…
