mysql> show innodb status;
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Status                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 
=====================================
090925  9:03:56 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 5 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 839, signal count 824
Mutex spin waits 0, rounds 20377, OS waits 414
RW-shared spins 828, OS waits 410; RW-excl spins 10, OS waits 9
------------
TRANSACTIONS
------------
Trx id counter 0 28150229
Purge done for trx's n:o < 0 28141830 undo n:o < 0 0
History list length 7
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 10262, OS thread id 1076648256
MySQL thread id 30, query id 359861 localhost root
show innodb status
---TRANSACTION 0 28150055, not started, process no 10262, OS thread id 1181616448
MySQL thread id 21, query id 357896 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28150228, not started, process no 10262, OS thread id 1183746368
MySQL thread id 29, query id 359860 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28150224, not started, process no 10262, OS thread id 1183213888
MySQL thread id 27, query id 359817 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28150216, not started, process no 10262, OS thread id 1182415168
MySQL thread id 24, query id 359730 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28150130, not started, process no 10262, OS thread id 1181882688
MySQL thread id 22, query id 358781 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28150227, not started, process no 10262, OS thread id 1182947648
MySQL thread id 26, query id 359857 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28150128, not started, process no 10262, OS thread id 1183480128
MySQL thread id 28, query id 358750 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28143244, not started, process no 10262, OS thread id 1182681408
MySQL thread id 25, query id 279577 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28150214, not started, process no 10262, OS thread id 1182148928
MySQL thread id 23, query id 359720 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28150127, not started, process no 10262, OS thread id 1181083968
MySQL thread id 19, query id 358742 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28141810, not started, process no 10262, OS thread id 1093626176
MySQL thread id 5, query id 263200 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
--------
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
200 OS file reads, 3019 OS file writes, 1976 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 2.60 writes/s, 2.40 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 35401603, used cells 50277, node heap has 75 buffer(s)
137.97 hash searches/s, 602.88 non-hash searches/s
---
LOG
---
Log sequence number 7 1963769982
Log flushed up to   7 1963769238
Last checkpoint at  7 1912188380
0 pending log writes, 0 pending chkp writes
997 log i/o's done, 2.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1886453869; in additional pool allocated 11446784
Buffer pool size   1048576
Free buffers       998308
Database pages     50193
Modified db pages  2465
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 204, created 50099, written 47709
0.00 reads/s, 0.20 creates/s, 25.59 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. 10262, id 1177622848, state: sleeping
Number of rows inserted 8797382, updated 1, deleted 0, read 50754
32.19 inserts/s, 0.00 updates/s, 0.00 deletes/s, 382.72 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
 | 
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.11 sec)

mysql> system ps -ef | grep mysql
mysql> show innodb status;
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Status                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 
=====================================
090925  9:05:15 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 18 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1076, signal count 959
Mutex spin waits 0, rounds 29740, OS waits 560
RW-shared spins 1041, OS waits 486; RW-excl spins 49, OS waits 16
------------
TRANSACTIONS
------------
Trx id counter 0 28167011
Purge done for trx's n:o < 0 28141830 undo n:o < 0 0
History list length 7
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 28166972, not started, process no 10262, OS thread id 1179220288
MySQL thread id 12, query id 552360 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166970, not started, process no 10262, OS thread id 1178954048
MySQL thread id 11, query id 552342 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166047, not started, process no 10262, OS thread id 1180019008
MySQL thread id 15, query id 541823 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166995, not started, process no 10262, OS thread id 1179752768
MySQL thread id 14, query id 552595 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166949, not started, process no 10262, OS thread id 1179486528
MySQL thread id 13, query id 552057 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166973, not started, process no 10262, OS thread id 1180551488
MySQL thread id 17, query id 552370 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166756, not started, process no 10262, OS thread id 1180285248
MySQL thread id 16, query id 549900 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166045, not started, process no 10262, OS thread id 1180817728
MySQL thread id 18, query id 541819 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166994, not started, process no 10262, OS thread id 1181350208
MySQL thread id 20, query id 552589 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 0, not started, process no 10262, OS thread id 1076648256
MySQL thread id 30, query id 552738 localhost root
show innodb status
---TRANSACTION 0 28166975, not started, process no 10262, OS thread id 1181616448
MySQL thread id 21, query id 552357 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166173, not started, process no 10262, OS thread id 1183746368
MySQL thread id 29, query id 543185 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166971, not started, process no 10262, OS thread id 1183213888
MySQL thread id 27, query id 552344 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28167000, not started, process no 10262, OS thread id 1182415168
MySQL thread id 24, query id 552640 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28167008, not started, process no 10262, OS thread id 1181882688
MySQL thread id 22, query id 552732 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166769, not started, process no 10262, OS thread id 1182947648
MySQL thread id 26, query id 549961 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166760, not started, process no 10262, OS thread id 1183480128
MySQL thread id 28, query id 549982 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28167009, not started, process no 10262, OS thread id 1182681408
MySQL thread id 25, query id 552736 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28167010, not started, process no 10262, OS thread id 1182148928
MySQL thread id 23, query id 552737 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166974, not started, process no 10262, OS thread id 1181083968
MySQL thread id 19, query id 552345 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28166940, not started, process no 10262, OS thread id 1093626176
MySQL thread id 5, query id 552053 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
--------
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
200 OS file reads, 3169 OS file writes, 2118 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 1.39 writes/s, 1.33 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 35401603, used cells 346364, node heap has 515 buffer(s)
578.75 hash searches/s, 1969.17 non-hash searches/s
---
LOG
---
Log sequence number 7 1965447455
Log flushed up to   7 1965447455
Last checkpoint at  7 1931124304
0 pending log writes, 0 pending chkp writes
1118 log i/o's done, 1.33 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1886455237; in additional pool allocated 11737856
Buffer pool size   1048576
Free buffers       997796
Database pages     50265
Modified db pages  1579
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 204, created 50171, written 48667
0.00 reads/s, 1.44 creates/s, 7.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. 10262, id 1177622848, state: sleeping
Number of rows inserted 8805816, updated 1, deleted 0, read 151536
109.55 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1320.04 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
 | 
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.11 sec)

mysql> show status;
+-----------------------------------+------------+
| Variable_name                     | Value      |
+-----------------------------------+------------+
| Aborted_clients                   | 0          | 
| Aborted_connects                  | 0          | 
| Binlog_cache_disk_use             | 0          | 
| Binlog_cache_use                  | 0          | 
| Bytes_received                    | 141        | 
| Bytes_sent                        | 10555      | 
| Com_admin_commands                | 0          | 
| Com_alter_db                      | 0          | 
| Com_alter_table                   | 0          | 
| Com_analyze                       | 0          | 
| Com_backup_table                  | 0          | 
| Com_begin                         | 0          | 
| Com_call_procedure                | 0          | 
| Com_change_db                     | 0          | 
| Com_change_master                 | 0          | 
| Com_check                         | 0          | 
| Com_checksum                      | 0          | 
| Com_commit                        | 0          | 
| Com_create_db                     | 0          | 
| Com_create_function               | 0          | 
| Com_create_index                  | 0          | 
| Com_create_table                  | 0          | 
| Com_create_user                   | 0          | 
| Com_dealloc_sql                   | 0          | 
| Com_delete                        | 0          | 
| 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                         | 0          | 
| Com_grant                         | 0          | 
| Com_ha_close                      | 0          | 
| Com_ha_open                       | 0          | 
| Com_ha_read                       | 0          | 
| Com_help                          | 0          | 
| Com_insert                        | 0          | 
| 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                      | 0          | 
| 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                | 0          | 
| Com_reset                         | 0          | 
| Com_restore_table                 | 0          | 
| Com_revoke                        | 0          | 
| Com_revoke_all                    | 0          | 
| Com_rollback                      | 0          | 
| Com_savepoint                     | 0          | 
| Com_select                        | 1          | 
| Com_set_option                    | 0          | 
| Com_show_binlog_events            | 0          | 
| Com_show_binlogs                  | 0          | 
| Com_show_charsets                 | 0          | 
| Com_show_collations               | 0          | 
| Com_show_column_types             | 0          | 
| Com_show_create_db                | 0          | 
| Com_show_create_table             | 0          | 
| Com_show_databases                | 0          | 
| Com_show_errors                   | 0          | 
| Com_show_fields                   | 0          | 
| Com_show_grants                   | 0          | 
| Com_show_innodb_status            | 2          | 
| Com_show_keys                     | 0          | 
| 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              | 0          | 
| Com_show_slave_hosts              | 0          | 
| Com_show_slave_status             | 0          | 
| Com_show_status                   | 1          | 
| Com_show_storage_engines          | 0          | 
| Com_show_tables                   | 0          | 
| Com_show_triggers                 | 0          | 
| Com_show_variables                | 0          | 
| 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                 | 0          | 
| Com_update                        | 0          | 
| 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                       | 31         | 
| Created_tmp_disk_tables           | 0          | 
| Created_tmp_files                 | 5          | 
| Created_tmp_tables                | 1          | 
| Delayed_errors                    | 0          | 
| Delayed_insert_threads            | 0          | 
| Delayed_writes                    | 0          | 
| Flush_commands                    | 1          | 
| Handler_commit                    | 0          | 
| Handler_delete                    | 0          | 
| Handler_discover                  | 0          | 
| Handler_prepare                   | 0          | 
| Handler_read_first                | 0          | 
| Handler_read_key                  | 0          | 
| Handler_read_next                 | 0          | 
| Handler_read_prev                 | 0          | 
| Handler_read_rnd                  | 0          | 
| Handler_read_rnd_next             | 0          | 
| Handler_rollback                  | 0          | 
| Handler_savepoint                 | 0          | 
| Handler_savepoint_rollback        | 0          | 
| Handler_update                    | 0          | 
| Handler_write                     | 132        | 
| Innodb_buffer_pool_pages_data     | 50291      | 
| Innodb_buffer_pool_pages_dirty    | 1070       | 
| Innodb_buffer_pool_pages_flushed  | 49202      | 
| Innodb_buffer_pool_pages_free     | 997504     | 
| Innodb_buffer_pool_pages_misc     | 781        | 
| Innodb_buffer_pool_pages_total    | 1048576    | 
| Innodb_buffer_pool_read_ahead_rnd | 1          | 
| Innodb_buffer_pool_read_ahead_seq | 0          | 
| Innodb_buffer_pool_read_requests  | 78564155   | 
| Innodb_buffer_pool_reads          | 164        | 
| Innodb_buffer_pool_wait_free      | 0          | 
| Innodb_buffer_pool_write_requests | 32912232   | 
| Innodb_data_fsyncs                | 2180       | 
| Innodb_data_pending_fsyncs        | 0          | 
| Innodb_data_pending_reads         | 0          | 
| Innodb_data_pending_writes        | 0          | 
| Innodb_data_read                  | 5525504    | 
| Innodb_data_reads                 | 200        | 
| Innodb_data_writes                | 3238       | 
| Innodb_data_written               | 1887059968 | 
| Innodb_dblwr_pages_written        | 0          | 
| Innodb_dblwr_writes               | 0          | 
| Innodb_log_waits                  | 0          | 
| Innodb_log_write_requests         | 2115749    | 
| Innodb_log_writes                 | 786        | 
| Innodb_os_log_fsyncs              | 1063       | 
| Innodb_os_log_pending_fsyncs      | 0          | 
| Innodb_os_log_pending_writes      | 0          | 
| Innodb_os_log_written             | 1080741888 | 
| Innodb_page_size                  | 16384      | 
| Innodb_pages_created              | 50197      | 
| Innodb_pages_read                 | 204        | 
| Innodb_pages_written              | 49202      | 
| 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               | 0          | 
| Innodb_rows_inserted              | 8809902    | 
| Innodb_rows_read                  | 200892     | 
| Innodb_rows_updated               | 1          | 
| Key_blocks_not_flushed            | 0          | 
| Key_blocks_unused                 | 6694       | 
| Key_blocks_used                   | 0          | 
| Key_read_requests                 | 0          | 
| Key_reads                         | 0          | 
| Key_write_requests                | 0          | 
| Key_writes                        | 0          | 
| Last_query_cost                   | 0.000000   | 
| Max_used_connections              | 26         | 
| Ndb_cluster_node_id               | 0          | 
| Ndb_config_from_host              |            | 
| Ndb_config_from_port              | 0          | 
| Ndb_number_of_data_nodes          | 0          | 
| Not_flushed_delayed_rows          | 0          | 
| Open_files                        | 15         | 
| Open_streams                      | 0          | 
| Open_tables                       | 64         | 
| Opened_tables                     | 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                           | 647105     | 
| Questions                         | 4          | 
| Rpl_status                        | NULL       | 
| Select_full_join                  | 0          | 
| Select_full_range_join            | 0          | 
| Select_range                      | 0          | 
| Select_range_check                | 0          | 
| Select_scan                       | 1          | 
| Slave_open_temp_tables            | 0          | 
| Slave_retried_transactions        | 0          | 
| Slave_running                     | OFF        | 
| Slow_launch_threads               | 0          | 
| Slow_queries                      | 0          | 
| Sort_merge_passes                 | 0          | 
| Sort_range                        | 0          | 
| Sort_rows                         | 0          | 
| Sort_scan                         | 0          | 
| 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             | 680142     | 
| 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                 | 26         | 
| Threads_created                   | 26         | 
| Threads_running                   | 1          | 
| Uptime                            | 1223       | 
+-----------------------------------+------------+
252 rows in set (0.00 sec)

mysql> show status;
+-----------------------------------+------------+
| Variable_name                     | Value      |
+-----------------------------------+------------+
| Aborted_clients                   | 0          | 
| Aborted_connects                  | 0          | 
| Binlog_cache_disk_use             | 0          | 
| Binlog_cache_use                  | 0          | 
| Bytes_received                    | 157        | 
| Bytes_sent                        | 16912      | 
| Com_admin_commands                | 0          | 
| Com_alter_db                      | 0          | 
| Com_alter_table                   | 0          | 
| Com_analyze                       | 0          | 
| Com_backup_table                  | 0          | 
| Com_begin                         | 0          | 
| Com_call_procedure                | 0          | 
| Com_change_db                     | 0          | 
| Com_change_master                 | 0          | 
| Com_check                         | 0          | 
| Com_checksum                      | 0          | 
| Com_commit                        | 0          | 
| Com_create_db                     | 0          | 
| Com_create_function               | 0          | 
| Com_create_index                  | 0          | 
| Com_create_table                  | 0          | 
| Com_create_user                   | 0          | 
| Com_dealloc_sql                   | 0          | 
| Com_delete                        | 0          | 
| 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                         | 0          | 
| Com_grant                         | 0          | 
| Com_ha_close                      | 0          | 
| Com_ha_open                       | 0          | 
| Com_ha_read                       | 0          | 
| Com_help                          | 0          | 
| Com_insert                        | 0          | 
| 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                      | 0          | 
| 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                | 0          | 
| Com_reset                         | 0          | 
| Com_restore_table                 | 0          | 
| Com_revoke                        | 0          | 
| Com_revoke_all                    | 0          | 
| Com_rollback                      | 0          | 
| Com_savepoint                     | 0          | 
| Com_select                        | 1          | 
| Com_set_option                    | 0          | 
| Com_show_binlog_events            | 0          | 
| Com_show_binlogs                  | 0          | 
| Com_show_charsets                 | 0          | 
| Com_show_collations               | 0          | 
| Com_show_column_types             | 0          | 
| Com_show_create_db                | 0          | 
| Com_show_create_table             | 0          | 
| Com_show_databases                | 0          | 
| Com_show_errors                   | 0          | 
| Com_show_fields                   | 0          | 
| Com_show_grants                   | 0          | 
| Com_show_innodb_status            | 2          | 
| Com_show_keys                     | 0          | 
| 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              | 0          | 
| Com_show_slave_hosts              | 0          | 
| Com_show_slave_status             | 0          | 
| Com_show_status                   | 2          | 
| Com_show_storage_engines          | 0          | 
| Com_show_tables                   | 0          | 
| Com_show_triggers                 | 0          | 
| Com_show_variables                | 0          | 
| 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                 | 0          | 
| Com_update                        | 0          | 
| 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                       | 31         | 
| Created_tmp_disk_tables           | 0          | 
| Created_tmp_files                 | 5          | 
| Created_tmp_tables                | 2          | 
| Delayed_errors                    | 0          | 
| Delayed_insert_threads            | 0          | 
| Delayed_writes                    | 0          | 
| Flush_commands                    | 1          | 
| Handler_commit                    | 0          | 
| Handler_delete                    | 0          | 
| Handler_discover                  | 0          | 
| Handler_prepare                   | 0          | 
| Handler_read_first                | 0          | 
| Handler_read_key                  | 0          | 
| Handler_read_next                 | 0          | 
| Handler_read_prev                 | 0          | 
| Handler_read_rnd                  | 0          | 
| Handler_read_rnd_next             | 253        | 
| Handler_rollback                  | 0          | 
| Handler_savepoint                 | 0          | 
| Handler_savepoint_rollback        | 0          | 
| Handler_update                    | 0          | 
| Handler_write                     | 384        | 
| Innodb_buffer_pool_pages_data     | 50294      | 
| Innodb_buffer_pool_pages_dirty    | 1077       | 
| Innodb_buffer_pool_pages_flushed  | 49202      | 
| Innodb_buffer_pool_pages_free     | 997462     | 
| Innodb_buffer_pool_pages_misc     | 820        | 
| Innodb_buffer_pool_pages_total    | 1048576    | 
| Innodb_buffer_pool_read_ahead_rnd | 1          | 
| Innodb_buffer_pool_read_ahead_seq | 0          | 
| Innodb_buffer_pool_read_requests  | 78589867   | 
| Innodb_buffer_pool_reads          | 164        | 
| Innodb_buffer_pool_wait_free      | 0          | 
| Innodb_buffer_pool_write_requests | 32914941   | 
| Innodb_data_fsyncs                | 2187       | 
| Innodb_data_pending_fsyncs        | 0          | 
| Innodb_data_pending_reads         | 0          | 
| Innodb_data_pending_writes        | 0          | 
| Innodb_data_read                  | 5525504    | 
| Innodb_data_reads                 | 200        | 
| Innodb_data_writes                | 3245       | 
| Innodb_data_written               | 1887152128 | 
| Innodb_dblwr_pages_written        | 0          | 
| Innodb_dblwr_writes               | 0          | 
| Innodb_log_waits                  | 0          | 
| Innodb_log_write_requests         | 2115947    | 
| Innodb_log_writes                 | 793        | 
| Innodb_os_log_fsyncs              | 1070       | 
| Innodb_os_log_pending_fsyncs      | 0          | 
| Innodb_os_log_pending_writes      | 0          | 
| Innodb_os_log_written             | 1080834048 | 
| Innodb_page_size                  | 16384      | 
| Innodb_pages_created              | 50200      | 
| Innodb_pages_read                 | 204        | 
| Innodb_pages_written              | 49202      | 
| 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               | 0          | 
| Innodb_rows_inserted              | 8810437    | 
| Innodb_rows_read                  | 207102     | 
| Innodb_rows_updated               | 1          | 
| Key_blocks_not_flushed            | 0          | 
| Key_blocks_unused                 | 6694       | 
| Key_blocks_used                   | 0          | 
| Key_read_requests                 | 0          | 
| Key_reads                         | 0          | 
| Key_write_requests                | 0          | 
| Key_writes                        | 0          | 
| Last_query_cost                   | 0.000000   | 
| Max_used_connections              | 26         | 
| Ndb_cluster_node_id               | 0          | 
| Ndb_config_from_host              |            | 
| Ndb_config_from_port              | 0          | 
| Ndb_number_of_data_nodes          | 0          | 
| Not_flushed_delayed_rows          | 0          | 
| Open_files                        | 15         | 
| Open_streams                      | 0          | 
| Open_tables                       | 64         | 
| Opened_tables                     | 0          | 
| Prepared_stmt_count               | 2          | 
| 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                           | 658990     | 
| Questions                         | 5          | 
| Rpl_status                        | NULL       | 
| Select_full_join                  | 0          | 
| Select_full_range_join            | 0          | 
| Select_range                      | 0          | 
| Select_range_check                | 0          | 
| Select_scan                       | 2          | 
| Slave_open_temp_tables            | 0          | 
| Slave_retried_transactions        | 0          | 
| Slave_running                     | OFF        | 
| Slow_launch_threads               | 0          | 
| Slow_queries                      | 0          | 
| Sort_merge_passes                 | 0          | 
| Sort_range                        | 0          | 
| Sort_rows                         | 0          | 
| Sort_scan                         | 0          | 
| 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             | 693071     | 
| 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                 | 26         | 
| Threads_created                   | 26         | 
| Threads_running                   | 1          | 
| Uptime                            | 1228       | 
+-----------------------------------+------------+
252 rows in set (0.00 sec)

mysql> show engine
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine     | Support  | Comment                                                        |
+------------+----------+----------------------------------------------------------------+
| MyISAM     | DEFAULT  | Default engine as of MySQL 3.23 with great performance         | 
| MEMORY     | YES      | Hash based, stored in memory, useful for temporary tables      | 
| InnoDB     | YES      | Supports transactions, row-level locking, and foreign keys     | 
| BerkeleyDB | YES      | Supports transactions and page-level locking                   | 
| BLACKHOLE  | NO       | /dev/null storage engine (anything you write to it disappears) | 
| EXAMPLE    | NO       | Example storage engine                                         | 
| ARCHIVE    | NO       | Archive storage engine                                         | 
| CSV        | NO       | CSV storage engine                                             | 
| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables                 | 
| FEDERATED  | NO       | Federated MySQL storage engine                                 | 
| MRG_MYISAM | YES      | Collection of identical MyISAM tables                          | 
| ISAM       | NO       | Obsolete storage engine                                        | 
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec)

mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine     | Support  | Comment                                                        |
+------------+----------+----------------------------------------------------------------+
| MyISAM     | DEFAULT  | Default engine as of MySQL 3.23 with great performance         | 
| MEMORY     | YES      | Hash based, stored in memory, useful for temporary tables      | 
| InnoDB     | YES      | Supports transactions, row-level locking, and foreign keys     | 
| BerkeleyDB | YES      | Supports transactions and page-level locking                   | 
| BLACKHOLE  | NO       | /dev/null storage engine (anything you write to it disappears) | 
| EXAMPLE    | NO       | Example storage engine                                         | 
| ARCHIVE    | NO       | Archive storage engine                                         | 
| CSV        | NO       | CSV storage engine                                             | 
| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables                 | 
| FEDERATED  | NO       | Federated MySQL storage engine                                 | 
| MRG_MYISAM | YES      | Collection of identical MyISAM tables                          | 
| ISAM       | NO       | Obsolete storage engine                                        | 
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec)

mysql> show innodb status;
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Status                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 
=====================================
090925  9:12:14 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 53 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 3273, signal count 2226
Mutex spin waits 0, rounds 152068, OS waits 1940
RW-shared spins 2419, OS waits 1003; RW-excl spins 495, OS waits 166
------------
TRANSACTIONS
------------
Trx id counter 0 28368021
Purge done for trx's n:o < 0 28141830 undo n:o < 0 0
History list length 7
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 28367857, not started, process no 10262, OS thread id 1189603648
MySQL thread id 55, query id 2862347 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367855, not started, process no 10262, OS thread id 1189337408
MySQL thread id 54, query id 2862405 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367821, not started, process no 10262, OS thread id 1188006208
MySQL thread id 49, query id 2862425 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367819, not started, process no 10262, OS thread id 1185077568
MySQL thread id 38, query id 2862179 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366479, not started, process no 10262, OS thread id 1185343808
MySQL thread id 39, query id 2846595 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367838, not started, process no 10262, OS thread id 1188272448
MySQL thread id 50, query id 2862266 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366431, not started, process no 10262, OS thread id 1187473728
MySQL thread id 47, query id 2846201 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366429, not started, process no 10262, OS thread id 1186941248
MySQL thread id 45, query id 2845978 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367851, not started, process no 10262, OS thread id 1189071168
MySQL thread id 53, query id 2862410 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367815, not started, process no 10262, OS thread id 1188538688
MySQL thread id 51, query id 2862034 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367831, not started, process no 10262, OS thread id 1188804928
MySQL thread id 52, query id 2862268 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367860, not started, process no 10262, OS thread id 1186142528
MySQL thread id 42, query id 2862398 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366460, not started, process no 10262, OS thread id 1187207488
MySQL thread id 46, query id 2846459 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367836, not started, process no 10262, OS thread id 1186675008
MySQL thread id 44, query id 2862267 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367958, not started, process no 10262, OS thread id 1185876288
MySQL thread id 41, query id 2863517 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366419, not started, process no 10262, OS thread id 1186408768
MySQL thread id 43, query id 2846618 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366483, not started, process no 10262, OS thread id 1185610048
MySQL thread id 40, query id 2846586 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367824, not started, process no 10262, OS thread id 1184811328
MySQL thread id 37, query id 2862196 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367778, not started, process no 10262, OS thread id 1184545088
MySQL thread id 36, query id 2862201 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367848, not started, process no 10262, OS thread id 1184278848
MySQL thread id 35, query id 2862438 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367850, not started, process no 10262, OS thread id 1076914496
MySQL thread id 33, query id 2862226 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366420, not started, process no 10262, OS thread id 1092061504
MySQL thread id 34, query id 2846472 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366488, not started, process no 10262, OS thread id 1184012608
MySQL thread id 32, query id 2846678 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367814, not started, process no 10262, OS thread id 1079667008
MySQL thread id 31, query id 2862389 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367846, not started, process no 10262, OS thread id 1087650112
MySQL thread id 6, query id 2862409 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367837, not started, process no 10262, OS thread id 1177889088
MySQL thread id 7, query id 2862400 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28368016, not started, process no 10262, OS thread id 1178155328
MySQL thread id 8, query id 2864161 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366444, not started, process no 10262, OS thread id 1178421568
MySQL thread id 9, query id 2846624 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28368019, not started, process no 10262, OS thread id 1178687808
MySQL thread id 10, query id 2864167 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367961, not started, process no 10262, OS thread id 1179220288
MySQL thread id 12, query id 2863551 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367779, not started, process no 10262, OS thread id 1178954048
MySQL thread id 11, query id 2862233 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367825, not started, process no 10262, OS thread id 1180019008
MySQL thread id 15, query id 2862404 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28368015, not started, process no 10262, OS thread id 1179752768
MySQL thread id 14, query id 2864156 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367861, not started, process no 10262, OS thread id 1179486528
MySQL thread id 13, query id 2862430 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366497, not started, process no 10262, OS thread id 1180551488
MySQL thread id 17, query id 2846614 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367859, not started, process no 10262, OS thread id 1180285248
MySQL thread id 16, query id 2862365 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366452, not started, process no 10262, OS thread id 1180817728
MySQL thread id 18, query id 2846585 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367844, not started, process no 10262, OS thread id 1181350208
MySQL thread id 20, query id 2862369 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 0, not started, process no 10262, OS thread id 1076648256
MySQL thread id 30, query id 2864175 localhost root
show innodb status
---TRANSACTION 0 28366473, not started, process no 10262, OS thread id 1181616448
MySQL thread id 21, query id 2846426 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367841, not started, process no 10262, OS thread id 1183746368
MySQL thread id 29, query id 2862446 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367811, not started, process no 10262, OS thread id 1183213888
MySQL thread id 27, query id 2862282 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28368017, not started, process no 10262, OS thread id 1182415168
MySQL thread id 24, query id 2864164 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367833, not started, process no 10262, OS thread id 1181882688
MySQL thread id 22, query id 2862348 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367853, not started, process no 10262, OS thread id 1182947648
MySQL thread id 26, query id 2862353 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28366499, not started, process no 10262, OS thread id 1183480128
MySQL thread id 28, query id 2846671 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367843, not started, process no 10262, OS thread id 1182681408
MySQL thread id 25, query id 2862414 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367862, not started, process no 10262, OS thread id 1182148928
MySQL thread id 23, query id 2862428 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367904, not started, process no 10262, OS thread id 1181083968
MySQL thread id 19, query id 2862951 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28367822, not started, process no 10262, OS thread id 1093626176
MySQL thread id 5, query id 2862129 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
---TRANSACTION 0 28368020, ACTIVE 0 sec, process no 10262, OS thread id 1187739968
MySQL thread id 48, query id 2864174 perf12.lab.bos.redhat.com 192.168.1.12 ejb3
--------
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
200 OS file reads, 4278 OS file writes, 2917 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 2.89 writes/s, 2.26 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 35401603, used cells 1948522, node heap has 2957 buffer(s)
3758.02 hash searches/s, 4329.20 non-hash searches/s
---
LOG
---
Log sequence number 7 1985380255
Log flushed up to   7 1985344379
Last checkpoint at  7 1983716162
0 pending log writes, 0 pending chkp writes
1824 log i/o's done, 2.06 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1886459797; in additional pool allocated 12493312
Buffer pool size   1048576
Free buffers       994542
Database pages     51077
Modified db pages  299
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 204, created 50983, written 53735
0.00 reads/s, 3.06 creates/s, 11.23 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. 10262, id 1177622848, state: sleeping
Number of rows inserted 8906466, updated 1, deleted 0, read 1364493
341.14 inserts/s, 0.00 updates/s, 0.00 deletes/s, 4139.60 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
 | 
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.10 sec)

mysql> 
mysql> show status;
+-----------------------------------+------------+
| Variable_name                     | Value      |
+-----------------------------------+------------+
| Aborted_clients                   | 0          | 
| Aborted_connects                  | 0          | 
| Binlog_cache_disk_use             | 0          | 
| Binlog_cache_use                  | 0          | 
| Bytes_received                    | 246        | 
| Bytes_sent                        | 35887      | 
| Com_admin_commands                | 0          | 
| Com_alter_db                      | 0          | 
| Com_alter_table                   | 0          | 
| Com_analyze                       | 0          | 
| Com_backup_table                  | 0          | 
| Com_begin                         | 0          | 
| Com_call_procedure                | 0          | 
| Com_change_db                     | 0          | 
| Com_change_master                 | 0          | 
| Com_check                         | 0          | 
| Com_checksum                      | 0          | 
| Com_commit                        | 0          | 
| Com_create_db                     | 0          | 
| Com_create_function               | 0          | 
| Com_create_index                  | 0          | 
| Com_create_table                  | 0          | 
| Com_create_user                   | 0          | 
| Com_dealloc_sql                   | 0          | 
| Com_delete                        | 0          | 
| 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                         | 0          | 
| Com_grant                         | 0          | 
| Com_ha_close                      | 0          | 
| Com_ha_open                       | 0          | 
| Com_ha_read                       | 0          | 
| Com_help                          | 0          | 
| Com_insert                        | 0          | 
| 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                      | 0          | 
| 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                | 0          | 
| Com_reset                         | 0          | 
| Com_restore_table                 | 0          | 
| Com_revoke                        | 0          | 
| Com_revoke_all                    | 0          | 
| Com_rollback                      | 0          | 
| Com_savepoint                     | 0          | 
| Com_select                        | 1          | 
| Com_set_option                    | 0          | 
| Com_show_binlog_events            | 0          | 
| Com_show_binlogs                  | 0          | 
| Com_show_charsets                 | 0          | 
| Com_show_collations               | 0          | 
| Com_show_column_types             | 0          | 
| Com_show_create_db                | 0          | 
| Com_show_create_table             | 0          | 
| Com_show_databases                | 0          | 
| Com_show_errors                   | 0          | 
| Com_show_fields                   | 0          | 
| Com_show_grants                   | 0          | 
| Com_show_innodb_status            | 3          | 
| Com_show_keys                     | 0          | 
| 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              | 0          | 
| Com_show_slave_hosts              | 0          | 
| Com_show_slave_status             | 0          | 
| Com_show_status                   | 3          | 
| Com_show_storage_engines          | 2          | 
| Com_show_tables                   | 0          | 
| Com_show_triggers                 | 0          | 
| Com_show_variables                | 0          | 
| 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                 | 0          | 
| Com_update                        | 0          | 
| 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                       | 56         | 
| Created_tmp_disk_tables           | 0          | 
| Created_tmp_files                 | 5          | 
| Created_tmp_tables                | 3          | 
| Delayed_errors                    | 0          | 
| Delayed_insert_threads            | 0          | 
| Delayed_writes                    | 0          | 
| Flush_commands                    | 1          | 
| Handler_commit                    | 0          | 
| Handler_delete                    | 0          | 
| Handler_discover                  | 0          | 
| Handler_prepare                   | 0          | 
| Handler_read_first                | 0          | 
| Handler_read_key                  | 0          | 
| Handler_read_next                 | 0          | 
| Handler_read_prev                 | 0          | 
| Handler_read_rnd                  | 0          | 
| Handler_read_rnd_next             | 506        | 
| Handler_rollback                  | 0          | 
| Handler_savepoint                 | 0          | 
| Handler_savepoint_rollback        | 0          | 
| Handler_update                    | 0          | 
| Handler_write                     | 636        | 
| Innodb_buffer_pool_pages_data     | 51246      | 
| Innodb_buffer_pool_pages_dirty    | 341        | 
| Innodb_buffer_pool_pages_flushed  | 54657      | 
| Innodb_buffer_pool_pages_free     | 994352     | 
| Innodb_buffer_pool_pages_misc     | 2978       | 
| Innodb_buffer_pool_pages_total    | 1048576    | 
| Innodb_buffer_pool_read_ahead_rnd | 1          | 
| Innodb_buffer_pool_read_ahead_seq | 0          | 
| Innodb_buffer_pool_read_requests  | 84251496   | 
| Innodb_buffer_pool_reads          | 164        | 
| Innodb_buffer_pool_wait_free      | 0          | 
| Innodb_buffer_pool_write_requests | 33545721   | 
| Innodb_data_fsyncs                | 3089       | 
| Innodb_data_pending_fsyncs        | 0          | 
| Innodb_data_pending_reads         | 0          | 
| Innodb_data_pending_writes        | 0          | 
| Innodb_data_read                  | 5525504    | 
| Innodb_data_reads                 | 200        | 
| Innodb_data_writes                | 4496       | 
| Innodb_data_written               | 2001267712 | 
| Innodb_dblwr_pages_written        | 0          | 
| Innodb_dblwr_writes               | 0          | 
| Innodb_log_waits                  | 0          | 
| Innodb_log_write_requests         | 2165426    | 
| Innodb_log_writes                 | 1562       | 
| Innodb_os_log_fsyncs              | 1879       | 
| Innodb_os_log_pending_fsyncs      | 0          | 
| Innodb_os_log_pending_writes      | 0          | 
| Innodb_os_log_written             | 1105554432 | 
| Innodb_page_size                  | 16384      | 
| Innodb_pages_created              | 51152      | 
| Innodb_pages_read                 | 204        | 
| Innodb_pages_written              | 54657      | 
| 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               | 0          | 
| Innodb_rows_inserted              | 8934138    | 
| Innodb_rows_read                  | 1699845    | 
| Innodb_rows_updated               | 1          | 
| Key_blocks_not_flushed            | 0          | 
| Key_blocks_unused                 | 6694       | 
| Key_blocks_used                   | 0          | 
| Key_read_requests                 | 0          | 
| Key_reads                         | 0          | 
| Key_write_requests                | 0          | 
| Key_writes                        | 0          | 
| Last_query_cost                   | 0.000000   | 
| Max_used_connections              | 51         | 
| Ndb_cluster_node_id               | 0          | 
| Ndb_config_from_host              |            | 
| Ndb_config_from_port              | 0          | 
| Ndb_number_of_data_nodes          | 0          | 
| Not_flushed_delayed_rows          | 0          | 
| Open_files                        | 15         | 
| Open_streams                      | 0          | 
| Open_tables                       | 106        | 
| Opened_tables                     | 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                           | 3500545    | 
| Questions                         | 10         | 
| Rpl_status                        | NULL       | 
| Select_full_join                  | 0          | 
| Select_full_range_join            | 0          | 
| Select_range                      | 0          | 
| Select_range_check                | 0          | 
| Select_scan                       | 3          | 
| Slave_open_temp_tables            | 0          | 
| Slave_retried_transactions        | 0          | 
| Slave_running                     | OFF        | 
| Slow_launch_threads               | 0          | 
| Slow_queries                      | 0          | 
| Sort_merge_passes                 | 0          | 
| Sort_range                        | 0          | 
| Sort_rows                         | 0          | 
| Sort_scan                         | 0          | 
| 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             | 3781054    | 
| 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                 | 51         | 
| Threads_created                   | 51         | 
| Threads_running                   | 1          | 
| Uptime                            | 1690       | 
+-----------------------------------+------------+
252 rows in set (0.00 sec)

mysql> quit