A query crash my site!!!!

Have you tried:

– deactivating all plugins to see if this resolves the problem? If this works, re-activate the plugins one by one until you find the problematic plugin(s).

– switching to the default theme to rule out any theme-specific problems?

– resetting the plugins folder by FTP or phpMyAdmin? Sometimes, an apparently inactive plugin can still cause problems.

Thank you for the answer….
Before all i want to tell you that my host privider told me that the problem IS my huge database….
It’s 2650 post. Could it really be the PROBLEM ITSELF???

i couldn’t belive it couse i HAVE NOT GOT ANY PROBELM UNTIL 5 DAYS Ago!!!!!
Please answer me!! COULD IT BE THAT 26500 POST ARE TOO MUCH FOR A BLOG?!?!?
COULD IT REALLY BE THAT I NEED TO LOWER THAT NUMBER (AS MU HOST PROVIDER SAY) AND I “NEED” TO RENT THIS MACHINE THAT SHOULD COST ME 300 EUROS EACH MONTH???

2 X quad core xeon E5420
8GB RAM
4 X HDD SAS 15.000rpm 146GB l’uno in raid 10
Banda: 2000 Gb su 100Mb
Pannello Hosting cPanel

tHE NUMBER OF THE POST OF MY DATABASE IS 2650 (2THOUSEND 6 HUNDREND AND 50 POST) NOT 26500 AS WRITTEN THE SECOND TIME!!!!

SORRY

This are the axact words used by my host provider (NETSONS)

“Must stop following query:

SQL_CALC_FOUND_ROWS SELECT DISTINCT wp_posts .* FROM wp_posts LEFT JOIN (SELECT DISTINCT tr.object_id, t.name from wp_term_relationships tr tt inner join wp_term_taxonomy on tt.term_taxonomy_id = tr.term_taxonomy_id inner join t on wp_terms t.term_id = tt.term_id) on tr tr.object_id = wp_posts.ID WHERE 1 = 1 AND (((((wp_posts.post_title LIKE ‘% KiteGen%’) OR
(Wp_posts.post_content LIKE ‘% KiteGen %’))) AND (wp_posts.post_password =”) AND wp_posts.post_type =’ post ‘AND (wp_posts.post_status =’ publish ‘)) AND post_type! =’ Revision ‘) AND post_status! = ‘future’ OR (tr.name LIKE ‘%% KiteGen’ AND post_status = ‘publish’ AND post_type = ‘Post’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 13;

and streamline its database.”

No, there are WordPress blogs with far more posts than that. Perhaps you have reached your hosting provider’s space limitation? If not, try Esmi’s suggestions.

No…i haven’t reach any space limitation!!

Have you tried Esmi’s suggestions?

I removed quite all…. now i have wordpress 2.9.2 with
2,691 Posts
442 Comments
32 Categories
541 Tags
i use Mistique theme and this plugins:

Advanced Export for WordPress & WordPress MU
Adds an Advanced Export to the Tools menu which allows selective exporting of pages, posts, specific categories and/or post statuses by date.

Deactivate | Edit
Version 2.8.3 | By Ron Rennick | Visit plugin site

Akismet
Akismet checks your comments against the Akismet web service to see if they look like spam or not. You need a WordPress.com API key to use it. You can review the spam it catches under “Comments.” To show off your Akismet stats just put <?php akismet_counter(); ?> in your template. See also: WP Stats plugin.

Deactivate | Edit
Version 2.2.7 | By Matt Mullenweg | Visit plugin site

All in One SEO Pack
Out-of-the-box SEO for your WordPress blog. Options configuration panel | Upgrade to Pro Version | Donate | Support | Amazon Wishlist

Deactivate | Edit
Version 1.6.10.2 | By Michael Torbert | Visit plugin site

Auto AdSense Sections
Automatically implement AdSense section targeting to improve the relevancy of your AdSense ads.

Deactivate | Edit
Version 1.0 | By Mathias Amnell | Visit plugin site

Blog Protector
Protects Your Valuable Blog Content As Well As Images From Being Copied.

Deactivate | Edit
Version 2.3 | By Anurag Choudhari | Visit plugin site
There is a new version of Blog Protector available. View version 2.4 Details or upgrade automatically.

Clean Options
finds orphaned options and allows for their removal from the wp_options table

Tools | Deactivate | Edit
Version 1.3.1 | By Mittineague | Visit plugin site

Delete-Revision
Delete revision post from Database,let us now to drop Redundancy, lose weight !

Deactivate | Edit
Version 1.3.1 | By gohsy | Visit plugin site

Frame Buster
Thwarts any attempt to load your site in a frame.

Deactivate | Edit
Version 5.0 | By Denis de Bernardy | Visit plugin site

Google AJAX Translation
Add Google AJAX Translation to your blog. This plugin allows your blog readers to translate your blog posts or comments into other languages. [Settings]

Deactivate | Edit
Version 0.6.0 | By Libin Pan, Michael Klein, and Nick Marshall | Visit plugin site

Google XML Sitemaps
This plugin will generate a special XML sitemap which will help search engines like Google, Yahoo, Bing and Ask.com to better index your blog.

Deactivate | Edit
Version 3.2.3 | By Arne Brachhold | Visit plugin site | Settings | FAQ | Support | Donate

JavaScript to Footer
This plugin automatically moves JavaScript code to page footer, speeding up page loading time.

Deactivate | Edit
Version 0.4 | By Vladimir Prelovac | Visit plugin site

Manageable
Inline editing of the date, title, author, categories, tags, status and more on both posts and pages without leaving the “Manage” admin sections. No need to load each post or page individually. Simply double-click anywhere in the post or page row and when you’re done, press enter. Requires WordPress 2.5 or above. This plugin doesn’t work in 2.7 since it’s been integrated into the core.

Deactivate | Edit
Version 1.1.1 | By Aaron Harp | Visit plugin site

Optimize DB
Let’s you optimize your WordPress database tables with one click. Click optimize on the right to start optimizing!

Optimize | Deactivate | Edit
Version 1.3 | By Joost de Valk | Visit plugin site

Quick Adsense
Quick Adsense offers a quicker & flexible way to insert Google Adsense or any Ads code into a blog post.

Setting | Deactivate | Edit
Version 1.6 | By Philip Ze | Visit plugin site

Revision Control
Allows finer control over the number of Revisions stored on a global & per-type/page basis.

Deactivate | Edit
Version 2.0 | By Dion Hulse | Visit plugin site

Simple Tags
Extended Tagging for WordPress 2.8 and 2.9 ! Suggested Tags, Mass edit tags, Autocompletion, Tag Cloud Widgets, Related Posts, Related Tags, etc!

Deactivate | Edit
Version 1.7.4.4 | By Amaury BALMER | Visit plugin site

W3 Total Cache
The fastest and most complete WordPress performance plugin. Dramatically improve the speed and user experience of your blog by adding: page caching, database caching, minify, content delivery network (CDN) functionality and more…

Settings | Deactivate | Edit
Version 0.8.5.2 | By Frederick Townes | Visit plugin site

WordPress Database Backup
On-demand backup of your WordPress database. Navigate to Tools → Backup to get started.

Deactivate | Edit
Version 2.2.2 | By Austin Matzko | Visit plugin site

Have you tried deactivating all of your plugins yet?

A FRIEND OF MINE SAy:

“I saw the query that you posted. And ‘of course “IT” IS the problem. There are a join between a table and a table generated by an additional join. And then on almost like a post-3000 … implants “by definition”.

MACMANX… SHOULD REALLY DEACTIVATE ALL MY PLUGINS?????

OK….ALL IS DEACTIVATED!!!!! LET’S SEE WHATS HAPPENS!!

Yes, deactivating your plugins is an essential troubleshooting step, as plugins can sometimes cause problems like this. If the problem is resolved by deactivating all of your plugins, reactivate each one individually until you find the cause. When you find the plugin causing the issue, get rid of it.

Also deactivate your caps lock key. That all-caps stuff is hard to read.

aahaaaha…sorry!!!! caps lock key removed from keaboard!!!! aahaah

let’ s see what will happens now!