Commands for Optimization
Now that you've had a tour of the principal things influencing database performance, it's time to spend a little time looking at the commands MySQL offers for improving the speed of your queries and the design of your tables.
Improving Tables for Joins and Other SELECT Queries: EXPLAIN
You heard previously that it's usually wise to add indexes to a table. In fact, if you are working with relatively large tables, the use of indexes is one of the biggest influencers of overall database performance.
You've read some rules-of-thumb about where to apply indexes—such as wherever a column is named in a WHERE clause, or where that column may be used as part of a join. But how can you be sure that you've applied them correctly? ...
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
