Results 1 to 5 of 5
  1. #1

    Unhappy high load data base in server

    i get this error in server
    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home45a/sub004/sc33212-ZYVF/***********/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/***********/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/***********/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/***********/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/***********/includes/statistics.php on line 78
    User '***********' 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
    SELECT title, icon, iconlocation, fileid, description, timesplayed, rating FROM on_files WHERE (cate "
    and when i open phpmyadmin to see on_files table

  2. #2
    Join Date
    Apr 2009
    Location
    Pittsburgh, Pennsylvania
    Posts
    582
    have you tried optimizing the tables?

  3. #3
    You need a VPS/Dedicated server.
    If you have too much traffic please upgrade.

    Also sometimes naughty BOTS bombard the site with pageviews and cause them to crash.
    Try banning them if you detect them.
    Softaculous - Auto Installer for cPanel, Direct Admin, InterWorx, Plesk, H-Sphere
    The only Auto Installer that installs 260+ scripts. Install in just ONE STEP!
    Virtualizor - VPS Control Panel supporting OpenVZ, Xen, KVM and has 60+ OS Templates
    Webuzo - Softaculous for the Cloud i.e. Softaculous Standalone

  4. #4
    Join Date
    May 2008
    Location
    Rutherford, NJ
    Posts
    68
    max_questions is a per-user limit set on a db server. i.e., user 'mysqluser1' can run 30 queries per hour, etc. if the server is your own, increase it for the db user this page is running on. if it is not, ask your server administrator for an increase.
    Database design and performance optimization, custom PHP scripts, and publicly available resources for developers!
    http://www.zeropride.com

  5. #5
    It is true that big database or any coding effect on the site so always use small coding.

Similar Threads

  1. Server high load/high mysql usage. Need new server. [HELP]
    By ToroPreto in forum Hosting Security and Technology
    Replies: 13
    Last Post: 07-05-2009, 07:12 PM
  2. high server load / high swap / lots of httpd
    By hbhb in forum Hosting Security and Technology
    Replies: 12
    Last Post: 02-22-2008, 09:17 AM
  3. Data Base Server question, I need some help.
    By jBud in forum Web Hosting
    Replies: 1
    Last Post: 10-19-2007, 04:40 PM
  4. Server load not very high but pages load slowly
    By singtel22 in forum Hosting Security and Technology
    Replies: 17
    Last Post: 01-27-2005, 02:43 PM
  5. Data base server
    By kj-96 in forum Dedicated Server
    Replies: 3
    Last Post: 10-22-2001, 03:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •