Hi all,
Now I'm facing a big problem and see if anyone know how to solve it. I'm
using RS6000 AIX 4.3.2 CPU*2 1G RAM with HA. And DB is MySQL 4.0.12-max.
Here is the content of my.cnf.
[client]
#password = your_password
port= 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=256M
set-variable= max_allowed_packet=1M
set-variable= table_cache=256
set-variable= sort_buffer=1M
set-variable= record_buffer=1M
set-variable= myisam_sort_buffer_size=64M
set-variable= thread_cache=8
set-variable= max_connections=400
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=4
log-bin
log_slow_queries
log_warnings
server-id = 1
default_character_set=gbk
# Uncomment the following if you are using BDB tables
skip-bdb
# Uncomment the following if you are using InnoDB tables
skip-innodb
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqldump]
quick
set-variable= max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable= key_buffer=128M
set-variable= sort_buffer=128M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[myisamchk]
set-variable= key_buffer=128M
set-variable= sort_buffer=128M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[mysqlhotcopy]
interactive-timeout
Now I have to restart mysqld one time in every day, because of cannot
connect it. The error message in .err file is:
030627 11:50:56 Error: Can't create thread to kill server
030627 11:51:06 mysqld restarted
/home/mysql/bin/mysqld: ready for connections.
Version: '4.0.12-max-log' socket: '/tmp/mysql.sock' port: 3306
030627 11:51:15 /home/mysql/bin/mysqld: Normal shutdown
030627 11:51:16 /home/mysql/bin/mysqld: Shutdown Complete
030627 11:51:16 mysqld ended
030627 12:05:19 mysqld started
/home/mysql/bin/mysqld: ready for connections.
Version: '4.0.12-max-log' socket: '/tmp/mysql.sock' port: 3306
030628 21:09:29 Out of memory; Check if mysqld or some other process uses
all available memory. If not you may have to use 'ulimit
' to allow mysqld to use more memory or you can add more swap space
030628 21:09:29 Out of memory; Check if mysqld or some other process uses
all available memory. If not you may have to use 'ulimit
' to allow mysqld to use more memory or you can add more swap space
030628 21:09:30 Out of memory; Check if mysqld or some other process uses
all available memory. If not you may have to use 'ulimit
' to allow mysqld to use more memory or you can add more swap space
030629 22:47:33 Error: Can't create thread to kill server
030629 22:47:43 mysqld restarted
/home/mysql/bin/mysqld: ready for connections.
Version: '4.0.12-max-log' socket: '/tmp/mysql.sock' port: 3306
030629 22:47:53 /home/mysql/bin/mysqld: Normal shutdown
030629 22:47:53 /home/mysql/bin/mysqld: Shutdown Complete
030629 22:47:53 mysqld ended
030629 23:07:26 mysqld started
/home/mysql/bin/mysqld: ready for connections.
Version: '4.0.12-max-log' socket: '/tmp/mysql.sock' port: 3306
ulimit result is
ulimit -a
time(seconds)unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes)32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000
show status result is
mysql show status;
+--+---+
| Variable_name| Value |
+--+---+
| Aborted_clients | 123 |
| Aborted_connects | 0 |
| Bytes_received | 152280|
| Bytes_sent | 125496454 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin| 0 |
| Com_change_db| 184 |
| Com_change_master| 0 |
| Com_check| 0 |
| Com_commit | 0 |
| Com_create_db| 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 0 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function| 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush| 0 |
| Com_grant| 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 52|
| Com_insert_select