…But lets assume you have not followed these recommendations to the book or some things just slipped… more complicated test which runs this query concurrently many times or even workload consisting of …. You may consider disabling innodb_stats_on_metadata and increasing innodb-stats-sample-pages to get…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… 5.2 as OS. This is quite typical server we recommend to run MySQL on. What is important I used Noop…_size = 16M innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
…:autoextend innodb_file_per_table=1 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=256M innodb_thread_concurrency=0 innodb_flush_log_at_trx_commit=1 innodb_flush… to be tested). What about LVM there ? Well, we often recommend to use LVM for backup purposes (even recent results are…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… = 131072 default-storage-engine = InnoDB #thread_concurrency = 32 innodb_buffer_pool_size = 4096M innodb_lock_wait_timeout = 120 innodb_use_sys_malloc = 0 … compatibility package). #old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment …
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…calculations therefore sometimes some tune is needed. In InnoDB these statistics are calculated automatically, check the … to trigger this problem we need: – Lot of concurrency – A long running query – Run an ANALYZE …going to work on is very used the recommendation is to run it during the low peak…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… Percona XtraDB Cluster server 5.5.24. Innodb durability was disabled for all tests (innodb_flush_log_at_trx_commit=2). All….99; gcs.fc_master_slave = yes” based on Codership’s recommended tuning for single-node writing. I was running wsrep_slave… to log-bin and innodb_support_xa being disabled in the PXC environments Semi-sync performs dismally under concurrency. Think about it…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… server restarts, has been removed. Instead, we recommend using the LRU Dump/Restore patch which … printed for the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) … found here. Bug Fixes On a high concurrency environment with compressed tables, users may experience …
Comment: Testing FusionIO: strict_sync is too strict...
June 18, 2009 By 8 Comments
… mysql, but mysql settings are innodb_write_io_threads=16 innodb_read_io_threads=16 so final concurrency on device may be different… needed, I will re-test it. Currently we can’t recommend FusionIO to customers who have strong durability requirements.
Comment: Heikki Tuuri to answer your in depth Innodb questions
September 28, 2007 By 51 Comments
… has a hi amount of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying…. Follow up question: My impression (from an external user of Innodb point of view) is that performance bugs don’t receive…
