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?
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
http://forum.coppermine-gallery.net/index.php/topic,55415.msg270616.html#msg270616