Slow posting for some members?

[Rob]

I know there is a lot of topics about a board being slow, but none (that I can find) about posting being slow!

I have one member who complains that posting takes anywhere from 40-90 seconds to finish. She is on dial up, but said it recently started doing it. Our server has PLENTLY of resources, so I know that isn't the problem.

We have told her to check her computer for spyware, but says that she did that, and it didn't work. Is there anything that I am missing?

Thanks

Rob
http://forum.realityfanforum.com

[mennou]

that is exactly  what happened to my forum..   see me i am on cable some  part of my site  are running  slow.. it takes long to open  some  of  my post  and who's online... not only me   my  members also have the same problem....   is there anything  i can do  to fix  that error... thank you.

forum  www.mixspot.com
account : test
pass :  test

[Fizzy]

Hi Rob,

You might like to start by getting the forum W3C compliant again
Try verifying it and then correct the errors, there's plenty of them

[Fizzy]

Same for Mennou

150 errors Too many mate.

[[Unknown]]

Rob,

If you view processes in phpMyAdmin, do you see any that say "locked"?

-[Unknown]

[Rob]

This is the only one in the list? Am I not looking at this right?

Kill   71937   fanforum   localhost   None   Query   0   ---   SHOW PROCESSLIST


Rob

[[Unknown]]

Try creating a file as I described in this topic:

http://www.simplemachines.org/community/index.php?topic=33865.msg253197#msg253197

-[Unknown]

[Rob]

Ok, Here is the link:
http://forum.realityfanforum.com/info.php

and here is the info it gave me:

18:41:54 up 17:29, 0 users, load average: 11.54, 6.08, 3.91 total used free shared buffers cached Mem: 2055384 2034260 21124 0 94436 892520 -/+ buffers/cache: 1047304 1008080 Swap: 2040244 20932 2019312 Query 0 SHOW PROCESSLIST

Is this good? I don't understand it??? 

Rob

[[Unknown]]

Is this a dedicated server?

18:41:54 up 17:29, 0 users, load average: 11.54, 6.08, 3.91

Is very bad.  Load averages should be below, in almost every case, 4.00.  Is it always like that, or was that a spike?  Right now:

03:48:28  up 5 days,  2:35,  0 users,  load average: 0.76, 0.94, 0.90

Which is a lot better... but still, not great.

         total     used      free     shared   buffers  cached
Mem:     2055384   2034260   21124    0        94436    892520
-/+ buffers/cache: 1047304   1008080
Swap:    2040244   20932     2019312

Memory usage looks okay, from that.

-[Unknown]

[Rob]

It is a shared server, however, from what I know, the other sites are not busy at all. When I checked, it wasn't at all as bad as 11.54, 6.08, 3.91.

Right now, this is what it is at:
load average: 1.20, 1.37, 1.18

But that is about usually where it is at!

Maybe when my year is up, it could be time to switch hosts!

Let me know, thanks for all the work you are going for me!

Rob

[[Unknown]]

Do you know what sort of processor or processors it is running with?  If you have cPanel, it should tell you in there.

For starters, have you tried using InnoDB for any of your tables?  Have you asked your host if they are using or willing to use eAccelerator?

What version of MySQL was this?

-[Unknown]

[Rob]

No, I have not tried InnoDB. I have no experience in it, and it scares me! LOL

The MySQL version is 4.0.22-standard.

As for the processer, I have looked in my cPanel, and can't find anything, is there a specific place I should be looking??

Thanks

Rob

[zodiac1]

Hi; I have a similar problem.
My forum has a normal speed; but for some users the speed is very slow; especially from the college that is behind a proxy server I guess.
I have been looking to the server statistics.

Here are the server settings:
General account information:

Hosting package bhsd
Shared Ip Address 89.149.195.252
Subdomains  0 / unlimited
Parked Domains 0 / unlimited
Addon Domains 0 / unlimited
MySQL Databases 1 / unlimited
Disk Space Usage 55.06 Megabytes
MySQL Disk Space 73.11 Megabytes
Disk space available 44.94 Megabytes
Bandwidth (this month) 557.34 Megabytes
Email Accounts 14 / unlimited
Email Forwarders 3
Auto-responders 0
Mailing Lists 0 / unlimited
Email Filters 0
Ftp Accounts 0 / unlimited

General server information:
Operating system Linux
Service Status Click to View
Kernel version hxxp:2.6.19.1.sm [nonactive]
Machine Type i686
Apache version 1.3.37 (Unix)
PERL version 5.8.7
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail
Installed Perl Modules Click to View
PHP version 4.4.5
MySQL version 4.1.21-standard
cPanel Build 10.9.0-RELEASE 118
Theme cPanel X v2.6.0 


I have a red sign on the "server load"
Server Load 18.78 (2 cpus) 

These statistics in phpmyadmin (mysql php runtime information) are also red signed:

Slow_queries 202  The number of queries that have taken more than long_query_time seconds. 

Handler_read_rnd 16 M 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. 

Handler_read_rnd_next 2,447.94 M 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. 

Slow_launch_threads 21  The number of threads that have taken more than slow_launch_time seconds to create. 

Created_tmp_disk_tables 3,239  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. 

Key_reads 6,785 k 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. 

Select_full_join 7,148  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_range_check 4  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.) 

Sort_merge_passes 2,429  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. 

Opened_tables 2,053 k The number of tables that have been opened. If opened tables is big, your table cache value is probably too small. 

Table_locks_waited 3,473  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. 


Can someone help me please; I don't know where to begin; and I can't find where to change those options and if the problem is related with those problems

Thank you

[Christian A. Herrnboeck]

Server Load 18.78 (2 cpus) 

No wonder your site is slow... With a load of 18, I'm amazed it's even accessible still! Who is your host? Usually, this happens with oversold hosting providers - sometimes, though, it happens to good hosts, so try contacting their support and see what they tell you


Best Regards,
Christian A. Herrnboeck

[zodiac1]

Thank you for answering.

It's a server load of 18 and not 18% ; I don't know if that makes a difference.
When the site is lagging; I still can perfectly reach my FTP; is it then possible, that SMF also slows down the site?
And It's only from the college that the site is lagging; from elsewhere I have not that problem.
Could eaccelerator solve this problem?

Thank You

[青山 素子]

It's a server load of 18 and not 18% ; I don't know if that makes a difference.

Correct. This means that 18 things are waiting for the CPU to get to them. Figure the CPU like a bank teller. It can only serve one customer at a time. The load is the number of people waiting in line to see the teller. Once the load gets past 2 or so, the system is being severely overloaded. (There are exceptions to this of course, but they don't really apply here.)

Of course, this can happen at times if a script of another customer has a problem and monopolizes the CPU. This does happen, but the important thing to look for is a pattern. Is the load always that high? Is it that high only at times when you find your forum to be slow? Is that a specific time of the day?

When the site is lagging; I still can perfectly reach my FTP; is it then possible, that SMF also slows down the site?

That could just be some fluke, or perhaps the FTP portion is faster because of caching. Since there isn't much to process, the server could just have the info in its memory and be running FTP from there.

And It's only from the college that the site is lagging; from elsewhere I have not that problem.
Could eaccelerator solve this problem?

Turn on the option to display page generation times. This will show how long the server itself spent creating the page and show if the slowdown is on that or the traffic.

There isn't enough known to determine if a caching engine will help, and since you are on shared hosting, your host would need to install it anyway.