mysql 启动异常

wolfguozi

mysql启动的时候老是出现这样的问题！请高手帮忙看看！我的服务器系统是AS5

080619 12:13:06  mysqld started
080619 12:13:07  InnoDB: Started; log sequence number 7 612307833
/usr/local/mysql//libexec/mysqld: Out of memory (Needed 357273600 bytes)
/usr/local/mysql//libexec/mysqld: Out of memory (Needed 267955200 bytes)
/usr/local/mysql//libexec/mysqld: Out of memory (Needed 200964096 bytes)
/usr/local/mysql//libexec/mysqld: Out of memory (Needed 150721536 bytes)

yueliangdao0608

Optimize your sql statement.

wolfguozi

以下是我的优化过的my.cnf# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 8M
table_cache = 1024
sort_buffer_size = 8M
net_buffer_length = 8M
read_buffer_size = 32M
read_rnd_buffer_size = 64M
myisam_sort_buffer_size = 32M
thread_cache_size = 16
query_cache_size = 256M
skip-name-resolve
tmp_table_size = 512M
thread_concurrency = 16
max_connections=400


innodb_buffer_pool_size = 2G
innodb_additional_mem_pool_size = 64M
innodb_thread_concurrency=16
innodb_max_dirty_pages_pct = 128
innodb_file_io_threads = 4

# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 256M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 0
innodb_lock_wait_timeout = 50

我的服务器是4G内存 4核的CPUX2

yueliangdao0608

你服务器的内存有多大？你的内存设置的实在是，跟我第一次设置的时候一样。