Hello, I have a strange problem with my mysql server. The mysql process seems to be using between 60 and 70 percent of the CPU at all times. Even when it is seemingly idle (not active queries). I'm not sure what to look for to see what it is doing other than truss'ing the process (I'm running it on Sparc Solaris 9 Ultra III procs). I have included the status and variables out put just incase something obvious pop's up there. Thanks alot!
Status
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 9 |
| Aborted_connects | 3 |
| Bytes_received | 173950772 |
| Bytes_sent | 148193771 |
| Connections | 6914 |
| Created_tmp_disk_tables | 5 |
| Created_tmp_tables | 246 |
| Created_tmp_files | 60 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 23819 |
| Handler_read_first | 50 |
| Handler_read_key | 1733808 |
| Handler_read_next | 609091 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 858202 |
| Handler_read_rnd_next | 497014755 |
| Handler_update | 1001154 |
| Handler_write | 2734124 |
| Key_blocks_used | 3129 |
| Key_read_requests | 9404342 |
| Key_reads | 3103 |
| Key_write_requests | 15079 |
| Key_writes | 14042 |
| Max_used_connections | 115 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 104 |
| Open_streams | 0 |
| Opened_tables | 435 |
| Questions | 739454 |
| Select_full_join | 54 |
| Select_full_range_join | 0 |
| Select_range | 68 |
| Select_range_check | 0 |
| Select_scan | 199027 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 30 |
| Sort_range | 4 |
| Sort_rows | 757025 |
| Sort_scan | 3392 |
| Table_locks_immediate | 583631 |
| Table_locks_waited | 96037 |
| Threads_cached | 0 |
| Threads_created | 6913 |
| Threads_connected | 102 |
| Threads_running | 3 |
| Uptime | 27352 |
+--------------------------+-----------+
54 rows in set (0.00 sec)
mysql> show variables;
+---------------------------------+--------------------------------------------
-------------------------------------------------------------------------------
--------------------------------+
| Variable_name |
Value
|
+---------------------------------+--------------------------------------------
-------------------------------------------------------------------------------
--------------------------------+
| back_log |
50
|
| basedir
| /pkg/dbase/
|
| bdb_cache_size |
8388600
|
| bdb_log_buffer_size |
32768
|
| bdb_home
| /vol/db/
|
| bdb_max_lock |
10000
|
| bdb_logdir
|
|
| bdb_shared_data |
OFF
|
| bdb_tmpdir
| /var/tmp/
|
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a:
(October 31,
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
| /vol/db/
|
| 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 |
8388600
|
| language
| /pkg/dbase/share/mysql/english/
|
| large_files_support |
ON
|
| locked_in_memory |
OFF
|
| 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 |
768
|
| 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 |
10
|
| net_write_timeout |
60
|
| open_files_limit |
0
|
| pid_file
| /vol/db/jotunheim.oit.pdx.edu.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_concurrency |
10
|
| thread_stack |
65536
|
| transaction_isolation | READ-
COMMITTED
|
| timezone |
PDT
|
| tmp_table_size |
33554432
|
| tmpdir
| /var/tmp/
|
| version |
3.23.44
|
| wait_timeout |
28800
|
+---------------------------------+--------------------------------------------
-------------------------------------------------------------------------------
--------------------------------+
91 rows in set (0.00 sec)
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
