… stuck in the innodb queue, with innodb_thread_concurrency set to 8 Happily enough innodb_thread_concurrency is the variable which can be set online so it is… you. As I mentioned in the start of this post changing innodb_thread_concurrency is happily online operation.
Comment: Drilling down to the source of the problem
November 14, 2008 By 7 Comments
… restart with zero innodb_thread_concurrency or did you change it online ? I’ve seen minor glitches sometimes (even in stick release) changing it online, though I thougth these were only related to counting transactions. About patch name – it is part of Innodb IO Patches: innodb…
Comment: Drilling down to the source of the problem
November 11, 2008 By 7 Comments
Peter, thanks – indeed quite an interesting case and makes feel good knowing we have the patch for it 
Also, I didn’t know innodb_thread_concurrency can be changed online – this is useful to experiment with.
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…InnoDB buffer is 256 page read requests for the aio read thread…innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…change was – I have significantly reduced InnoDB…innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…threads running concurrently…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…of this has been changed to make PBXT more InnoDB-like, but other … more details later. How does online backup work in PBXT, and …have a maintenance thread like InnoDB‘s main thread? PBXT has several system threads, that… criteria are things like backup, concurrency, ACID compliance and crash recovery….
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…. Now what is about MySQL/Innodb specifics ? First, in MySQL if … we have partial fix for) meaning concurrent transaction commits will need to be …re running replication Slave as slave thread will issue single IO request …big pain of semi-online MySQL/OS upgrades and Schema changes. Backups SAN …
