Original Message:
My forum doesn't get a fraction of the traffic that many of the boards here do, but it's running dirt-dog slow.
It's a Web host that I've been a reseller for, for about 6 years now, and the machines have always been really fast. I submitted a request to them mentioning that the server performance was really slow, and this was the reply I got:
We have tested other sites on the same server, and were not able to reproduce any performance-related problems with the other sites. We did notice that your site appears to use the MySQL database heavily. I would recommend that your client optimize their database/tabes as much as possible and see if the problem persists.
Are there certain options in the control panel I should be looking at that are harder on MySQL and the server in general than others? Options that would make this big of a difference? It's taking minutes to load pages sometimes.
Troubleshooting SQL Server 2005/2008 Performance and Scalability ::
SQL Server best practices, whitepapers and deep technical lessons learned from large for troubleshooting SQL Server 2005/2008 performance issues Systems
http://sqlcat.com/presentations/archive/2008/04/18/troublecalability-flowchart.aspxHOME |
Troubleshooting Microsoft® SQL Server™ 2005 Database and Database ::
you troubleshoot Microsoft SQL Server 2005 performance by analyzing tools that are used to determine database and database server performance issues.
http://www.elementk.com/s.asp?p=67013HOME |
This was an import from Eve that ran really well at first, but just started slowing down the past 2 days. The traffic was a lot higher while it was running well, because I had sent out an Email broadcast. AFTER the traffic died down to normal (which isn't very high), the forum became real slow. Other things, like the PHPinfo script run really fast.
Server info, to the best of my ability (let me know if I'm leaving out critical info, and I can get it from the hosting provider):
1. is this on dedicated or shared virual server
Shared.
2. your server specs:
cpu speed/type single or dual cpus): Don't Know
how much memory installed: Don't Know
hard drive type/configuration: Don't Know
linux distributor or windows version: FreeBSD
apache/IIS version: apache
PHP version: 4.3.2
MySQL version: 3.23.58-log
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server?
N/A
4. if possible how mysql was compiled/installed
IIS troubleshooting, administration, and concepts. : Troubleshooting ::
the types of performance problems that can Removing an IIS servers IP address from HTTP responses Troubleshooting High CPU performance issues - Part 1
http://blogs.msdn.com/mike/archive/2007/12/06/troubleshootu-performance-issues.aspxHOME |
MS Course 2011 - Troubleshooting MS Exchange Server 2003 NYC, Microsoft ::
priced, training classes in Microsoft Course 2011 - Troubleshooting MS Exchange Server 2003. With experienced Server performance. Security issues
http://www.tccitsolutions.com/courses/2011.htmlHOME |
No idea, sorry.
5. your top stats
Newest member to the forums:
Record online users: 32 (09-27-2004 02:04 PM)
Top poster: [Scott Spain - 1397]
Most replied to thread: [Quantitative Analysis of Focus Groups]
Most viewed thread: [New research applications through online methods]
Most popular forum: [General Research Discussion]
[b]6. your mysql configuration variables located at /etc/my.cnf or c:my.cnf so post the contents inside of my.cnf (minus any passwords of course). If on Windows server if you don't have that file you need to log into telnet and as root user type
back_log: 50
basedir: /usr/local/mysql-3.23/
bdb_cache_size: 8388600
bdb_home: /usr/local/mysql-3.23/var/
bdb_log_buffer_size: 32768
bdb_logdir: (Null)
bdb_max_lock: 10000
bdb_shared_data: OFF
bdb_tmpdir: /var/tmp/
bdb_version: Sleepycat Software: Berkeley DB 3.2.9a: (September 11, 2003)
binlog_cache_size: 32768
character_set: latin1
character_sets: latin1 ujis sjis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent_insert: ON
connect_timeout: 5
datadir: /usr/local/mysql-3.23/var/
delay_key_write: ON
delayed_insert_limit: 100
delayed_insert_timeout: 300
delayed_queue_size: 1000
flush: OFF
flush_time: 0
have_bdb: YES
have_gemini: NO
have_innodb: NO
have_isam: YES
have_openssl: NO
have_raid: NO
init_file: (Nnull)
interactive_timeout: 28800
join_buffer_size: 131072
key_buffer_size: 8388600
language: /usr/local/mysql-3.23/share/mysql/english/
large_files_support: ON
log: ON
log_bin: OFF
log_long_queries: OFF
log_slave_updates: OFF
log_update: OFF
long_query_time: 10
low_priority_updates: OFF
lower_case_table_names: 0
max_allowed_packet: 1048576
max_binlog_cache_size: 4294967295
max_binlog_size: 1073741824
max_connect_errors: 999999999
max_connections: 100
max_delayed_threads: 20
max_heap_table_size: 16777216
max_join_size: 4294967295
max_sort_length: 1024
max_tmp_tables: 32
max_user_connections: 0
max_write_lock_count: 4294967295
myisam_max_extra_sort_file_size: 256
myisam_max_sort_file_size: 2047
myisam_recover_options: 0
myisam_sort_buffer_size: 8388608
net_buffer_length: 16384
net_read_timeout: 30
net_retry_count: 1000000
net_write_timeout: 60
open_files_limit: 0
pid_file: /u/local/mysql/var/mysqld.pid
port: 3306
protocol_version: 10
query_buffer_size: 0
record_buffer: 131072
record_rnd_buffer: 131072
safe_show_database: ON
server_id: 0
skip_locking: OFF
skip_networking: OFF
skip_show_database: OFF
slave_net_timeout: 3600
slow_launch_time: 2
socket: /tmp/mysql.sock
sort_buffer: 2097144
sql_mode: 0
table_cache: 64
table_type: MYISAM
thread_cache_size: 0
thread_stack: 65536
timezone: EDT
tmp_table_size: 33554432
tmpdir: /var/tmp/
transaction_isolation: READ-COMMITTED
version: 3.23.58-log
wait_timeout: 28800
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
http://forum.researchinfo.com/troubleshoot/mysqlextendedstatus.php
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
vB is the only thing on the server.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is?
Most users ever online was 32, 09-27-2004 at 02:04 PM. This was after sending out an Email broadcast to let people know the new forum was up and running. It seemed to handle the load fine then.
Right now there is 1 (me) online. The most I've noticed lately is 5.
Cookie timeout is set to 900.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://forum.researchinfo.com/troubleshoot/phpinfo.php
11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following:
Don't have access. :(
12. what version of vB are you running?
3.03
Trying everything I can think of...
I ran a "Check Tables" command on everything, and "cpsession" and "session" came back with "The handler for the table doesn't support check/repair".
From my host:
SSH access is not available in the Rapidsite hosting enviornment, and running a shell command such as 'top' would require SSH access to the server. I am not certain what you are referring to with regards to 'top stats'. The top command does not keep or save statistical information, it displays a list of running processes and other diagnostic information such as memory and process usage in 5 second intervals by default. It does not save historical information. Please confirm the exact command that you wish for us to run, and we will review your request. Please note that we cannot guarantee that we will be able to run this command, as there may be security implications to running the command. The command would show all running processes on the server, including processes for other sites on the same server.
So, can y'all tell me what command I should request that they run?
Then its a good chance to point them to this thread, as only the people who root access are going to be able to help you
I ran "Optimize Tables" and got the exact same message from the exact same two tables.
I access my MySQL database by using Navicat (http://www.navicat.com). I ran "Optimize Tables" on everything, and that didn't seem to help.
I have no clue what happened, but sometime today it started running at normal speed again.
I'm having a real tough time coming to grips with this being a problem of simply being on a shared host, or a few settings. Mainly because it worked great when we had 32 people online at once, and many more messages being posted, because of the Email broadcast I sent out.
Right now nobody is on and it's really slow. With only 1700 messages and 4000 posts (all but about 20 imported), what could possibly be happening that's hammering the server this hard? Nobody's on, but my hosting provider tells me I'm heavily accessing the mySQL database. How am I heavily accessing it with 1-2 people viewing the forum, and not even posting messages? It took 32 seconds for the main forum index to load.
And TOP is a linux program sort of like windows task manager ;)
LOL. I thought the stats I provided seemed less than useful. How would one go about getting these TOP Stats?
I'm having a real tough time coming to grips with this being a problem of simply being on a shared host, or a few settings. Mainly because it worked great when we had 32 people online at once, and many more messages being posted, because of the Email broadcast I sent out.
Right now nobody is on and it's really slow. With only 1700 messages and 4000 posts (all but about 20 imported), what could possibly be happening that's hammering the server this hard? Nobody's on, but my hosting provider tells me I'm heavily accessing the mySQL database. How am I heavily accessing it with 1-2 people viewing the forum, and not even posting messages? It took 32 seconds for the main forum index to load.
LOL. I thought the stats I provided seemed less than useful. How would one go about getting these TOP Stats?
from what you describe with no forum traffic on your forums and still being slow then it IS a problem with the shared server or one of the other web sites sharing your server
with the server info you're unsure about in first post, can you ask your web host for this info since without knowing the server hardware and configuration used it's hard to figure out anything from out end
Thats fine, thoughs tables dont support it.
You would need to login to ssh and run the command top.
I've contacted my host (RapidSite) to see if they'll run TOP stats for me. They don't give me SSH access.
If this is a shared server im not sure how much we will be able to do, George will be able to make recomendations but unless the host applys them, there is not much you can do.
And TOP is a linux program sort of like windows task manager ;)
Done. Good thinking. Thanks.
 Nortel Unveils Vision, Strategy for Israeli High-Performance Net
 Busy Friday Leads to Strong Close for Net Stocks
|
