Bug #47149 high load data base in server
Submitted: 5 Sep 2009 6:38 Modified: 5 Sep 2009 16:57
Reporter: yasser m Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[5 Sep 2009 6:38] yasser m
Description:
i get this error in my server
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home45a/sub004/sc33212-ZYVF/xxxxxx.com/includes/sessions.php on line 89

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home45a/sub004/sc33212-ZYVF/xxxxxx.com/includes/sessions.php on line 128

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home45a/sub004/sc33212-ZYVF/xxxxxx.com/includes/statistics.php on line 28

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home45a/sub004/sc33212-ZYVF/xxxxxx.com/includes/functions.php on line 361

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home45a/sub004/sc33212-ZYVF/xxxxxx.com/includes/statistics.php on line 78
User 'xxxxxx.com' has exceeded the 'max_questions' resource (current value: 1) 

i think the problem in data base because in the past  i was many user online up to 1000 user and have many page preview and the site work fast and staple but now i donnt have this user and the site get this error
look to my bandwidth  
[img]http://irooc.com/images/673_bandwith.jpg[/img]

 and there is anther thing when i my data base suspended my host give me this note 
 " database xxxx suspended for causing high load on our server with queries like:

SELECT title, icon, iconlocation, fileid, description, timesplayed, rating FROM on_files WHERE (cate  "
and when i open phpmyadmin   to see on_files table i get this 
[img]http://irooc.com/images/779_1img.jpg[/img]

and when i try to repair it by click in repair table i get this
[img]http://irooc.com/images/837_2img.jpg[/img]
so if you please help me fast my site get down because this error

How to repeat:
i dont know
[5 Sep 2009 16:57] Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.