Hi,
Quote:
when you e.g. optimize a table through “Tools > Table Diagnostics” the executed statements are not shown in the history tab
Executed statements are shown in the History tab. Can you tell us your SQLyog version?. What exact steps did you perform in “Tools > Table Diagnostics”? And also, clear History tab and perform “Tools > Table Diagnostics” and goto History tab and copy paste the query generated here.