Hi, We have mysql 3.23.43 running under FreeBSD 4.2, two-processors and a Tyan LE S2510 motherboard with 1 gig of ram. After a few peak loads of the server (load avg. gets higher than 20), mysql starts eating processor cycles. Server load gets close to 1.0, mysqld is active all the time, although almost no queries comes in.
Has anyone had this problem before? Any help is highly appreciated. Below is (slightly edited) "mysqldadmin status extended-status variable" output. mysqladmin -u root -p status extended-status variables Enter password: Uptime: 382385 Threads: 26 Questions: 10065975 Slow queries: 3 Opens: 414 Flush tables: 1 Open tables: 64 Queries per second avg: 26.324 +--------------------------+------------+ | Variable_name | Value | +--------------------------+------------+ | Aborted_clients | 1006 | | Aborted_connects | 0 | | Bytes_received | 1030079334 | | Bytes_sent | 3599913822 | | Connections | 460421 | | Created_tmp_disk_tables | 787 | | Created_tmp_tables | 11911 | | Created_tmp_files | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 292472 | | Handler_read_first | 1291 | | Handler_read_key | 9330959 | | Handler_read_next | 4044092 | | Handler_read_prev | 0 | | Handler_read_rnd | 19142458 | | Handler_read_rnd_next | 959934027 | | Handler_update | 3251570 | | Handler_write | 3824893 | | Key_blocks_used | 10086 | | Key_read_requests | 40011425 | | Key_reads | 8283 | | Key_write_requests | 1549487 | | Key_writes | 762676 | | Max_used_connections | 229 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 64 | | Open_files | 112 | | Open_streams | 0 | | Opened_tables | 414 | | Questions | 10065975 | | Select_full_join | 71 | | Select_full_range_join | 87 | | Select_range | 683 | | Select_range_check | 77 | | Select_scan | 65901 | | Slave_running | OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 3 | | Sort_merge_passes | 0 | | Sort_range | 140 | | Sort_rows | 15892575 | | Sort_scan | 42546 | | Table_locks_immediate | 9382816 | | Table_locks_waited | 11753 | | Threads_cached | 0 | | Threads_created | 460420 | | Threads_connected | 26 | | Threads_running | 1 | | Uptime | 382385 | +--------------------------+------------+ | Variable_name | Value +---------------------------------+------------ | back_log | 450 | basedir | /usr/local/ | bdb_cache_size | 8388600 | bdb_log_buffer_size | 32768 | bdb_home | /var/db/mysql/ | bdb_max_lock | 10000 | bdb_logdir | | bdb_shared_data | OFF | bdb_tmpdir | /var/tmp/ | bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (October 3, 2001) | binlog_cache_size | 32768 | character_set | latin1 | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | concurrent_insert | ON | connect_timeout | 5 | datadir | /var/db/mysql/ | delay_key_write | ON | delayed_insert_limit | 100 | delayed_insert_timeout | 300 | delayed_queue_size | 1000 | flush | OFF | flush_time | 0 | have_bdb | YES | have_gemini | NO | have_innodb | NO | have_isam | YES | have_raid | NO | have_openssl | NO | init_file | | interactive_timeout | 28800 | join_buffer_size | 131072 | key_buffer_size | 16773120 | language | /usr/local/share/mysql/english/ | large_files_support | ON | log | OFF | log_update | OFF | log_bin | OFF | log_slave_updates | OFF | log_long_queries | OFF | long_query_time | 10 | low_priority_updates | OFF | lower_case_table_names | 0 | max_allowed_packet | 1048576 | max_binlog_cache_size | 4294967295 | max_binlog_size | 1073741824 | max_connections | 1000 | max_connect_errors | 10 | max_delayed_threads | 20 | max_heap_table_size | 16777216 | max_join_size | 4294967295 | max_sort_length | 1024 | max_user_connections | 0 | max_tmp_tables | 32 | max_write_lock_count | 4294967295 | myisam_max_extra_sort_file_size | 256 | myisam_max_sort_file_size | 2047 | myisam_recover_options | 0 | myisam_sort_buffer_size | 8388608 | net_buffer_length | 16384 | net_read_timeout | 30 | net_retry_count | 1000000 | net_write_timeout | 60 | open_files_limit | 0 | pid_file | /var/db/mysql/turbo.pid | port | 3306 | protocol_version | 10 | record_buffer | 131072 | record_rnd_buffer | 131072 | query_buffer_size | 0 | safe_show_database | OFF | server_id | 0 | slave_net_timeout | 3600 | skip_locking | OFF | skip_networking | OFF | skip_show_database | OFF | slow_launch_time | 2 | socket | /tmp/mysql.sock | sort_buffer | 2097144 | sql_mode | 0 | table_cache | 64 | table_type | MYISAM | thread_cache_size | 0 | thread_stack | 65536 | transaction_isolation | READ-COMMITTED | timezone | EST | tmp_table_size | 33554432 | tmpdir | /var/tmp/ | version | 3.23.43 | wait_timeout | 3600 +---------------------------------+---------------- $uptime 4:50AM up 4 days, 10:28, 1 user, load averages: 1.08, 1.08, 1.02 $ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
