… in following graphs. Hardware for tests: HP ProLiant DL380 G6, filesystem: ext4, mounted with nobarrier. The results for random write case… oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards. If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It will…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… de facto filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD, or… one more point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5…: 97 MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also… Core Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool. Using 16K read sizes (matches…Innodb team will put on their roadmap. With SSD coming this will be important. And it …
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…later Dimitri in his article MySQL Performance: Analyzing Percona’s TPCC-like Workload on MySQL 5.5 sounded doubt … all as all writes are managed by the filesystem, and filesystem will use its own block size.. – Of … IO block size. And I know that other SSD/Flash drives like to have IO multiplied to …
Comment: Working with many files and file system fragmentation
March 18, 2008 By 11 Comments
… be arranged as 1 file per filesystem c. recently Mysql 5.1 table partitioning allowed to use SSD for most recent data (most… record inserted/updated can trigger updates on several indices. No filesystem is immune to fragmentation unfortunately, the only way to reduce…
Comment: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
…. For example how much storage can you get with Intel SSDs ? RAID5 from 8 64G drives will give you 448G of… very interesting to see how raw IO, filesystems as well as MySQL scale with multiple Intel SSD drives of FusionIO cards. I have…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence …. These can also be rendered useless by filesystems that don’t allow parallel writing to …estimate’ (good default) and ‘keep_average’ designed for SSD type storage. Running Percona Server and using …
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
…100%. As you may know (check my presentation) SSD design requires background “garbage collector” activity, which requires… Centos 5.3 2-6.18.164 Kernel Filesystem is XFS formatted with mkfs.xfs -s size…(important in question for log related activity in MySQL) I am looking forward to present results in…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
…not impressive, I had to move to standard for filesystems 4K blocks. For benchmark I used sysbench oltp with…70GB 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 …
