Problem query overloading server

[Marco van Herwaarden]

If this is not with 1 specific user, then it is strange that you woudl only sometimes get problems. This query is part of fetch_language_fields_sql() which in turn is called by fetch_userinfo() (and 1 more), so if this query was the problem i would expect it to happen all the time.

More likely is that there is another query that locks up some tables used in the reported query. The reported query is exected often and might be waiting on that previous query to release the tables. If this is the case, then you should try to locate the query that locks up everything, as that will be the clue to solving this.

You might try opening a support ticket, but based on the info provided thusfar i doubt they can help you unless you can locate the query that locks the tables.