High mysql load

[cmanns]

Hi I manage a server running a large cpg install

it's roughly

We have 456677 registered users
In total there are 146 users online (in the past 10 minutes) :: 95 Registered, and 51 Guests
There are: 16,045 renders, viewed 53,499,591 times and 133,426 comments

I optimized the db, mytop was showing tons of queries just running forever from cpg causing no pages to load.

It might be a version or so out of date I'll try to check any ideas?

Code Select Expand

      Id      User         Host/IP         DB      Time    Cmd Query or State
      --      ----         -------         --      ----    --- ----------
      46      root       localhost xxx         0  Query show full processlist
      48   xxx localhost:30488 xxx        28  Query DELETE FROM cpg131_users WHERE user_name = '' LIMIT 1
      49   xxx localhost:30490 xxx        28  Query SELECT user_name FROM cpg131_users WHERE user_id = '444408'
      22   xxx localhost:30446 xxx        32  Query SELECT user_id, user_name, UNIX_TIMESTAMP(user_regdate) as user_regdate, UNIX_TIMESTAMP(user_la
      23   xxx localhost:30449 xxx        32  Query SELECT user_id, user_name, UNIX_TIMESTAMP(user_regdate) as user_regdate,


There was tons of these the servers very powerful, I guess it randomly stopped (I don't see these queries anymore either... :S

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php/topic,55415.msg270616.html#msg270616