Windows 2003 Server Optimisation request
 

<div>I'm getting lots of CPU load at or near 100% and appreciate any knowledgeable help in configuring the server. Thanks in advance.

1. Dedicated server

2. Intel Celeron 1.7 Ghz, 1 Gb of Ram
Hard drive: 55.2 Gb with 13.8 Gb free
Windows 2003 Server
Apache 2.2
PHP 5
MySQL version: mysql 5.1.34

3. vB 3.8.2

4. MySQL using MyISAM

5. if possible how mysql was compiled/installed -- Windows installer

6. (So log into your server via ssh telnet as root user and type the command in bold - top) Can you translate this to a Windows 2003 server?


7.
Quote:
port=3306
basedir="C:/MySQL/"
datadir="C:/Data/"
default-character-set=latin1
default-storage-engine=MyISAM
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION"
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=51M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=102M
key_buffer_size=84M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_data_home_dir="C:/MySQL/Data/"
innodb_additional_mem_pool_size=3440K
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=163M
innodb_log_file_size=82M
innodb_thread_concurrency=8
8.
<div style="margin:20px; margin-top:5px; "> Quote:
MySQL Variables
Variable_name Value
auto_increment_increment 1
auto_increment_offset 1
autocommit ON
automatic_sp_privileges ON
back_log 50
basedir C:\MySQL5\
big_tables OFF
binlog_cache_size 32768
binlog_format STATEMENT
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:\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:\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 ON
error_count 0
event_scheduler DISABLED
expire_logs_days 0
flush OFF
flush_time 1800
foreign_key_checks ON
ft_boolean_syntax + ->