… the main stream developers are tuning their engines towards them (which is not what they’re there for.) It becomes a kind of… major benchmarks for their tuning, so why not make them dance to our tune instead, become the Puppeteer and not the Puppet, writing and… drop-in replacements for MySQL like Percona and MariaDB which are either tweaking or flat out overhauling their query engines in their…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
…MyISAM. If you have a huge number of concurrent writes and selects and query performance must be consistently …, tables which are easily maintained, is more easily tuned and a system that will run even when …right. My point is, MyISAM is still a good engine for a lot of situations and InnoDB is not …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive workloads especially for large… depend on hardware and mix of storage engines, while per session variables are typically workload…. I normally leave per session variable tuning to second step after I can analyze…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… for Innodb storage engine to be more specific. Lets look at update queries (from replication thread for example…’re using RAID10 – most commonly used RAID level for write intensive database systems, you will have 2 … effect well. So as you might see tuning IO subsystem can indeed be fun – there …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… is also responsible for writing consistent snapshots of the index files to disk. The frequency of checkpoints, as with other engines like InnoDB…. On the other hand, I aim to provide expert tuning parameters for installations that need to extract maximum performance from the hardware…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
…, especially for write pressure case As you may know FusionIO recommends to have space reservation to get sustainable write performance (Tuning Techniques for Writes). … tuned by Virident engineers, while FusionIO card was tuned only by me and I may not have all knowledge needed for FusionIO tuning. …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… Mixing Storage Engines ? Sure you can mix storage engines but I suggest …Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really. MyISAM for… times for Innodb tables in particular for write intensive workloads. Check here for details. …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… for different storage engines is a pain in replication. To start we have to write second binary log file when all transaction engines…to different storage engines and performance tuning becomes more complicated. Now what is interesting for probably 95% of applications single storage engine would …
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… concurrency tickets used for each: mysql> CREATE TABLE test_table ( -> id int -> ) ENGINE=InnoDB; — 0 Tickets …words, if you’re optimizing for throughput in this scenario, you will tune innodb_concurrency_tickets to…=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read_io_threads=…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… number of rseg may be helpful for CPU scale of write-intentional workloads. See benchmark results…._accel_rate — This parameter is additional tuning the amount of insert buffer processing by … in further releases. We are open for features requests for new engine and ready to accept community …
