show global status; +------------------------------------------+----------------------+ | Variable_name | Value | +------------------------------------------+----------------------+ | Aborted_clients | 2 | | Aborted_connects | 2 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use | 0 | | Bytes_received | 1534065355 | | Bytes_sent | 203367425 | | Com_admin_commands | 185 | | Com_assign_to_keycache | 0 | | Com_alter_db | 0 | | Com_alter_db_upgrade | 0 | | Com_alter_event | 0 | | Com_alter_function | 0 | | Com_alter_procedure | 0 | | Com_alter_server | 0 | | Com_alter_table | 490 | | Com_alter_tablespace | 0 | | Com_analyze | 0 | | Com_begin | 453233 | | Com_binlog | 0 | | Com_call_procedure | 0 | | Com_change_db | 108 | | Com_change_master | 0 | | Com_check | 0 | | Com_checksum | 0 | | Com_commit | 453233 | | Com_create_db | 98 | | Com_create_event | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_procedure | 0 | | Com_create_server | 0 | | Com_create_table | 784 | | Com_create_trigger | 0 | | Com_create_udf | 0 | | Com_create_user | 0 | | Com_create_view | 0 | | Com_dealloc_sql | 0 | | Com_delete | 3 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 1 | | Com_drop_event | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_procedure | 0 | | Com_drop_server | 0 | | Com_drop_table | 0 | | Com_drop_trigger | 0 | | Com_drop_user | 0 | | Com_drop_view | 0 | | Com_empty_query | 8 | | Com_execute_sql | 0 | | Com_flush | 6 | | Com_grant | 6 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 1995538 | | Com_insert_select | 0 | | Com_install_plugin | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_release_savepoint | 0 | | Com_rename_table | 0 | | Com_rename_user | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_resignal | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_rollback | 0 | | Com_rollback_to_savepoint | 0 | | Com_savepoint | 0 | | Com_select | 75484 | | Com_set_option | 102367 | | Com_signal | 0 | | Com_show_authors | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_charsets | 0 | | Com_show_collations | 4 | | Com_show_contributors | 0 | | Com_show_create_db | 0 | | Com_show_create_event | 0 | | Com_show_create_func | 0 | | Com_show_create_proc | 0 | | Com_show_create_table | 16 | | Com_show_create_trigger | 0 | | Com_show_databases | 8 | | Com_show_engine_logs | 0 | | Com_show_engine_mutex | 0 | | Com_show_engine_status | 300 | | Com_show_events | 16 | | Com_show_errors | 0 | | Com_show_fields | 0 | | Com_show_function_status | 16 | | Com_show_grants | 0 | | Com_show_keys | 0 | | Com_show_master_status | 0 | | Com_show_open_tables | 0 | | Com_show_plugins | 0 | | Com_show_privileges | 0 | | Com_show_procedure_status | 16 | | Com_show_processlist | 309 | | Com_show_profile | 0 | | Com_show_profiles | 0 | | Com_show_relaylog_events | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 299 | | Com_show_status | 609 | | Com_show_storage_engines | 4 | | Com_show_table_status | 30 | | Com_show_tables | 1 | | Com_show_triggers | 16 | | Com_show_variables | 301 | | 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_reprepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_truncate | 0 | | Com_uninstall_plugin | 0 | | Com_unlock_tables | 0 | | Com_update | 1 | | 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 | 54936 | | Created_tmp_disk_tables | 794 | | Created_tmp_files | 1002 | | Created_tmp_tables | 58771 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 6 | | Handler_commit | 2525010 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_prepare | 0 | | Handler_read_first | 34344 | | Handler_read_key | 48033280 | | Handler_read_last | 602 | | Handler_read_next | 19056567 | | Handler_read_prev | 145504 | | Handler_read_rnd | 2177891 | | Handler_read_rnd_next | 72051454 | | Handler_rollback | 1 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 12810921 | | Handler_write | 4380146 | | Innodb_buffer_pool_pages_data | 11353 | | Innodb_buffer_pool_pages_dirty | 982 | | Innodb_buffer_pool_pages_flushed | 3673090 | | Innodb_buffer_pool_pages_free | 0 | | Innodb_buffer_pool_pages_misc | 18446744073709548454 | | Innodb_buffer_pool_pages_total | 8191 | | Innodb_buffer_pool_read_ahead | 296216 | | Innodb_buffer_pool_read_ahead_evicted | 364369 | | Innodb_buffer_pool_read_requests | 240774176 | | Innodb_buffer_pool_reads | 1880822 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 13154792 | | Innodb_data_fsyncs | 912002 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 21469057024 | | Innodb_data_reads | 2304949 | | Innodb_data_writes | 2487235 | | Innodb_data_written | 52632366592 | | Innodb_dblwr_pages_written | 1836545 | | Innodb_dblwr_writes | 68828 | | Innodb_have_atomic_builtins | ON | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 3192181 | | Innodb_log_writes | 551993 | | Innodb_os_log_fsyncs | 561811 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 1690305536 | | Innodb_page_size | 16384 | | Innodb_pages_created | 33748 | | Innodb_pages_read | 2270657 | | Innodb_pages_written | 1836545 | | Innodb_row_lock_current_waits | 0 | | Innodb_row_lock_time | 449212 | | Innodb_row_lock_time_avg | 5 | | Innodb_row_lock_time_max | 20523 | | Innodb_row_lock_waits | 83998 | | Innodb_rows_deleted | 0 | | Innodb_rows_inserted | 568075 | | Innodb_rows_read | 107592411 | | Innodb_rows_updated | 354577 | | Innodb_truncated_status_writes | 0 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 6698 | | Key_blocks_used | 46 | | Key_read_requests | 1250989 | | Key_reads | 1 | | Key_write_requests | 22219 | | Key_writes | 0 | | Last_query_cost | 0.000000 | | Max_used_connections | 175 | | Not_flushed_delayed_rows | 0 | | Open_files | 1 | | Open_streams | 0 | | Open_table_definitions | 400 | | Open_tables | 400 | | Opened_files | 19334 | | Opened_table_definitions | 5133 | | Opened_tables | 8658 | | Performance_schema_cond_classes_lost | 0 | | Performance_schema_cond_instances_lost | 0 | | Performance_schema_file_classes_lost | 0 | | Performance_schema_file_handles_lost | 0 | | Performance_schema_file_instances_lost | 0 | | Performance_schema_locker_lost | 0 | | Performance_schema_mutex_classes_lost | 0 | | Performance_schema_mutex_instances_lost | 0 | | Performance_schema_rwlock_classes_lost | 0 | | Performance_schema_rwlock_instances_lost | 0 | | Performance_schema_table_handles_lost | 0 | | Performance_schema_table_instances_lost | 0 | | Performance_schema_thread_classes_lost | 0 | | Performance_schema_thread_instances_lost | 0 | | Prepared_stmt_count | 0 | | Qcache_free_blocks | 0 | | Qcache_free_memory | 0 | | Qcache_hits | 0 | | Qcache_inserts | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 0 | | Qcache_queries_in_cache | 0 | | Qcache_total_blocks | 0 | | Queries | 3137909 | | Questions | 3137884 | | Rpl_status | AUTH_MASTER | | Select_full_join | 0 | | Select_full_range_join | 9 | | Select_range | 60942 | | Select_range_check | 0 | | Select_scan | 14476 | | Slave_heartbeat_period | 0.000 | | Slave_open_temp_tables | 0 | | Slave_received_heartbeats | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 28 | | Sort_merge_passes | 1 | | Sort_range | 135 | | Sort_rows | 1092802 | | Sort_scan | 56898 | | 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 | 123723455 | | Table_locks_waited | 0 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threads_cached | 0 | | Threads_connected | 29 | | Threads_created | 54934 | | Threads_running | 1 | | Uptime | 89949 | | Uptime_since_flush_status | 89949 | +------------------------------------------+----------------------+ 309 rows in set (0.00 sec) show engine innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 110712 16:15:10 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 15 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 85771 1_second, 85747 sleeps, 8445 10_second, 2748 background, 2747 flush srv_master_thread log flush and writes: 86353 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 105526, signal count 791002 Mutex spin waits 1970071, rounds 6391600, OS waits 34120 RW-shared spins 187194, rounds 1485013, OS waits 31914 RW-excl spins 238250, rounds 2401982, OS waits 32981 Spin rounds per wait: 3.24 mutex, 7.93 RW-shared, 10.08 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 26873744 Purge done for trx's n:o < 268736DD undo n:o < 0 History list length 2561 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 54915, query id 3139204 localhost thomas.parrott show engine innodb status ---TRANSACTION 268736D3, not started MySQL thread id 54968, query id 3138900 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268736D2, not started MySQL thread id 54967, query id 3138896 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268736C7, not started MySQL thread id 54965, query id 3138862 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268736C5, not started MySQL thread id 54964, query id 3138854 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687371F, not started MySQL thread id 54962, query id 3139102 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687371E, not started MySQL thread id 54961, query id 3139100 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873737, not started MySQL thread id 54959, query id 3139173 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873736, not started MySQL thread id 54958, query id 3139171 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687364E, not started MySQL thread id 54957, query id 3138551 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687362D, not started MySQL thread id 54956, query id 3138467 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687362C, not started MySQL thread id 54955, query id 3138462 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687360B, not started MySQL thread id 54954, query id 3138378 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687360A, not started MySQL thread id 54953, query id 3138376 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268735F5, not started MySQL thread id 54951, query id 3138327 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268735F4, not started MySQL thread id 54950, query id 3138323 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268735DB, not started MySQL thread id 54946, query id 3138253 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268735DA, not started MySQL thread id 54945, query id 3138251 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873716, not started MySQL thread id 54944, query id 3139074 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873733, not started MySQL thread id 54941, query id 3139162 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873734, not started MySQL thread id 54940, query id 3139165 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873572, not started MySQL thread id 54939, query id 3137983 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873571, not started MySQL thread id 54938, query id 3137979 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873717, not started MySQL thread id 54937, query id 3139077 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687355A, not started MySQL thread id 54935, query id 3137908 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873543, not started MySQL thread id 54934, query id 3137854 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268735F7, not started MySQL thread id 54933, query id 3138331 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687363E, not started MySQL thread id 54917, query id 3138518 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687363F, not started MySQL thread id 54916, query id 3138520 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687372B, not started MySQL thread id 54909, query id 3139138 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687372C, not started MySQL thread id 54908, query id 3139142 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873639, not started MySQL thread id 54905, query id 3138499 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873739, not started MySQL thread id 54904, query id 3139180 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873715, not started MySQL thread id 54903, query id 3139071 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687373A, not started MySQL thread id 54902, query id 3139182 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687320B, not started MySQL thread id 54901, query id 3136855 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873202, not started MySQL thread id 54900, query id 3136849 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873740, not started MySQL thread id 54899, query id 3139199 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268731D4, not started MySQL thread id 54898, query id 3136738 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268731D2, not started MySQL thread id 54897, query id 3136729 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268731D0, not started MySQL thread id 54896, query id 3136726 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873742, not started MySQL thread id 54894, query id 3139203 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687372A, not started MySQL thread id 54893, query id 3139134 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268736AB, not started MySQL thread id 54891, query id 3138792 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687373F, not started MySQL thread id 54890, query id 3139197 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26873086, not started MySQL thread id 54878, query id 3135835 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26872A00, not started MySQL thread id 54832, query id 3132912 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2687249A, not started MySQL thread id 54788, query id 3130468 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268736C2, not started MySQL thread id 54782, query id 3138844 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 268735C9, not started MySQL thread id 54775, query id 3138200 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 26872310, not started MySQL thread id 54773, query id 3129503 rps-coredb01.infinity.local 172.16.5.15 ict-import ---TRANSACTION 2684B66C, not started MySQL thread id 50225, query id 2867199 rps-build01.infinity.local 172.16.5.8 rob.norman -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2305899 OS file reads, 2488140 OS file writes, 912430 OS fsyncs 4.80 reads/s, 9216 avg bytes/read, 26.86 writes/s, 11.80 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 95, seg size 97, 97518 merges merged operations: insert 166191, delete mark 9890, delete 10 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 276671, node heap has 4 buffer(s) 3.27 hash searches/s, 270.25 non-hash searches/s --- LOG --- Log sequence number 187039035359 Log flushed up to 187039035359 Last checkpoint at 187037423546 0 pending log writes, 0 pending chkp writes 562202 log i/o's done, 7.67 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 137363456; in additional pool allocated 0 Dictionary memory allocated 325743851 Buffer pool size 8191 Free buffers 0 Database pages 11441 Old database pages 4203 Modified db pages 1111 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4418569, not young 0 5.40 youngs/s, 0.00 non-youngs/s Pages read 2271607, created 33765, written 1837120 4.80 reads/s, 0.53 creates/s, 17.87 writes/s Buffer pool hit rate 995 / 1000, young-making rate 5 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.20/s LRU len: 11441, unzip_LRU len: 1145 I/O sum[2045]:cur[0], unzip sum[4557]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 15490, id 1204738368, state: sleeping Number of rows inserted 568402, updated 354765, deleted 0, read 107593791 9.13 inserts/s, 5.00 updates/s, 0.00 deletes/s, 48.46 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) free total used free shared buffers cached Mem: 3145728 1750032 1395696 0 0 0 -/+ buffers/cache: 1750032 1395696 Swap: 0 0 0 vmstat 1 10 procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 2 0 0 1395688 0 0 0 0 15 136 0 0 1 0 96 2 0 0 0 0 1395688 0 0 0 0 0 136 0 1420 18 1 68 13 0 1 1 0 1395688 0 0 0 0 0 820 0 639 25 0 63 12 0 1 0 0 1395688 0 0 0 0 8 164 0 408 25 0 74 1 0 0 1 0 1395688 0 0 0 0 16 460 0 1511 19 1 69 12 0 0 2 0 1395688 0 0 0 0 16 336 0 1101 6 0 80 13 0 0 1 0 1395688 0 0 0 0 0 152 0 382 0 0 87 12 0 0 1 0 1395688 0 0 0 0 0 132 0 326 0 0 87 13 0 0 0 0 1395688 0 0 0 0 0 144 0 324 0 0 99 0 0 0 1 0 1395688 0 0 0 0 0 160 0 336 0 0 88 12 0