… shared or replicated storage is best solution for most MySQL High Availability needs. The reasons are: – Bad memory or MySQL Bugs on Primary can… by DRBD – Long switch time even for Innodb tables – on large system tuned for performance filesystem recovery from journal and Innodb recovery can…
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
… CPU bound, while to understand if MySQL goes through more rows than it… at update queries (from replication thread for example). When update is performed first… a lot, but remember this was the best case. Typically you will not be… various seriolization, stripe sizes, cache policies, filesystem and…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… also tell you what we think is best for you, which is our job). After the …; vgs; lvs These commands show me what filesystems are mounted, how much space they have …MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has the Percona patches for…
Post: Is DRBD the right choice for me?
July 7, 2009 By 18 Comments
…seems pretty common to find customers install DRBD for the wrong reasons. There are many pros/cons to … DRBD is a lot longer: After resource transfer, a filesystem check runs (0-5 seconds). mysqld is started (1… requires 100% consistency, then DRBD is one of your best choices on the mysql-market today…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… 15K 600GB 16MB Cache SAS Filesystem: XFS, mkfs.xfs -s size=4096, mount -o nobarrier Benchmark: For the benchmark I took a… mention that on these datasizes, sysbench workload is pretty nasty, MySQL will mostly reads and writes pages from buffer pool (replacing… allows us to see the best possible scenario for SSD running under MySQL, the final result will show the best possible gain. I do…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… RPM (individual file dependencies for parts of libc and friends were the best!), I finally get…remove’ and Debian’s insistence on using the Filesystem Hierarchy Standard. They didn’t follow it …for using their operating system, I wanted to toss in my (perhaps garbled – I’ve been reading the mysql…
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 … is my go-to setting for managing Checkpoint age. To be clear, the best we have today (IMO)…
