…how to build high-performance systems to do this work. Let’s see some ways you can build…to successfully scale large click-processing and other types of event-analysis databases. In some cases I’ve been able to…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
…(for the same database) you join the… execution for large ranges. Lets …MySQL has to build (and do lookups) for all combinations which is 31*10=310 in this case. But if it gets to…to learn about MySQL Optimizer gotchas 
At the same time I figured out how to make MySQL Optimizer to do what we want to…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
…large data sets in mySQL teach you ? Of course you have to learn a lot about query optimization, art of building… database is already loaded. So operating wit such large databases you need to be patient and learn to… you simply need to plan carefully how you’re going to alter your database because it …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…good to speed up accesses to database. Some people would also remember if indexes are helpful or not depends on index selectivity – how large …to populate the caches. With proper application architecture and table design you can build applications operating with very large data sets based on MySQL…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…Database Egos” – Storage Engine developers showcase as one of keynotes. Today let me start with most popular transactional storage engine for MySQL…Building index by sort allows to build them physically sorted so they should be much faster for IO Bound Index scans and large…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…to pick either long recovery time or further degraded performance. In the large databases I run in production relaying on MySQL…to ensured consistency – MySQL Replication can out of sync – and there is bunch of tips in documentation of how to…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
…to be it is important to build the good argument to suggest Innodb. Application Readiness Application should be ready to…to adjust processes as required to work with Innodb. For example binary copy of one of the databases from the Slave to…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…database handles for read and write operations, this HA solution can scales the read operations to…MySQL, altering a table means recreating the whole table and it is a blocking operations. Altering a large…to another server. As a conclusion, replication can be used in many cases to build…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…how to compute up to this point. You can calculate the standard deviation, the median, any desired percentile (depending on how large… systems such as database servers. As a… is common in MySQL servers I …build your own from a Radio Shack kit). What does this mean? It means that I need to go back to…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…MySQL installations or managed hosting provider. For large MySQL web MySQL…to other database systems. MySQL has to do more than one fsync() for the log because it internally implements XA to…build…
