5 Ways to Boost MySQL Scalability

There are a lot of scalability challenges we see with clients over and over. The list could easily include 20, 50 or even 100 items, but we shortened it down to the biggest five issues we see. 1. Tune those queries By far the biggest bang for your buck is query optimization. Queries can be …

Data warehousing – What is it and why is it important?

Have a question? Email me anytime sean@iheavy.com A data warehouse is a special type of database.  It is used to store large amounts of data, such as analytics, historical, or customer data, and then build large reports and data mining against it.  It is markedly different from a web-facing or high-transaction database, which typically has …

Query Profiling – What is it and why is it important?

Queries are so-named because of the lovely language we call SQL – simplified query language.  That’s a bit of sarcasm on my part, I’ve never found it particularly simple or elegant.  Profiling them involves finding how they are spending their time, and what they are asking the server to do.   In this way you can …

Website Optimization – What is it and why is it important?

When you enter a website name in your browser or click on a google result, you start a cascade of events to unfold.  Your request various pieces and components that make up the webpage from a remote server which hosts that website.  Those pieces are sent back to you, and your browser assembles them. There …

MySQL Optimization

Experiencing performance problems with your MySQL 4.x or 5.x database? We can help. We have over a decade of experience tuning sophisticated multi-tier web applications. This allows us to identify and pinpoint problems quickly, drilldown to the relevant application and SQL, and sift out the problem code. All this makes your applications run faster, and …