[mysql@gestor6 ~]$ mysql --version mysql Ver 14.12 Distrib 5.0.27, for redhat-linux-gnu (i686) using readline 5.0 mysql> show variables; +---------------------------------+------------------------------------------------------------+ | Variable_name | Value | +---------------------------------+------------------------------------------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | /usr/ | | bdb_cache_size | 8388600 | | bdb_home | /var/lib/mysql/ | | bdb_log_buffer_size | 262144 | | bdb_logdir | | | bdb_max_lock | 10000 | | bdb_shared_data | OFF | | bdb_tmpdir | /mysql_temp/ | | binlog_cache_size | 32768 | | bulk_insert_buffer_size | 8388608 | | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | completion_type | 0 | | concurrent_insert | 1 | | connect_timeout | 5 | | datadir | /var/lib/mysql/ | | date_format | %Y-%m-%d | | datetime_format | %Y-%m-%d %H:%i:%s | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | div_precision_increment | 4 | | engine_condition_pushdown | OFF | | expire_logs_days | 0 | | flush | OFF | | flush_time | 0 | | ft_boolean_syntax | + -><()~*:""&| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit | 20 | | ft_stopword_file | (built-in) | | group_concat_max_len | 1024 | | have_archive | NO | | have_bdb | YES | | have_blackhole_engine | NO | | have_compress | YES | | have_crypt | YES | | have_csv | NO | | have_dynamic_loading | YES | | have_example_engine | NO | | have_federated_engine | NO | | have_geometry | YES | | have_innodb | YES | | have_isam | NO | | have_merge_engine | YES | | have_ndbcluster | NO | | have_openssl | DISABLED | | have_query_cache | YES | | have_raid | NO | | have_rtree_keys | YES | | have_symlink | YES | | init_connect | | | init_file | | | init_slave | | | innodb_additional_mem_pool_size | 20971520 | | innodb_autoextend_increment | 8 | | innodb_buffer_pool_awe_mem_mb | 0 | | innodb_buffer_pool_size | 402653184 | | innodb_checksums | ON | | innodb_commit_concurrency | 0 | | innodb_concurrency_tickets | 500 | | innodb_data_file_path | sgo_ibdata_01:2000M;sgo_ibdatai_02:1000M:autoextend | | innodb_data_home_dir | /var/opt/mysql/innodb | | innodb_doublewrite | ON | | innodb_fast_shutdown | 1 | | innodb_file_io_threads | 4 | | innodb_file_per_table | ON | | innodb_flush_log_at_trx_commit | 1 | | innodb_flush_method | | | innodb_force_recovery | 0 | | innodb_lock_wait_timeout | 50 | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_arch_dir | /var/opt/mysql/log-archives | | innodb_log_archive | OFF | | innodb_log_buffer_size | 8388608 | | innodb_log_file_size | 104857600 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | /var/opt/mysql/log-archives | | innodb_max_dirty_pages_pct | 90 | | innodb_max_purge_lag | 0 | | innodb_mirrored_log_groups | 1 | | innodb_open_files | 300 | | innodb_support_xa | ON | | innodb_sync_spin_loops | 20 | | innodb_table_locks | ON | | innodb_thread_concurrency | 8 | | innodb_thread_sleep_delay | 10000 | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | key_buffer_size | 402653184 | | key_cache_age_threshold | 300 | | key_cache_block_size | 1024 | | key_cache_division_limit | 100 | | language | /usr/share/mysql/english/ | | large_files_support | ON | | large_page_size | 0 | | large_pages | OFF | | lc_time_names | en_US | | license | GPL | | local_infile | ON | | locked_in_memory | OFF | | log | OFF | | log_bin | ON | | log_bin_trust_function_creators | OFF | | log_error | | | log_queries_not_using_indexes | OFF | | log_slave_updates | OFF | | log_slow_queries | OFF | | log_warnings | 1 | | long_query_time | 10 | | low_priority_updates | OFF | | lower_case_file_system | OFF | | lower_case_table_names | 0 | | max_allowed_packet | 1047552 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connect_errors | 10 | | max_connections | 100 | | max_delayed_threads | 20 | | max_error_count | 64 | | max_heap_table_size | 16777216 | | max_insert_delayed_threads | 20 | | max_join_size | 4294967295 | | max_length_for_sort_data | 1024 | | max_prepared_stmt_count | 16382 | | max_relay_log_size | 0 | | max_seeks_for_key | 4294967295 | | max_sort_length | 1024 | | max_sp_recursion_depth | 0 | | max_tmp_tables | 32 | | max_user_connections | 0 | | max_write_lock_count | 4294967295 | | multi_range_count | 256 | | myisam_data_pointer_size | 6 | | myisam_max_sort_file_size | 2147483647 | | myisam_recover_options | OFF | | myisam_repair_threads | 1 | | myisam_sort_buffer_size | 67108864 | | myisam_stats_method | nulls_unequal | | net_buffer_length | 16384 | | net_read_timeout | 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | new | OFF | | old_passwords | ON | | open_files_limit | 1134 | | optimizer_prune_level | 1 | | optimizer_search_depth | 62 | | pid_file | /var/run/mysqld/mysqld.pid | | port | 3306 | | preload_buffer_size | 32768 | | prepared_stmt_count | 16382 | | protocol_version | 10 | | query_alloc_block_size | 8192 | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 33554432 | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | | query_prealloc_size | 8192 | | range_alloc_block_size | 2048 | | read_buffer_size | 2093056 | | read_only | OFF | | read_rnd_buffer_size | 262144 | | relay_log_purge | ON | | relay_log_space_limit | 0 | | rpl_recovery_rank | 0 | | secure_auth | OFF | | server_id | 1 | | skip_external_locking | ON | | skip_networking | OFF | | skip_show_database | OFF | | slave_compressed_protocol | OFF | | slave_load_tmpdir | /mysql_temp/ | | slave_net_timeout | 3600 | | slave_skip_errors | OFF | | slave_transaction_retries | 10 | | slow_launch_time | 2 | | socket | /tmp/mysql.sock | | sort_buffer_size | 2097144 | | sql_big_selects | ON | | sql_mode | | | sql_notes | ON | | sql_warnings | OFF | | ssl_ca | | | ssl_capath | | | ssl_cert | | | ssl_cipher | | | ssl_key | | | storage_engine | MyISAM | | sync_binlog | 0 | | sync_frm | ON | | system_time_zone | CLT | | table_cache | 512 | | table_lock_wait_timeout | 50 | | table_type | MyISAM | | thread_cache_size | 8 | | thread_stack | 196608 | | time_format | %H:%i:%s | | time_zone | SYSTEM | | timed_mutexes | OFF | | tmp_table_size | 33554432 | | tmpdir | /mysql_temp/ | | transaction_alloc_block_size | 8192 | | transaction_prealloc_size | 4096 | | tx_isolation | READ-COMMITTED | | updatable_views_with_limit | YES | | version | 5.0.27-log | | version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (October 21, 2006) | | version_comment | Source distribution | | version_compile_machine | i686 | | version_compile_os | redhat-linux-gnu | | wait_timeout | 28800 | +---------------------------------+------------------------------------------------------------+ 228 rows in set (0.00 sec) mysql> SHOW FULL PROCESSLIST; +-------+------+----------------------+------+-------------+-------+----------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+------+----------------------+------+-------------+-------+----------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------+ | 1 | dba | 172.29.15.10:2226 | NULL | Sleep | 1 | | NULL | | 30374 | dba | 172.29.15.10:4698 | NULL | Sleep | 0 | | NULL | | 35394 | OVPN | 192.168.110.185:3941 | ovpn | Sleep | 2 | | NULL | | 35502 | ovpn | 128.223.1.48:41133 | ovpn | Sleep | 21 | | NULL | | 35505 | ovpn | 128.223.1.48:41134 | ovpn | Query | 21 | Updating | UPDATE VPN_GROUPS SET CALL_COST_SUM=45406.71 WHERE VPN_GROUP_GUID_PK='E2FE1048-CB7D-53C6-4C65-A66B3CE7EEEE' | | 37054 | repl | gestor5:33337 | NULL | Binlog Dump | 40815 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 65930 | dba | 172.29.15.216:1468 | NULL | Sleep | 3 | | NULL | | 67480 | ovpn | 128.223.1.16:55987 | ovpn | Sleep | 1377 | | NULL | | 67580 | ovpn | 128.223.1.35:35090 | ovpn | Sleep | 21 | | NULL | | 67601 | ovpn | 128.223.1.101:56440 | ovpn | Sleep | 37 | | NULL | | 67759 | ovpn | 128.223.1.16:56027 | ovpn | Sleep | 15 | | NULL | | 68217 | ovpn | 128.223.1.101:56497 | ovpn | Sleep | 102 | | NULL | | 68281 | ovpn | 128.223.1.49:45194 | ovpn | Sleep | 776 | | NULL | | 68297 | ovpn | 128.223.1.35:36154 | ovpn | Sleep | 667 | | NULL | | 68655 | ovpn | 128.223.1.101:56535 | ovpn | Sleep | 892 | | NULL | | 68668 | ovpn | 128.223.1.101:56537 | ovpn | Sleep | 39 | | NULL | | 68671 | ovpn | 128.223.1.101:56538 | ovpn | Sleep | 466 | | NULL | | 68672 | ovpn | 128.223.1.101:56539 | ovpn | Sleep | 576 | | NULL | | 68704 | ovpn | 128.223.1.101:56541 | ovpn | Sleep | 38 | | NULL | | 68711 | ovpn | 128.223.1.101:56543 | ovpn | Sleep | 36 | | NULL | | 68712 | ovpn | 128.223.1.101:56544 | ovpn | Sleep | 166 | | NULL | | 68718 | ovpn | 128.223.1.101:56546 | ovpn | Sleep | 37 | | NULL | | 68744 | ovpn | 128.223.1.101:56551 | ovpn | Sleep | 37 | | NULL | | 68998 | ovpn | 128.223.1.101:56565 | ovpn | Sleep | 1 | | NULL | | 68999 | ovpn | 128.223.1.101:56567 | ovpn | Sleep | 37 | | NULL | | 69051 | ovpn | 128.223.1.16:56153 | ovpn | Sleep | 1339 | | NULL | | 69125 | ovpn | 128.223.1.101:56575 | ovpn | Sleep | 1132 | | NULL | | 69143 | ovpn | 128.223.1.101:56576 | ovpn | Sleep | 37 | | NULL | | 69147 | ovpn | 128.223.1.101:56578 | ovpn | Sleep | 37 | | NULL | | 69156 | ovpn | 128.223.1.101:56580 | ovpn | Sleep | 37 | | NULL | | 69199 | ovpn | 128.223.1.16:56164 | ovpn | Sleep | 15 | | NULL | | 69204 | ovpn | 128.223.1.16:56165 | ovpn | Sleep | 1404 | | NULL | | 69209 | ovpn | 128.223.1.101:56582 | ovpn | Sleep | 265 | | NULL | | 69251 | ovpn | 128.223.1.16:56170 | ovpn | Sleep | 1 | | NULL | | 69252 | ovpn | 128.223.1.16:56171 | ovpn | Sleep | 15 | | NULL | | 69316 | ovpn | 128.223.1.16:56176 | ovpn | Sleep | 657 | | NULL | | 69325 | ovpn | 128.223.1.16:56178 | ovpn | Sleep | 15 | | NULL | | 69331 | ovpn | 128.223.1.16:56179 | ovpn | Sleep | 1116 | | NULL | | 69333 | ovpn | 128.223.1.16:56180 | ovpn | Sleep | 1594 | | NULL | | 69334 | ovpn | 128.223.1.101:56590 | ovpn | Sleep | 37 | | NULL | | 69341 | ovpn | 128.223.1.101:56591 | ovpn | Sleep | 36 | | NULL | | 69359 | ovpn | 128.223.1.16:56185 | ovpn | Sleep | 20 | | NULL | | 69377 | ovpn | 128.223.1.16:56188 | ovpn | Sleep | 636 | | NULL | | 69386 | ovpn | 128.223.1.16:56190 | ovpn | Sleep | 41 | | NULL | | 69423 | ovpn | 128.223.1.49:45195 | ovpn | Sleep | 63 | | NULL | | 69454 | ovpn | 128.223.1.16:56202 | ovpn | Sleep | 15 | | NULL | | 69552 | ovpn | 128.223.1.35:37943 | ovpn | Sleep | 96 | | NULL | | 69586 | ovpn | 128.223.1.16:56216 | ovpn | Sleep | 472 | | NULL | | 69597 | ovpn | 128.223.1.16:56217 | ovpn | Sleep | 354 | | NULL | | 69621 | ovpn | 128.223.1.16:56219 | ovpn | Sleep | 299 | | NULL | | 69635 | root | localhost | ovpn | Query | 0 | NULL | SHOW FULL PROCESSLIST | +-------+------+----------------------+------+-------------+-------+----------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------+ 51 rows in set (0.00 sec) mysql> SHOW INNODB STATUS\G *************************** 1. row *************************** Status: ===================================== 090907 14:04:45 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 0 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 466264, signal count 465249 Mutex spin waits 1061049, rounds 4064780, OS waits 95952 RW-shared spins 730592, OS waits 351694; RW-excl spins 9847, OS waits 2764 ------------ TRANSACTIONS ------------ Trx id counter 2 1248750820 Purge done for trx's n:o < 2 1248749152 undo n:o < 0 0 History list length 18 Total number of lock structs in row lock hash table 53 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 2 1248733218, not started, process no 26628, OS thread id 2079189920 MySQL thread id 69635, query id 50407624 localhost root SHOW INNODB STATUS ---TRANSACTION 2 1248750669, not started, process no 26628, OS thread id 2079591328 MySQL thread id 69621, query id 50407463 128.223.1.16 ovpn ---TRANSACTION 2 1248741607, not started, process no 26628, OS thread id 2084162464 MySQL thread id 69552, query id 50379552 128.223.1.35 ovpn ---TRANSACTION 2 1248744198, not started, process no 26628, OS thread id 2088352672 MySQL thread id 69423, query id 50387319 128.223.1.49 ovpn ---TRANSACTION 2 1248748842, not started, process no 26628, OS thread id 2078989216 MySQL thread id 69359, query id 50405461 128.223.1.16 ovpn ---TRANSACTION 2 1248642058, not started, process no 26628, OS thread id 2061343648 MySQL thread id 69341, query id 50388844 128.223.1.101 ovpn ---TRANSACTION 2 1248632993, not started, process no 26628, OS thread id 2070440864 MySQL thread id 69334, query id 50388828 128.223.1.101 ovpn ---TRANSACTION 2 1248629356, not started, process no 26628, OS thread id 2070842272 MySQL thread id 69325, query id 50405767 128.223.1.16 ovpn ---TRANSACTION 2 1248625882, not started, process no 26628, OS thread id 2068560800 MySQL thread id 69252, query id 50405778 128.223.1.16 ovpn ---TRANSACTION 2 1248749810, not started, process no 26628, OS thread id 2061142944 MySQL thread id 69251, query id 50406654 128.223.1.16 ovpn ---TRANSACTION 2 1248749150, not started, process no 26628, OS thread id 2061945760 MySQL thread id 69199, query id 50405818 128.223.1.16 ovpn ---TRANSACTION 2 1248745447, not started, process no 26628, OS thread id 2062347168 MySQL thread id 69156, query id 50388842 128.223.1.101 ovpn ---TRANSACTION 2 1248645312, not started, process no 26628, OS thread id 2077850528 MySQL thread id 69147, query id 50388835 128.223.1.101 ovpn ---TRANSACTION 2 1248585980, not started, process no 26628, OS thread id 2071042976 MySQL thread id 69143, query id 50388819 128.223.1.101 ovpn ---TRANSACTION 2 1248580201, not started, process no 26628, OS thread id 2088754080 MySQL thread id 68999, query id 50388824 128.223.1.101 ovpn ---TRANSACTION 2 1248750368, not started, process no 26628, OS thread id 2060139424 MySQL thread id 68998, query id 50407142 128.223.1.101 ovpn ---TRANSACTION 2 1248570172, not started, process no 26628, OS thread id 2064399264 MySQL thread id 68744, query id 50388843 128.223.1.101 ovpn ---TRANSACTION 2 1248572065, not started, process no 26628, OS thread id 2064800672 MySQL thread id 68718, query id 50388826 128.223.1.101 ovpn ---TRANSACTION 2 1248745283, not started, process no 26628, OS thread id 2063797152 MySQL thread id 68704, query id 50388817 128.223.1.101 ovpn ---TRANSACTION 2 1248745419, not started, process no 26628, OS thread id 2064599968 MySQL thread id 68668, query id 50388793 128.223.1.101 ovpn ---TRANSACTION 2 1248695660, not started, process no 26628, OS thread id 2088553376 MySQL thread id 68297, query id 50286968 128.223.1.35 ovpn ---TRANSACTION 2 1248696319, not started, process no 26628, OS thread id 2071645088 MySQL thread id 68281, query id 50254604 128.223.1.49 ovpn ---TRANSACTION 2 1248595525, not started, process no 26628, OS thread id 2060741536 MySQL thread id 67759, query id 50405791 128.223.1.16 ovpn ---TRANSACTION 2 1248665504, not started, process no 26628, OS thread id 2071243680 MySQL thread id 67601, query id 50388847 128.223.1.101 ovpn ---TRANSACTION 2 1248748673, not started, process no 26628, OS thread id 2078251936 MySQL thread id 67580, query id 50405331 128.223.1.35 ovpn ---TRANSACTION 2 1248750819, not started, process no 26628, OS thread id 2083117984 MySQL thread id 35394, query id 50407617 192.168.110.185 OVPN ---TRANSACTION 0 0, not started, process no 26628, OS thread id 2085215136 MySQL thread id 30374, query id 50407622 172.29.15.10 dba ---TRANSACTION 0 0, not started, process no 26628, OS thread id 2089155488 MySQL thread id 1, query id 50407623 172.29.15.10 dba ---TRANSACTION 2 1248748690, ACTIVE 41 sec, process no 26628, OS thread id 2083957664 starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 320 MySQL thread id 35505, query id 50405302 128.223.1.48 ovpn Updating UPDATE VPN_GROUPS SET CALL_COST_SUM=45406.71 WHERE VPN_GROUP_GUID_PK='E2FE1048-CB7D-53C6-4C65-A66B3CE7EEEE' ------- TRX HAS BEEN WAITING 41 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 10 page no 806 n bits 160 index `PRIMARY` of table `ovpn/VPN_GROUPS` trx id 2 1248748690 lock_mode X locks rec but not gap waiting Record lock, heap no 33 PHYSICAL RECORD: n_fields 12; compact format; info bits 0 0: len 30; hex 45324645313034382d434237442d353343362d344336352d413636423343; asc E2FE1048-CB7D-53C6-4C65-A66B3C;...(truncated); 1: len 6; hex 00024a6dd55f; asc Jm _;; 2: len 7; hex 000004801a0151; asc Q;; 3: len 8; hex 800012411f0c04b7; asc A ;; 4: len 30; hex 46364245453334362d363242382d383032382d363430322d363731353932; asc F6BEE346-62B8-8028-6402-671592;...(truncated); 5: len 11; hex 53312e3130363931323230; asc S1.10691220;; 6: len 11; hex 53312e3130363931323230; asc S1.10691220;; 7: len 10; hex 312e3130363931323230; asc 1.10691220;; 8: SQL NULL; 9: len 4; hex 80024612; asc F ;; 10: len 8; hex 0000000080370641; asc 7 A;; 11: len 8; hex 14ae47e1ea22e640; asc G " @;; ------------------ ---TRANSACTION 2 1248748689, ACTIVE 41 sec, process no 26628, OS thread id 2071985056 2 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 35502, query id 50405280 128.223.1.48 ovpn ---TRANSACTION 2 1248745282, ACTIVE 61 sec, process no 26628, OS thread id 2079390624 4 lock struct(s), heap size 320, undo log entries 2 MySQL thread id 69386, query id 50388643 128.223.1.16 ovpn ---TRANSACTION 2 1248741305, ACTIVE 122 sec, process no 26628, OS thread id 2062146464 MySQL thread id 68217, query id 50379222 128.223.1.101 ovpn ---TRANSACTION 2 1248739075, ACTIVE 165 sec, process no 26628, OS thread id 2061544352 2 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 69454, query id 50405815 128.223.1.16 ovpn ---TRANSACTION 2 1248738015, ACTIVE 186 sec, process no 26628, OS thread id 2061745056 6 lock struct(s), heap size 1024, undo log entries 2 MySQL thread id 68712, query id 50375154 128.223.1.101 ovpn ---TRANSACTION 2 1248731970, ACTIVE 285 sec, process no 26628, OS thread id 2085616544 6 lock struct(s), heap size 1024, undo log entries 2 MySQL thread id 69209, query id 50362537 128.223.1.101 ovpn ---TRANSACTION 2 1248731815, ACTIVE 288 sec, process no 26628, OS thread id 2064198560 2 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 68711, query id 50388953 128.223.1.101 ovpn ---TRANSACTION 2 1248726195, ACTIVE 374 sec, process no 26628, OS thread id 2060942240 6 lock struct(s), heap size 1024, undo log entries 2 MySQL thread id 69597, query id 50349007 128.223.1.16 ovpn ---TRANSACTION 2 1248720308, ACTIVE 486 sec, process no 26628, OS thread id 2083756960 4 lock struct(s), heap size 320, undo log entries 2 MySQL thread id 68671, query id 50340184 128.223.1.101 ovpn ---TRANSACTION 2 1248719471, ACTIVE 492 sec, process no 26628, OS thread id 2070641568 5 lock struct(s), heap size 320, undo log entries 2 MySQL thread id 69586, query id 50336483 128.223.1.16 ovpn ---TRANSACTION 2 1248712031, ACTIVE 596 sec, process no 26628, OS thread id 2062547872 6 lock struct(s), heap size 1024, undo log entries 2 MySQL thread id 68672, query id 50315309 128.223.1.101 ovpn ---TRANSACTION 2 1248708181, ACTIVE 656 sec, process no 26628, OS thread id 2078051232 6 lock struct(s), heap size 1024, undo log entries 2 MySQL thread id 69377, query id 50300894 128.223.1.16 ovpn ---TRANSACTION 2 1248705622, ACTIVE 677 sec, process no 26628, OS thread id 2083318688 4 lock struct(s), heap size 320, undo log entries 2 MySQL thread id 69316, query id 50289954 128.223.1.16 ovpn ---TRANSACTION 2 1248686848, ACTIVE 921 sec, process no 26628, OS thread id 2063997856 16 lock struct(s), heap size 2496, undo log entries 3 MySQL thread id 68655, query id 50231949 128.223.1.101 ovpn ---TRANSACTION 2 1248672347, ACTIVE 1136 sec, process no 26628, OS thread id 2077649824 6 lock struct(s), heap size 1024, undo log entries 2 MySQL thread id 69331, query id 50185937 128.223.1.16 ovpn ---TRANSACTION 2 1248671409, ACTIVE 1152 sec, process no 26628, OS thread id 2088954784 4 lock struct(s), heap size 320, undo log entries 2 MySQL thread id 69125, query id 50184018 128.223.1.101 ovpn ---TRANSACTION 2 1248658930, ACTIVE 1359 sec, process no 26628, OS thread id 2084563872 6 lock struct(s), heap size 1024, undo log entries 2 MySQL thread id 69051, query id 50159782 128.223.1.16 ovpn ---TRANSACTION 2 1248655329, ACTIVE 1397 sec, process no 26628, OS thread id 2060540832 4 lock struct(s), heap size 320, undo log entries 2 MySQL thread id 67480, query id 50147894 128.223.1.16 ovpn ---TRANSACTION 2 1248651556, ACTIVE 1464 sec, process no 26628, OS thread id 2083519392 6 lock struct(s), heap size 1024, undo log entries 2 MySQL thread id 69204, query id 50146324 128.223.1.16 ovpn ---TRANSACTION 2 1248642993, ACTIVE 1614 sec, process no 26628, OS thread id 2066680736 2 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 69333, query id 50129153 128.223.1.16 ovpn -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (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 528005 OS file reads, 10809219 OS file writes, 10563417 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 5241, seg size 5243, 16482 inserts, 16482 merged recs, 15740 merges Hash table size 1593833, used cells 111395, node heap has 114 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 706 996083000 Log flushed up to 706 996083000 Last checkpoint at 706 995557168 0 pending log writes, 0 pending chkp writes 10516083 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 459560118; in additional pool allocated 2708096 Buffer pool size 24576 Free buffers 0 Database pages 24462 Modified db pages 15 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 1224364, created 127080, written 684595 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 1 read views open inside InnoDB Main thread process no. 26628, id 2518223776, state: sleeping Number of rows inserted 4331025, updated 1925614, deleted 2138498, read 1644803271 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (0.01 sec)