… configuration C (shown in the graph as the blue line – SSD config) which shows the most consistent performance. The others all have…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
… is suitable to use with MySQL. Benchmark date: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare with… GB246413519394151.27 Conclusion In conclusion I see that Intel SSD 910 handles MySQL workload quite well, I did not face any problem… Intel SSD 910 is suitable to use with MySQL / Percona Server. Link to raw results and stats Raw results, config, OS and MySQL metrics…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…_checkpoint (estimate) were the default values. The raw results, full config files, and scripts are in our Benchmarks Wiki. The graphical… FusionIO or Virident cards. An additional optimization we have for SSDs is big log files. For this run, I used innodb… is the config file used for benchmarks on FusionIO: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…, but later Dimitri in his article MySQL Performance: Analyzing Percona’s TPCC-like Workload on MySQL 5.5 sounded doubt that it…, and run tpcc-mysql benchmark with 500W using Percona Server 5.5.8. Here is relevant part of config what I used… sensitive to IO block size. And I know that other SSD/Flash drives like to have IO multiplied to their internal…
Comment: Why you don't want to shard.
August 7, 2009 By 34 Comments
… sharding for as long as possible. Recent development in the MySQL and File Systems point toward migration to ZFS hybrid storage… run MySQL with perfect scalability with this machine setup: http://www.flickr.com/photos/gavinmroy/2871736448/ That’s the standard DB config that PostgreSQL can scale to. 32 cores with 100 spindles. If we now use SSDs in the caching…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
… GB on server), and compared 1 and 16 users in MySQL-5.1.46/PBXT and Percona Server / XtraDB – 5.1… systems. As storage system it was Intel SSD X25-M card. While full results and config are on Wiki: http://www.percona…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… about 70GB of data. I allocated 35GB for cache on SSD and I used 16GB and 10GB buffer pool sizes. I… I encourage you to test yourself (my full scripts and mysql config files are on Wiki page). There are binaries for CentOS…
