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.
MySQL – How to Get Estimate Cost of Executing a Query
execution-planMySQLperformancequery-performance
Related Question
- MySQL – How to Trace Optimizer’s Work
- MySQL Performance – Why Does MySQL Take Too Long with Matching Index?
- PostgreSQL – How to Speed Up DISTINCT Query?
- Postgresql – How to accurately measure query time in PostgreSQL (because EXPLAIN ANALYZE does not seem to do it)
- PostgreSQL – Analyzing Slow Query with Low Memory Usage and High Writes
- Postgresql – How to increase timing performace of a SQL query
- Sql-server – ny reasonable way to determine what executed a query
- PostgreSQL Query Planning – How Postgres Computes Row Count Estimate
Best Answer
There isn't much out there for MySQL except the following:
Read these carefully, see what you think ...