What is your query limit set to?
Thread Starter
BackY
(@backy)
75,000 per hour. (the limit is set to the database’s user, not the database) I tried changing the database user but the limits gets exceeded right away! (this started to happen the last 1-2days)
Turn off all your plugins. If this JUST started happening, what changed?
Thread Starter
BackY
(@backy)
Nothing. I’ve allways used these plugins. I don’t think that the plugins could use that much of a queries.
I don’t think that the plugins could use that much of a queries.
Think about that for a second.
ALL of your site data is stored on the Database, with the exception of what’s in your wp-config.php file. Every time a page loads it makes queries. Plugins add to that.
What are your permalinks set to?
Thread Starter
BackY
(@backy)
I don’t have a long list of plugins anyways. maybe 20 max. and half o them are dynamic, half of them only run when I run them (or once a day, like backups and stuff)
permalinks:
Default http://www.sitename.com/?p=123
Turn them off anyway.
Normally when things ‘just’ start happening, it’s from a change (I know, duh), but when YOU don’t change anything you have to ask your host if anything changed.
Check your error logs and your site traffic. Is anything abnormal?
Thread Starter
BackY
(@backy)
I firstly contacted them. thats where I got the infos that the limis is being exceeded, can I pm you with the logs? or maybe post them here and you can check ? I guess theres nothing harmful to share in the logs lol :d
Post them on pastebin.com (or as a .txt on your server, since that won’t use the DB). But. Did they offer any help besides telling you that you were running out?
75,000 per hour is fairly standard IIRC
Read http://www.sprabhu.com/wordpress/232/ for some info, but I would mostly look to see if ONE IP keeps hitting my site, and block ’em with .htaccess
Thread Starter
BackY
(@backy)
Thread Starter
BackY
(@backy)
Can I use a separate database for my plugins !? or fix this somehow ?
Sorry, I don’t do email support (except for paying clients). And I removed your email from sight so you don’t get more spam email.
Splitting WP across two DBs is possible, but I suspect would cause more problems since you have to use a plugin to do it, and I’m PRETTY sure it’s only meant for posts and not the site options.
Anyway. What YOU need to do is go over those files (I’m not doing it, I have a job to keep me busy 😉 ) and look at the IPs. If they’re yours, you can remove ’em from the list for now. If they’re NOT yours, just make a judgement call on how many calls from one IP there are. Look up that IP. Does that seem legit? Move on.
The other thing to keep in mind is that since this happens when you POST, and not at other times (that you’ve said) it’s VERY likely that a plugin or setting change is doing this. Be logical. Do you have a sitemap plugin? Turn it off. A ping or RSS plugin? Turn that off too.
