Next privilege 300 Rep.
Create new tags
Next badge 0/1
~3k people reached
- 1 post edited
- 0 helpful flags
- 24 votes cast
Make sure MySQL is not accepting remote connections
There is also --skip-networking ...
Mysql: Large Query with subqueries optimization
keys that matches or not was a question specific to that post, you can forget this part. The technique is to use select * from performance_schema.objects_summary_global_by_type to see how much table io is done, detailed by table.