… is IO bound or CPU bound, while to understand if MySQL goes through more rows than it needs to requires look… point of the article. In original article I mentioned having multiple hard drives does not help if you have single query (or… deal with ? In this case you also can benefit from multiple drives because of the different reason. If you’re using RAID10…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… row which means you get about 100 rows/sec. Note multiple drives do not really help a lot as we’re speaking… large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by… have whole bunch of problems solved just doing so. Use multiple servers to host portions of data set. Store portion of…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
…, and solid-state storage — specifically, the Virident tachIOn drive — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease… done. You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server white paper.
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… post I got number number of comments saying if MySQL would not have multiple storage engine interface it would not allow people… MySQL Users Conference over the years. This is about 2000 people a year for last 8 years. Remove people which attended multiple… as people who make their Hot Rods and people who drive Honda Civic. Hot Rods are cool and allow you a…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided to write some… you have many hard drives you can’t really get advantage of them unless you can get multiple outstanding requests. Performance with 64 threads was 2334.63 Requests/sec which is perfect scalability to 6 hard drive this…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… systems only had one bearing hard disk drive (HDD) as in RAID1 or one disk drive at all, you couldn’t really… sectors (again due to the fact operations are done in multiples of 512-bytes), outside of the RAID you want to… so in these cases there would be fewer pages spanning multiple disks so the effects of misalignment would be less significant…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding… disk based SAN (no Flash) the drives are same drives you will see in directly attached…it is more reliable, same as server with multiple power supplies ECC memory kill-chip and…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… they have instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important… issues along you need enough concurrency to utilize multiple hard drives and with 50 drives you would need at least 50 outstanding requests… but not optimize for it, putting it on shared drive (or OS+Stuff drive if there is one) – you do not want…
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 …peaked out at 13.500 queries/sec with multiple threads which corresponds to even worse scalability. Disabling…buffer pool so IOs will mostly come from drives directly which means hundreds or may be …
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… enabled Binary log with MySQL 5.0 you loose group commit which can dramatically increase commit rate for multiple user load. See… write per rotation, which is about 250 for 15000 RPM drive. If you’re getting more without battery backed up cache… single server a box with few CPUs and few hard drives while running MySQL.
