…. I frequently see batch jobs killing server performance overtaking buffer pool. Though full …state of Innodb scalability with multiple threads and multiple concurrent transactions ? HT: The scalability in my…HT: According to tests by Peter Zaitsev, O_DIRECT works well to remove double buffering…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
…may be slow due to random logical I/O. Implementing preload of full .ibd file with … restore single table from backup, possibly on different server (different slave). It’s all about time – …www.mysqlperformanceblog.com/2006/11/21/opening-tables-scalability/. Partially it can be fixed by recent patches…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…I’ll update the page Scalability – Scalable Read Only Transactions – Concurrent Innodb data…Replication Event Checksums – Time Delayed Replication – Server UUID – Improved Logging for Row …- – Show Host Cache Contents – - Improved File I/O Instrumentation – Improved EXPLAIN – - Explain for UPDATE/…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…them a basic question – if you have a server with 16GB of RAM which will be … innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The actual number…is 8 is decent start innodb_flush_method=O_DIRECT Avoid double buffering and reduce swap pressure…
Comment: Another scalability fix in XtraDB
January 24, 2009 By 13 Comments
… higher end configurations they could get significant throughout increases w/o archtiectural changes. Right now I’m running into cases where… as innodb servers, but all the scalability benchmarks seem to indicate I’d be better off sticking with 8 core servers leading to… ap These days its hard to buy a commercial grade server with < 8 cores, or at the very least its make…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… use them for benchmarking. On the desktop, I installed Percona-Server-11.2 which I configured with the following Innodb settings…_size=64M innodb_log_buffer_size=8M innodb_flush_method=O_DIRECT innodb_flush_log_at_trx_commit=0 max_connections… afraid the same scalability issues affects actives connections although these are also affected by concurrency issues. With new servers having 24+ cores…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
… different innodb_buffer_pool_size (while having innodb_flush_method=O_DIRECT) and see how performance depends on buffer size so… memory or more servers. Of course this is all oversimplifications – you’ve also got to look at CPU scalability in particular if…
Post: Countless storage engines
May 3, 2007 By 6 Comments
…can imporove performance of tasks with intensive I/O load a lot. Second feature – fast index build…, as license price is 20.000$ per server ( the price I heard somewhere, not sure …” data structure. The developers promises ultimate speed and scalability for index access operations. It’s interesting …
