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] 2   Go Down

Author Topic: Photo gallery slow to respond, please assist.  (Read 16379 times)

0 Members and 2 Guests are viewing this topic.

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Photo gallery slow to respond, please assist.
« on: May 29, 2009, 02:26:31 am »

Good afternoon all!  ;D

I have my main page at www.bestinthewestphoto.com. Then the coppermine installation is at www.bestinthewestphoto.com/coppermine/ is where I'm having the issue.

I've used the debug mode (what a GREAT idea!!) and have seen page load times all the way up to 189.892 seconds although the usual is 38 - 52 seconds.
I have contacted my web server and they say there is nothing they can do.... One person said that they saw a problem and would 'upgrade' my concern, the upgrade person then stated they don't see a problem....
I have used mysql and optimized my tables, ran repair, and even checked them out and found NOTHING that helped.

I will include the debug log here in hopes of some ideas.

I've also killed the logging, and other things I've seen that others have had problems with (in the config area, no extras or random thumbnails...) I have searched and just have not found my problem.

I will try anything, although I'm somewhat green under the hood of the program itself.

Here is the debug mode:
Code: [Select]
USER:
------------------
Array
(
    [ID] => 1eddb04dbb8c0fde566065fc4a4a01f6
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [0] => 45280
            [1] => 2946
            [2] => 44236
            [3] => 1768
            [4] => 42960
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Jason
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg148_filetypes; (0.001s)
    [1] => select * from cpg148_plugins order by priority asc; (0s)
    [2] => delete from `coppbitw`.cpg148_sessions where time<1243551139 and remember=0; (0.759s)
    [3] => delete from `coppbitw`.cpg148_sessions where time<1242345139; (3.078s)
    [4] => select user_id from `coppbitw`.cpg148_sessions where session_id = '4d36550164992feb420c5de59e61d1ae' (1.238s)
    [5] => select user_id as id, user_password as password from `coppbitw`.cpg148_users where user_id=1 (1.562s)
    [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 `coppbitw`.cpg148_users AS u INNER JOIN `coppbitw`.cpg148_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
    [7] => SELECT user_group_list FROM `coppbitw`.cpg148_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 cpg148_usergroups WHERE group_id in (1) (2.081s)
    [9] => SELECT group_name FROM  cpg148_usergroups WHERE group_id= 1 (1.896s)
    [10] => update `coppbitw`.cpg148_sessions set time='1243554750' where session_id = '4d36550164992feb420c5de59e61d1ae' (0s)
    [11] => SELECT user_favpics FROM cpg148_favpics WHERE user_id = 1 (1.135s)
    [12] => SELECT * FROM cpg148_shop_config ORDER BY priority ASC (0.007s)
    [13] => DELETE FROM cpg148_banned WHERE expiry < '2009-05-28 16:54:56' (0.478s)
    [14] => SELECT * FROM cpg148_banned WHERE (ip_addr='70.134.69.228' OR ip_addr='70.134.69.228' OR user_id=1) AND brute_force=0 (0.62s)
    [15] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = ''  ORDER BY pos (0.783s)
    [16] => SELECT aid FROM cpg148_albums as a WHERE category>=10000 (1.536s)
    [17] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.001s)
    [18] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '1'  ORDER BY pos (0.07s)
    [19] => SELECT aid FROM cpg148_albums WHERE category = 5 (0.001s)
    [20] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0.001s)
    [21] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '5'  ORDER BY pos (0.001s)
    [22] => SELECT aid FROM cpg148_albums WHERE category = 6 (1.903s)
    [23] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (2.03s)
    [24] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '6'  ORDER BY pos (0.341s)
    [25] => SELECT aid FROM cpg148_albums WHERE category = 282 (1.345s)
    [26] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 282 (1.093s)
    [27] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '282'  ORDER BY pos (0.001s)
    [28] => SELECT aid FROM cpg148_albums WHERE category = 286 (0s)
    [29] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 286 (0s)
    [30] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '286'  ORDER BY pos (0s)
    [31] => SELECT aid FROM cpg148_albums WHERE category = 285 (0s)
    [32] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 285 (0s)
    [33] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '285'  ORDER BY pos (0s)
    [34] => SELECT aid FROM cpg148_albums WHERE category = 284 (1.608s)
    [35] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 284 (0.687s)
    [36] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '284'  ORDER BY pos (0.256s)
    [37] => SELECT aid FROM cpg148_albums WHERE category = 311 (0.25s)
    [38] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 311 (0.163s)
    [39] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '311'  ORDER BY pos (0.003s)
    [40] => SELECT aid FROM cpg148_albums WHERE category = 310 (0.002s)
    [41] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 310 (0s)
    [42] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '310'  ORDER BY pos (0.013s)
    [43] => SELECT aid FROM cpg148_albums WHERE category = 309 (0.003s)
    [44] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 309 (0.001s)
    [45] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '309'  ORDER BY pos (0.016s)
    [46] => SELECT aid FROM cpg148_albums WHERE category = 305 (0.002s)
    [47] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 305 (0s)
    [48] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '305'  ORDER BY pos (0.001s)
    [49] => SELECT aid FROM cpg148_albums WHERE category = 308 (0.001s)
    [50] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 308 (2.87s)
    [51] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '308'  ORDER BY pos (0.114s)
    [52] => SELECT aid FROM cpg148_albums WHERE category = 283 (0.191s)
    [53] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 283 (0.255s)
    [54] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '283'  ORDER BY pos (0.151s)
    [55] => SELECT aid FROM cpg148_albums WHERE category = 287 (0.001s)
    [56] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 287 (0.305s)
    [57] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '287'  ORDER BY pos (0.14s)
    [58] => SELECT aid FROM cpg148_albums WHERE category = 302 (0.002s)
    [59] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 302 (0.45s)
    [60] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '302'  ORDER BY pos (0.159s)
    [61] => SELECT aid FROM cpg148_albums WHERE category = 303 (0.001s)
    [62] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 303 (0.001s)
    [63] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '303'  ORDER BY pos (0.237s)
    [64] => SELECT aid FROM cpg148_albums WHERE category = 17 (0.263s)
    [65] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 17 (0s)
    [66] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '17'  ORDER BY pos (1.238s)
    [67] => SELECT aid FROM cpg148_albums WHERE category = 21 (0.01s)
    [68] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 21 (0.371s)
    [69] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '21'  ORDER BY pos (0.022s)
    [70] => SELECT aid FROM cpg148_albums WHERE category = 281 (0.001s)
    [71] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 281 (0.625s)
    [72] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '281'  ORDER BY pos (0.703s)
    [73] => SELECT aid FROM cpg148_albums WHERE category = 262 (0.2s)
    [74] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 262 (0.242s)
    [75] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '262'  ORDER BY pos (0s)
    [76] => SELECT aid FROM cpg148_albums WHERE category = 20 (0s)
    [77] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 20 (0s)
    [78] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '20'  ORDER BY pos (0s)
    [79] => SELECT aid FROM cpg148_albums WHERE category = 242 (0.055s)
    [80] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 242 (0.112s)
    [81] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '242'  ORDER BY pos (0s)
    [82] => SELECT aid FROM cpg148_albums WHERE category = 25 (0s)
    [83] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 25 (0.001s)
    [84] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '25'  ORDER BY pos (0.108s)
    [85] => SELECT aid FROM cpg148_albums WHERE category = 229 (0.016s)
    [86] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 229 (0.031s)
    [87] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '229'  ORDER BY pos (0.179s)
    [88] => SELECT aid FROM cpg148_albums WHERE category = 214 (0.128s)
    [89] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 214 (0.045s)
    [90] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '214'  ORDER BY pos (0.001s)
    [91] => SELECT aid FROM cpg148_albums WHERE category = 27 (0.001s)
    [92] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 27 (0.005s)
    [93] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '27'  ORDER BY pos (0.001s)
    [94] => SELECT aid FROM cpg148_albums WHERE category = 33 (0.028s)
    [95] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 33 (0.019s)
    [96] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '33'  ORDER BY pos (0.004s)
    [97] => SELECT aid FROM cpg148_albums WHERE category = 19 (0.137s)
    [98] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 19 (0.004s)
    [99] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '19'  ORDER BY pos (0.001s)
    [100] => SELECT aid FROM cpg148_albums WHERE category = 24 (0.344s)
    [101] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 24 (0.22s)
    [102] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '24'  ORDER BY pos (0s)
    [103] => SELECT aid FROM cpg148_albums WHERE category = 206 (0s)
    [104] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 206 (0s)
    [105] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '206'  ORDER BY pos (0s)
    [106] => SELECT aid FROM cpg148_albums WHERE category = 213 (0.001s)
    [107] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 213 (0.062s)
    [108] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '213'  ORDER BY pos (0.125s)
    [109] => SELECT aid FROM cpg148_albums WHERE category = 18 (0.192s)
    [110] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 18 (0s)
    [111] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '18'  ORDER BY pos (0s)
    [112] => SELECT aid FROM cpg148_albums WHERE category = 223 (0.001s)
    [113] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 223 (0.076s)
    [114] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '223'  ORDER BY pos (0.486s)
    [115] => SELECT aid FROM cpg148_albums WHERE category = 203 (1.454s)
    [116] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 203 (0.928s)
    [117] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '203'  ORDER BY pos (0.241s)
    [118] => SELECT aid FROM cpg148_albums WHERE category = 192 (0.167s)
    [119] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 192 (0.508s)
    [120] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '192'  ORDER BY pos (0.451s)
    [121] => SELECT aid FROM cpg148_albums WHERE category = 190 (0s)
    [122] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 190 (0.385s)
    [123] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '190'  ORDER BY pos (0.001s)
    [124] => SELECT aid FROM cpg148_albums WHERE category = 227 (0.001s)
    [125] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 227 (3.368s)
    [126] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '227'  ORDER BY pos (0.179s)
    [127] => SELECT aid FROM cpg148_albums WHERE category = 29 (0.002s)
    [128] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 29 (0.001s)
    [129] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '29'  ORDER BY pos (0.185s)
    [130] => SELECT aid FROM cpg148_albums WHERE category = 225 (0.15s)
    [131] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 225 (0.014s)
    [132] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '225'  ORDER BY pos (0.001s)
    [133] => SELECT aid FROM cpg148_albums WHERE category = 16 (0.001s)
    [134] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 16 (0.001s)
    [135] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '16'  ORDER BY pos (0.001s)
    [136] => SELECT aid FROM cpg148_albums WHERE category = 15 (0.001s)
    [137] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 15 (0.001s)
    [138] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '15'  ORDER BY pos (0.007s)
    [139] => SELECT aid FROM cpg148_albums WHERE category = 193 (0.009s)
    [140] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 193 (0s)
    [141] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '193'  ORDER BY pos (0s)
    [142] => SELECT aid FROM cpg148_albums WHERE category = 26 (0s)
    [143] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 26 (0s)
    [144] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '26'  ORDER BY pos (0s)
    [145] => SELECT aid FROM cpg148_albums WHERE category = 32 (0s)
    [146] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 32 (0s)
    [147] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '32'  ORDER BY pos (0s)
    [148] => SELECT aid FROM cpg148_albums WHERE category = 14 (0s)
    [149] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 14 (0s)
    [150] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '14'  ORDER BY pos (0s)
    [151] => SELECT aid FROM cpg148_albums WHERE category = 22 (0s)
    [152] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 22 (0s)
    [153] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '22'  ORDER BY pos (0s)
    [154] => SELECT aid FROM cpg148_albums WHERE category = 23 (0s)
    [155] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 23 (0s)
    [156] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '23'  ORDER BY pos (0.005s)
    [157] => SELECT aid FROM cpg148_albums WHERE category = 28 (0.005s)
    [158] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 28 (0.005s)
    [159] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '28'  ORDER BY pos (0s)

Continued below:
Logged

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #1 on: May 29, 2009, 02:28:05 am »

Code: [Select]
[160] => SELECT aid FROM cpg148_albums WHERE category = 194 (0s)
    [161] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 194 (0s)
    [162] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '194'  ORDER BY pos (0.006s)
    [163] => SELECT aid FROM cpg148_albums WHERE category = 13 (0.002s)
    [164] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 13 (0.001s)
    [165] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '13'  ORDER BY pos (0.003s)
    [166] => SELECT aid FROM cpg148_albums WHERE category = 10 (0s)
    [167] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 10 (0s)
    [168] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '10'  ORDER BY pos (0s)
    [169] => SELECT aid FROM cpg148_albums WHERE category = 7 (0s)
    [170] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
    [171] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '7'  ORDER BY pos (0s)
    [172] => SELECT aid FROM cpg148_albums WHERE category = 8 (0s)
    [173] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0.001s)
    [174] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '8'  ORDER BY pos (0.171s)
    [175] => SELECT aid FROM cpg148_albums WHERE category = 40 (0.044s)
    [176] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 40 (0.001s)
    [177] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '40'  ORDER BY pos (0.001s)
    [178] => SELECT aid FROM cpg148_albums WHERE category = 41 (0.001s)
    [179] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 41 (0.105s)
    [180] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '41'  ORDER BY pos (0.064s)
    [181] => SELECT aid FROM cpg148_albums WHERE category = 42 (0.034s)
    [182] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 42 (0.001s)
    [183] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '42'  ORDER BY pos (0.013s)
    [184] => SELECT aid FROM cpg148_albums WHERE category = 43 (0.001s)
    [185] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 43 (0.01s)
    [186] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '43'  ORDER BY pos (0.183s)
    [187] => SELECT aid FROM cpg148_albums WHERE category = 12 (0s)
    [188] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 12 (0s)
    [189] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '12'  ORDER BY pos (0s)
    [190] => SELECT aid FROM cpg148_albums WHERE category = 37 (0s)
    [191] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 37 (0s)
    [192] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '37'  ORDER BY pos (0s)
    [193] => SELECT aid FROM cpg148_albums WHERE category = 275 (0s)
    [194] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 275 (0s)
    [195] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '275'  ORDER BY pos (0s)
    [196] => SELECT aid FROM cpg148_albums WHERE category = 39 (0s)
    [197] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 39 (0.06s)
    [198] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '39'  ORDER BY pos (0.209s)
    [199] => SELECT aid FROM cpg148_albums WHERE category = 30 (0s)
    [200] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 30 (0s)
    [201] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '30'  ORDER BY pos (0s)
    [202] => SELECT aid FROM cpg148_albums WHERE category = 38 (0s)
    [203] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 38 (0s)
    [204] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '38'  ORDER BY pos (0s)
    [205] => SELECT aid FROM cpg148_albums as a WHERE category = '0' (0.047s)
    [206] => SELECT count(*) FROM cpg148_albums as a WHERE 1 (0.011s)
    [207] => SELECT count(*) FROM cpg148_pictures as p LEFT JOIN cpg148_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.005s)
    [208] => SELECT count(*) FROM cpg148_comments as c LEFT JOIN cpg148_pictures as p ON c.pid=p.pid LEFT JOIN cpg148_albums as a ON a.aid=p.aid WHERE 1 (0.003s)
    [209] => SELECT count(*) FROM cpg148_categories WHERE 1 (0.001s)
    [210] => SELECT sum(hits) FROM cpg148_pictures as p LEFT JOIN cpg148_albums as a ON p.aid=a.aid WHERE 1 (0s)
    [211] => SELECT COUNT(*) FROM cpg148_pictures WHERE approved = 'NO' (0.063s)
    [212] => SELECT count(*) FROM cpg148_albums as a WHERE category = '0' (0.005s)
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.4 - OK
------------------
mySQL version: 5.0.51a-log
------------------
Coppermine version: 1.4.20(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
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 4.1.11
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.2
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 | .:/usr/local/lib/php-5.2.4/lib/php | .:/usr/local/lib/php-5.2.4/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 500 | 500
max_input_time | 90 | 90
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 189.892 seconds - 213 queries in 45.021 seconds - Album set : ; Meta set: ;

The problemed sites address is: http://bestinthewestphoto.com/coppermine/

If you need a user name please feel free to use:
User: test
PW: test123


Thank you all for taking the time to give me a hand, I'm sure in need.
I run this site for my mother and wife's photography practice. They said they've had concerns with people asking about loading time and the site.

- Jason
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Photo gallery slow to respond, please assist.
« Reply #2 on: May 29, 2009, 03:13:45 am »

Upgrade your Coppermine installation - it is old, you are at risk.
Quote
<!--Coppermine Photo Gallery 1.4.20 (stable)-->
Don't post debug unless asked - board rule.

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #3 on: May 29, 2009, 03:19:24 am »

Upgrade your Coppermine installation - it is old, you are at risk.Don't post debug unless asked - board rule.

I'll look into upgrading, thank you for that.

I'm sorry about posting the debug like that - I was trying to be prepared as I could.
Logged

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #4 on: May 29, 2009, 04:38:21 am »

Ok, I just performed my update!!

Unfortunately the same exact problem exists.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Photo gallery slow to respond, please assist.
« Reply #5 on: May 29, 2009, 10:07:16 am »

Speed is sufficient in my opinion - at least when I looked.
There is a load of queires going on according to debug_output. As you haven't enabled debug_output for everyone, we can't see foir ourselves on which page that happens. Also post what mods/plugins you're using, preferably with links to the announcement threads.
Logged

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #6 on: May 29, 2009, 05:28:40 pm »

I'm sorry about that, I didn't mean to waste your time!
I will enable debugging output for everyone (I forgot that)...
Plugins:
=========================================================================
Name Photo Shop v1.3.6     
Author Stramm stramm@gmx.net stramm.st.funpic.org
Description Photo Shop adds a possibility to sell images on your Coppermine Photo Gallery.
http://forum.coppermine-gallery.net/index.php/topic,57206.0.html

Name CAPTCHA v3.0     
Author bmossavari at My Project
Description Fighting with spam with CAPTCHA,
Configuration By default confirmation will not show for register users , comment out those lines under codebase.php if you want confirmation for all
http://forum.coppermine-gallery.net/index.php/topic,36319.0.html

Name CPGMassImport v2.0     
Author Nibbler, Donnoman cpg-contrib.org, Flux, and Paver.
Description CPGMassImport gives the admin the ability to import large numbers of pictures organized by directory structure.
http://cpg-contrib.org/board/index.php?board=25.0

=======================================================================================

Debugging is now active.
It seems like it takes awhile for the site to 'wake up' from non activity... this morning it took 148 seconds to access it, but, it took 1.6 seconds to access the plug in panel...
I wish I knew how to help you better, if there's anything else please let me know!

Thank you for your time all!

- Jason
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Photo gallery slow to respond, please assist.
« Reply #7 on: May 29, 2009, 06:55:37 pm »

One suggestion based on a different experience, rather than any direct observations...
Take a look around for log/error files - anything in them? have they grown to huge sizes?

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #8 on: May 29, 2009, 10:46:57 pm »

One suggestion based on a different experience, rather than any direct observations...
Take a look around for log/error files - anything in them? have they grown to huge sizes?



Thank you for the great tips Imagine! I have indeed checked the log/error files in coppermine and they have shown nothing to me. I then dis-abled logging as I read it would speed things up.
So as of now my logs are off.

I sure appreciate it, keep 'em coming! :)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Photo gallery slow to respond, please assist.
« Reply #9 on: May 29, 2009, 11:03:49 pm »

i-imagine probably wasn't refering to coppermine's log, but to the server's log.
Logged

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #10 on: May 29, 2009, 11:28:57 pm »

i-imagine probably wasn't refering to coppermine's log, but to the server's log.
I feel so stupid...

No nothing there on the log and it shows no errors. I'm on Startlogic if that helps.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Photo gallery slow to respond, please assist.
« Reply #11 on: May 30, 2009, 10:55:38 am »

If there's actually "nothing" in that log, you're definitely looking into the wrong file. The server's access log must be full. I could understand if you said
Quote
it doesn't mean anything to me
or
Quote
I don't have access to it
, but
nothing there on the log
doesn't apply.

I'm on Startlogic if that helps.
Not really, sorry.
Logged

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #12 on: May 30, 2009, 04:30:31 pm »

If there's actually "nothing" in that log, you're definitely looking into the wrong file. The server's access log must be full. I could understand if you said  or , butdoesn't apply.
Not really, sorry.

It's borderline another language to me! :)

All it has is files that were accessed and IPs of the person accessing the files. It's HORRIDLY long and unkept, but, other than what they acessed, I never saw an error or notice in them.

You had mentioned alot of queries, is there a way I can turn that off?

Logged

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #13 on: May 30, 2009, 04:31:46 pm »

The only other thing I can think of is don't have access to the log in question maybe?
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Photo gallery slow to respond, please assist.
« Reply #14 on: May 30, 2009, 05:36:48 pm »

Like it or not you are now a webmaster and it is in your best interest to find out how your server works, collects error and usage data and also how to perform maintenance. A big log could contain hacking attempts, bandwidth theft info. or it could have data that would help you to promote your site. One log and one log alone would be unusual - ex. FTP and HTTP activity should be logged separately.

You could/would/should learn a little bit more about how your Coppermine works and if your really need to have so much/many listings on every page (try searching google for queries), if your pages load differently with varied image/thumb/plugin/mod/tablerow combinations, etc, etc..

I found your site to be inconsistent at best, could it be caused by a shared server? That would be your issue to solve, since it would be difficult to see if you are on the same IP or in the same box as a porn site or someone who is getting DOS'd, You and your hosting company will have to solve that.

Don't be shy with digging around and making changes, you might even have some fun.



Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #15 on: May 30, 2009, 07:28:27 pm »

Imagine, thank you for your help in this!

I went into the startlogic control panel (it's very pretty but not very useful I guess...) I finally found AWStats loaded there. I kept search around and I FTP'd in my site and found a dir called stats.... Voila.... Everything and more I wanted to know about my site!!

FTP logs - Noone transfering or trying to get into my site that's not my IP address w/ my or another user name. So it looks good there.
All files (including my recent update recommended by you) are listed and the trailing details as well (who, where, when...).

I did however find quite a few 404 errors dealing with coppermine and image file names....
Example:

/coppermine/IMG_9727.jpg   1   http://www.bestinthewestphoto.com/coppermine/thumbnails.php

The coppermine directory you see listed is how my web server is setup... the IMG is the image name. It says the referrer is thumbnails.php

It isn't one specific image file, it's very hit and miss.
I haven't move anything, I've added, but not deleted or moved any image files.

I've seen no other referrers than index.php, thumbnails.php, and displayimage.php


=========================

I've also noticed in the log that I have 108 hits for code 206 - Partial content as it's listed...
However on the 206 codes i can't find ANYWHERE where the actual file/content error is or what they were trying to access.

I'm going to keep digging -
Thank you again! Can't wait for this to be fixed  ;D
Logged

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #16 on: May 30, 2009, 07:31:14 pm »

I'm a TOTAL idiot - I wanted to edit my above post and instead marked it 'solved'.... aaaarrrggghh.

Sorry guys, could you mark it unsolved for me? I'm going to search around and see if I can do it myself.


I was going to tell
Logged

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #17 on: May 31, 2009, 04:24:37 am »

Well i learned a few things today  ;D

I pinged my site and got:

Code: [Select]
C:\Documents and Settings\Jason>ping www.bestinthewestphoto.com

Pinging www.bestinthewestphoto.com [66.96.134.79] with 32 bytes of data:

Reply from 66.96.134.79: bytes=32 time=96ms TTL=243
Reply from 66.96.134.79: bytes=32 time=97ms TTL=243
Reply from 66.96.134.79: bytes=32 time=96ms TTL=243
Reply from 66.96.134.79: bytes=32 time=95ms TTL=243

Ping statistics for 66.96.134.79:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 95ms, Maximum = 97ms, Average = 96ms

C:\Documents and Settings\Jason>

I also then did a tracert:
Code: [Select]
C:\Documents and Settings\Jason>tracert www.bestinthewestphoto.com

Tracing route to www.bestinthewestphoto.com [66.96.134.79]
over a maximum of 30 hops:

  1     1 ms     1 ms     1 ms  192.168.1.1
  2     1 ms     1 ms     1 ms  192.168.0.1
  3     9 ms     9 ms     9 ms  70.134.95.254
  4    10 ms     9 ms     9 ms  dist2-vlan50.mtry01.pbi.net [216.102.186.188]
  5    10 ms     9 ms     9 ms  63.197.100.196
  6    23 ms    22 ms    21 ms  151.164.38.46
  7    22 ms    22 ms    21 ms  po5-2.core01.sjc04.atlas.cogentco.com [154.54.13.93]
  8    21 ms    21 ms    21 ms  te9-2.mpd01.sjc04.atlas.cogentco.com [154.54.0.173]
  9    22 ms    22 ms    22 ms  te8-2.ccr02.sfo01.atlas.cogentco.com [154.54.7.173]
 10    60 ms    61 ms    61 ms  te3-3.ccr02.mci01.atlas.cogentco.com [154.54.6.162]
 11    70 ms    70 ms    69 ms  te2-1.mpd02.ord01.atlas.cogentco.com [154.54.6.254]
 12   102 ms    94 ms    94 ms  te8-1.ccr02.bos01.atlas.cogentco.com [154.54.7.170]
 13    96 ms    95 ms    95 ms  endurance-international-group.demarc.cogentco.com [38.97.106.34]
 14    95 ms    96 ms    95 ms  238.252.148.207.static.yourhostingaccount.com [207.148.252.238]
 15    95 ms    95 ms    95 ms  79.134.96.66.static.eigbox.net [66.96.134.79]

Trace complete.

C:\Documents and Settings\Jason>

I've been reading and honestly noone publishes a 'guideline' or normal use for these times... I just wanted to put them up there if they mean anything...

I also went to the MYSQL and optimized all the tables in my database... still no change.
Logged

Jasondt2001

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Photo gallery slow to respond, please assist.
« Reply #18 on: May 31, 2009, 05:12:17 am »

I THINK I'M ON TO SOMETHING?!?!!!

I went and looked around at the MYSQL Runtime information and even though it's another language there was a few values written in red indicating a problem!

Code: [Select]
=================================================================================================================================
Query statistics: Since its startup, 2,736,117,263 queries have been sent to the server.
Total ø per hour ø per minute ø per second
3 G 2.07 M 34.44 k 574.07
Query type ø per hour %
admin commands 0 0.00 0.00%
alter db 0 0.00 0.00%
alter table 0 0.00 0.00%
analyze 0 0.00 0.00%
backup table 0 0.00 0.00%
begin 0 0.00 0.00%
call procedure 0 0.00 0.00%
change db 0 0.00 0.00%
change master 0 0.00 0.00%
check 0 0.00 0.00%
checksum 0 0.00 0.00%
commit 0 0.00 0.00%
create db 0 0.00 0.00%
create function 0 0.00 0.00%
create index 0 0.00 0.00%
create table 0 0.00 0.00%
create user 0 0.00 0.00%
delete 0 0.00 0.00%
delete multi 0 0.00 0.00%
do 0 0.00 0.00%
drop db 0 0.00 0.00%
drop function 0 0.00 0.00%
drop index 0 0.00 0.00%
drop table 0 0.00 0.00%
drop user 0 0.00 0.00%
flush 0 0.00 0.00%
grant 0 0.00 0.00%
ha close 0 0.00 0.00%
ha open 0 0.00 0.00%
ha read 0 0.00 0.00%
help 0 0.00 0.00%
insert 0 0.00 0.00%
insert select 0 0.00 0.00%
kill 0 0.00 0.00%
load 0 0.00 0.00%
load master data 0 0.00 0.00%
load master table 0 0.00 0.00%
lock tables 0 0.00 0.00%
optimize 0 0.00 0.00%
preload keys 0 0.00 0.00%
purge 0 0.00 0.00%
purge before date 0 0.00 0.00%
rename table 0 0.00 0.00%
repair 0 0.00 0.00%
replace 0 0.00 0.00%
replace select 0 0.00 0.00%
reset 0 0.00 0.00%
restore table 0 0.00 0.00%
revoke 0 0.00 0.00%
revoke all 0 0.00 0.00%
Query type ø per hour %
rollback 0 0.00 0.00%
savepoint 0 0.00 0.00%
select 1 0.76 m 0.00%
set option 2 0.00 0.00%
show binlog events 0 0.00 0.00%
show binlogs 1 0.76 m 0.00%
show charsets 1 0.76 m 0.00%
show collations 1 0.76 m 0.00%
show column types 0 0.00 0.00%
show create db 0 0.00 0.00%
show create table 0 0.00 0.00%
show databases 0 0.00 0.00%
show errors 0 0.00 0.00%
show fields 0 0.00 0.00%
show grants 0 0.00 0.00%
show innodb status 0 0.00 0.00%
show keys 0 0.00 0.00%
show logs 0 0.00 0.00%
show master status 0 0.00 0.00%
show ndb status 0 0.00 0.00%
show new master 0 0.00 0.00%
show open tables 0 0.00 0.00%
show privileges 0 0.00 0.00%
show processlist 0 0.00 0.00%
show slave hosts 0 0.00 0.00%
show slave status 0 0.00 0.00%
show status 1 0.76 m 0.00%
show storage engines 0 0.00 0.00%
show tables 0 0.00 0.00%
show triggers 0 0.00 0.00%
show variables 2 0.00 0.00%
show warnings 0 0.00 0.00%
slave start 0 0.00 0.00%
slave stop 0 0.00 0.00%
stmt close 0 0.00 0.00%
stmt execute 0 0.00 0.00%
stmt fetch 0 0.00 0.00%
stmt prepare 0 0.00 0.00%
stmt reset 0 0.00 0.00%
stmt send long data 0 0.00 0.00%
truncate 0 0.00 0.00%
unlock tables 0 0.00 0.00%
update 0 0.00 0.00%
update multi 0 0.00 0.00%
xa commit 0 0.00 0.00%
xa end 0 0.00 0.00%
xa prepare 0 0.00 0.00%
xa recover 0 0.00 0.00%
xa rollback 0 0.00 0.00%
xa start 0 0.00 0.00%
Begin Variable Value Description
Flush_commands 1 The number of executed FLUSH statements.
Last_query_cost 10.50 The total cost of the last compiled query as computed by the query optimizer. Useful for comparing the cost of different query plans for the same query. The default value of 0 means that no query has been compiled yet.
Slow_queries 0 The number of queries that have taken more than long_query_time seconds. MySQL - Documentation
Begin InnoDB Variable Value Description
Variables InnoDB Status MySQL - Documentation
Innodb_buffer_pool_pages_data 0 The number of pages containing data (dirty or clean).
Innodb_buffer_pool_pages_dirty 0 The number of pages currently dirty.
Innodb_buffer_pool_pages_flushed 0 The number of buffer pool pages that have been requested to be flushed.
Innodb_buffer_pool_pages_free 0 The number of free pages.
Innodb_buffer_pool_pages_latched 0 The number of latched pages in InnoDB buffer pool. These are pages currently being read or written or that can't be flushed or removed for some other reason.
Innodb_buffer_pool_pages_misc 0 The number of pages busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index. This value can also be calculated as Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data.
Innodb_buffer_pool_pages_total 0 Total size of buffer pool, in pages.
Innodb_buffer_pool_read_ahead_rnd 0 The number of "random" read-aheads InnoDB initiated. This happens when a query is to scan a large portion of a table but in random order.
Innodb_buffer_pool_read_ahead_seq 0 The number of sequential read-aheads InnoDB initiated. This happens when InnoDB does a sequential full table scan.
Innodb_buffer_pool_read_requests 0 The number of logical read requests InnoDB has done.
Innodb_buffer_pool_reads 0 The number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read.
Innodb_buffer_pool_wait_free 0 Normally, writes to the InnoDB buffer pool happen in the background. However, if it's necessary to read or create a page and no clean pages are available, it's necessary to wait for pages to be flushed first. This counter counts instances of these waits. If the buffer pool size was set properly, this value should be small.
Innodb_buffer_pool_write_requests 0 The number writes done to the InnoDB buffer pool.
Innodb_data_fsyncs 0 The number of fsync() operations so far.
Innodb_data_pending_fsyncs 0 The current number of pending fsync() operations.
Innodb_data_pending_reads 0 The current number of pending reads.
Innodb_data_pending_writes 0 The current number of pending writes.
Innodb_data_read 0 The amount of data read so far, in bytes.
Innodb_data_reads 0 The total number of data reads.
Innodb_data_writes 0 The total number of data writes.
Innodb_data_written 0 The amount of data written so far, in bytes.
Innodb_dblwr_pages_written 0 The number of doublewrite writes that have been performed and the number of pages that have been written for this purpose.
Innodb_dblwr_writes 0 The number of doublewrite writes that have been performed and the number of pages that have been written for this purpose.
Innodb_log_waits 0 The number of waits we had because log buffer was too small and we had to wait for it to be flushed before continuing.
Innodb_log_write_requests 0 The number of log write requests.
Innodb_log_writes 0 The number of physical writes to the log file.
Innodb_os_log_fsyncs 0 The number of fsyncs writes done to the log file.
Innodb_os_log_pending_fsyncs 0 The number of pending log file fsyncs.
Innodb_os_log_pending_writes 0 Pending log file writes.
Innodb_os_log_written 0 The number of bytes written to the log file.
Innodb_page_size 0 The compiled-in InnoDB page size (default 16KB). Many values are counted in pages; the page size allows them to be easily converted to bytes.
Innodb_pages_created 0 The number of pages created.
Innodb_pages_read 0 The number of pages read.
Innodb_pages_written 0 The number of pages written.
Innodb_row_lock_current_waits 0 The number of row locks currently being waited for.
Innodb_row_lock_time 0 The total time spent in acquiring row locks, in milliseconds.
Innodb_row_lock_time_avg 0 The average time to acquire a row lock, in milliseconds.
Innodb_row_lock_time_max 0 The maximum time to acquire a row lock, in milliseconds.
Innodb_row_lock_waits 0 The number of times a row lock had to be waited for.
Innodb_rows_deleted 0 The number of rows deleted from InnoDB tables.
Innodb_rows_inserted 0 The number of rows inserted in InnoDB tables.
Innodb_rows_read 0 The number of rows read from InnoDB tables.
Innodb_rows_updated 0 The number of rows updated in InnoDB tables.
Begin NDB Variable Value Description
Ndb_cluster_node_id 0
Ndb_config_from_host
Ndb_config_from_port 0
Ndb_number_of_data_nodes 0
Begin SSL Variable Value Description
Ssl_accept_renegotiates 0
Ssl_accepts 0
Ssl_callback_cache_hits 0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects 0
Ssl_connect_renegotiates 0
Ssl_ctx_verify_depth 0
Ssl_ctx_verify_mode 0
Ssl_default_timeout 0
Ssl_finished_accepts 0
Ssl_finished_connects 0
Ssl_session_cache_hits 0
Ssl_session_cache_misses 0
Ssl_session_cache_mode NONE
Ssl_session_cache_overflows 0
Ssl_session_cache_size 0
Ssl_session_cache_timeouts 0
Ssl_sessions_reused 0
Ssl_used_session_cache_entries 0
Ssl_verify_depth 0
Ssl_verify_mode 0
Ssl_version
Begin Handler Variable Value Description
Handler_commit 0 The number of internal COMMIT statements.
Handler_delete 0 The number of times a row was deleted from a table.
Handler_discover 0 The MySQL server can ask the NDB Cluster storage engine if it knows about a table with a given name. This is called discovery. Handler_discover indicates the number of time tables have been discovered.
Handler_prepare 0
Handler_read_first 0 The number of times the first entry was read from an index. If this is high, it suggests that the server is doing a lot of full index scans; for example, SELECT col1 FROM foo, assuming that col1 is indexed.
Handler_read_key 0 The number of requests to read a row based on a key. If this is high, it is a good indication that your queries and tables are properly indexed.
Handler_read_next 0 The number of requests to read the next row in key order. This is incremented if you are querying an index column with a range constraint or if you are doing an index scan.
Handler_read_prev 0 The number of requests to read the previous row in key order. This read method is mainly used to optimize ORDER BY ... DESC.
Handler_read_rnd 0 The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
[b]Handler_read_rnd_next 168 The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.[/b]
Handler_rollback 0 The number of internal ROLLBACK statements.
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 0 The number of requests to update a row in a table.
Handler_write 296 The number of requests to insert a row in a table.
Begin Query cache Variable Value Description
Flush query cache MySQL - Documentation
Qcache_free_blocks 50 k The number of free memory blocks in query cache.
Qcache_free_memory 152 M The amount of free memory for query cache.
Qcache_hits 1 G The number of cache hits.
Qcache_inserts 368 M The number of queries added to the cache.
[b]Qcache_lowmem_prunes 106 M The number of queries that have been removed from the cache to free up memory for caching new queries. This information can help you tune the query cache size. The query cache uses a least recently used (LRU) strategy to decide which queries to remove from the cache.[/b]
Qcache_not_cached 352 M The number of non-cached queries (not cachable, or not cached due to the query_cache_type setting).
Qcache_queries_in_cache 111 k The number of queries registered in the cache.
Qcache_total_blocks 305 k The total number of blocks in the query cache.
Begin Threads Variable Value Description
Show processes MySQL - Documentation
Slow_launch_threads 0 The number of threads that have taken more than slow_launch_time seconds to create.
Threads_cached 45 The number of threads in the thread cache. The cache hit rate can be calculated as Threads_created/Connections. If this value is red you should raise your thread_cache_size.
Threads_connected 27 The number of currently open connections.
Threads_created 774 k The number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value. (Normally this doesn't give a notable performance improvement if you have a good thread implementation.)
Threads_running 5 The number of threads that are not sleeping.
Threads_cache_hitrate_% 99.26 %
Begin Binary log Variable Value Description
MySQL - Documentation
Binlog_cache_disk_use 0 The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction.
Binlog_cache_use 0 The number of transactions that used the temporary binary log cache.
Begin Temporary data Variable Value Description
Created_tmp_disk_tables 0 The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Created_tmp_files 6 k How many temporary files mysqld has created.
Created_tmp_tables 5 The number of in-memory temporary tables created automatically by the server while executing statements.
Begin Delayed inserts Variable Value Description
Delayed_errors 0 The number of rows written with INSERT DELAYED for which some error occurred (probably duplicate key).
Delayed_insert_threads 2 The number of INSERT DELAYED handler threads in use. Every different table on which one uses INSERT DELAYED gets its own thread.
Delayed_writes 175 k The number of INSERT DELAYED rows written.
Not_flushed_delayed_rows 0 The number of rows waiting to be written in INSERT DELAY queues.
Begin Key cache Variable Value Description
MySQL - Documentation
Key_blocks_not_flushed 2 The number of key blocks in the key cache that have changed but haven't yet been flushed to disk. It used to be known as Not_flushed_key_blocks.
Key_blocks_unused 842 k The number of unused blocks in the key cache. You can use this value to determine how much of the key cache is in use.
Key_blocks_used 175 k The number of used blocks in the key cache. This value is a high-water mark that indicates the maximum number of blocks that have ever been in use at one time.
Key_read_requests 166.54 G The number of requests to read a key block from the cache.
[b]Key_reads 2.25 G The number of physical reads of a key block from disk. If Key_reads is big, then your key_buffer_size value is probably too small. The cache miss rate can be calculated as Key_reads/Key_read_requests.
[/b]Key_write_requests 2.39 G The number of requests to write a key block to the cache.
Key_writes 603 M The number of physical writes of a key block to disk.
Key_buffer_fraction_% 19.66 %
Begin Joins Variable Value Description
Select_full_join 0 The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
Select_full_range_join 0 The number of joins that used a range search on a reference table.
Select_range 0 The number of joins that used ranges on the first table. (It's normally not critical even if this is big.)
Select_range_check 0 The number of joins without keys that check for key usage after each row. (If this is not 0, you should carefully check the indexes of your tables.)
Select_scan 5 The number of joins that did a full scan of the first table.
Begin Replication Variable Value Description
Show slave hosts Show slave status MySQL - Documentation
Rpl_status NULL The status of failsafe replication (not yet implemented).
Slave_open_temp_tables 0 The number of temporary tables currently open by the slave SQL thread.
Slave_retried_transactions 0 Total (since startup) number of times the replication slave SQL thread has retried transactions.
Slave_running OFF This is ON if this server is a slave that is connected to a master.
Begin Sorting Variable Value Description
Sort_merge_passes 0 The number of merge passes the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable.
Sort_range 0 The number of sorts that were done with ranges.
Sort_rows 0 The number of sorted rows.
Sort_scan 0 The number of sorts that were done by scanning the table.
Begin Tables Variable Value Description
Flush (close) all tables Show open tables
Open_tables 1 k The number of tables that are open.
Opened_tables 0 The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.
Table_locks_immediate 1 G The number of times that a table lock was acquired immediately.
[b]Table_locks_waited 4 M The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.
[/b]Begin Transaction coordinator Variable Value Description
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Begin Variable Value Description
Compression OFF
Open_files 2 k The number of files that are open.
Open_streams 0 The number of streams that are open (used mainly for logging).
Prepared_stmt_count 0
Uptime_since_flush_status 5 M
=================================================================================================================================

I'm trying to understand how this all works, I want to flush the queries but it says I do not have the appropriate permissions (because I cannot perform the reload function).

I BOLDED everything that was in red.

Have I stumbled upon something useful??

I know it's a pain in the butt baby-sitting me, i'm sorry!

- Jason
« Last Edit: May 31, 2009, 12:25:24 pm by Phill Luckhurst »
Logged

Nibbler

  • Guest
Re: Photo gallery slow to respond, please assist.
« Reply #19 on: May 31, 2009, 12:13:05 pm »

It's up to your host to adjust the mysql server configuration. Looks like you are on a very busy server.
Logged
Pages: [1] 2   Go Up
 

Page created in 0.037 seconds with 20 queries.