Status with INNODB Engine 5.0.24 ===================================== 060810 19:04:35 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 43 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 9026, signal count 9025 Mutex spin waits 96235, rounds 107301, OS waits 1165 RW-shared spins 14017, OS waits 6980; RW-excl spins 607, OS waits 277 ------------ TRANSACTIONS ------------ Trx id counter 0 3749958 Purge done for trx's n:o < 0 3747973 undo n:o < 0 0 History list length 43 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 3749956, not started, OS thread id 2348 MySQL thread id 829, query id 363515 sebastian1.intern.ipro.de 172.16.222.161 Ra ring ---TRANSACTION 0 0, not started, OS thread id 3020 MySQL thread id 827, query id 363516 localhost 127.0.0.1 root show innodb status ---TRANSACTION 0 3749950, not started, OS thread id 3640 MySQL thread id 748, query id 363472 volkmann.intern.ipro.de 172.16.6.17 Volkman n ---TRANSACTION 0 3747955, ACTIVE 3083 sec, OS thread id 2528 MySQL thread id 741, query id 358229 sebastian1.intern.ipro.de 172.16.222.161 Ra ring Trx read view will not see trx with id >= 0 3747956, sees < 0 3747956 -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 133164 OS file reads, 110280 OS file writes, 23636 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.07 writes/s, 0.07 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 103 inserts, 103 merged recs, 99 merges Hash table size 2212699, used cells 166009, node heap has 170 buffer(s) 0.19 hash searches/s, 0.19 non-hash searches/s --- LOG --- Log sequence number 17 943341463 Log flushed up to 17 943341463 Last checkpoint at 17 943341019 0 pending log writes, 0 pending chkp writes 16751 log i/o's done, 0.07 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 579110226; in additional pool allocated 942464 Buffer pool size 32768 Free buffers 0 Database pages 32598 Modified db pages 8 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 133154, created 65411, written 89520 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread id 3792, state: sleeping Number of rows inserted 2836251, updated 2572, deleted 3448, read 1160546482 0.05 inserts/s, 0.02 updates/s, 0.00 deletes/s, 0.09 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ mysql> show global status; +-----------------------------------+------------+ | Variable_name | Value | +-----------------------------------+------------+ | Aborted_clients | 10 | | Aborted_connects | 125 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Bytes_received | 145443948 | | Bytes_sent | 3335920853 | | Com_admin_commands | 861 | | Com_alter_db | 0 | | Com_alter_table | 3 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 77 | | Com_change_db | 8 | | Com_change_master | 0 | | Com_check | 212 | | Com_checksum | 0 | | Com_commit | 10650 | | Com_create_db | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_dealloc_sql | 0 | | Com_delete | 3448 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_drop_user | 0 | | Com_execute_sql | 0 | | Com_flush | 6 | | Com_grant | 2 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 12163 | | 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 | 212 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 1 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 1 | | Com_revoke_all | 0 | | Com_rollback | 29 | | Com_savepoint | 0 | | Com_select | 110801 | | Com_set_option | 21471 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_charsets | 0 | | Com_show_collations | 8 | | Com_show_column_types | 0 | | Com_show_create_db | 2 | | Com_show_create_table | 527 | | Com_show_databases | 0 | | Com_show_errors | 0 | | Com_show_fields | 2258 | | Com_show_grants | 0 | | Com_show_innodb_status | 1170 | | Com_show_keys | 1078 | | Com_show_logs | 0 | | Com_show_master_status | 0 | | Com_show_ndb_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_privileges | 0 | | Com_show_processlist | 14 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 1169 | | Com_show_storage_engines | 8 | | Com_show_tables | 113 | | Com_show_triggers | 212 | | Com_show_variables | 21 | | Com_show_warnings | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_stmt_close | 0 | | Com_stmt_execute | 0 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_truncate | 0 | | Com_unlock_tables | 2 | | Com_update | 2942 | | Com_update_multi | 0 | | Com_xa_commit | 0 | | Com_xa_end | 0 | | Com_xa_prepare | 0 | | Com_xa_recover | 0 | | Com_xa_rollback | 0 | | Com_xa_start | 0 | | Compression | OFF | | Connections | 830 | | Created_tmp_disk_tables | 7448 | | Created_tmp_files | 5 | | Created_tmp_tables | 10386 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 1 | | Handler_commit | 28475 | | Handler_delete | 3 | | Handler_discover | 0 | | Handler_prepare | 0 | | Handler_read_first | 9081 | | Handler_read_key | 4627417 | | Handler_read_next | 13435134 | | Handler_read_prev | 66866 | | Handler_read_rnd | 5572702 | | Handler_read_rnd_next | 1141236408 | | Handler_rollback | 33 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 14 | | Handler_write | 8172890 | | Innodb_buffer_pool_pages_data | 32598 | | Innodb_buffer_pool_pages_dirty | 0 | | Innodb_buffer_pool_pages_flushed | 89528 | | Innodb_buffer_pool_pages_free | 0 | | Innodb_buffer_pool_pages_latched | 0 | | Innodb_buffer_pool_pages_misc | 170 | | Innodb_buffer_pool_pages_total | 32768 | | Innodb_buffer_pool_read_ahead_rnd | 1703 | | Innodb_buffer_pool_read_ahead_seq | 422 | | Innodb_buffer_pool_read_requests | 221116711 | | Innodb_buffer_pool_reads | 48738 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 13406774 | | Innodb_data_fsyncs | 23639 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 2183778304 | | Innodb_data_reads | 133164 | | Innodb_data_writes | 110290 | | Innodb_data_written | 4147021824 | | Innodb_dblwr_pages_written | 89528 | | Innodb_dblwr_writes | 3508 | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 2480353 | | Innodb_log_writes | 13840 | | Innodb_os_log_fsyncs | 16612 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 1211879936 | | Innodb_page_size | 16384 | | Innodb_pages_created | 65411 | | Innodb_pages_read | 133154 | | Innodb_pages_written | 89528 | | Innodb_row_lock_current_waits | 0 | | Innodb_row_lock_time | 0 | | Innodb_row_lock_time_avg | 0 | | Innodb_row_lock_time_max | 0 | | Innodb_row_lock_waits | 0 | | Innodb_rows_deleted | 3448 | | Innodb_rows_inserted | 2836251 | | Innodb_rows_read | 1160546482 | | Innodb_rows_updated | 2572 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 3586 | | Key_blocks_used | 488 | | Key_read_requests | 26326 | | Key_reads | 991 | | Key_write_requests | 272 | | Key_writes | 33 | | Last_query_cost | 0.000000 | | Max_used_connections | 27 | | Not_flushed_delayed_rows | 0 | | Open_files | 1 | | Open_streams | 0 | | Open_tables | 6 | | Opened_tables | 3475 | | Qcache_free_blocks | 2309 | | Qcache_free_memory | 5291000 | | Qcache_hits | 191123 | | Qcache_inserts | 105309 | | Qcache_lowmem_prunes | 12474 | | Qcache_not_cached | 8599 | | Qcache_queries_in_cache | 4557 | | Qcache_total_blocks | 11842 | | Questions | 363529 | | Rpl_status | NULL | | Select_full_join | 2 | | Select_full_range_join | 39 | | Select_range | 9444 | | Select_range_check | 0 | | Select_scan | 12322 | | Slave_open_temp_tables | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 31 | | Sort_merge_passes | 0 | | Sort_range | 34004 | | Sort_rows | 5598047 | | Sort_scan | 6927 | | Ssl_accept_renegotiates | 0 | | Ssl_accepts | 0 | | Ssl_callback_cache_hits | 0 | | Ssl_cipher | | | Ssl_cipher_list | | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_ctx_verify_depth | 0 | | Ssl_ctx_verify_mode | 0 | | Ssl_default_timeout | 0 | | Ssl_finished_accepts | 0 | | Ssl_finished_connects | 0 | | Ssl_session_cache_hits | 0 | | Ssl_session_cache_misses | 0 | | Ssl_session_cache_mode | NONE | | Ssl_session_cache_overflows | 0 | | Ssl_session_cache_size | 0 | | Ssl_session_cache_timeouts | 0 | | Ssl_sessions_reused | 0 | | Ssl_used_session_cache_entries | 0 | | Ssl_verify_depth | 0 | | Ssl_verify_mode | 0 | | Ssl_version | | | Table_locks_immediate | 252874 | | Table_locks_waited | 0 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threads_cached | 6 | | Threads_connected | 5 | | Threads_created | 45 | | Threads_running | 1 | | Uptime | 160670 | +-----------------------------------+------------+ 245 rows in set (0.02 sec) mysql> Task Manager ------------ Handles: 13287 Threads: 24