Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `patient_last_examined` (
- `patient_last_examined_id` int(12) NOT NULL AUTO_INCREMENT,
- `patient_id` int(12) NOT NULL,
- `operator_id` int(12) NOT NULL,
- `section_name` varchar(255) COLLATE latin1_general_ci NOT NULL,
- `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON
- UPDATE CURRENT_TIMESTAMP,
- `status` enum('0','1') COLLATE latin1_general_ci NOT NULL,
- `save_or_review` int(11) NOT NULL COMMENT '1 = save, 2 = Reviewed',
- `section_complete` int(1) NOT NULL COMMENT '1 = section associated with
- complete reviewed,0=section not associated with complete reviewed',
- `section_complete_id` int(11) NOT NULL COMMENT 'it store complete section pk
- id',
- `formid` int(11) NOT NULL DEFAULT '0',
- `src_server` int(10) DEFAULT NULL,
- `parent_id` int(10) DEFAULT NULL,
- `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`patient_last_examined_id`),
- KEY `section_name` (`section_name`),
- KEY `patient_id` (`patient_id`)
- ) ENGINE=MyISAM AUTO_INCREMENT=177622 DEFAULT CHARSET=latin1
- COLLATE=latin1_general_ci
- SHOW INDEX FROM patient_last_examined;
- Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
- patient_last_examined 0 PRIMARY 1 patient_last_examined_id A 177621 NULL NULL BTREE
- patient_last_examined 1 section_name 1 section_name A 59207 NULL NULL BTREE
- patient_last_examined 1 patient_id 1 patient_id A 25374 NULL NULL BTREE
- Aborted_clients 0
- Aborted_connects 1
- Binlog_cache_disk_use 0
- Binlog_cache_use 0
- Binlog_stmt_cache_disk_use 0
- Binlog_stmt_cache_use 0
- Bytes_received 23502509
- Bytes_sent 39704702
- Com_admin_commands 162
- Com_assign_to_keycache 0
- Com_alter_db 0
- Com_alter_db_upgrade 0
- Com_alter_event 0
- Com_alter_function 0
- Com_alter_instance 0
- Com_alter_procedure 0
- Com_alter_server 0
- Com_alter_table 0
- Com_alter_tablespace 0
- Com_alter_user 0
- Com_analyze 0
- Com_begin 0
- Com_binlog 0
- Com_call_procedure 0
- Com_change_db 110
- Com_change_master 0
- Com_change_repl_filter 0
- Com_check 0
- Com_checksum 0
- Com_commit 0
- Com_create_db 0
- Com_create_event 0
- Com_create_function 0
- Com_create_index 0
- Com_create_procedure 0
- Com_create_server 0
- Com_create_table 5
- Com_create_trigger 0
- Com_create_udf 0
- Com_create_user 0
- Com_create_view 0
- Com_dealloc_sql 0
- Com_delete 1
- Com_delete_multi 0
- Com_do 0
- Com_drop_db 0
- Com_drop_event 0
- Com_drop_function 0
- Com_drop_index 0
- Com_drop_procedure 0
- Com_drop_server 0
- Com_drop_table 1
- Com_drop_trigger 0
- Com_drop_user 0
- Com_drop_view 0
- Com_empty_query 0
- Com_execute_sql 0
- Com_explain_other 0
- Com_flush 0
- Com_get_diagnostics 0
- Com_grant 0
- Com_ha_close 0
- Com_ha_open 0
- Com_ha_read 0
- Com_help 0
- Com_insert 11649
- Com_insert_select 11
- Com_install_plugin 0
- Com_kill 0
- Com_load 0
- Com_lock_tables 0
- Com_optimize 0
- Com_preload_keys 0
- Com_prepare_sql 0
- Com_purge 0
- Com_purge_before_date 0
- Com_release_savepoint 0
- Com_rename_table 0
- Com_rename_user 0
- Com_repair 0
- Com_replace 0
- Com_replace_select 0
- Com_reset 0
- Com_resignal 0
- Com_revoke 0
- Com_revoke_all 0
- Com_rollback 0
- Com_rollback_to_savepoint 0
- Com_savepoint 0
- Com_select 33946
- Com_set_option 135
- Com_signal 0
- Com_show_binlog_events 0
- Com_show_binlogs 1
- Com_show_charsets 1
- Com_show_collations 1
- Com_show_create_db 0
- Com_show_create_event 0
- Com_show_create_func 1
- Com_show_create_proc 0
- Variable_name Value
- Com_show_create_table 4
- Com_show_create_trigger 0
- Com_show_databases 2
- Com_show_engine_logs 0
- Com_show_engine_mutex 0
- Com_show_engine_status 0
- Com_show_events 0
- Com_show_errors 0
- Com_show_fields 46
- Com_show_function_code 0
- Com_show_function_status 0
- Com_show_grants 1
- Com_show_keys 7
- Com_show_master_status 0
- Com_show_open_tables 0
- Com_show_plugins 0
- Com_show_privileges 0
- Com_show_procedure_code 0
- Com_show_procedure_status 0
- Com_show_processlist 0
- Com_show_profile 0
- Com_show_profiles 0
- Com_show_relaylog_events 0
- Com_show_slave_hosts 0
- Com_show_slave_status 0
- Com_show_status 12
- Com_show_storage_engines 0
- Com_show_table_status 35
- Com_show_tables 52
- Com_show_triggers 0
- Com_show_variables 20
- Com_show_warnings 0
- Com_show_create_user 0
- Com_shutdown 0
- Com_slave_start 0
- Com_slave_stop 0
- Com_group_replication_start 0
- Com_group_replication_stop 0
- Com_stmt_execute 0
- Com_stmt_close 0
- Com_stmt_fetch 0
- Com_stmt_prepare 0
- Com_stmt_reset 0
- Com_stmt_send_long_data 0
- Com_truncate 11
- Com_uninstall_plugin 0
- Com_unlock_tables 0
- Com_update 8082
- 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
- Com_stmt_reprepare 0
- Connection_errors_accept 0
- Connection_errors_internal 0
- Connection_errors_max_connections 0
- Connection_errors_peer_address 0
- Connection_errors_select 0
- Connection_errors_tcpwrap 0
- Connections 5132
- Created_tmp_disk_tables 60
- Created_tmp_files 6
- Created_tmp_tables 5164
- Delayed_errors 0
- Delayed_insert_threads 0
- Delayed_writes 0
- Flush_commands 1
- Handler_commit 124
- Handler_delete 2341
- Handler_discover 0
- Handler_external_lock 120510
- Handler_mrr_init 0
- Handler_prepare 0
- Handler_read_first 4970
- Handler_read_key 64672
- Handler_read_last 1696
- Handler_read_next 750631
- Handler_read_prev 74207
- Handler_read_rnd 10355
- Handler_read_rnd_next 498809547
- Handler_rollback 0
- Handler_savepoint 0
- Handler_savepoint_rollback 0
- Handler_update 8033
- Handler_write 49110
- Innodb_buffer_pool_dump_status Dumping of buffer pool not started
- Innodb_buffer_pool_load_status Buffer pool(s) load completed at 180413 23:00:54
- Innodb_buffer_pool_resize_status
- Innodb_buffer_pool_pages_data 24213
- Innodb_buffer_pool_bytes_data 396705792
- Innodb_buffer_pool_pages_dirty 0
- Innodb_buffer_pool_bytes_dirty 0
- Innodb_buffer_pool_pages_flushed 164
- Innodb_buffer_pool_pages_free 303244
- Innodb_buffer_pool_pages_misc 203
- Innodb_buffer_pool_pages_total 327660
- Innodb_buffer_pool_read_ahead_rnd 0
- Variable_name Value
- Innodb_buffer_pool_read_ahead 0
- Innodb_buffer_pool_read_ahead_evicted 0
- Innodb_buffer_pool_read_requests 529906
- Innodb_buffer_pool_reads 24176
- Innodb_buffer_pool_wait_free 0
- Innodb_buffer_pool_write_requests 52630
- Innodb_data_fsyncs 26
- Innodb_data_pending_fsyncs 0
- Innodb_data_pending_reads 0
- Innodb_data_pending_writes 0
- Innodb_data_read 396202496
- Innodb_data_reads 24262
- Innodb_data_writes 195
- Innodb_data_written 6221824
- Innodb_dblwr_pages_written 130
- Innodb_dblwr_writes 3
- Innodb_log_waits 0
- Innodb_log_write_requests 3769
- Innodb_log_writes 10
- Innodb_os_log_fsyncs 15
- Innodb_os_log_pending_fsyncs 0
- Innodb_os_log_pending_writes 0
- Innodb_os_log_written 1402368
- Innodb_page_size 16384
- Innodb_pages_created 36
- Innodb_pages_read 24177
- Innodb_pages_written 164
- 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 2341
- Innodb_rows_inserted 0
- Innodb_rows_read 322420
- Innodb_rows_updated 0
- Innodb_num_open_files 76
- Innodb_truncated_status_writes 0
- Innodb_available_undo_logs 128
- Key_blocks_not_flushed 0
- Key_blocks_unused 843530
- Key_blocks_used 13838
- Key_read_requests 1043706
- Key_reads 13435
- Key_write_requests 60933
- Key_writes 60772
- Locked_connects 0
- Max_execution_time_exceeded 0
- Max_execution_time_set 0
- Max_execution_time_set_failed 0
- Max_used_connections 12
- Max_used_connections_time 2018-04-14 00:44:24
- Not_flushed_delayed_rows 0
- Ongoing_anonymous_transaction_count 0
- Open_files 2106
- Open_streams 0
- Open_table_definitions 1905
- Open_tables 1870
- Opened_files 11861
- Opened_table_definitions 1927
- Opened_tables 2768
- Performance_schema_accounts_lost 0
- Performance_schema_cond_classes_lost 0
- Performance_schema_cond_instances_lost 0
- Performance_schema_digest_lost 0
- Performance_schema_file_classes_lost 0
- Performance_schema_file_handles_lost 0
- Performance_schema_file_instances_lost 0
- Performance_schema_hosts_lost 0
- Performance_schema_index_stat_lost 0
- Performance_schema_locker_lost 0
- Performance_schema_memory_classes_lost 0
- Performance_schema_metadata_lock_lost 0
- Performance_schema_mutex_classes_lost 0
- Performance_schema_mutex_instances_lost 0
- Performance_schema_nested_statement_lost 0
- Performance_schema_prepared_statements_lost 0
- Performance_schema_program_lost 0
- Performance_schema_rwlock_classes_lost 0
- Performance_schema_rwlock_instances_lost 0
- Performance_schema_session_connect_attrs_lost 0
- Performance_schema_socket_classes_lost 0
- Performance_schema_socket_instances_lost 0
- Performance_schema_stage_classes_lost 0
- Performance_schema_statement_classes_lost 0
- Performance_schema_table_handles_lost 0
- Performance_schema_table_instances_lost 0
- Performance_schema_table_lock_stat_lost 0
- Performance_schema_thread_classes_lost 0
- Performance_schema_thread_instances_lost 0
- Performance_schema_users_lost 0
- Prepared_stmt_count 0
- Qcache_free_blocks 885
- Qcache_free_memory 58958760
- Qcache_hits 72836
- Qcache_inserts 29034
- Qcache_lowmem_prunes 0
- Qcache_not_cached 4911
- Qcache_queries_in_cache 7269
- Qcache_total_blocks 15519
- Variable_name Value
- Queries 132251
- Questions 132087
- Select_full_join 0
- Select_full_range_join 0
- Select_range 7948
- Select_range_check 0
- Select_scan 5337
- Slave_open_temp_tables 0
- Slow_launch_threads 0
- Slow_queries 11
- Sort_merge_passes 0
- Sort_range 30
- Sort_rows 1406
- Sort_scan 15
- 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_server_not_after Dec 12 06:37:05 2027 GMT
- Ssl_server_not_before Dec 14 06:37:05 2017 GMT
- Ssl_session_cache_hits 0
- Ssl_session_cache_misses 0
- Ssl_session_cache_mode Unknown
- 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 53992
- Table_locks_waited 0
- Table_open_cache_hits 53758
- Table_open_cache_misses 2768
- Table_open_cache_overflows 870
- Tc_log_max_pages_used 0
- Tc_log_page_size 0
- Tc_log_page_waits 0
- Threads_cached 2
- Threads_connected 10
- Threads_created 12
- Threads_running 2
- Uptime 12798
- Uptime_since_flush_status 12798
Add Comment
Please, Sign In to add comment