Is there any way to get the estimate cost of executing a query in MySQL?

Question

In PostgreSQL, EXPLAIN or EXPLAIN ANALYZE will show the estimate cost of executing a query. But EXPLAIN in MySQL doesn't provide this information. How can I get the estimate cost without installation of other tools? I'm using MySQL-5.6.16.

score 10 · Answer 1 · answered Sep 15 '16 at 22:44

10

In short

Run your SELECT ... query
SHOW STATUS LIKE 'last_query_cost'
if the answer was 0 rerun the query with select SQL_NO_CACHE ... and do step 2 above again

answered Sep 15 '16 at 22:44

Ruan Malan N

321
3
3

score 5 · Accepted Answer · answered Mar 29 '14 at 01:27

5

There isn't much out there for MySQL except the following:

Read these carefully, see what you think ...

answered Mar 29 '14 at 01:27

RolandoMySQLDBA

185,223
33
326
536

Is there any way to get the estimate cost of executing a query in MySQL?

2 Answers2

Linked