Slow, Errors, and Bears - Oh My! -- Need Optimization help!

[pgowder]

My vBulletin is not performing as fast as it could be. I need some expert help.

Please recommend what I need to do. Are there configurations I can change to help? Or is it time to get a new server? Split the site across multiple servers?

On the next post I'll answer the standard questions.

The forum is here:
www.powwows.com/gathering

One of the odd things is that this vBulletin will run slow, but this one:

www.luckypredictions.com will run fine at the same times.

And they are both on the same server??

I'm starting to see this error:
PHP has encountered an Access Violation at 7C82CAA2

And this error on various files also occurs often during the day:

Fatal error: Maximum execution time of 30 seconds exceeded in C:...gathering\p lugins\vbplaza_postbit_start.php on line 12



Thanks for the help!

[pgowder]

1. Dedicated server
2. Dual Xeon 2.4
4 gb ram
IIS
PHP 5.2.2
MySQL 5.0.37-community-nt
3. 3.6.8
4. Yes we do have some innob

[pgowder]

#This File was made from template file created by PLESK installator program

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions


[mysqld]
# change this to the actual path to mysql root
basedir=C:/Program Files/SWsoft/Plesk/MySql
# change this to actual path to the data dir
datadir=C:/Program Files/SWsoft/Plesk/MySql/data
[mysqld]
skip-innodb
max_connections = 200
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 5M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 10800
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 4M
query_cache_size = 128M
query_cache_type = 1
#query_prealloc_size = 16384
#query_alloc_block_size = 16384

[mysqld_safe]
#open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[WinMySQLadmin]
Server=C:/Program Files/SWsoft/Plesk/MySql/bin/mysqld-nt.exe

[pgowder]

9. No there are several sites running on the server. But none get the traffic that this site does.
Other scripts:
photopost
hubz
coppermine
wordpress
10.
Cookie timeout is 1200
Usually 150-300 users online
Max was 971
11. http://www.nativemusicsource.com/a.php

[pgowder]

uto_increment_increment 1
auto_increment_offset 1
automatic_sp_privileges ON
back_log 50
basedir C:\Program Files\SWsoft\Plesk\Databases\MySQL\
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir C:\Program Files\SWsoft\Plesk\Databases\MySQL\share\charsets\
collation_connection latin1_swedish_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
completion_type 0
concurrent_insert 1
connect_timeout 10
datadir C:\Program Files\SWsoft\Plesk\Databases\MySQL\Data\
date_format %Y-%m-%d
datetime_format %Y-%m-%d %H:%i:%s
default_week_format 0
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
div_precision_increment 4
engine_condition_pushdown OFF
expire_logs_days 0
flush OFF
flush_time 1800
ft_boolean_syntax + -><()~*:""&|
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (built-in)
group_concat_max_len 1024
have_archive YES
have_bdb NO
have_blackhole_engine NO
have_compress YES
have_crypt NO
have_csv NO
have_dynamic_loading YES
have_example_engine NO
have_federated_engine NO
have_geometry YES
have_innodb YES
have_isam NO
have_merge_engine YES
have_ndbcluster NO
have_openssl DISABLED
have_query_cache YES
have_raid NO
have_rtree_keys YES
have_symlink YES
init_connect
init_file
init_slave
innodb_additional_mem_pool_size 2097152
innodb_autoextend_increment 8
innodb_buffer_pool_awe_mem_mb 0
innodb_buffer_pool_size 16777216
innodb_checksums ON
innodb_commit_concurrency 0
innodb_concurrency_tickets 500
innodb_data_file_path ibdata1:10M:autoextend
innodb_data_home_dir
innodb_doublewrite ON
innodb_fast_shutdown 1
innodb_file_io_threads 4
innodb_file_per_table OFF
innodb_flush_log_at_trx_commit 1
innodb_flush_method
innodb_force_recovery 0
innodb_lock_wait_timeout 50
innodb_locks_unsafe_for_binlog OFF
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 1048576
innodb_log_file_size 10485760
innodb_log_files_in_group 2
innodb_log_group_home_dir .\
innodb_max_dirty_pages_pct 90
innodb_max_purge_lag 0
innodb_mirrored_log_groups 1
innodb_open_files 300
innodb_rollback_on_timeout OFF
innodb_support_xa ON
innodb_sync_spin_loops 20
innodb_table_locks ON
innodb_thread_concurrency 8
innodb_thread_sleep_delay 10000
interactive_timeout 28800
join_buffer_size 1044480
key_buffer_size 16777216
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
language C:\Program Files\SWsoft\Plesk\Databases\MySQL\share\english\
large_files_support ON
large_page_size 0
large_pages OFF
lc_time_names en_US
license GPL
local_infile ON
log OFF
log_bin OFF
log_bin_trust_function_creators OFF
log_error .\cp.err
log_queries_not_using_indexes OFF
log_slave_updates OFF
log_slow_queries OFF
log_warnings 1
long_query_time 10
low_priority_updates OFF
lower_case_file_system ON
lower_case_table_names 1
max_allowed_packet 16776192
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connect_errors 10
max_connections 1910
max_delayed_threads 20
max_error_count 64
max_heap_table_size 16777216
max_insert_delayed_threads 20
max_join_size 4294967295
max_length_for_sort_data 1024
max_prepared_stmt_count 16382
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_sp_recursion_depth 0
max_tmp_tables 32
max_user_connections 0
max_write_lock_count 4294967295
multi_range_count 256
myisam_data_pointer_size 6
myisam_max_sort_file_size 2147483647
myisam_recover_options OFF
myisam_repair_threads 1
myisam_sort_buffer_size 67108864
myisam_stats_method nulls_unequal
named_pipe OFF
net_buffer_length 4096
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new OFF
old_passwords ON
open_files_limit 2048
optimizer_prune_level 1
optimizer_search_depth 62
pid_file C:\Program Files\SWsoft\Plesk\Databases\MySQL\Data\cp.pid
port 3306
preload_buffer_size 32768
profiling OFF
profiling_history_size 15
protocol_version 10
query_alloc_block_size 16384
query_cache_limit 10485760
query_cache_min_res_unit 4096
query_cache_size 134217728
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 16384
range_alloc_block_size 2048
read_buffer_size 1044480
read_only OFF
read_rnd_buffer_size 258048
relay_log_purge ON
relay_log_space_limit 0
rpl_recovery_rank 0
secure_auth OFF
shared_memory OFF
shared_memory_base_name MYSQL
server_id 0
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
slave_compressed_protocol OFF
slave_load_tmpdir C:\WINDOWS\TEMP\
slave_net_timeout 3600
slave_skip_errors OFF
slave_transaction_retries 10
slow_launch_time 2
sort_buffer_size 5242872
sql_big_selects ON
sql_mode
sql_notes ON
sql_warnings OFF
ssl_ca
ssl_capath
ssl_cert
ssl_cipher
ssl_key
storage_engine InnoDB
sync_binlog 0
sync_frm ON
system_time_zone Eastern Daylight Time
table_cache 64
table_lock_wait_timeout 50
table_type InnoDB
thread_cache_size 512
thread_stack 196608
time_format %H:%i:%s
time_zone SYSTEM
timed_mutexes OFF
tmp_table_size 67108864
tmpdir C:\WINDOWS\TEMP\
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
tx_isolation REPEATABLE-READ
updatable_views_with_limit YES
version 5.0.37-community-nt
version_comment MySQL Community Edition (GPL)
version_compile_machine ia32
version_compile_os Win32
wait_timeout 10800

[pgowder]

Aborted_clients 15890
Aborted_connects 0
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 2229
Bytes_sent 417948
Com_admin_commands 0
Com_alter_db 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 1
Com_change_master 0
Com_check 0
Com_checksum 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_create_user 0
Com_dealloc_sql 0
Com_delete 0
Com_delete_multi 0
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_drop_user 0
Com_execute_sql 0
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 0
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_preload_keys 0
Com_prepare_sql 0
Com_purge 0
Com_purge_before_date 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_revoke_all 0
Com_rollback 0
Com_savepoint 0
Com_select 4
Com_set_option 0
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_charsets 0
Com_show_collations 0
Com_show_column_types 0
Com_show_create_db 0
Com_show_create_table 0
Com_show_databases 0
Com_show_errors 0
Com_show_fields 0
Com_show_grants 0
Com_show_innodb_status 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_ndb_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_privileges 0
Com_show_processlist 0
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 1
Com_show_storage_engines 0
Com_show_tables 0
Com_show_triggers 0
Com_show_variables 0
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_stmt_close 0
Com_stmt_execute 0
Com_stmt_fetch 0
Com_stmt_prepare 0
Com_stmt_reset 0
Com_stmt_send_long_data 0
Com_truncate 0
Com_unlock_tables 0
Com_update 1
Com_update_multi 0
Com_xa_commit 0
Com_xa_end 0
Com_xa_prepare 0
Com_xa_recover 0
Com_xa_rollback 0
Com_xa_start 0
Compression OFF
Connections 1522401
Created_tmp_disk_tables 0
Created_tmp_files 157
Created_tmp_tables 1
Delayed_errors 3
Delayed_insert_threads 1
Delayed_writes 4501
Flush_commands 1
Handler_commit 0
Handler_delete 0
Handler_discover 0
Handler_prepare 0
Handler_read_first 1
Handler_read_key 21
Handler_read_next 1
Handler_read_prev 0
Handler_read_rnd 0
Handler_read_rnd_next 1
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 1
Handler_write 131
Innodb_buffer_pool_pages_data 1013
Innodb_buffer_pool_pages_dirty 0
Innodb_buffer_pool_pages_flushed 30089
Innodb_buffer_pool_pages_free 0
Innodb_buffer_pool_pages_latched 0
Innodb_buffer_pool_pages_misc 11
Innodb_buffer_pool_pages_total 1024
Innodb_buffer_pool_read_ahead_rnd 591
Innodb_buffer_pool_read_ahead_seq 362
Innodb_buffer_pool_read_requests 171094612
Innodb_buffer_pool_reads 20503
Innodb_buffer_pool_wait_free 0
Innodb_buffer_pool_write_requests 89379
Innodb_data_fsyncs 27488
Innodb_data_pending_fsyncs 0
Innodb_data_pending_reads 0
Innodb_data_pending_writes 0
Innodb_data_read 644386816
Innodb_data_reads 39207
Innodb_data_writes 50711
Innodb_data_written 1018659840
Innodb_dblwr_pages_written 30089
Innodb_dblwr_writes 5836
Innodb_log_waits 0
Innodb_log_write_requests 52637
Innodb_log_writes 9848
Innodb_os_log_fsyncs 14793
Innodb_os_log_pending_fsyncs 0
Innodb_os_log_pending_writes 0
Innodb_os_log_written 30175232
Innodb_page_size 16384
Innodb_pages_created 734
Innodb_pages_read 39069
Innodb_pages_written 30089
Innodb_row_lock_current_waits 0
Innodb_row_lock_time 0
Innodb_row_lock_time_avg 0
Innodb_row_lock_time_max 0
Innodb_row_lock_waits 0
Innodb_rows_deleted 773
Innodb_rows_inserted 2464
Innodb_rows_read 162250534
Innodb_rows_updated 5736
Key_blocks_not_flushed 0
Key_blocks_unused 4736
Key_blocks_used 14347
Key_read_requests 348613099
Key_reads 4744683
Key_write_requests 7960782
Key_writes 247832
Last_query_cost 0.000000
Max_used_connections 225
Not_flushed_delayed_rows 0
Open_files 102
Open_streams 0
Open_tables 64
Opened_tables 2
Prepared_stmt_count 0
Qcache_free_blocks 13727
Qcache_free_memory 61152328
Qcache_hits 5965640
Qcache_inserts 1769245
Qcache_lowmem_prunes 54497
Qcache_not_cached 627152
Qcache_queries_in_cache 23836
Qcache_total_blocks 65992
Questions 13833039
Rpl_status NULL
Select_full_join 0
Select_full_range_join 0
Select_range 1
Select_range_check 0
Select_scan 1
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 0
Sort_range 0
Sort_rows 0
Sort_scan 0
Ssl_accept_renegotiates 0
Ssl_accepts 0
Ssl_callback_cache_hits 0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects 0
Ssl_connect_renegotiates 0
Ssl_ctx_verify_depth 0
Ssl_ctx_verify_mode 0
Ssl_default_timeout 0
Ssl_finished_accepts 0
Ssl_finished_connects 0
Ssl_session_cache_hits 0
Ssl_session_cache_misses 0
Ssl_session_cache_mode NONE
Ssl_session_cache_overflows 0
Ssl_session_cache_size 0
Ssl_session_cache_timeouts 0
Ssl_sessions_reused 0
Ssl_used_session_cache_entries 0
Ssl_verify_depth 0
Ssl_verify_mode 0
Ssl_version
Table_locks_immediate 4902271
Table_locks_waited 12547
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 174
Threads_connected 52
Threads_created 225
Threads_running 1
Uptime 226705
Uptime_since_flush_status 226705

[eva2000]

do you have more than one my.ini or my.cnf file on the server as the settings you posted don't match the mysql variables output you posted i.e. mysql settings says you have thread_cache_size = 64 and table_cache = 512 but your mysql variables output say the opposite for table_cache = 64 and thread_cache_size = 512. This suggests you have another my.ini/my.cnf telling mysql what do to somewhere on the server below root level at C:\

I'd first update to PHP 4.4.7 or PHP 5.2.4 and MySQL 5.0.45/48.

Probably do well to move off windows to a linux server - better support help hehe

[pgowder]

do you have more than one my.ini or my.cnf file on the server as the settings you posted don't match the mysql variables output you posted i.e. mysql settings says you have thread_cache_size = 64 and table_cache = 512 but your mysql variables output say the opposite for table_cache = 64 and thread_cache_size = 512. This suggests you have another my.ini/my.cnf telling mysql what do to somewhere on the server below root level at C:\

I'd first update to PHP 4.4.7 or PHP 5.2.4 and MySQL 5.0.45/48.

Probably do well to move off windows to a linux server - better support help hehe

Hmm, maybe. How's this one:


#This File was made from template file created by PLESK installator program

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions


[mysqld]
# change this to the actual path to mysql root
basedir=C:/Program Files/SWsoft/Plesk/MySql
# change this to actual path to the data dir
datadir=C:/Program Files/SWsoft/Plesk/MySql/data
[mysqld]
#skip-innodb
max_connections = 5000
key_buffer = 128M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 2400
thread_cache_size = 512
wait_timeout = 10800
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 4M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[WinMySQLadmin]
Server=C:/Program Files/SWsoft/Plesk/MySql/bin/mysqld-nt.exe

[pgowder]

do you have more than one my.ini or my.cnf file on the server as the settings you posted don't match the mysql variables output you posted i.e. mysql settings says you have thread_cache_size = 64 and table_cache = 512 but your mysql variables output say the opposite for table_cache = 64 and thread_cache_size = 512. This suggests you have another my.ini/my.cnf telling mysql what do to somewhere on the server below root level at C:\

I'd first update to PHP 4.4.7 or PHP 5.2.4 and MySQL 5.0.45/48.

Probably do well to move off windows to a linux server - better support help hehe

Thanks for the feedback. I'm really looking for more advice than just upgrading php and mysql. It has been my experience that upgrades to those help, but not really that much. But if you know of serious bug fixes between where I am now and those versions let me know.

And I'm up for moving to any kind of server. But I need more of a compelling reason than better support!

Any other tips to help performance?

Thanks

[eva2000]

Upgrading PHP/MySQL helps eliminate them as factors first. Troubleshooting is a process of trial and error when it comes to such issues with servers etc.

Other than that, yes your my.cnf is messed up and that can cause performance issues such as memory swapping to disk. Have you checked your memory swap usage ?

Max execution time exceeded message, try raising the value in php.ini and seeing if that helps.

Is that my.ini another separate file on the server ?? again that one differs from the mysql variables output you posted initially i..e table_cache = 2400 versus 64 and max_connections differed from 200 and 5000 from my.ini versus mysqladmin variables output of 1910.

[pgowder]

Upgrading PHP/MySQL helps eliminate them as factors first. Troubleshooting is a process of trial and error when it comes to such issues with servers etc.

Other than that, yes your my.cnf is messed up and that can cause performance issues such as memory swapping to disk. Have you checked your memory swap usage ?

Max execution time exceeded message, try raising the value in php.ini and seeing if that helps.

Is that my.ini another separate file on the server ?? again that one differs from the mysql variables output you posted initially i..e table_cache = 2400 versus 64 and max_connections differed from 200 and 5000 from my.ini versus mysqladmin variables output of 1910.

What am I looking for about the swap memory?

How can I find out which ini file my MySQL is using?

[pgowder]

Upgrading PHP/MySQL helps eliminate them as factors first. Troubleshooting is a process of trial and error when it comes to such issues with servers etc.

Other than that, yes your my.cnf is messed up and that can cause performance issues such as memory swapping to disk. Have you checked your memory swap usage ?

Max execution time exceeded message, try raising the value in php.ini and seeing if that helps.

Is that my.ini another separate file on the server ?? again that one differs from the mysql variables output you posted initially i..e table_cache = 2400 versus 64 and max_connections differed from 200 and 5000 from my.ini versus mysqladmin variables output of 1910.

Swap isn't being used much.

I believe I've found the right one!

[MySQLD]
#log=mysql.sql
port=3306
basedir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL
datadir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL\\Data

default-character-set=latin1
default-storage-engine=INNODB
query_cache_size=128M
table_cache=2400
tmp_table_size=128M
thread_cache_size=512
#myisam_max_sort_file_size=100G
#myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=64M
key_buffer = 128M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=2M
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=5000
key_buffer=16M
max_allowed_packet=16M
sort_buffer=5M
net_buffer_length=4K
old_passwords=1

tmp_table_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
wait_timeout = 10800
connect_timeout = 10
max_connect_errors = 10
query_cache_limit = 10M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384

#long_query_time = 5
#log-long-format
#log-queries-not-using-indexes
#log-slow-queries = C:\\paul\\mysql_slow2.log

[client]
port=3306

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[eva2000]

Beside my highly recommended MySQL 5.0.45/48 update and PHP update, try this better optimised my.ini below.

I would rename (not delete) all other my.ini/my.cnf files that exist on your web server so as not to conflict with global settings specified at C:\my.ini

C:\my.ini should ideally be the only my.ini that exists for mysql


[client]
port=3306

[mysqld]
default-character-set=latin1
port=3306
basedir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL
datadir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL\\Data
old_passwords
back_log = 75
max_connections = 1024
key_buffer_size = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 4M
table_cache = 2000
thread_cache_size = 256
wait_timeout = 30
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 4
concurrent_insert = 2
table_lock_wait_timeout = 35
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 8M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 131072
query_alloc_block_size = 65536
#default-storage-engine = MyISAM
default-storage-engine=INNODB

innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=32M
innodb_log_file_size=10M
innodb_thread_concurrency=8

#long_query_time = 5
#log-long-format
#log-queries-not-using-indexes
#log-slow-queries = C:\\paul\\mysql_slow2.log

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
restart mysql then repost output for contents of stats.txt from below command

mysqladmin -u root -p var ext ver > stats.txt

then wait a day or two and rerun command again and post output for stats.txt again

This is just so see how it goes with more optimal my.ini settings first

[pgowder]

I've inserted that as my new my.ini.

And I've seen notes that I should not upgrade to those versions. And again I don't want to upgrade just for the sake of upgrading. Have you seen information that there are fixes in those version that would help?

What stats are you looking for?

[eva2000]

There's soo many MySQL 5.0.x change log entries since 5.0.37 http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs.html and PHP 5.2.4 http://www.php.net/ChangeLog-5.php#5.2.4

Stats for confirming that the my.ini changes are to the right my.ini and the extended-status output to see if the variables are helping or not.

[pgowder]

I'm moving to a new server! I'll continue this discussion after I get it up and running.

[john2k]

The forum is here:
www.powwows.com/gathering (http://www.powwows.com/gathering)

One of the odd things is that this vBulletin will run slow, but this one:

www.luckypredictions.com (http://www.luckypredictions.com) will run fine at the same times.

And they are both on the same server??

Do both forums have the exact same setup, the same mods added? From that it seems to me that it is not so much a server hardware issue as it is either a configuration issue or simply too many people accessing the same thing at the same time on the larger forum.


I'm starting to see this error:


PHP has encountered an Access Violation at 7C82CAA2


As far as I know, this means PHP needs to access something that it does not have permissions for. This error very often is associated with hosting on Windows as I haven't seen the same level of reports about this on Linux servers.


And this error on various files also occurs often during the day:

Fatal error: Maximum execution time of 30 seconds exceeded in C:...gathering\p lugins\vbplaza_postbit_start.php on line 12

The vbplaza plugin. You might try disabling it or contacting the developer to see if there's a way to cut down on resource usage. It could be that too many people are loading the script and causing something with it to lock up (maybe database table locking?).

1. Dedicated server
2. Dual Xeon 2.4
4 gb ram
IIS
PHP 5.2.2
MySQL 5.0.37-community-nt
3. 3.6.8


My guess is that this hardware should be very capable of handling your server load.

Just for comparison and to give you an idea of similar hardware - I run 9 vB forums with an approximate total of 3x the traffic of your two forums on a dual Opteron 246 with 8gb RAM 8, 8 hard drives (15k rpm) (RAID1 OS, RAID10 mysql & web files, 2 hot spares), CentOS 4.4 (Linux), Apache 2, PHP 5 (with APC cache) & MySQL 5.

There is a lot of room for my sites to grow on that server. I'm not recommending the same type of hardware for you, just trying to show what can be hosted effectively on a somewhat similar system.

What type of server and OS have you chosen for your upgrade?

[pgowder]

Do both forums have the exact same setup, the same mods added? From that it seems to me that it is not so much a server hardware issue as it is either a configuration issue or simply too many people accessing the same thing at the same time on the larger forum.



As far as I know, this means PHP needs to access something that it does not have permissions for. This error very often is associated with hosting on Windows as I haven't seen the same level of reports about this on Linux servers.



The vbplaza plugin. You might try disabling it or contacting the developer to see if there's a way to cut down on resource usage. It could be that too many people are loading the script and causing something with it to lock up (maybe database table locking?).



My guess is that this hardware should be very capable of handling your server load.

Just for comparison and to give you an idea of similar hardware - I run 9 vB forums with an approximate total of 3x the traffic of your two forums on a dual Opteron 246 with 8gb RAM 8, 8 hard drives (15k rpm) (RAID1 OS, RAID10 mysql & web files, 2 hot spares), CentOS 4.4 (Linux), Apache 2, PHP 5 (with APC cache) & MySQL 5.

There is a lot of room for my sites to grow on that server. I'm not recommending the same type of hardware for you, just trying to show what can be hosted effectively on a somewhat similar system.

What type of server and OS have you chosen for your upgrade?

First as for vbplaza, that is just an example. I get that error with every php file at different times.

I'm staying with Windows. I have some applications that require it, plus that is where I am more comfortable.

What forums do you run?