08.07.2014, 15:54
(
Последний раз редактировалось Danny; 08.07.2014 в 16:46.
)
Quote:
Could you turn on mysql_log(LOG_ALL) and post the entire mysql_log.txt? It contains exact query execution times.
|
Amount of rows: http://puu.sh/a2fNj/ade97206a3.png
Unfortunately this isn't the log which caused a 102-second server hang. I deleted that one accidentally. But still you can see here loading takes up to one and a half minute. I have never experience that with the old plugin version and I read some replies of people toying with huge amounts of data to test the plugin, and they were all able to get a much better load time out of it.
The hang appears to be random: this afternoon I could reproduce it ~10 times, but when I tried it an hour or so ago I couldn't after 5 attempts.
EDIT: The 230-sized table in the puush link is one we don't use, sorry for including it on the screenshot.