O banco está disponível?

[JoséCarlos_Plima]

Tenho uma aplicação que, de repente, trava ao consultar o banco de dados e recebo uma mensagem indicando que o banco não está mais disponível.

Estes travamentos não são em todos os clientes e, mesmo nos clientes em que acontece isto, não são em todos os computadores em que a aplicação está sendo executada.

Para simular este erro, acessei o banco em um servidor e tirei o cabo de rede de meu computador.

Alterei a classe de acesso ao banco de dados para que ao falhar um acesso ao banco (try / cacth) eu abro o banco novamente.

Este procedimento tem o inconveniente de demorar muito (vários segundos) mesmo com um timeout de 1 segundo.

cnFila.Open("DRIVER={MySQL ODBC 5.1 Driver}; SERVER=" & strServer & ";" & "DATABASE=" & strDataBase & ";PWD=" & strPWD & ";;UID=" & strUID & ";OPTION=3;Connection Timeout=1")

Minha pergunta é:

Como saber, dentro do VB Net 2010, que o banco está disponível para consultas?

A única forma é recuperando um erro na execução de algum comando?

Desde já agradeço.

JCarlos

[Denis Courcy]

...

Minha pergunta é:

Como saber, dentro do VB Net 2010, que o banco está disponível para consultas?

A única forma é recuperando um erro na execução de algum comando?

Desde já agradeço.

JCarlos

JCarlos

Quanto a primeira pergunta não conheço o VB Net para te fornecer uma resposta adequada.

Quanto a sua segunda pergunta, creio que seja a melhor opção. Em meus sistemas coloco try/catch em todas as transações para saber onde pode estar acontecendo algum erro.

[JoséCarlos_Plima]

E quanto ao problema do timeout?

Muitas vezes o tempo entre o erro (retirada do cabo de rede) e a execução do primeiro comando do catch é enorme (mais de 15 segundos).

[Denis Courcy]

E quanto ao problema do timeout?

Muitas vezes o tempo entre o erro (retirada do cabo de rede) e a execução do primeiro comando do catch é enorme (mais de 15 segundos).

Por favor informe o resultado dos seguintes comandos:

show status;

show variables;

[JoséCarlos_Plima]

Conforme solicitado:

Query show status, Mon Nov 18 08:43:22 2013 Variable_name Value Aborted_clients 0 Aborted_connects 6 Binlog_cache_disk_use 0 Binlog_cache_use 0 Bytes_received 320 Bytes_sent 537 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 2 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 2 Com_set_option 2 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 0 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 1 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 15 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 2 Handler_rollback 0 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_update 0 Handler_write 133 Innodb_buffer_pool_pages_data 69 Innodb_buffer_pool_pages_dirty 0 Innodb_buffer_pool_pages_flushed 0 Innodb_buffer_pool_pages_free 2683 Innodb_buffer_pool_pages_misc 0 Innodb_buffer_pool_pages_total 2752 Innodb_buffer_pool_read_ahead_rnd 1 Innodb_buffer_pool_read_ahead_seq 0 Innodb_buffer_pool_read_requests 551 Innodb_buffer_pool_reads 18 Innodb_buffer_pool_wait_free 0 Innodb_buffer_pool_write_requests 0 Innodb_data_fsyncs 3 Innodb_data_pending_fsyncs 0 Innodb_data_pending_reads 0 Innodb_data_pending_writes 0 Innodb_data_read 3313664 Innodb_data_reads 79 Innodb_data_writes 3 Innodb_data_written 1536 Innodb_dblwr_pages_written 0 Innodb_dblwr_writes 0 Innodb_log_waits 0 Innodb_log_write_requests 0 Innodb_log_writes 1 Innodb_os_log_fsyncs 3 Innodb_os_log_pending_fsyncs 0 Innodb_os_log_pending_writes 0 Innodb_os_log_written 512 Innodb_page_size 16384 Innodb_pages_created 0 Innodb_pages_read 69 Innodb_pages_written 0 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 0 Innodb_rows_read 0 Innodb_rows_updated 0 Key_blocks_not_flushed 0 Key_blocks_unused 7173 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 6 Not_flushed_delayed_rows 0 Open_files 12 Open_streams 0 Open_tables 6 Opened_tables 0 Prepared_stmt_count 0 Qcache_free_blocks 1 Qcache_free_memory 9428392 Qcache_hits 0 Qcache_inserts 0 Qcache_lowmem_prunes 0 Qcache_not_cached 13 Qcache_queries_in_cache 0 Qcache_total_blocks 1 Queries 34 Questions 8 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 (null) Ssl_cipher_list (null) 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 (null) Table_locks_immediate 12 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 6 Threads_created 6 Threads_running 1 Uptime 1196 Uptime_since_flush_status 1196

Query show variables, Mon Nov 18 08:50:51 2013 Variable_name Value auto_increment_increment 1 auto_increment_offset 1 automatic_sp_privileges ON back_log 50 basedir C:\Program Files\MySQL\MySQL Server 5.0\ binlog_cache_size 32768 bulk_insert_buffer_size 8388608 character_set_client utf8 character_set_connection utf8 character_set_database latin1 character_set_filesystem binary character_set_results utf8 character_set_server latin1 character_set_system utf8 character_sets_dir C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ collation_connection utf8_general_ci collation_database latin1_swedish_ci collation_server latin1_swedish_ci completion_type 0 concurrent_insert 1 connect_timeout 10 datadir C:\Program Files\MySQL\MySQL Server 5.0\Data\ date_format %Y-%m-%d datetime_format %Y-%m-%d %H:%i:%s default_week_format 0 delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 div_precision_increment 4 keep_files_on_create OFF engine_condition_pushdown OFF expire_logs_days 0 flush OFF flush_time 1800 ft_boolean_syntax + -><()~*:""&| ft_max_word_len 84 ft_min_word_len 4 ft_query_expansion_limit 20 ft_stopword_file (built-in) group_concat_max_len 1024 have_archive YES have_bdb NO have_blackhole_engine YES have_compress YES have_community_features YES have_profiling YES have_crypt NO have_csv NO have_dynamic_loading YES have_example_engine NO have_federated_engine YES have_geometry YES have_innodb YES have_isam NO have_merge_engine YES have_ndbcluster NO have_openssl DISABLED have_ssl DISABLED have_query_cache YES have_raid NO have_rtree_keys YES have_symlink YES hostname NOTESIMPLUS init_connect (null) init_file (null) init_slave (null) innodb_additional_mem_pool_size 2097152 innodb_autoextend_increment 8 innodb_buffer_pool_awe_mem_mb 0 innodb_buffer_pool_size 45088768 innodb_checksums ON innodb_commit_concurrency 0 innodb_concurrency_tickets 500 innodb_data_file_path ibdata1:10M:autoextend innodb_data_home_dir (null) innodb_adaptive_hash_index ON innodb_doublewrite ON innodb_fast_shutdown 1 innodb_file_io_threads 4 innodb_file_per_table OFF innodb_flush_log_at_trx_commit 1 innodb_flush_method (null) innodb_force_recovery 0 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_arch_dir (null) innodb_log_archive OFF innodb_log_buffer_size 1048576 innodb_log_file_size 10485760 innodb_log_files_in_group 2 innodb_log_group_home_dir .\ innodb_max_dirty_pages_pct 90 innodb_max_purge_lag 0 innodb_mirrored_log_groups 1 innodb_open_files 300 innodb_rollback_on_timeout OFF innodb_support_xa ON innodb_sync_spin_loops 20 innodb_table_locks ON innodb_thread_concurrency 8 innodb_thread_sleep_delay 10000 innodb_use_legacy_cardinality_algorithm ON interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8388608 key_cache_age_threshold 300 key_cache_block_size 1024 key_cache_division_limit 100 language C:\Program Files\MySQL\MySQL Server 5.0\share\english\ large_files_support ON large_page_size 0 large_pages OFF lc_time_names en_US license GPL local_infile ON log OFF log_bin OFF log_bin_trust_function_creators OFF log_error C:\Program Files\MySQL\MySQL Server 5.0\Data\NOTESIMPLUS.err log_queries_not_using_indexes OFF log_slave_updates OFF log_slow_queries OFF log_warnings 1 long_query_time 10 low_priority_updates OFF lower_case_file_system ON lower_case_table_names 1 max_allowed_packet 1048576 max_binlog_cache_size 4294963200 max_binlog_size 1073741824 max_connect_errors 10 max_connections 335 max_delayed_threads 20 max_error_count 64 max_heap_table_size 16777216 max_insert_delayed_threads 20 max_join_size 18446744073709551615 max_length_for_sort_data 1024 max_prepared_stmt_count 16382 max_relay_log_size 0 max_seeks_for_key 4294967295 max_sort_length 1024 max_sp_recursion_depth 0 max_tmp_tables 32 max_user_connections 0 max_write_lock_count 4294967295 multi_range_count 256 myisam_data_pointer_size 6 myisam_max_sort_file_size 107374182400 myisam_recover_options OFF myisam_repair_threads 1 myisam_sort_buffer_size 8388608 myisam_stats_method nulls_unequal named_pipe OFF net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 new OFF old_passwords OFF open_files_limit 1745 optimizer_prune_level 1 optimizer_search_depth 62 pid_file C:\Program Files\MySQL\MySQL Server 5.0\Data\NOTESIMPLUS.pid plugin_dir (null) port 3306 preload_buffer_size 32768 profiling OFF profiling_history_size 15 protocol_version 10 query_alloc_block_size 8192 query_cache_limit 1048576 query_cache_min_res_unit 4096 query_cache_size 9437184 query_cache_type ON query_cache_wlock_invalidate OFF query_prealloc_size 8192 range_alloc_block_size 4096 read_buffer_size 65536 read_only OFF read_rnd_buffer_size 262144 relay_log (null) relay_log_index (null) relay_log_info_file relay-log.info relay_log_purge ON relay_log_space_limit 0 rpl_recovery_rank 0 secure_auth OFF secure_file_priv (null) shared_memory OFF shared_memory_base_name MYSQL server_id 0 skip_external_locking ON skip_networking OFF skip_show_database OFF slave_compressed_protocol OFF slave_load_tmpdir C:\Windows\TEMP\ slave_net_timeout 3600 slave_skip_errors OFF slave_transaction_retries 10 slow_launch_time 2 sort_buffer_size 214016 sql_big_selects ON sql_mode STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION sql_notes ON sql_warnings OFF ssl_ca (null) ssl_capath (null) ssl_cert (null) ssl_cipher (null) ssl_key (null) storage_engine InnoDB sync_binlog 0 sync_frm ON system_time_zone Hor table_cache 700 table_lock_wait_timeout 50 table_type InnoDB thread_cache_size 16 thread_stack 196608 time_format %H:%i:%s time_zone SYSTEM timed_mutexes OFF tmp_table_size 16777216 tmpdir C:\Windows\TEMP\ transaction_alloc_block_size 8192 transaction_prealloc_size 4096 tx_isolation REPEATABLE-READ updatable_views_with_limit YES version 5.0.86-community-nt version_comment MySQL Community Edition (GPL) version_compile_machine ia32 version_compile_os Win32 wait_timeout 28800

[JoséCarlos_Plima]

Melhor assim:

Query show status, Mon Nov 18 08:43:22 2013

Variable_name Value

Aborted_clients 0

Aborted_connects 6

Binlog_cache_disk_use 0

Binlog_cache_use 0

Bytes_received 320

Bytes_sent 537

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 2

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 2

Com_set_option 2

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 0

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 1

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 15

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 2

Handler_rollback 0

Handler_savepoint 0

Handler_savepoint_rollback 0

Handler_update 0

Handler_write 133

Innodb_buffer_pool_pages_data 69

Innodb_buffer_pool_pages_dirty 0

Innodb_buffer_pool_pages_flushed 0

Innodb_buffer_pool_pages_free 2683

Innodb_buffer_pool_pages_misc 0

Innodb_buffer_pool_pages_total 2752

Innodb_buffer_pool_read_ahead_rnd 1

Innodb_buffer_pool_read_ahead_seq 0

Innodb_buffer_pool_read_requests 551

Innodb_buffer_pool_reads 18

Innodb_buffer_pool_wait_free 0

Innodb_buffer_pool_write_requests 0

Innodb_data_fsyncs 3

Innodb_data_pending_fsyncs 0

Innodb_data_pending_reads 0

Innodb_data_pending_writes 0

Innodb_data_read 3313664

Innodb_data_reads 79

Innodb_data_writes 3

Innodb_data_written 1536

Innodb_dblwr_pages_written 0

Innodb_dblwr_writes 0

Innodb_log_waits 0

Innodb_log_write_requests 0

Innodb_log_writes 1

Innodb_os_log_fsyncs 3

Innodb_os_log_pending_fsyncs 0

Innodb_os_log_pending_writes 0

Innodb_os_log_written 512

Innodb_page_size 16384

Innodb_pages_created 0

Innodb_pages_read 69

Innodb_pages_written 0

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 0

Innodb_rows_read 0

Innodb_rows_updated 0

Key_blocks_not_flushed 0

Key_blocks_unused 7173

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 6

Not_flushed_delayed_rows 0

Open_files 12

Open_streams 0

Open_tables 6

Opened_tables 0

Prepared_stmt_count 0

Qcache_free_blocks 1

Qcache_free_memory 9428392

Qcache_hits 0

Qcache_inserts 0

Qcache_lowmem_prunes 0

Qcache_not_cached 13

Qcache_queries_in_cache 0

Qcache_total_blocks 1

Queries 34

Questions 8

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 (null)

Ssl_cipher_list (null)

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 (null)

Table_locks_immediate 12

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 6

Threads_created 6

Threads_running 1

Uptime 1196

Uptime_since_flush_status 1196

Query show variables, Mon Nov 18 08:50:51 2013

Variable_name Value

auto_increment_increment 1

auto_increment_offset 1

automatic_sp_privileges ON

back_log 50

basedir C:\Program Files\MySQL\MySQL Server 5.0\

binlog_cache_size 32768

bulk_insert_buffer_size 8388608

character_set_client utf8

character_set_connection utf8

character_set_database latin1

character_set_filesystem binary

character_set_results utf8

character_set_server latin1

character_set_system utf8

character_sets_dir C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\

collation_connection utf8_general_ci

collation_database latin1_swedish_ci

collation_server latin1_swedish_ci

completion_type 0

concurrent_insert 1

connect_timeout 10

datadir C:\Program Files\MySQL\MySQL Server 5.0\Data\

date_format %Y-%m-%d

datetime_format %Y-%m-%d %H:%i:%s

default_week_format 0

delay_key_write ON

delayed_insert_limit 100

delayed_insert_timeout 300

delayed_queue_size 1000

div_precision_increment 4

keep_files_on_create OFF

engine_condition_pushdown OFF

expire_logs_days 0

flush OFF

flush_time 1800

ft_boolean_syntax + -><()~*:""&|

ft_max_word_len 84

ft_min_word_len 4

ft_query_expansion_limit 20

ft_stopword_file (built-in)

group_concat_max_len 1024

have_archive YES

have_bdb NO

have_blackhole_engine YES

have_compress YES

have_community_features YES

have_profiling YES

have_crypt NO

have_csv NO

have_dynamic_loading YES

have_example_engine NO

have_federated_engine YES

have_geometry YES

have_innodb YES

have_isam NO

have_merge_engine YES

have_ndbcluster NO

have_openssl DISABLED

have_ssl DISABLED

have_query_cache YES

have_raid NO

have_rtree_keys YES

have_symlink YES

hostname NOTESIMPLUS

init_connect (null)

init_file (null)

init_slave (null)

innodb_additional_mem_pool_size 2097152

innodb_autoextend_increment 8

innodb_buffer_pool_awe_mem_mb 0

innodb_buffer_pool_size 45088768

innodb_checksums ON

innodb_commit_concurrency 0

innodb_concurrency_tickets 500

innodb_data_file_path ibdata1:10M:autoextend

innodb_data_home_dir (null)

innodb_adaptive_hash_index ON

innodb_doublewrite ON

innodb_fast_shutdown 1

innodb_file_io_threads 4

innodb_file_per_table OFF

innodb_flush_log_at_trx_commit 1

innodb_flush_method (null)

innodb_force_recovery 0

innodb_lock_wait_timeout 50

innodb_locks_unsafe_for_binlog OFF

innodb_log_arch_dir (null)

innodb_log_archive OFF

innodb_log_buffer_size 1048576

innodb_log_file_size 10485760

innodb_log_files_in_group 2

innodb_log_group_home_dir .\

innodb_max_dirty_pages_pct 90

innodb_max_purge_lag 0

innodb_mirrored_log_groups 1

innodb_open_files 300

innodb_rollback_on_timeout OFF

innodb_support_xa ON

innodb_sync_spin_loops 20

innodb_table_locks ON

innodb_thread_concurrency 8

innodb_thread_sleep_delay 10000

innodb_use_legacy_cardinality_algorithm ON

interactive_timeout 28800

join_buffer_size 131072

key_buffer_size 8388608

key_cache_age_threshold 300

key_cache_block_size 1024

key_cache_division_limit 100

language C:\Program Files\MySQL\MySQL Server 5.0\share\english\

large_files_support ON

large_page_size 0

large_pages OFF

lc_time_names en_US

license GPL

local_infile ON

log OFF

log_bin OFF

log_bin_trust_function_creators OFF

log_error C:\Program Files\MySQL\MySQL Server 5.0\Data\NOTESIMPLUS.err

log_queries_not_using_indexes OFF

log_slave_updates OFF

log_slow_queries OFF

log_warnings 1

long_query_time 10

low_priority_updates OFF

lower_case_file_system ON

lower_case_table_names 1

max_allowed_packet 1048576

max_binlog_cache_size 4294963200

max_binlog_size 1073741824

max_connect_errors 10

max_connections 335

max_delayed_threads 20

max_error_count 64

max_heap_table_size 16777216

max_insert_delayed_threads 20

max_join_size 18446744073709551615

max_length_for_sort_data 1024

max_prepared_stmt_count 16382

max_relay_log_size 0

max_seeks_for_key 4294967295

max_sort_length 1024

max_sp_recursion_depth 0

max_tmp_tables 32

max_user_connections 0

max_write_lock_count 4294967295

multi_range_count 256

myisam_data_pointer_size 6

myisam_max_sort_file_size 107374182400

myisam_recover_options OFF

myisam_repair_threads 1

myisam_sort_buffer_size 8388608

myisam_stats_method nulls_unequal

named_pipe OFF

net_buffer_length 16384

net_read_timeout 30

net_retry_count 10

net_write_timeout 60

new OFF

old_passwords OFF

open_files_limit 1745

optimizer_prune_level 1

optimizer_search_depth 62

pid_file C:\Program Files\MySQL\MySQL Server 5.0\Data\NOTESIMPLUS.pid

plugin_dir (null)

port 3306

preload_buffer_size 32768

profiling OFF

profiling_history_size 15

protocol_version 10

query_alloc_block_size 8192

query_cache_limit 1048576

query_cache_min_res_unit 4096

query_cache_size 9437184

query_cache_type ON

query_cache_wlock_invalidate OFF

query_prealloc_size 8192

range_alloc_block_size 4096

read_buffer_size 65536

read_only OFF

read_rnd_buffer_size 262144

relay_log (null)

relay_log_index (null)

relay_log_info_file relay-log.info

relay_log_purge ON

relay_log_space_limit 0

rpl_recovery_rank 0

secure_auth OFF

secure_file_priv (null)

shared_memory OFF

shared_memory_base_name MYSQL

server_id 0

skip_external_locking ON

skip_networking OFF

skip_show_database OFF

slave_compressed_protocol OFF

slave_load_tmpdir C:\Windows\TEMP\

slave_net_timeout 3600

slave_skip_errors OFF

slave_transaction_retries 10

slow_launch_time 2

sort_buffer_size 214016

sql_big_selects ON

sql_mode STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

sql_notes ON

sql_warnings OFF

ssl_ca (null)

ssl_capath (null)

ssl_cert (null)

ssl_cipher (null)

ssl_key (null)

storage_engine InnoDB

sync_binlog 0

sync_frm ON

system_time_zone Hor

table_cache 700

table_lock_wait_timeout 50

table_type InnoDB

thread_cache_size 16

thread_stack 196608

time_format %H:%i:%s

time_zone SYSTEM

timed_mutexes OFF

tmp_table_size 16777216

tmpdir C:\Windows\TEMP\

transaction_alloc_block_size 8192

transaction_prealloc_size 4096

tx_isolation REPEATABLE-READ

updatable_views_with_limit YES

version 5.0.86-community-nt

version_comment MySQL Community Edition (GPL)

version_compile_machine ia32

version_compile_os Win32

wait_timeout 28800