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

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

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).

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

Você está concatenando os dois valores. :P Tente: total = CDbl(Val(valor1) + Val(valor2)) :D

Coloque em cada assinalamento de variável um & " " Por exemplo: txtNome.Text = TbCli!NOME & " " OK, eu sei que isto acrescenta um espaço em branco ao final de um campo que não contenha null. Se isto for um problema para você troque o código para: txtNome.Text = mid(TbCli!NOME & " ", 1, Tamanho) Espero ter ajudado. :D