…run a few slave instances each of production database servers and will perform the backups. The write load is …to start a war but ZFS performance level was less than half of xfs for the tpcc test and …for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… for MySQL with large Innodb database using typical Web workload what … optimization. I call this Innodb Performance Optimization Basics so these are … particular roadblocks with it try XFS. You can use noatime and …for Innodb Especially when coming from MyISAM background there would be some …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…of misalignment. File system of choice was XFS. Barriers and physical disk cache was disabled…= 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_…performance up to 15% in case of 8 threads running concurrently. Because the customer was running a database…
Comment: Opening Tables scalability
March 20, 2007 By 27 Comments
… 3 500 000 myisam tables per each server. Each forum gets it’s own database (~90 tables in one database) . We have similar… 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: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
…of our customers was complaining that the database would lock up at random times… This was MySQL 5.0 running MyISAM/InnoDB mix, not heavily loaded. We … on that system due to potential performance impact. However, somehow I have noticed…remove. Note that on ext4 and xfs you should not have this problem…
