…and memory consuming, so ideally you would want to download the “slow query log” to another machine and…Tables” section lists the queries that you can use to gather more data about the underlying tables involved and the query execution plan used by MySQL…

…lot of performance gains before I move to such unusual setup. Q: Table1 has… column and using order by on another column. do i need to add the index on column…table or filesort for group by by this column. This works because by scanning data in index order MySQL gets data in already sorted order and…

…to see MySQL memory consumption plotted. I use “VSZ” columns from “ps” output on Linux. It helps me to…table cache, especially if you’re using large blobs. It is easy to check though. Run “FLUSH TABLES” and…