Hi,
Recently my server has been hanging. It's a beefy dedicated box usually running at 0.20 load, but during these spikes it hits 50.0 load and hangs for roughly 8-15mins, then is back to normal again.
Host says this database activity seems to be happening at the time:
"I have found that during these spikes there are a good number of queries like the below running for extended periods:"
Host: localhost
db: myforum_main
Command: Execute
Time: 59
State: Sending data
Info: SELECT thread.thread_id
FROM xf_thread AS thread
LEFT JOIN xf_thread_ignore
Progress: 0.000
Any ideas what I should investigate or look into? Thanks
Recently my server has been hanging. It's a beefy dedicated box usually running at 0.20 load, but during these spikes it hits 50.0 load and hangs for roughly 8-15mins, then is back to normal again.
Host says this database activity seems to be happening at the time:
"I have found that during these spikes there are a good number of queries like the below running for extended periods:"
Host: localhost
db: myforum_main
Command: Execute
Time: 59
State: Sending data
Info: SELECT thread.thread_id
FROM xf_thread AS thread
LEFT JOIN xf_thread_ignore
Progress: 0.000
Any ideas what I should investigate or look into? Thanks
