Now that flash storage is becoming more popular, IO alignment question keeps popping … smallest amount of disk IO that systems can do. NAND flash on the other hand can have a page size of…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… there are impossible. Furthermore, this optimization is not needed for flash devices, like FusionIO or Virident cards. An additional optimization we…: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO… ? If we’re speaking about purely disk based SAN (no Flash) the drives are same drives you will see in directly… are very latency critical. Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable transactions the…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…_pool_size settings: 13G, 52G, an 144G on a tpcc-mysql workload with 1000W (around 100GB of data). This combination of… innodb_adaptive_checkpoint=keep_average innodb_read_ahead=none For MySQL 5.5.8, I used: innodb_log_file_size=2000M… the difference between different settings of innodb_io_capacity for MySQL 5.5.8. Small innodb_io_capacity values are really…
Post: Presentations Announcement: 2010 O'Reilly MySQL Conference & Expo
April 29, 2010 By 4 Comments
… the list: Achieving PCI Compliance with MySQL Author: Ryan Lowe, Fernando Ipar An Overview of Flash Storage for Databases Author: Vadim Tkachenko… Trudeau Chosing Hardware And Operating System For MySQL Author: Peter Zaitsev Diagnosing and Fixing MySQL Performance Problems Author: Baron Schwartz, Morgan Tocker…
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
… MySQL Performance Problems Peter Zaitsev: Scaling Applications with Caching, Sharding and Replication Baron Schwartz: EXPLAIN Demystified Vadim Tkachenko: An Overview of Flash Storage for Databases Matt Yonkovit: The Five Minute DBA Bill Schuler, Baron Schwartz: Performance and Feature Enhancements to MySQL and…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 16 Comments
…/sec on faster hardware and disks (say better RAID or Flash) which is a very cool number. Of course, mind you… for more performance optimizations. Dmitri has good suggestions on tuning MySQL 5.5 and this is what I used for start…_pool_instances=8 was very important. Second thing – Partitioning. Unfortunately MySQL 5.5 leaves the huge bottleneck for write workloads in…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have…-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table… comment. Next, I plan to look at IO alignment on Flash cards to see what benefits we can get there from…
Post: White Paper: Flashcache and MySQL on Virident drive
September 19, 2011 By 2 Comments
Our latest MySQL white paper is Improving Percona Server performance with Flashcache on … as a way of getting some of the benefit of flash without all of the cost, or the size limitations.
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
Many of the prominent companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software developers, hosted … worked with Percona to test and validate their PCI-E flash cards, and Fusion-IO sent us free cards to use…
