Monthly Archives - February 2014

How to avoid common (but deadly) MySQL development mistakes

MySQL software developers are under pressure to do more in less time and create applications that adapt to ever-changing requirements. And it’s true that some of a developer’s time is wasted when his or her method of optimizing involves trying every combination of code and index definition.
There is a better way. And next Wednesday […]

Read more

How rows_sent can be more than rows_examined?

When looking at queries that are candidates for optimization I often recommend that people look at rows_sent and rows_examined values as available in the slow query log (as well as some other places). If rows_examined is by far larger than rows_sent, say 100 larger, then the query is a great candidate for optimization. Optimization […]

Read more

March 5 Webinar: Which MongoDB Distribution Should You Use? AOL Benchmark

It may be easy to choose a NoSQL database, but do you know which distribution is best for you? Which will perform better? Which will scale further? Look before you leap.
Register Now!
SPEAKER: John Schulz
DATE: Wednesday, March 5th
TIME: 1pm ET
AOL, the well-known mass media corporation, asked themselves these questions and ran […]

Read more

DBA 101: Sometimes forgotten functionality in the MySQL client

The MySQL client has some functionalities some of us never use. Why would you use them and what is the added value of this?
Every DBA and developer has had a moment when he or she needs to connect to a MySQL database using the command line tool. Therefore I’ve written down an explanation of […]

Read more