Re: Performance Tuning Tools

[Rick James]

Step 1. Forget most of the complexity of Oracle.

> a SQL area of parsed statements for re-use
No. Parsing is fast enough so that there is little use for such.

> AWR ... Is there an equivalent in MySQL?
The SlowLog is the best tool. (It is much less than what Oracle gives you.)

Learn to use
SHOW CREATE TABLE
SHOW TABLE STATUS
EXPLAIN SELECT

A MySQL DBA can handle perhaps a few dozen separate MySQL servers. The ratio for Oracle is closer to 1:1. (See Step 1)

MySQL, in its simplicity, does not have the smarts to compensate for sloppy schemas and queries. Subqueries and Views, for example, are (in many cases) poorly optimized. The user (DBA / developer) is admonished to use JOINs (etc) instead. This forum is littered with examples of such.

BTree indexing is the best all-around indexing type. It is essentially the only type available in MySQL. Forget Bit, Hash, etc. (See Step 1)

A PRIMARY KEY in InnoDB is UNIQUE and Clustered. Period. (See Step 1)