… tuned system you have if you put too heavy of concurrent load on it the response times will increase and user… to use. Do push concurrency too high Many developers will test script with multiple level of concurrency and find out doing work… to serve other users too you typically need to reduce concurrency to where it does not overload the system. Unless it…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… has a hi amount of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying… – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… on case by case basics before recommending the move. Is MyISAM used as …), generally slower writes, slower blob handling, concurrency issues, problems dealing with very large number…Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_size=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io…-128GB RAM per box is not something rare already and recommendation to fit at least active dataset in memory is one…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… enable innodb_locks_unsafe_for_binlog option, which will relax locks which Innodb sets on statement execution, which generally gives better concurrency. However as the name says it makes locks unsafe fore replication and point in time recovery, so use innodb_locks… you really know what you’re doing. I would not recommend it unless it is really needed as you might not…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…-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=8 –max-connections=1500 –table-cache… by 10-23% for full table scan queries. I unambiguously recommend to switch to 5.0.30 – 5.0.32 release…
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… hundreds of queries stuck in the innodb queue, with innodb_thread_concurrency set to 8 Happily enough innodb_thread_concurrency is the variable which can… very interesting case about optimal innodb_thread_concurrency. I continue reading (and hearing at the conferences) conflicting recommendations – some suggest to set 0…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…Try number of CPU’s*2 for thread_concurrency thread_concurrency = 8 ft_min_word_len=3 #skip-… = # # binary logging – not required for slaves, but recommended #log-bin # Point the following paths to…innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb…
Comment: Returning to InnoDB scalability
August 6, 2006 By 42 Comments
… raised innodb_thread_concurrency to 12. Currently I’m not seeing any of the problems I was seeing before when innodb_thread_concurrency was over 4. On a side note, would you still recommend following the innodb_thread_concurrency = ( 2* cpu ) pattern…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
…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…
