mysql cpu使用率_mysql cpu 使用率100%

mysql的my.ini文件信息如下：[client]port=3306[mysql]default-character-set=gbk[mysqld]port=3306basedir="D:/ProgramFiles/MySQL/MySQLServer5.0/"datadir="D:/ProgramFiles/MySQL...

mysql的my.ini 文件信息如下：

[client]

port=3306

[mysql]

default-character-set=gbk

[mysqld]

port=3306

basedir="D:/Program Files/MySQL/MySQL Server 5.0/"

datadir="D:/Program Files/MySQL/MySQL Server 5.0/Data/"

default-character-set=gbk

default-storage-engine=INNODB

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

log-slow-queries

long_query_time=1

log_long_format

#max_connections=800

max_connections=1024

back_log = 50

#query_cache_size=84M

query_cache_size=64M

#table_cache=1520

table_cache=507

#tmp_table_size=30M

tmp_table_size=32M

#thread_cache_size=38

thread_cache_size=16

#*** MyISAM Specific options

myisam_max_sort_file_size=10G

myisam_max_extra_sort_file_size=10G

myisam_sort_buffer_size=30M

#key_buffer_size=129M

key_buffer_size=16M

read_buffer_size=64K

read_rnd_buffer_size=256K

sort_buffer_size=256K

#*** INNODB Specific options ***

innodb_data_file_path=ibdata1:900M;ibdata2:50M:autoextend

innodb_additional_mem_pool_size=16M

#innodb_flush_log_at_trx_commit=1

innodb_flush_log_at_trx_commit=0

#innodb_log_buffer_size=3M

innodb_log_buffer_size=8M

innodb_log_files_in_group=2

#innodb_buffer_pool_size=249M

innodb_buffer_pool_size=512M

#innodb_log_file_size=169M

innodb_log_file_size=256M

innodb_lock_wait_timeout=120

innodb_thread_concurrency=8

innodb_file_per_table

[mysqldump]

quick

max_allowed_packet = 16M

展开