leaving comments on gallery photos is S-L-O-W

[glowinggal]

we have had numerous complaints about how slow the gallery is to comment on - due to this issue we have LOST a lot of members from posting and using our site over the last few months.

What we need to find out is why the comments are so slow to process; and how to fix it.

we are upgrading to the latest build later today but back in 06 we had this issue as well after upgrading to the most current build at that time; and someone very helpful here at PP helped us and optimized our db; but it's now occurring again as well.

[Chuck S]

Hello

well you would want to optimise your database a least monthly to maintain mysql health and also other factors like how big the site is and how much traffic can all determine speed verus the hardware used.

[glowinggal]

Hi Chuck; I had originally worked with you in regard to the same issue i believe back in 2006.

LMK if perhaps you might have time to look into this for us.

But in the meantime here are our server stats:

erver Information
Processor Information
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz
Processor #1 speed: 2394.077 MHz
Processor #1 cache size: 4096 KB

Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz
Processor #2 speed: 2394.077 MHz
Processor #2 cache size: 4096 KB

Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz
Processor #3 speed: 2394.077 MHz
Processor #3 cache size: 4096 KB

Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz
Processor #4 speed: 2394.077 MHz
Processor #4 cache size: 4096 KB



Memory Information
Memory: 3759416k/4194304k available (2043k kernel code, 39180k reserved, 846k data, 232k init, 2882432k highmem)



System Information
Linux cp.scrapbook-bytes.com 2.6.18-8.1.1.el5 #1 SMP Mon Apr 9 09:46:54 EDT 2007 i686 i686 i386 GNU/Linux



Physical Disks
SCSI device sda: 625142448 512-byte hdwr sectors (320073 MB)
sda: Write Protect is off
sda: Mode Sense: 00 3a 00 00
SCSI device sda: drive cache: write back
SCSI device sda: 625142448 512-byte hdwr sectors (320073 MB)
sda: Write Protect is off
sda: Mode Sense: 00 3a 00 00
SCSI device sda: drive cache: write back
sd 0:0:0:0: Attached scsi disk sda
sd 0:0:0:0: Attached scsi generic sg0 type 0



Current Memory Usage
total used free shared buffers cached
Mem: 3762084 3451500 310584 0 525596 2090444
-/+ buffers/cache: 835460 2926624
Swap: 4096564 60 4096504
Total: 7858648 3451560 4407088



Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 290G 95G 180G 35% /
/dev/sda1 251M 17M 222M 7% /boot
tmpfs 1.8G 0 1.8G 0% /dev/shm
/usr/tmpDSK 485M 11M 449M 3% /tmp



Main >> Server Status >> Service Status

Service Status

cpsrvd up
named (9.3.4-P1) up
Server Load 0.84 (4 cpus)
Memory Used 23 %
Swap Used 0.00 %
Disk /dev/sda1 (/boot) 7 %
Disk /dev/sda3 (/) 35 %

[Chuck S]

Have you attempted to optimise your database? If you have not optimised databases in a couple years this could cause issues with slowdowns.

[glowinggal]

yes via phpmyadmin and the selecting the tables within the db and "optimizing"?

[Chuck S]

That would be the correct action. Does that help?

[glowinggal]

nope.

[Chuck S]

You can post a link and test login for us to look at.

[glowinggal]

username: amytest
password: test08

You can post test comments here:
SBB September 2008 Collab - Fairweather - FREE WITH $10.00 purchase - Digital Scrapbooking Layouts


overall we'd love to have the gallery work much faster but don't know what we need to do for that happen but in particular many have complained about how long it takes to leave comments.

[Chuck S]

Your login here does not appear to work.