Slowdown...

[Cyberpawz]

The rest of my site is fast, or faster than I can complain about, but every time I attempt to go to:

http://www.cyberpawz.com/coppermine/

The site takes nearly a minute plus to load.  Becore I uploaded to 1.4.4 the server had a decent amount of speed to it, now it seems to be rather slow.  Is there a reason for this?

The connection it has is a 5Mbps download, and a 1Mbps upload, this should not be happening.

[Joachim Müller]

reduce the number of queries needed to build the page by removing or reducing the meta albums. I have no other suggestions. Self-hosting is not recommended.

[Cyberpawz]

reduce the number of queries needed to build the page by removing or reducing the meta albums. I have no other suggestions. Self-hosting is not recommended.

How exactly do I do that?

As for self hosting that isn't much of an issue soon I'm going to be upgrading up to a 30 down 15 up connection soon.

[Joachim Müller]

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#changing

[Cyberpawz]

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#changing

Changing the meta albums info is going to affect the index.php page? Just out of curiosity I'd like to know how that exactly works if possible.  I read what was on the link you gave me, and it says the meta data is something that the cameras utilize, but even so... how does that affect the front page when none of that data is shown?

Especially since it seems the rest of the site doesn't have the slowdown the main page does.

[Joachim Müller]

"meta" is greek and means "transcending/above/beyond", so in computer terms this means "additional". You're mixing up terms here: in HTML, there is meta information that contains additional information about a page. Meta data from cameras contain additional information about a pic (e.g. the date when it was taken), there are several picture meta data specifications, e.g. EXIF or IPTC. In coppermine, we refer to the "pseudo"-albums like "last uploaded" or "random" as "meta albums", as they're not real albums, but they visually behave as if they were.
I was suggesting to get rid of those meta albums or reduce the number of them on your index pages, by changing "The content of the main page" from "catlist/alblist/random,2/lastup,2" to "catlist/alblist/random/lastup" or even "catlist/alblist".
The reason for my recommendation: when composing the meta albums, coppermine needs to perform huge queries, which may cause slowdowns for less powerful servers or for pages with huge traffic.

[Stramm]

don't allow private user galleries, that'll take a lot of heat of the mysql server
Files and thumbnails advanced settings - Albums can be private (Note: if you switch from 'yes' to 'no' any current private albums will become public) -> set this to 'no'

and maybe you want to enable debug mode

[Cyberpawz]

OK, but still how come it seems to me that the only slowdown, is on the main page... not after you click anywhere else... I could understand if the server slowed down when you accessed folders, and had all data of theirs showing...which I don't have...

But this is where the intro page is I am a little lost of why the slowdown only exists on the first page and no where else...

Oh and I did the debug mode... want me to post the data here or PM it? So far nothing looks out of the ordinary, or nothing there shows what would cause this problem in the first place.

[Stramm]

The index is the most resource hungry page.
Read above for my suggestions.

[Cyberpawz]

The index is the most resource hungry page.
Read above for my suggestions.

There are only three people that utilize private galleries in my server... no more than that, and they each only have one gallery a piece with a maximum of 20 photos in one... so I don't know how that would cause my index.php to slow to a crawl after upgrading to 1.4.4 when 1.4.3 had no issues like this at all.

[Stramm]

don't allow private user galleries, that'll take a lot of heat of the mysql server
...
and maybe you want to enable debug mode

if you don't want my help... OK

[Cyberpawz]

if you don't want my help... OK

Actually if you read the post again I stated I put debug mode on... and asked what I should do with the text that it creates... you never responded... I hate to be rude, but reading what the other person types goes both ways.

[Stramm]

Before I wrote my last msg I checked and didn't see debug on... same as now

[Cyberpawz]

Before I wrote my last msg I checked and didn't see debug on... same as now

I put debug mode only on as for the Admins to see, I don't need the end users to see debugging information... if you want to see it then tell me, and I'll post it here.


USER:
------------------
Array
(
    [ID] => f0d043fcaded179e3f8efa09dfcb7420
    [am] => 1
    [liv] => Array
        (
           

• => 21489
              [1] => 30475
              [2] => 900
              [3] => 20120
              [4] => 13407
          )
  
      [search] => Array
          (
              [search] => private
              [album] => search
              [newer_than] =>
              [older_than] =>
              [type] => AND
          )
  
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_name] => Cyberpawz
      [groups] => Array
          (
             
• => 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] => 10
      [num_URI_upload] => 5
      [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
  (
     
• => SELECT extension, mime, content, player FROM cpg11d_filetypes; (0.009s)
      [1] => select * from cpg11d_plugins order by priority asc; (0.001s)
      [2] => delete from `rfcimg`.cpg11d_sessions where time<1144008017 and remember=0; (0.036s)
      [3] => delete from `rfcimg`.cpg11d_sessions where time<1142802017; (0.001s)
      [4] => select user_id from `rfcimg`.cpg11d_sessions where session_id=md5("608f8dd7665a2f795848873457fa565c5dc8f3a2342397927ae04fb5f003ba49"); (0.001s)
      [5] => select user_id as id, user_password as password from `rfcimg`.cpg11d_users where user_id=1 (0.002s)
      [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 `rfcimg`.cpg11d_users AS u INNER JOIN `rfcimg`.cpg11d_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.002s)
      [7] => SELECT user_group_list FROM `rfcimg`.cpg11d_users AS u WHERE user_id='1' and user_group_list <> ''; (0.001s)
      [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 cpg11d_usergroups WHERE group_id in (1) (0.001s)
      [9] => SELECT group_name FROM  cpg11d_usergroups WHERE group_id= 1 (0.001s)
      [10] => update `rfcimg`.cpg11d_sessions set time='1144011618' where session_id=md5('608f8dd7665a2f795848873457fa565c5dc8f3a2342397927ae04fb5f003ba49'); (0.001s)
      [11] => SELECT user_favpics FROM cpg11d_favpics WHERE user_id = 1 (0.008s)
      [12] => DELETE FROM cpg11d_banned WHERE expiry < '2006-04-02 21:00:18' (0.001s)
      [13] => SELECT * FROM cpg11d_banned WHERE (ip_addr='24.61.248.81' OR ip_addr='24.61.248.81' OR user_id=1) AND brute_force=0 (0.001s)
      [14] => SELECT cid, name, description, thumb FROM cpg11d_categories WHERE parent = ''  ORDER BY pos (0.001s)
      [15] => SELECT aid FROM cpg11d_albums as a WHERE category>=10000 (0.017s)
      [16] => SELECT count(*) FROM cpg11d_pictures as p, cpg11d_albums as a WHERE p.aid = a.aid AND category >= 10000 (0.073s)
      [17] => SELECT cid, name, description, thumb FROM cpg11d_categories WHERE parent = '1'  ORDER BY pos (0.001s)
      [18] => SELECT aid FROM cpg11d_albums as a WHERE category = '0' (0.001s)
      [19] => SELECT count(*) FROM cpg11d_albums as a WHERE 1 (0.001s)
      [20] => SELECT count(*) FROM cpg11d_pictures as p LEFT JOIN cpg11d_albums as a ON a.aid=p.aid WHERE 1 (0.088s)
      [21] => SELECT count(*) FROM cpg11d_comments as c LEFT JOIN cpg11d_pictures as p ON c.pid=p.pid LEFT JOIN cpg11d_albums as a ON a.aid=p.aid WHERE 1 (0.083s)
      [22] => SELECT count(*) FROM cpg11d_categories WHERE 1 (0.001s)
      [23] => SELECT sum(hits) FROM cpg11d_pictures as p LEFT JOIN cpg11d_albums as a ON p.aid=a.aid WHERE 1 (0.453s)
      [24] => SELECT COUNT(*) FROM cpg11d_pictures WHERE approved = 'NO' (0.068s)
      [25] => SELECT count(*) FROM cpg11d_albums as a WHERE category = '0' (0.001s)
      [26] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'  (0.075s)
      [27] => SELECT * FROM cpg11d_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8 (1.087s)
      [28] => SELECT count(*) from cpg11d_comments where pid=10562 and msg_id!=0 (0.08s)
      [29] => SELECT count(*) from cpg11d_comments where pid=5507 and msg_id!=0 (0.001s)
      [30] => SELECT count(*) from cpg11d_comments where pid=16865 and msg_id!=0 (0.001s)
      [31] => SELECT count(*) from cpg11d_comments where pid=9505 and msg_id!=0 (0.001s)
      [32] => SELECT count(*) from cpg11d_comments where pid=17552 and msg_id!=0 (0.001s)
      [33] => SELECT count(*) from cpg11d_comments where pid=22356 and msg_id!=0 (0.001s)
      [34] => SELECT count(*) from cpg11d_comments where pid=14337 and msg_id!=0 (0.001s)
      [35] => SELECT count(*) from cpg11d_comments where pid=6966 and msg_id!=0 (0.001s)
      [36] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'  (0.078s)
      [37] => SELECT * FROM cpg11d_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8 (0.011s)
      [38] => SELECT count(*) from cpg11d_comments where pid=30578 and msg_id!=0 (0.001s)
      [39] => SELECT count(*) from cpg11d_comments where pid=30577 and msg_id!=0 (0.001s)
      [40] => SELECT count(*) from cpg11d_comments where pid=30576 and msg_id!=0 (0.001s)
      [41] => SELECT count(*) from cpg11d_comments where pid=30575 and msg_id!=0 (0.001s)
      [42] => SELECT count(*) from cpg11d_comments where pid=30574 and msg_id!=0 (0.001s)
      [43] => SELECT count(*) from cpg11d_comments where pid=30573 and msg_id!=0 (0.001s)
      [44] => SELECT count(*) from cpg11d_comments where pid=30572 and msg_id!=0 (0.001s)
      [45] => SELECT count(*) from cpg11d_comments where pid=30571 and msg_id!=0 (0.001s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 5.0.4 - OK
  ------------------
  mySQL version: 4.1.13-standard
  ------------------
  Coppermine version: 1.4.4(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 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 4.1.3-beta
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE -I/Users/marc/svn/entropy/php-module/src/mysql-standard-4.1.3-beta-apple-darwin7.4.0-powerpc/include
  MYSQL_LIBS -L/Users/marc/svn/entropy/php-module/src/mysql-standard-4.1.3-beta-apple-darwin7.4.0-powerpc/lib -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.4
  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/php5/lib/php | .:/usr/local/php5/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 | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 2.933 seconds - 46 queries in 2.2 seconds - Album set : ; Meta set: ;

[Joachim Müller]

as expected, the query to populate the random meta album is burning most cpu cyles. Turn the random pics off as suggested.

[Cyberpawz]

as expected, the query to populate the random meta album is burning most cpu cyles. Turn the random pics off as suggested.

Which is where? I already tried to do so in the config section of the forum, and so far the option to do so isn't worded as elegant as you state it here.

[Joachim Müller]

I have a deja vu, is this thread stuck in an endless circle? Did you actually read the docs as I suggested:

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#changing

[Cyberpawz]

I have a deja vu, is this thread stuck in an endless circle? Did you actually read the docs as I suggested:

Yes and I figured it out myself, the reason I asked was because the page didn't load fast enough, and the link you gave me didn't go towards where you pointed. I was looking for the words you used, so cut down on the reading and the chase...