[Forum] Mysql server shut down

[HeLLCiTo]

Hi


i recive a mail from my host that i have an excess of charge in my database, they send me the slq consult problem.

[URL="https://phpmyadmin.srv.cat/compartit/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fes%2Fselect.html&server=56&token=1b586ffd3e1cba87f440d10097741769"]SELECT[/URL] searchcore.searchgroupid, searchcore.dateline
FROM         searchcore         AS searchcore
INNER         JOIN         thread         AS thread ON (         searchcore.contenttypeid         =1
AND         searchcore.groupid = thread.threadid )         
JOIN         searchgroup         AS searchgroup         ON (         searchgroup.searchgroupid         = searchcore.searchgroupid         )         
WHERE         thread.forumid
IN (         40 )         
AND         searchgroup.dateline >=1321103567
AND         thread.pollid >=1
AND         searchgroup.contenttypeid
IN ( '2'
 )


What do this sql?

thanks a lot

[Lynne]

What is that supposed to be? If it is a database error, you didn't include the part that acutually shows the error.

[HeLLCiTo]

is not an error, my host shut down my web because a have a lot of connections with this slql consult

[Lynne]

Your host is upset because you have people using search? OK, you could turn off search and see if then they are happy - AdminCP > Settings > Options > Message Searching Options > Search Engine Enabled

[Videx]

If you're on shared hosting it's probably just that the host has oversold their shared servers. The server slows down, and live users like your own start hammering at it trying to get results. So the host sees that and says you're the problem.