Eyes on Final Fantasy Forums > Reference > General Archive > Feedback Forum Archive > Server randomly ceases to load for minutes at a time.

[The Man]

Only seems to happen around this time of night. Just thought you should know.

[Samuraid]

Hmm. Yeah, I've seen it do that at certain times during the day.

Either the log processing program is to blame, or MySQL is getting held up on a table lock.

I'll look into it right now.

[Del Murder]

Sometimes this happens at the end of the month.

[Yamaneko]

It happens sporadically actually.

[Samuraid]

Yeah, most times I see it occur randomly throughout the day, and only for about 30 seconds. During that time, a bunch of connections start to stack up, on EoFF only. (other sites on the server are mostly unaffected)

I think it's due to a sluggish MySQL update that locks a forum database table and causes all the select queries on that table to block until the update completes. It's also possible that a cron job is optimizing the the database, which locks entire tables down during the optimize process.

If anyone notices the forums freezing, please note the exact time of day (and your timezone) and send me a PM. That would help immensly.

[The Man]

well, I made this thread like thirty seconds after the most recent time it happened. If it happens again I'll let you know.

[Yamaneko]

Sometimes I get locked out of specific parts of the DB. I can access the index, but not threadbit or any thread for that matter. I always thought it was a cron job doing its job.

[Samuraid]

Well, no cron jobs should be running optimize queries. If they are, they shall be disabled.