… will run a few slave instances each of production database servers and will perform the backups. The write load is not excessive… partition correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is… want to start a war but ZFS performance level was less than half of xfs for the tpcc test and that’s…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… be dedicated for MySQL with large Innodb database using typical Web workload what settings you… And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines…running in particular roadblocks with it try XFS. You can use noatime and nodiratime options…
Comment: Is your server's performance about to degrade?
May 19, 2010 By 13 Comments
… years I have recommended xfs without hesitation. You will see that’s what Vadim runs all his high-performance benchmarks on too. It’s hard to contemplate a high-performance database server on anything else these…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… minimize the effects of misalignment. File system of choice was XFS. Barriers and physical disk cache was disabled. The tool I… the performance improved another 20-40%. It took me a while to figure it out, but here’s what happened – for XFS… and improves performance up to 15% in case of 8 threads running concurrently. Because the customer was running a database which was…
Post: linux.conf.au 2012 roundup
January 24, 2012 By Leave a Comment
… great talks on a variety of topics – everything from filesystem performance to open hardware, to repurposing existing hardware to upcoming challenges… suitable for database workloads anywhere in the near future, I suspect we’ll see BTRFS as the root filesystem and XFS as the filesystem for the database server in the not too distant future…
Comment: Opening Tables scalability
March 20, 2007 By 27 Comments
… each server. Each forum gets it’s own database (~90 tables in one database) . We have similar issue – when server is overloaded… tables – best performance setting for us is table_cache=0. Now it’s hosted on Linux 2.6 & XFS which supports more… faster in this than XFS. I’m afraid of putting such many tables into one database – this cause worse performance problems – like hosting…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… Expo 2010 “An Overview of Flash Storage for Databases” I mentioned that most likely there are other… the price) as well as high performance in general and stable performance under high load in particular, and…2-6.18.164 Kernel Filesystem is XFS formatted with mkfs.xfs -s size=4096 option ( size=4096,…
Comment: btrfs - probably not ready yet
May 23, 2012 By 17 Comments
The general rule for database performance is: use XFS. There have been exceptions (see Vadim’s post on how … number of huge database installations that will only run on XFS is non-trivial (anything else would kill their performance enough to possibly…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…with an access to the server), and compare performance with SAS hard drives. System specification Dell PowerEdge… Seagate Cheetah 15K 600GB 16MB Cache SAS Filesystem: XFS, mkfs.xfs -s size=4096, mount -o nobarrier Benchmark:…256 (3TB) to 32 (375GB). As a backend database I use Percona Server 5.5.19. I…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
…to run in RightScale environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite…also I tested IO on single volume. I used xfs filesystem mounted with noatime,nobarrier options and for …in regular server I’d never suggest RAID0 for database, but speaking about EBS I am not sure …
