Hello. You can use SHOW PROCESSLIST and slow log to find out what queries make such a heavy load. See: http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
Sebastien Roy wrote: > > 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 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
