Slow Query Log analysis (or specific query analysis) is ordered per two hour block, paid when ordered, to look for anything to speed up query completion. 1 unit of 2 HOURS is the minimum to be ordered for this effort. Please make Skype TALK or telephone contact prior to ordering this service to review your scope of analysis requirements.
You select 400 lines from your Slow Query Log for analysis. Discard head and tail prior to submission. We will likely ask you to supply EXPLAIN SELECT SQL_NO_CACHE ......
- SHOW WARNINGS (or similar information from performance_schema)
- SHOW CREATE TABLE tablename(s) to consider during analysis.
- SHOW INDEX FROM tablename(s) to be aware of existing indexes.
Back To Basics will email suggestions for your consideration.