Not signed in (Sign In)

Vanilla 1.1.10 is a product of Lussumo. More Information: Documentation, Community Support.

General Support: MySQL using 100% CPU usage?

Bottom of Page

1 to 3 of 3

  1.  
    • CommentAuthori-CONICA
    • CommentTimeJan 21st 2009
     
    Hi,
    I used to have my site hosted on a shared host. It has 46,000 images.
    As this site in particular was of an adult nature, they asked me to remove it.

    I've setup servers on both windows vista, on a very high spec machine. Also on a smaller, less powerful pc using Fedora 10.
    Both servers use PHP 5.2.8, MySQL 5.1.30 on apache 2.2.
    On both systems, my database, on windows mysqld.exe is using 100% cpu usage and taking anywhere between 5~10 seconds. Taking a little longer on the Linux system.
    This is after downloading a dump of the database from my host, and importing it into my new setup.
    Any idea what's causing the high load? I can't continue to use the site with this kind of load, the site is offline until it's fixed.

    Please help.
    Thanks.
    •  
      CommentAuthorsidtheduck
    • CommentTimeJan 23rd 2009
     
    Hi i-CONICA,

    I have never used / tested a database of this size, so I can't tell what the server overhead would be with 46,000 images. Don't know what to tell you.
    • CommentAuthori-CONICA
    • CommentTimeJan 25th 2009
     
    Hi, thanks for the response sidtheduck.

    It doesn't seem a necessary overhead from any kind of MySQL DB of this size unless there is major repeated functions and inefficient code...
    I'm going to test plogger with a much smaller number of images to see where the problem lies.

    Thanks.

1 to 3 of 3

  1.