Coppermine Gallery and Performance, Light Version?

[dke]

Hi,

I've been having huge trouble with my webserver lately, and since im not a pro at php/apache/sql it has taken awhile for me to understand the issue of my problem.

Ive concluded from my benchmarks with AB binary which is included in apache, that coppermine is to heavy for a P4 3200ghz 2gb ddr2 ram and a 7200sata2 drive to run with 25k pictures.

Ive slimmed down the start page to just text, zero images but still apache cannot handle more then 25-27 requests per second. There's somthing with the coppermine code that just isnt performance giving. As im not a coder i dont know, but i was wondering if there may be a "light" version of coppermine somewhere as i love the gallery, but there's to many features that i cannot disable (i guess?)

I disabeled all that i can through editing and by the gui, and im down to 47 requests on the index page, and it loads in 0.35 seconds which is great, but the instance i get around 2-5 people browsing my server cloggs, as my apache strugle to send requests above 25 per second..

Heres a result from my webserver using PHP and coppermine gallery with maximumly stripped index:

Code Select Expand


ab -kc 10 -t 30 http://localhost/

Benchmarking localhost (be patient)
Finished 811 requests


Server Software:        Apache
Server Hostname:        localhost
Server Port:            80

Document Path:          /
Document Length:        12356 bytes

Concurrency Level:      10
Time taken for tests:   30.62500 seconds
Complete requests:      811
Failed requests:        0
Write errors:           0
Keep-Alive requests:    0
Total transferred:      10594175 bytes
HTML transferred:       10028211 bytes
Requests per second:    26.98 [#/sec] (mean)
Time per request:       370.684 [ms] (mean)
Time per request:       37.068 [ms] (mean, across all concurrent requests)
Transfer rate:          344.12 [Kbytes/sec] received

Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        0    0   2.9      0      31
Processing:    62  351 307.6    265    4000
Waiting:       62  334 302.6    250    4000
Total:         62  352 307.6    265    4000

Percentage of the requests served within a certain time (ms)
  50%    265
  66%    328
  75%    421
  80%    484
  90%    703
  95%   1000
  98%   1281
  99%   1390
100%   4000 (longest request)

You can clearly see something is wrong, while on the other hand with PHP disabled , i get these results :

Code Select Expand


ab -kc 10 -t 30 http://localhost/

Benchmarking localhost (be patient)
Completed 5000 requests
Completed 10000 requests
Completed 15000 requests
Completed 20000 requests
Completed 25000 requests
Completed 30000 requests
Finished 33101 requests


Server Software:        Apache/2.2.4
Server Hostname:        localhost
Server Port:            80

Document Path:          /
Document Length:        40834 bytes

Concurrency Level:      10
Time taken for tests:   30.000 seconds
Complete requests:      33101
Failed requests:        0
Write errors:           0
Keep-Alive requests:    32779
Total transferred:      1361140254 bytes
HTML transferred:       1351654139 bytes
Requests per second:    1103.37 [#/sec] (mean)
Time per request:       9.063 [ms] (mean)
Time per request:       0.906 [ms] (mean, across all concurrent requests)
Transfer rate:          44307.93 [Kbytes/sec] received

Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        0    0   0.2      0      15
Processing:     0    8  27.4      0     718
Waiting:        0    7  26.7      0     718
Total:          0    8  27.4      0     718

Percentage of the requests served within a certain time (ms)
  50%      0
  66%     15
  75%     15
  80%     15
  90%     15
  95%     31
  98%     46
  99%     93
100%    718 (longest request)

You can clearly see that i gained around 100 times performance increase... i dont expect to get apache to handle 1100 requests per second with coppermine, but ATLEAST 200... What's taking up all the recources?

Ive searched the forums to many times to count for performance increasing tips and ive done em all, nothing helps. Should i look for a lighter gallery to host my 25k pics or is there a solution out there besides getting the usual "Get linux" comment ?

Posting a link to my gallery wont be nessesary as ive done that before and no one found a problem.

[Joachim Müller]

Should i look for a lighter gallery to host my 25k pics or is there a solution out there besides getting the usual "Get linux" comment ?

So you're running a Windows-driven server? This might indeed be the reason (and no, this is not the usual Microsoft-bashing). There are reports of huger galleries with less server power handling more visitors. Does you webhost use a PHP accelerator like the Zend Optimizer (you can find out looking at phpinfo)?

[dke]

Hi,

I'm using eAccelerator but maybe zend is much better? I've heard its not free.

[Nibbler]

What is actually causing the load? MySQL? If so make sure you have tuned the configuration appropriately and have the query cache properly set up.

[dke]

What is actually causing the load? MySQL? If so make sure you have tuned the configuration appropriately and have the query cache properly set up.

the variables i've setup for query-cache is as following:

query_cache_type = 1
query_cache_size = 128M

I don't fully understand how caching works so i'm bound to make big mistakes here.

[dke]

Sorry for the double post, didn't realize i couldn't edit my post.

I have a hard time telling where the load comes from, as i've benchmarked different types of php scripts and it seems that all gives me the same results, no matter if they have code that cause heavy sql load (lots of big queries) or if its simple small php scripts.

But if i use the taskmanager tool while i benchmark, the majority of the cpu goes to apache, while the rest lies with mysql.

[Nibbler]

Don't benchmark random scripts, just look at the cpu usage when Coppermine is under natural heavy load.

[dke]

Don't benchmark random scripts, just look at the cpu usage when Coppermine is under natural heavy load.

Ah, yes... I've been checking the CPU usage when coppermine is experiencing these issues, and i cannot see anything that would cause apache to run slowly, cpu maybe peaks at 25% when someone clicks a large image, other then that it goes from 5 to 15 randomly.

[dke]

After some serious reconfiguration i've manage to see that what happens is that SQL is taking upp all resources at 20+ req/second resulting in apache being real slow.

I can easly generate this high load issue by using the AB binary included with apache. Using the AB binary on my index.php i see that apache reaches a ridiculous respons time of 10 000ms ++ at peak requests of 20 req/second (which isnt hard to generate with real users and coppermine being that: each thumbnail request = 1 request... 8 thumbs per page + 3 users browsing = peak!!)

If i benchmark a php script that does not have mysql queries there are huge difference in the statistics.. I can generate up to 1000 request/second without having above 10ms respons time.

My guess is that this kind of gallery is not ment to be installed on one single computer, running both apache/php/sql on the same machine.

I wish there was a way to make this work without having to build a NASA rig at home!

For the future i really hope you consider making a coppermine "light" version with stripped down "features" that does not generate so many queries/requests per page, cause i clearly still wanna use your software, its the best out there (look and user friendly wise)

Thank you for your time.

[Nibbler]

Vast majority of Coppermine galleries are running on a single server setup. Looking back at your previous posts you said you are running this on Windows XP. If you use a server operating system instead of a home operating system you are bound to see better results.

[Joachim Müller]

Coppermine can already be configured to save resources, as most options that eat a lot of resources can be disabled. As Nibbler suggested: use a decent server operating system instead of a desktop operating system that is designed to do the job and the job can be done easily on a machine with less power.
Instead of bashing Coppermine for waste of resources, you better connsider getting an operating system that handles resources more carefully. I have little sympathy for a plain rant about coppermine's resources consumption if you're not even willing to discuss the alternatives. Marking thread as "closed".

[dke]

Hi,

I was down to below 50 queries on my index.php, i finally though id remove some albums, so i did... all of the sudden i get 122 queries on index.php.

Code Select Expand

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg147_filetypes; (0s)
    [1] => select * from cpg147_plugins order by priority asc; (0s)
    [2] => delete from `coppermine`.cpg147_sessions where time<1187242067 and remember=0; (0.002s)
    [3] => delete from `coppermine`.cpg147_sessions where time<1186036067; (0.002s)
    [4] => select user_id from `coppermine`.cpg147_sessions where session_id=md5("86669f9e19268cc9902e443055a1f4c84fb84d85bcf77fa0db14736c1c851695"); (0s)
    [5] => select user_id as id, user_password as password from `coppermine`.cpg147_users where user_id=1 (0s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `coppermine`.cpg147_users AS u INNER JOIN `coppermine`.cpg147_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `coppermine`.cpg147_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg147_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg147_usergroups WHERE group_id= 1 (0s)
    [10] => update `coppermine`.cpg147_sessions set time='1187245667' where session_id=md5('86669f9e19268cc9902e443055a1f4c84fb84d85bcf77fa0db14736c1c851695'); (0s)
    [11] => SELECT cid, name, description, thumb FROM cpg147_categories WHERE parent = ''  ORDER BY pos (0.001s)
    [12] => SELECT aid FROM cpg147_albums WHERE category = 14 (0s)
    [13] => SELECT count(*) FROM cpg147_pictures as p, cpg147_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 14 (0s)
    [14] => SELECT count(*) FROM cpg147_albums as a WHERE category = '14' (0s)
    [15] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg147_albums as a LEFT JOIN cpg147_pictures as p ON a.thumb=p.pid WHERE category=14 ORDER BY a.pos LIMIT 0,2 (0.001s)
    [16] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg147_albums AS a  LEFT JOIN cpg147_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (100, 102)GROUP BY a.aid (0.001s)
    [17] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='163807' (0.001s)
    [18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='150180' (0s)
    [19] => SELECT cid, name, description, thumb FROM cpg147_categories WHERE parent = '14'  ORDER BY pos (0s)
    [20] => SELECT aid FROM cpg147_albums WHERE category = 9 (0s)
    [21] => SELECT count(*) FROM cpg147_pictures as p, cpg147_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 9 (0.014s)
    [22] => SELECT count(*) FROM cpg147_albums as a WHERE category = '9' (0s)
    [23] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg147_albums as a LEFT JOIN cpg147_pictures as p ON a.thumb=p.pid WHERE category=9 ORDER BY a.pos LIMIT 0,46 (0.001s)
    [24] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg147_albums AS a  LEFT JOIN cpg147_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (63, 64, 65, 44, 35, 61, 48, 52, 36, 45, 82, 70, 69, 67, 43, 49, 104, 39, 78, 62, 77, 37, 71, 59, 47, 57, 112, 38, 74, 55, 50, 72, 76, 58, 40, 46, 42, 51, 54, 113, 83, 60, 41, 56, 87, 92)GROUP BY a.aid (0.328s)
    [25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='157462' (0s)
    [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158334' (0s)
    [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158790' (0s)
    [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159440' (0s)
    [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='163805' (0s)
    [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158756' (0.001s)
    [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='160948' (0.001s)
    [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159379' (0.001s)
    [33] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='163846' (0s)
    [34] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159381' (0s)
    [35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159390' (0s)
    [36] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159367' (0s)
    [37] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='161201' (0s)
    [38] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159500' (0s)
    [39] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159479' (0s)
    [40] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159270' (0s)
    [41] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159561' (0s)
    [42] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159248' (0s)
    [43] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158153' (0s)
    [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159410' (0s)
    [45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159445' (0s)
    [46] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159443' (0s)
    [47] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158105' (0s)
    [48] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159322' (0s)
    [49] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159439' (0s)
    [50] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159079' (0s)
    [51] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158711' (0.001s)
    [52] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158986' (0s)
    [53] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159045' (0s)
    [54] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='154376' (0s)
    [55] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158662' (0s)
    [56] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158627' (0s)
    [57] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158786' (0s)
    [58] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159145' (0s)
    [59] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159564' (0s)
    [60] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159136' (0s)
    [61] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158800' (0s)
    [62] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159505' (0s)
    [63] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='149598' (0s)
    [64] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159392' (0s)
    [65] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159467' (0s)
    [66] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159105' (0s)
    [67] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='159468' (0s)
    [68] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158409' (0s)
    [69] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='162229' (0s)
    [70] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='164037' (0s)
    [71] => SELECT cid, name, description, thumb FROM cpg147_categories WHERE parent = '9'  ORDER BY pos (0s)
    [72] => SELECT aid FROM cpg147_albums WHERE category = 15 (0s)
    [73] => SELECT count(*) FROM cpg147_pictures as p, cpg147_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 15 (0.001s)
    [74] => SELECT count(*) FROM cpg147_albums as a WHERE category = '15' (0s)
    [75] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg147_albums as a LEFT JOIN cpg147_pictures as p ON a.thumb=p.pid WHERE category=15 ORDER BY a.pos LIMIT 0,3 (0.001s)
    [76] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg147_albums AS a  LEFT JOIN cpg147_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (105, 109, 107)GROUP BY a.aid (0.013s)
    [77] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='155657' (0s)
    [78] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='158804' (0s)
    [79] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='163629' (0s)
    [80] => SELECT cid, name, description, thumb FROM cpg147_categories WHERE parent = '15'  ORDER BY pos (0s)
    [81] => SELECT aid FROM cpg147_albums WHERE category = 11 (0s)
    [82] => SELECT count(*) FROM cpg147_pictures as p, cpg147_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 11 (0.005s)
    [83] => SELECT count(*) FROM cpg147_albums as a WHERE category = '11' (0s)
    [84] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg147_albums as a LEFT JOIN cpg147_pictures as p ON a.thumb=p.pid WHERE category=11 ORDER BY a.pos LIMIT 0,4 (0.001s)
    [85] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg147_albums AS a  LEFT JOIN cpg147_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (34, 33, 29, 103)GROUP BY a.aid (0.094s)
    [86] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='162771' (0.001s)
    [87] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='163850' (0.001s)
    [88] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='163851' (0.001s)
    [89] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='163992' (0.001s)
    [90] => SELECT cid, name, description, thumb FROM cpg147_categories WHERE parent = '11'  ORDER BY pos (0s)
    [91] => SELECT aid FROM cpg147_albums WHERE category = 13 (0s)
    [92] => SELECT count(*) FROM cpg147_pictures as p, cpg147_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 13 (0.001s)
    [93] => SELECT count(*) FROM cpg147_albums as a WHERE category = '13' (0s)
    [94] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg147_albums as a LEFT JOIN cpg147_pictures as p ON a.thumb=p.pid WHERE category=13 ORDER BY a.pos LIMIT 0,4 (0.001s)
    [95] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg147_albums AS a  LEFT JOIN cpg147_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (25, 13, 97, 28)GROUP BY a.aid (0.004s)
    [96] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='160207' (0.002s)
    [97] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='160867' (0.001s)
    [98] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='160208' (0.001s)
    [99] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg147_pictures WHERE pid='163575' (0.001s)
    [100] => SELECT cid, name, description, thumb FROM cpg147_categories WHERE parent = '13'  ORDER BY pos (0s)
    [101] => SELECT aid FROM cpg147_albums as a WHERE category>=10000 (0s)
    [102] => SELECT count(*) FROM cpg147_pictures as p, cpg147_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.001s)
    [103] => SELECT cid, name, description, thumb FROM cpg147_categories WHERE parent = '1'  ORDER BY pos (0s)
    [104] => SELECT aid FROM cpg147_albums as a WHERE category = '0' (0s)
    [105] => SELECT count(*) FROM cpg147_albums as a WHERE 1 (0s)
    [106] => SELECT count(*) FROM cpg147_pictures as p LEFT JOIN cpg147_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.037s)
    [107] => SELECT count(*) FROM cpg147_comments as c LEFT JOIN cpg147_pictures as p ON c.pid=p.pid LEFT JOIN cpg147_albums as a ON a.aid=p.aid WHERE 1 (0.001s)
    [108] => SELECT count(*) FROM cpg147_categories WHERE 1 (0s)
    [109] => SELECT sum(hits) FROM cpg147_pictures as p LEFT JOIN cpg147_albums as a ON p.aid=a.aid WHERE 1 (0.159s)
    [110] => SELECT COUNT(*) FROM cpg147_pictures WHERE approved = 'NO' (0.019s)
    [111] => SELECT count(*) FROM cpg147_albums as a WHERE category = '0' (0s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 5.2.3 - OK
------------------
mySQL version: 5.0.45-community-nt-log
------------------
Coppermine version: 1.4.12(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support: 1
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support:
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.37
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .;C:\php5\pear | .;C:\php5\pear
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | no value | no value
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 60 | 60
max_input_time | 100 | 100
upload_max_filesize | 20M | 20M
post_max_size | 20M | 20M
==========================
Page generated in 0.827 seconds - 112 queries in 0.702 seconds - Album set : ; Meta set: ;

What's going on?