Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: High CPU Load  (Read 2312 times)

0 Members and 1 Guest are viewing this topic.

Danaldinho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
  • Lil Wayne Fan
    • Lil Wayne
High CPU Load
« on: April 13, 2009, 09:58:28 pm »

Hey,

On my gallery, I have a really high CPU load with over 170 queries.

It is making my website really slow and making it keep crashing.

I have tried to reduce the queries by removing the views, statistics and random boxes such as the "most viewed", "latets uploads" and "random pics" etc, but still no luck.

Is there a way for me to reduce it?

Thanks alot :)

Here is my gallery: http://www.lilwaynehq.com/gallery and the queries are below:

Code: [Select]
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0.004s)
    [1] => select * from cpg14x_plugins order by priority asc; (0.002s)
    [2] => delete from `dannym_gallery`.cpg14x_sessions where time<1239647919 and remember=0; (0.001s)
    [3] => delete from `dannym_gallery`.cpg14x_sessions where time<1238441919; (0.001s)
    [4] => select user_id from `dannym_gallery`.cpg14x_sessions where session_id = '4bbe1b1f56954f0b1abb7739c18b2ea7' (0.001s)
    [5] => select user_id as id, user_password as password from `dannym_gallery`.cpg14x_users where user_id=1 (0s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `dannym_gallery`.cpg14x_users AS u INNER JOIN `dannym_gallery`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `dannym_gallery`.cpg14x_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 cpg14x_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [10] => update `dannym_gallery`.cpg14x_sessions set time='1239651519' where session_id = '4bbe1b1f56954f0b1abb7739c18b2ea7' (0s)
    [11] => SELECT description from cpg14x_albums WHERE aid='' (0s)
    [12] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0s)
    [13] => DELETE FROM cpg14x_banned WHERE expiry < '2009-04-13 19:38:39' (0s)
    [14] => SELECT * FROM cpg14x_banned WHERE (ip_addr='86.29.18.137' OR ip_addr='86.29.18.137' OR user_id=1) AND brute_force=0 (0s)
    [15] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = ''  ORDER BY name (0.001s)
    [16] => SELECT aid FROM cpg14x_albums WHERE category = 2 (0s)
    [17] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0.001s)
    [18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='46' (0.001s)
    [19] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '2' (0s)
    [20] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,11 (0.001s)
    [21] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (145, 1, 2, 3, 4, 5, 6, 9, 10, 8, 7)GROUP BY a.aid (0s)
    [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3606' (0s)
    [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='23' (0s)
    [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3314' (0s)
    [25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='40' (0s)
    [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='34' (0s)
    [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='65' (0s)
    [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='56' (0s)
    [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='67' (0s)
    [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='70' (0s)
    [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='78' (0s)
    [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='87' (0s)
    [33] => SELECT aid FROM cpg14x_albums WHERE category = 3 (0s)
    [34] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0s)
    [35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='148' (0s)
    [36] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '3' (0s)
    [37] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 0,3 (0.001s)
    [38] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (11, 12, 13)GROUP BY a.aid (0.001s)
    [39] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='138' (0s)
    [40] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3661' (0s)
    [41] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='148' (0s)
    [42] => SELECT aid FROM cpg14x_albums WHERE category = 4 (0s)
    [43] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0.001s)
    [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2099' (0s)
    [45] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '4' (0s)
    [46] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=4 ORDER BY a.pos LIMIT 0,12 (0.002s)
    [47] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (119, 99, 116, 117, 118, 113, 111, 115, 100, 101, 137, 102)GROUP BY a.aid (0.003s)
    [48] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3785' (0s)
    [49] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2664' (0s)
    [50] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2672' (0s)
    [51] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2682' (0s)
    [52] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2723' (0.001s)
    [53] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2704' (0.001s)
    [54] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2725' (0.001s)
    [55] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3136' (0.001s)
    [56] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3137' (0.001s)
    [57] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2858' (0.001s)
    [58] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3851' (0.001s)
    [59] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3608' (0.001s)
    [60] => SELECT aid FROM cpg14x_albums WHERE category = 5 (0s)
    [61] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0s)
    [62] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='157' (0s)
    [63] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '5' (0s)
    [64] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=5 ORDER BY a.pos LIMIT 0,1 (0s)
    [65] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (16)GROUP BY a.aid (0.001s)
    [66] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3712' (0s)
    [67] => SELECT aid FROM cpg14x_albums WHERE category = 6 (0s)
    [68] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0s)
    [69] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2113' (0s)
    [70] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '6' (0s)
    [71] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,3 (0s)
    [72] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (17, 18, 19)GROUP BY a.aid (0.001s)
    [73] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2176' (0s)
    [74] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3856' (0s)
    [75] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3857' (0s)
    [76] => SELECT aid FROM cpg14x_albums WHERE category = 7 (0s)
    [77] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
    [78] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='14' (0s)
    [79] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '7' (0s)
    [80] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=7 ORDER BY a.pos LIMIT 0,2 (0s)
    [81] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (20, 104)GROUP BY a.aid (0s)
    [82] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3855' (0s)
    [83] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3609' (0.001s)
    [84] => SELECT aid FROM cpg14x_albums WHERE category = 8 (0s)
    [85] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0s)
    [86] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1801' (0s)
    [87] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '8' (0s)
    [88] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=8 ORDER BY a.pos LIMIT 0,12 (0s)
    [89] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (61, 103, 144, 142, 62, 60, 64, 65, 88, 84, 85, 83)GROUP BY a.aid (0s)
    [90] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2253' (0s)
    [91] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2154' (0s)
    [92] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3633' (0s)
    [93] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3532' (0s)
    [94] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1262' (0s)
    [95] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1353' (0s)
    [96] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1309' (0s)
    [97] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1343' (0s)
    [98] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1771' (0.001s)
    [99] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2044' (0s)
    [100] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2064' (0s)
    [101] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1778' (0s)
    [102] => SELECT aid FROM cpg14x_albums WHERE category = 9 (0s)
    [103] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 9 (0s)
    [104] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='204' (0s)
    [105] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '9' (0s)
    [106] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=9 ORDER BY a.pos LIMIT 0,1 (0s)
    [107] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (21)GROUP BY a.aid (0s)
    [108] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3988' (0s)
    [109] => SELECT aid FROM cpg14x_albums WHERE category = 10 (0s)
    [110] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 10 (0s)
    [111] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='279' (0s)
    [112] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '10' (0s)
    [113] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=10 ORDER BY a.pos LIMIT 0,1 (0s)
    [114] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (22)GROUP BY a.aid (0s)
    [115] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3984' (0s)
    [116] => SELECT aid FROM cpg14x_albums WHERE category = 11 (0s)
    [117] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 11 (0s)
    [118] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2196' (0s)
    [119] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '11' (0s)
    [120] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=11 ORDER BY a.pos LIMIT 0,4 (0s)
    [121] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (42, 43, 44, 152)GROUP BY a.aid (0s)
    [122] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3991' (0s)
    [123] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3853' (0s)
    [124] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2167' (0s)
    [125] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3823' (0s)
    [126] => SELECT aid FROM cpg14x_albums WHERE category = 12 (0s)
    [127] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 12 (0s)
    [128] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1054' (0s)
    [129] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '12' (0s)
    [130] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=12 ORDER BY a.pos LIMIT 0,12 (0s)
    [131] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (147, 105, 45, 47, 57, 46, 48, 49, 143, 138, 50, 141)GROUP BY a.aid (0s)
    [132] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3657' (0s)
    [133] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3242' (0s)
    [134] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='960' (0s)
    [135] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='966' (0.001s)
    [136] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1141' (0.001s)
    [137] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2220' (0.001s)
    [138] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2178' (0s)
    [139] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='980' (0s)
    [140] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3562' (0s)
    [141] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3756' (0s)
    [142] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='998' (0s)
    [143] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3716' (0s)
    [144] => SELECT aid FROM cpg14x_albums WHERE category = 13 (0s)
    [145] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 13 (0s)
    [146] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2078' (0s)
    [147] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '13' (0s)
    [148] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=13 ORDER BY a.pos LIMIT 0,2 (0s)
    [149] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (23, 24)GROUP BY a.aid (0s)
    [150] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3811' (0s)
    [151] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='302' (0.002s)
    [152] => SELECT aid FROM cpg14x_albums as a WHERE category>=10000 (0s)
    [153] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
    [154] => SELECT aid FROM cpg14x_albums WHERE category = 14 (0s)
    [155] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 14 (0s)
    [156] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='907' (0s)
    [157] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '14' (0s)
    [158] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=14 ORDER BY a.pos LIMIT 0,12 (0s)
    [159] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (25, 27, 32, 127, 146, 38, 30, 35, 31, 39, 28, 36)GROUP BY a.aid (0s)
    [160] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2797' (0s)
    [161] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='723' (0s)
    [162] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='751' (0s)
    [163] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3030' (0s)
    [164] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='3645' (0.001s)
    [165] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='772' (0s)
    [166] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='790' (0s)
    [167] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='2480' (0s)
    [168] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='847' (0s)
    [169] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='851' (0.001s)
    [170] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='882' (0.001s)
    [171] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='904' (0s)
    [172] => SELECT aid FROM cpg14x_albums as a WHERE category = '0' (0.001s)
    [173] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0.008s)
    [174] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '0' (0s)
)
Logged

Nibbler

  • Guest
Re: High CPU Load
« Reply #1 on: April 13, 2009, 10:14:34 pm »

All of those database queries are fast. Are you sure it's MySQL that's causing high load?
Logged

Danaldinho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
  • Lil Wayne Fan
    • Lil Wayne
Re: High CPU Load
« Reply #2 on: April 13, 2009, 10:21:53 pm »

Ok, thanks
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: High CPU Load
« Reply #3 on: April 14, 2009, 09:20:40 am »

OK what? Could you answer Nibbler's question?

Additionally, you're running an outdated version. You have been told in the past already about the consequences of running outdated app, so I won't repeat this...
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.