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 | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_purge | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_select | 1086 | | Com_set_option | 44 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_create | 44 | | Com_show_databases | 0 | | Com_show_fields | 44 | | Com_show_grants | 0 | | Com_show_keys | 0 | | Com_show_logs | 0 | | Com_show_master_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 1 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 3 | | Com_show_innodb_status | 0 | | Com_show_tables | 1 | | Com_show_variables | 1 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 22 | | Connections | 188 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 25 | | Created_tmp_files | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 0 | | Handler_read_first | 7 | | Handler_read_key | 661490 | | Handler_read_next | 1280199 | | Handler_read_prev | 0 | | Handler_read_rnd | 311374 | | Handler_read_rnd_next | 24358462 | | Handler_rollback | 0 | | Handler_update | 1 | | Handler_write | 784 | | Key_blocks_used | 811 | | Key_read_requests | 2047856 | | Key_reads | 811 | | Key_write_requests | 170 | | Key_writes | 170 | | Max_used_connections | 47 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 45 | | Open_files | 93 | | Open_streams | 0 | | Opened_tables | 51 | | Questions | 1498 | | Qcache_queries_in_cache | 0 | | Qcache_inserts | 0 | | Qcache_hits | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 0 | | Qcache_free_memory | 0 | | Qcache_free_blocks | 0 | | Qcache_total_blocks | 0 | | Rpl_status | NULL | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 112 | | Select_range_check | 0 | | Select_scan | 256 | | Slave_open_temp_tables | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 3 | | Sort_merge_passes | 0 | | Sort_range | 38 | | Sort_rows | 592518 | | Sort_scan | 112 | | Table_locks_immediate | 1770 | | Table_locks_waited | 0 | | Threads_cached | 0 | | Threads_created | 48 | | Threads_connected | 48 | | Threads_running | 1 | | Uptime | 14473 | +--------------------------+-----------+ 131 rows in set (0.00 sec) Does anybody has idea about it? I really need help. Thanks a lot. -Ares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
