…and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple…transaction commits and so the purge begins. The tests were performed on Percona’s R900 machine. The scripts and results are on Benchmark Wiki and…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of Innodb performance counters were exported and…and some other system structures. Pending reads and writes are pending requests on buffer pool level. Innodb may merge multiple …
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…performance effect of it is yet unknown – how transactional system implements logging and dirty buffers flushing has serious impact on performance…read and row write. The file is taking about 8 bytes per row as I understand so it should be very small and…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… in the processlist for multiple statement transactions. Looking at SHOW INNODB STATUS you would notice large amount of log writes and fsyncs per second… do not read this post as MySQL 5.0 is junk in terms of performance and you should stay on MySQL 4.1 until MySQL has…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
…performs a checkpoint , I thought it might be useful to explain another important mechanism that affects both response time and throughput – The transaction…multiple times since at restart and…transaction will never complete. Both the MySQL configuration and…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… performance independently from anything else. Performance This…read caching more efficient in its memory while write buffering can too be done by MySQL and…MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable transactions the log write…multiple power supplies ECC memory kill-chip and…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
…write size. InnoDB writes to the log files in multiples of 512 bytes. Mark Callaghan explained this and some of its performance…writes might accumulate and become much larger. What happens if the log buffer is actually smaller than a transaction…
Post: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
January 18, 2007 By 15 Comments
…and what is also important atomically, remember at that time MySQL only had ISAM tables with table locks and no transactions…perform row replacement without reading old data first, and of course because you could set it to replace multiple…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…perform as good as SSD ? Not really. Leaving all potential serialization issues along you need enough concurrency to utilize multiple hard drives and…and another one for Transactional Logs you will often wast 4 hard drives from performance standpoint without a good reason. Having OS and…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…multiple threads and multiple concurrent transactions ? HT: The scalability in my opinion is ‘mediocre’, and…performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of the checkpointing rate? Postgres exposes this data and…
