…to do very well, while with even just two Quad Core CPUs scalability issues can be observed…need more. Also note new 2.5″ SAS hard drives. They are tiny but often faster than bigger … transaction-isolation=READ-COMMITTED. This option has some performance benefits, especially in locking in 5.0 and even…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… on how to tackle application performance. These questions are: Should we …memory may be couple of SATA hard drives – something one would rent for $100…replication you would want at least two. Implementing memcache may look like …% does not give you much benefit – you would just need another server…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…writes and fsyncs per second which matches your hard drive capacity. Plus you would normally see single … If you can’t use any of first two workarounds you better to get battery backed …can offer substantial performance improvements in variety of cases as well as has other benefits. This is …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… can see the drive status, too. Sometimes a failed drive is present but … differences. I’ll usually capture two of these. It looks like this: […performance problem. Not really for the server, since it’s a cheap query. It adds hardly… a consideration of the costs and benefits on the system as a whole…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… you need and get the performance you need. Because I’ve built two such systems to manage online …benefits of purging and archiving data can be dramatic. Take It Easy On Replication Building aggregated tables is hard … long time and run on many fewer disk drives with much less memory, or even with 10-…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…always analyze the local system performance independently from anything else. Performance This is perhaps the most … more hard drives than directly attached storage but usually also at much higher prices per drive. The… have a benefit of having the system which you can actually split in two (ie for …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… (incorrectly) to swap out MySQL. There are two solutions here. Memlock and O_DIRECT. Memlock … Is it possible to get the same benefit if you’re performing INSERT with multiple values? We …performance by using couple of MySQL Servers on single node. You can make them to use different hard drives…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… not different selectivity might show benefit from using indexes. In fact … normalized to several tables or perform complex queries finding relationships between objects…assume join would be close to two full table scans (as 60mil … time is your concern many hard drives and large number of CPUs will…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… this point for databases of decent size. Two important compression questions you need to decide …, especially for CPU bound MySQL Load. The benefit in this case is less space requirement … – this is again much less than hard drive sequential read performance, though the fact this gives us …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… are slowly working on the performance enhancement requests. It takes time…SSD can give the main benefit to – writes to log files…when sequentially written to the drives at the rate of 100MB/…trivial question, but it’s hard to find a good answer… main database (from 16GB, 2 two-year old HT’ed XEONs …
