- 论坛徽章:
- 0
|
参数已做调整,现在如下,
[mysqld]
#delay_key_write = all
max_connections = 500
max_connect_errors = 100000
key_buffer = 256M
myisam_sort_buffer_size = 51200000
join_buffer_size = 2097152
read_buffer_size = 4194304
sort_buffer_size = 4194304
table_cache = 1000
thread_cache_size = 80
max_join_size = 512000000
max_binlog_cache_size = 512000000
tmp_table_size = 102400000
max_heap_table_size = 102400000
read_rnd_buffer_size = 5242880
bulk_insert_buffer_size = 64M
thread_concurrency = 2
query_cache_limit = 4000000
query_cache_size = 0
query_cache_type = 1
wait_timeout = 7200
interactive_timeout = 7200
skip-innodb
skip-bdb
[root@5co2 data]#
但问题并没有解决,情况如下
080814 22:00:18 mysqld started
080814 22:00:18 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
080814 22:00:18 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
080814 22:00:19 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.26-standard' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
Number of processes running now: 0
080814 22:53:47 mysqld restarted
080814 22:53:48 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
080814 22:53:48 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
080814 22:53:48 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.26-standard' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
Number of processes running now: 0
080814 23:17:23 mysqld restarted
^G/usr/local/mysql/bin/mysqld: Out of memory (Needed 237527040 bytes)
^G/usr/local/mysql/bin/mysqld: Out of memory (Needed 178145280 bytes)
^G/usr/local/mysql/bin/mysqld: Out of memory (Needed 133607424 bytes)
^G/usr/local/mysql/bin/mysqld: Out of memory (Needed 100205568 bytes)
^G/usr/local/mysql/bin/mysqld: Out of memory (Needed 75153408 bytes)
080814 23:17:23 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
080814 23:17:23 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
080814 23:17:23 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.26-standard' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
[ 本帖最后由 yxyup 于 2008-8-15 09:49 编辑 ] |
|
免费注册
楼主: yxyup
发表于 2008-08-14 11:22
发表于 2008-08-14 14:31
