… RAID0 to store InnoDB datafiles. For InnoDB logs and system tablespace I used partition on …_flushing in InnoDB-plugin is not quite balanced, it may do overaggressive flushing, when it …user) usage: Even with improvements, XtraDB performs less 150MB/s in disk writes (from benchmarks we saw FusionIO …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…) system performance to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk IO estimation. When you can… hardware will take you to reach appropriate performance, what kind of hardware provides better balance of CPU vs IO utilization as well…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… a pain in replication. To start we have to write second binary log file when all transaction engines have their own ! Quality… complicated plus you have to deal with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…_tickets too high can have startlingly negative performance implications. On the other hand, if we…as with most other parameters, this is a balancing act. It really comes down to …log_files_in_group=2 innodb_log_file_size=1900M innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb_write…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…, which is our new high-performance transactional storage engine Maatkit, which …obvious example is our enhanced slow-logging functionality, which is part of …, but not often, that someone just writes new functionality for free in spare … is a great balancing act, and finding a balance that seems to …
Comment: High-Performance Click Analysis with MySQL
December 23, 2008 By 13 Comments
…lookups but you need to keep the balance of keeping data compact. 4) MyISAM vs …as default but tradeoff between space and performance can be important for some applications. Actually… surely will be bound by sequential disk writes) – this gives convenience of running SQL … keeps all events as logs…
