Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
Long running txp_prefs queries
I’m suddenly getting reports of queries against txp_prefs running for longer than 1 minute and needing to be killed. The query in question is
select name, val from txp_prefs where prefs_id=1 AND user_name=''which happens as part of get_prefs() I have 120 rows in the preferences table some extra stuff from old plugins I should prune (problems with having an install upgraded since gamma) but this does not seem really that big.
Any thoughts on figuring out the bottleneck? I haven’t troubleshooted mysql in awhile.
Shoving is the answer – pusher robot
Offline
Pages: 1