… check out the improvements in mysql 5.6 http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html These… they made an SSD as fast as Ram or if one was to raid 10 a bunch of SSD‘s then we could put the Innodb straight to SSD and not even…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
…%. As you may know (check my presentation) SSD design requires background “garbage collector” activity, which …: if a single module fails, the internal RAID will allow to continue operations, and after …(important in question for log related activity in MySQL) I am looking forward to present results …
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… – it’s XFS alignment by RAID strip size, XFS aligned file allocation, raid partition should be created aligned … of data. I allocated 35GB for cache on SSD and I used 16GB and 10GB buffer pool sizes…encourage you to test yourself (my full scripts and mysql config files are on Wiki page). There are …
Comment: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
…cheaper controler, and perhaps with a more write costly RAID discipline (ie. RAID 5). A setup with storage accessible through multiple … results may be even more favouring noop if you used SSD drives. I mean, chances are that those results are …the controler do impact some I/O bound loads with MySQL
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
… RAM 4x 80 GB SSD MLC CentOS 5 x 64 bits RAID-5 HW In this server is installing MySql 5.5.21….log init_connect=SET CHARACTER SET utf8 datadir=/data/mysql socket=/data/mysql/mysql.sock [General] skip-name-resolve #skip-bdb default-time…/mysql/mysql.sock [Server] server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql…
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
… talk about putting SSD on the local servers. There are three types of failures: * mysql becomes unavailable (best case) * mysql connection are unresponsive… panics weekly. * hardware failure – typically losing a disk. Usually the RAID controller does the right thing though when hard drives don…
Comment: Intel 520 SSD in MySQL sysbench oltp benchmark
May 27, 2012 By 11 Comments
…from official website, neither this server, nor this raid controller support SATA-III (6-gbit one). 380…II. No wonder – according to published benchmarks this SSD drive should do 520-550 mb/s (without… in terms of performance too – both overall and mysql-specific). I think newer LSI cards (2108-based)…
Comment: Percona Server vs MySQL on Intel 320 SSD
February 29, 2012 By 21 Comments
Wlad These SSD reviews of yours are just superb. My favourite on the MySQL Performace blog! You can also do a review on the best available hardware raid-sets and give your advise.
Comment: Clustrix benchmarks under tpcc-mysql workload
October 27, 2011 By 9 Comments
Andy, on high concurrency in MySQL what really comes into play is internal locking, and under-… did not look what is bottleneck with 7 Intel 320 SSD drives, as main focus there was on Clustrix systems. However… worth to mention that it was software RAID0, not hardware RAID.
Post: Looking on 5.4 - IO bound benchmarks
April 30, 2009 By 5 Comments
…our Dell PowerEdge R900 box (16 cores, 32GB of RAM, RAID 10 on 8 SAS 2.5″ 15K RPM disks). …being update with my next CPU benchmarks, and benchmark on SSD & FusionIO), also I post graph there: Results are in …per minute, more is better). So I can confirm that MySQL team did great job with 5.4 and it …
