… better understanding of when using the Hash Join will be best and when not. Although Hash Joins are available since MariaDB… first take a look at the configuration used with different MySQL flavors. MySQL 5.5.24 Configuration innodb_file_per_table=1… and the MySQL datadir is on a 4-disk Software RAID5 volume, the disks are 5.4K RPM disks. The filesystem used…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… 600GB HDD drives: Seagate Cheetah 15K 600GB 16MB Cache SAS Filesystem: XFS, mkfs.xfs -s size=4096, mount -o nobarrier Benchmark… mention that on these datasizes, sysbench workload is pretty nasty, MySQL will mostly reads and writes pages from buffer pool (replacing… us to see the best possible scenario for SSD running under MySQL, the final result will show the best possible gain. I do…
Comment: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… or replicated storage is best solution for most MySQL High Availability needs. The reasons are: – Bad memory or MySQL Bugs on Primary can… even for Innodb tables – on large system tuned for performance filesystem recovery from journal and Innodb recovery can take 20+ minutes… over. In this case you will be able to get best of all worlds – consistence up to last transaction, typically fast…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
…-out solution has traditionally been popular for MySQL, it’s interesting to see what room we… rows (about 18GB worth of data+indexes) XFS Filesystem mounted with nobarrier option. Tests run with: RAID10…when data fits completely in the buffer pool (best performance). It’s important to point out that…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… IO bound or CPU bound, while to understand if MySQL goes through more rows than it needs to requires … – This is a lot, but remember this was the best case. Typically you will not be able to get … not even mentioning various seriolization, stripe sizes, cache policies, filesystem and OS issues 
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… parts of libc and friends were the best!), I finally get to experience the joy … remove’ and Debian’s insistence on using the Filesystem Hierarchy Standard. They didn’t follow it perfectly… libs combined with getting upset about the mysql config directory (due to multiple packages maintaining it) …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number…AIO. These can also be rendered useless by filesystems that don’t allow parallel writing to the…for managing Checkpoint age. To be clear, the best we have today (IMO) is using innodb_…
Post: Is DRBD the right choice for me?
July 7, 2009 By 18 Comments
… provide 100% consistency, and then as much uptime as possible. MySQL Replication (with a manager such as MMM) aims to have… in DRBD is a lot longer: After resource transfer, a filesystem check runs (0-5 seconds). mysqld is started (1-5… that requires 100% consistency, then DRBD is one of your best choices on the mysql-market today.
