… PCI-e flash card as storage. By default linkbench dataset has 10M ids(after load of data size of datadir ~10GB). We…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops…=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…All tests were conducted with approximately 78GiB of data (32 tables, 10M rows each) and a… configure MySQL as if it were using SSD storage or to just use an optimized HDD storage … this Virident card (configuration C): innodb_io_capacity = 30000 innodb_adaptive_flushing_method = keep_average…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
…an SLC-based PCIe solid-state storage device which claims to provide …s take a look at the data. With the sysbench fileIO test in… performance: Synchronous read reaches peak capacity somewhere between 32 and 64 threads…How well does it perform with MySQL? Exact results vary, depending upon the…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… cases. When storage type changes, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for… way to check for known incompatibilities and fix them. The data storage is however only small part of the problem – much bigger… measuring its capacity) Setting up the Slave(s) If you want to minimize downtime it is best to use MySQL Replication for…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status … raw input data), which is quite nice. Each shard contains only 128MB of data! Storage engine makes…-import-table-from-xtrabackup=1 innodb-io-capacity=1000 innodb-log-buffer-size=32M innodb…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, …data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data… standaloneblogpercona.commanual storage_engineblogpercona.commanual…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… data, you are most likely using the InnoDB storage engine, since MyISAM is not transactional and do not sync data to disk. Similarly, MySQL… hardware) the write capacity of a database server. In term of write capacity here are you choices. Write capacity MySQL replication Fair Master-Master…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…much inevitable: if you do this kind of data processing in MySQL, you’re going to end up heavily I…Sharding is inevitable if your write workload exceeds the capacity of a single server (or if you’re … An impression per day becomes a fixed overhead of storage size. So, you actually have as many rows…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… – if you have MySQL/server restart you may have warmup being quite shorter than in case of local storage. It is also… looking for maximal data consistency (as SAN users often are) you better have binary log flushed on commit too. MySQL also has… it great. My Advice for Scaling IO capacity with SAN (this applies to directly attached storage too) is to really understand what…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… cases when storage size becomes the limit rather than number of IOs it can handle. Imagine for example data archive storage. On BoardReader for example we’re limited by space and how much data we can comfortably put in MySQL Instance… not always the case. Another mistake is to measure IO capacity in spindles – So your hard drive can do 200 random…
