Hey guys,
In my last email I was talking about 5 daemon on the same box. We change that to use only one daemon and we upgrade to 5.0.xx-64bit instead of 4.1.xx-64bits.
The machine itself it's a 12 CPU running AIX 5.3 ML03 with 4 Gig of RAM. The machine it's big web server running Apache/PHP and of course MySQL as the backend database. We don't use for the moment INNODB, only MYISAM. Someone can tell me if my my.cnf sounds good for that king of machine. And don't know why but since this afternoon the daemon stop responding and use 100% of the CPU. I think it's trying to use more memory and the system don't want.
Thanks The my.cnf file looks like that: [client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock key_buffer_size = 32M back_log = 50 max_connections = 100 max_connect_errors = 10 table_cache = 512 max_allowed_packet = 16M binlog_cache_size = 1M max_heap_table_size = 64M sort_buffer_size = 8M join_buffer_size = 8M thread_cache_size = 8 thread_concurrency = 24 query_cache_size = 64M query_cache_limit = 2M ft_min_word_len = 4 default_table_type = MYISAM thread_stack = 192K transaction_isolation = REPEATABLE-READ tmp_table_size = 128M log-bin=mysql-bin log_slow_queries long_query_time = 2 log_long_format log-bin=mysql-bin server-id = 1 [mysqldump] quick max_allowed_packet = 32M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout -- ** *Sébastien Roy* Administrateur de Systèmes Senior / Senior System Administrator ** *PointPub Communications.* - Laval, Canada (514) 867-1079 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>* **www.pointpub.net* <http://www.pointpub.net/> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
