Server Configuration

[Descend]

Hi to all people
today I started my forum on a hard'n'heavy metal website of which I deal with technical problems and other maintenance
(here's the url: http://www.eutk.net/forums)
Unfortunately I noticed that is a little bit slow, probably due to mysql
My server runs on win 2000 with php 4.3.0 and mysql 4.0.5
The machine has 1 Giga Ram
Can you suggest me what to modify on the settings to quick the scripts?

[eva2000]

Originally posted by Descend
Hi to all people
today I started my forum on a hard'n'heavy metal website of which I deal with technical problems and other maintenance
(here's the url: http://www.eutk.net/forums)
Unfortunately I noticed that is a little bit slow, probably due to mysql
My server runs on win 2000 with php 4.3.0 and mysql 4.0.5
The machine has 1 Giga Ram
Can you suggest me what to modify on the settings to quick the scripts? please provide the following

1. is this on dedicated or shared virual server
2. your server specs, such as mysql and php version
3. if possible how mysql was compiled/installed
4. your top stats (linux only)
5. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

mysqladmin -u root -p variables

copy and paste output here

6. your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status

copy and paste output here

or preferred is to installed extended-status output script which is either located

- in your vB 2.2.6 or higher vB version's zip file extra's folder, upload mysqlinfo.php script to your site or if you're on an pre vB 2.2.6 install go to
- http://vbulletin.com/forum/showthread.php?threadid=3477 and install that scrip making sure to edit $mysqllogin line with your own mysqlusername and password

and post url to that here

7. oh and is your vB the only thing on the server? or other scripts? sites?

8. how many average and max concurrent users on your vB forum ?

9. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

<?
phpinfo();
?>

i.e. yourdomain.com/phpinfo.php

10. 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 :

KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients

11. what version of vB are you running ?

[Descend]

On this morning our VBulletin for unknown reasons ceased to run...
the ASP scripts on our server keep on normally run but since today, hour 6PM (local hour), our forum goes on CGI timeout.
In add, the mail service did never run (http://www.eutk.net/forums/mailtest.php)
Could you help us please?
Here the infos that you requested:
1. We have a dedicated server
2. Operative Sistem Win 2000 Server
Mysql 4.0.9 gamma-win
PhP 4.3.0 PHPINFO: http://www.eutk.net/forums/phpinfo.php
1 Giga Ram
ISS 4.0
3. Mysql has been installed with the typical process of the installation file, downloaded from the official site
4. -
5. Variable

back_log 50
basedir C:\Inetpub\mysql\
bdb_cache_size 8388600
bdb_log_buffer_size 32768
bdb_home C:\Inetpub\mysql\data\
bdb_max_lock 10000
bdb_logdir
bdb_shared_data OFF
bdb_tmpdir C:\WINNT\TEMP\
bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (January 10, 2003)
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis 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
convert_character_set
datadir C:\Inetpub\mysql\data\
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 1800
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
ft_boolean_syntax + -><()~*:""&|
have_bdb YES
have_innodb DISABLED
have_isam YES
have_raid NO
have_symlink YES
have_openssl NO
have_query_cache YES
init_file
innodb_additional_mem_pool_size 1048576
innodb_buffer_pool_size 8388608
innodb_data_file_path
innodb_data_home_dir
innodb_file_io_threads 4
innodb_force_recovery 0
innodb_thread_concurrency 8
innodb_flush_log_at_trx_commit 0
innodb_fast_shutdown ON
innodb_flush_method
innodb_lock_wait_timeout 50
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 1048576
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir
innodb_mirrored_log_groups 1
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language C:\Inetpub\mysql\share\english\
large_files_support ON
local_infile ON
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_slow_queries OFF
log_warnings OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names ON
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 268435456
myisam_max_sort_file_size 2147483647
myisam_recover_options OFF
myisam_sort_buffer_size 8388608
named_pipe OFF
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file C:\Inetpub\mysql\data\DOCBROS.pid
port 3306
protocol_version 10
read_buffer_size 131072
read_rnd_buffer_size 262144
rpl_recovery_rank 0
query_cache_limit 1048576
query_cache_size 0
query_cache_type ON
Variable_name Value
server_id 0
slave_net_timeout 3600
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
sort_buffer_size 2097144
sql_mode 0
table_cache 64
table_type MYISAM
thread_cache_size 0
thread_stack 65536
tx_isolation REPEATABLE-READ
timezone W. Europe Standard Time
tmp_table_size 33554432
tmpdir C:\WINNT\TEMP\
version 4.0.9-gamma-max-nt
wait_timeout 28800

6.MYSQL EXtENDED STATUS:
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_clients | 4 |
| Aborted_connects | 1 |
| Bytes_received | 0 |
| Bytes_sent | 0 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 32 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 0 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 3 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 67 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 3 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 2 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 3 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 11 |
| Com_show_variables | 14 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 0 |
| Connections | 26 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 0 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 0 |
| Handler_read_first | 9 |
| Handler_read_key | 335 |
| Handler_read_next | 239 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 228 |
| Handler_read_rnd_next | 92 |
| Handler_rollback | 0 |
| Handler_update | 0 |
| Handler_write | 3 |
| Key_blocks_used | 9 |
| Key_read_requests | 2042 |
| Key_reads | 9 |
| Key_write_requests | 0 |
| Key_writes | 0 |
| Max_used_connections | 9 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 44 |
| Open_files | 86 |
| Open_streams | 0 |
| Opened_tables | 50 |
| Questions | 145 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 4 |
| Select_range_check | 0 |
| Select_scan | 16 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 4 |
| Sort_rows | 228 |
| Sort_scan | 0 |
| Table_locks_immediate | 107 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 25 |
| Threads_connected | 10 |
| Threads_running | 1 |
| Uptime | 1040 |
+--------------------------+-------+
5. Mysqlinfo.php : http://www.eutk.net/forums/mysqlinfo.php
6. On the server is installed a website structured upon an ASP programming (www.eutk.net (http://www.eutk.net))

[Steve Machol]

I just accesssed your forums without ny errors:

http://www.eutk.net/forums/

What is the exact error you are getting?

[Descend]

Originally posted by Steve Machol
I just accesssed your forums without ny errors:

http://www.eutk.net/forums/

What is the exact error you are getting?

We've solved our entry problems and so the forum is accessible. Anyway is the configuration ok or can be improved?

[Steve Machol]

Don't know. We'll need to hear from the server guru - eva2000. :)

[Descend]

Originally posted by Steve Machol
Don't know. We'll need to hear from the server guru - eva2000. :)
eheh ok we hope the guru's reply :D

[adrianchew]

Descend - you might want to consider switching to a Redhat Linux server instead. I did a benchmark once between Windows and Linux running on the same machine... and Linux won the test for performance.

Any reason you're running mysql 4.0?... 3.x is still much better IMO right now.

[eva2000]

Originally posted by Descend
eheh ok we hope the guru's reply :D well i'm waiting for the mysqlinfo.php page to load sigh

but you can also check your mysql error log in your mysql data folder *.err to see what errors are reported there

[Descend]

Hi,
the mysqlinfo.php file has been installed on our server at http://www.eutk.net/forums/mysqlinfo.php but it doesn't work! I checked the mysql.err file in the mysql installation folder and I found the following errors (I don't know if they are the ones tou were refering to):

MySql: ready for connections
MySql: ready for connections
030122 10:50:46 MySql: Normal shutdown
030122 10:50:47 MySql: Shutdown Complete
MySql: ready for connections
030122 13:09:22 MySql: Normal shutdown
030122 13:09:23 MySql: Forcing close of thread 1944 user: ''
MySql: ready for connections
030122 13:29:06 MySql: Normal shutdown
030122 13:29:07 MySql: Forcing close of thread 348 user: ''
030122 13:29:07 MySql: Forcing close of thread 347 user: ''
030122 13:29:07 MySql: Forcing close of thread 346 user: ''
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
030123 11:33:10 MySql: Normal shutdown
030123 11:33:11 MySql: Forcing close of thread 5360 user: ''
030123 11:33:11 MySql: Forcing close of thread 5359 user: ''
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
030123 19:39:26 MySql: Normal shutdown
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
030125 11:32:22 MySql: Normal shutdown
030125 11:32:22 MySql: Shutdown Complete
MySql: ready for connections
030125 14:53:42 MySql: Normal shutdown
030125 14:53:43 MySql: Forcing close of thread 2525 user: ''
030125 14:53:43 MySql: Forcing close of thread 2524 user: ''
030125 14:53:43 MySql: Forcing close of thread 2523 user: ''
030125 14:53:43 MySql: Forcing close of thread 2522 user: ''
030125 14:53:43 MySql: Forcing close of thread 2521 user: ''
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
030126 18:55:21 MySql: Normal shutdown
030126 18:55:22 MySql: Forcing close of thread 7854 user: ''
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
030127 22:12:54 MySql: Normal shutdown
030127 22:12:54 MySql: Shutdown Complete
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
030128 18:36:14 MySql: Normal shutdown
030128 18:36:15 MySql: Shutdown Complete
MySql: ready for connections
030128 18:44:50 MySql: Normal shutdown
030128 18:44:51 MySql: Shutdown Complete
MySql: ready for connections
030128 18:55:14 MySql: Normal shutdown
030128 18:55:15 MySql: Shutdown Complete
MySql: ready for connections
030128 18:59:47 MySql: Normal shutdown
030128 18:59:48 MySql: Shutdown Complete
MySql: ready for connections
MySql: ready for connections
030128 20:13:24 MySql: Normal shutdown
030128 20:13:25 MySql: Shutdown Complete
MySql: ready for connections
030128 20:54:58 MySql: Normal shutdown
030128 20:54:58 MySql: Shutdown Complete
MySql: ready for connections
030128 22:00:29 MySql: Normal shutdown
030128 22:00:29 MySql: Shutdown Complete
MySql: ready for connections
030128 22:35:16 MySql: Normal shutdown
030128 22:35:17 MySql: Shutdown Complete
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections
If we start the file repair.php (http://www.eutk.net/forums/repair.php?check=1) we see this message related to the eutkforum.session table:
Checking table session
Table Operation Type Text
eutkforum.session check error The handler for the table doesn't support check
Repairing table session
eutkforum.session repair error The handler for the table doesn't support repair

[Descend]

up :(

[eva2000]

have you tried downgrading to mysql 3.23.55 ?