arnaldo_zyl

Senhores, Estou precisando de ajuda na configuração do MySQL. Alguma consultas ele vai bem, mas em outras é muito lento. Tenho algumas funcionalidades onde são criado arquivos temporário,e ai demora mais ainda. Gostaria de uma orientação. Desde já agradeços a quem possa me ajudar. Tipo de tabela: MyISAM Configurações da maquina: [root@d7 ~]# cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 23 model name : Intel® Xeon® CPU X3360 @ 2.83GHz stepping : 7 cpu MHz : 2000.000 cache size : 6144 KB physical id : 0 siblings : 4 core id : 0 cpu cores : 4 apicid : 0 fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 lahf_lm bogomips : 5652.80 RAM 6 GB Arquivo my.cnf mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 max_connections = 2500 # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links=0 　 [mysqld] lower_case_table_names = 1 tmp_table_size = 32 thread_cache_size = 35 [mysqld_safe] log-error=/var/log/mysqld.log id-file=/var/run/mysqld/mysqld.pd GLOBAL STATUS: Aborted_clients............................. 113 Aborted_connects............................ 30 Binlog_cache_disk_use....................... 0 Binlog_cache_use............................ 0 Bytes_received.............................. 47758626 Bytes_sent.................................. 665286052 Com_admin_commands.......................... 3656 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............................... 105006 Com_change_master........................... 0 Com_check................................... 0 Com_checksum................................ 0 Com_commit.................................. 50 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.................................. 199 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.................................. 22968 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................................ 2 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............................... 50 Com_select.................................. 142142 Com_set_option.............................. 772 Com_show_binlog_events...................... 0 Com_show_binlogs............................ 0 Com_show_charsets........................... 7 Com_show_collations......................... 7 Com_show_column_types....................... 0 Com_show_create_db.......................... 144 Com_show_create_table....................... 270 Com_show_databases.......................... 98 Com_show_errors............................. 0 Com_show_fields............................. 18025 Com_show_grants............................. 0 Com_show_innodb_status...................... 0 Com_show_keys............................... 124 Com_show_logs............................... 0 Com_show_master_status...................... 93 Com_show_ndb_status......................... 0 Com_show_new_master......................... 0 Com_show_open_tables........................ 0 Com_show_privileges......................... 0 Com_show_processlist........................ 3154 Com_show_slave_hosts........................ 0 Com_show_slave_status....................... 0 Com_show_status............................. 4493 Com_show_storage_engines.................... 2 Com_show_tables............................. 15 Com_show_triggers........................... 0 Com_show_variables.......................... 204 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.................................. 103112 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................................. 105076 Created_tmp_disk_tables..................... 23377 Created_tmp_files........................... 33 Created_tmp_tables.......................... 37068 Delayed_errors.............................. 0 Delayed_insert_threads...................... 0 Delayed_writes.............................. 0 Flush_commands.............................. 2 Handler_commit.............................. 114 Handler_delete.............................. 3187 Handler_discover............................ 0 Handler_prepare............................. 0 Handler_read_first.......................... 13767 Handler_read_key............................ 151560077 Handler_read_next........................... 3567419038 Handler_read_prev........................... 1987218 Handler_read_rnd............................ 90591811 Handler_read_rnd_next....................... 728044965 Handler_rollback............................ 0 Handler_savepoint........................... 0 Handler_savepoint_rollback.................. 0 Handler_update.............................. 155730634 Handler_write............................... 9389443 Innodb_buffer_pool_pages_data............... 90 Innodb_buffer_pool_pages_dirty.............. 0 Innodb_buffer_pool_pages_flushed............ 165 Innodb_buffer_pool_pages_free............... 421 Innodb_buffer_pool_pages_misc............... 1 Innodb_buffer_pool_pages_total.............. 512 Innodb_buffer_pool_read_ahead_rnd........... 5 Innodb_buffer_pool_read_ahead_seq........... 0 Innodb_buffer_pool_read_requests............ 7495112 Innodb_buffer_pool_reads.................... 43 Innodb_buffer_pool_wait_free................ 0 Innodb_buffer_pool_write_requests........... 7281 Innodb_data_fsyncs.......................... 304 Innodb_data_pending_fsyncs.................. 0 Innodb_data_pending_reads................... 0 Innodb_data_pending_writes.................. 0 Innodb_data_read............................ 3592192 Innodb_data_reads........................... 70 Innodb_data_writes.......................... 364 Innodb_data_written......................... 5934592 Innodb_dblwr_pages_written.................. 165 Innodb_dblwr_writes......................... 46 Innodb_log_waits............................ 0 Innodb_log_write_requests................... 925 Innodb_log_writes........................... 161 Innodb_os_log_fsyncs........................ 208 Innodb_os_log_pending_fsyncs................ 0 Innodb_os_log_pending_writes................ 0 Innodb_os_log_written....................... 503808 Innodb_page_size............................ 16384 Innodb_pages_created........................ 4 Innodb_pages_read........................... 86 Innodb_pages_written........................ 165 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........................ 1698 Innodb_rows_read............................ 2498350 Innodb_rows_updated......................... 0 Key_blocks_not_flushed...................... 0 Key_blocks_unused........................... 1 Key_blocks_used............................. 7245 Key_read_requests........................... 118298349 Key_reads................................... 7898186 Key_write_requests.......................... 2480160 Key_writes.................................. 398223 Last_query_cost............................. 0.000000 Max_used_connections........................ 123 Not_flushed_delayed_rows.................... 0 Open_files.................................. 58 Open_streams................................ 0 Open_tables................................. 64 Opened_tables............................... 939 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..................................... 506003 Questions................................... 506003 Rpl_status.................................. NULL Select_full_join............................ 0 Select_full_range_join...................... 0 Select_range................................ 46 Select_range_check.......................... 0 Select_scan................................. 48835 Slave_open_temp_tables...................... 0 Slave_retried_transactions.................. 0 Slave_running............................... OFF Slow_launch_threads......................... 0 Slow_queries................................ 8 Sort_merge_passes........................... 10 Sort_range.................................. 47067 Sort_rows................................... 556724 Sort_scan................................... 20652 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....................... 226341 Table_locks_waited.......................... 46896 Tc_log_max_pages_used....................... 0 Tc_log_page_size............................ 0 Tc_log_page_waits........................... 0 Threads_cached.............................. 32 Threads_connected........................... 19 Threads_created............................. 345 Threads_running............................. 1 Uptime...................................... 28027 GLOBAL VARIABLES: auto_increment_increment.................... 1 auto_increment_offset....................... 1 automatic_sp_privileges..................... ON back_log.................................... 50 basedir..................................... /usr/ bdb_cache_size.............................. 8384512 bdb_home.................................... /var/lib/mysql/ bdb_log_buffer_size......................... 262144 bdb_logdir.................................. bdb_max_lock................................ 10000 bdb_shared_data............................. OFF bdb_tmpdir.................................. /tmp/ binlog_cache_size........................... 32768 bulk_insert_buffer_size..................... 8388608 character_set_client........................ latin1 character_set_connection.................... latin1 character_set_database...................... latin1 character_set_filesystem.................... binary character_set_results....................... latin1 character_set_server........................ latin1 character_set_system........................ utf8 character_sets_dir.......................... /usr/share/mysql/charsets/ collation_connection........................ latin1_swedish_ci collation_database.......................... latin1_swedish_ci collation_server............................ latin1_swedish_ci completion_type............................. 0 concurrent_insert........................... 1 connect_timeout............................. 10 datadir..................................... /var/lib/mysql/ date_format................................. %Y-%m-%d datetime_format............................. %Y-%m-%d %H:%i:%s default_week_format......................... 0 delay_key_write............................. ON delayed_insert_limit........................ 100 delayed_insert_timeout...................... 300 delayed_queue_size.......................... 1000 div_precision_increment..................... 4 keep_files_on_create........................ OFF engine_condition_pushdown................... OFF expire_logs_days............................ 0 flush....................................... OFF flush_time.................................. 0 ft_boolean_syntax........................... + -><()~*:""&| ft_max_word_len............................. 84 ft_min_word_len............................. 4 ft_query_expansion_limit.................... 20 ft_stopword_file............................ (built-in) group_concat_max_len........................ 1024 have_archive................................ NO have_bdb.................................... YES have_blackhole_engine....................... NO have_compress............................... YES have_community_features..................... NO have_profiling.............................. NO have_crypt.................................. YES have_csv.................................... NO have_dynamic_loading........................ YES have_example_engine......................... NO have_federated_engine....................... NO have_geometry............................... YES have_innodb................................. YES have_isam................................... NO have_merge_engine........................... YES have_ndbcluster............................. NO have_openssl................................ DISABLED have_ssl.................................... DISABLED have_query_cache............................ YES have_raid................................... NO have_rtree_keys............................. YES have_symlink................................ YES hostname.................................... d7.d.de.static.xlhost.com init_connect................................ init_file................................... init_slave.................................. innodb_additional_mem_pool_size............. 1048576 innodb_autoextend_increment................. 8 innodb_buffer_pool_awe_mem_mb............... 0 innodb_buffer_pool_size..................... 8388608 innodb_checksums............................ ON innodb_commit_concurrency................... 0 innodb_concurrency_tickets.................. 500 innodb_data_file_path....................... ibdata1:10M:autoextend innodb_data_home_dir........................ 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......................... innodb_force_recovery....................... 0 innodb_lock_wait_timeout.................... 50 innodb_locks_unsafe_for_binlog.............. OFF innodb_log_arch_dir......................... innodb_log_archive.......................... OFF innodb_log_buffer_size...................... 1048576 innodb_log_file_size........................ 5242880 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............................. 8384512 key_cache_age_threshold..................... 300 key_cache_block_size........................ 1024 key_cache_division_limit.................... 100 language.................................... /usr/share/mysql/english/ large_files_support......................... ON large_page_size............................. 0 large_pages................................. OFF lc_time_names............................... en_US license..................................... GPL local_infile................................ ON locked_in_memory............................ OFF log......................................... OFF log_bin..................................... OFF log_bin_trust_function_creators............. OFF log_error................................... log_queries_not_using_indexes............... OFF log_slave_updates........................... OFF log_slow_queries............................ OFF log_warnings................................ 1 long_query_time............................. 10 low_priority_updates........................ OFF lower_case_file_system...................... OFF lower_case_table_names...................... 1 max_allowed_packet.......................... 1048576 max_binlog_cache_size....................... 4294963200 max_binlog_size............................. 1073741824 max_connect_errors.......................... 10 max_connections............................. 2500 max_delayed_threads......................... 20 max_error_count............................. 64 max_heap_table_size......................... 16777216 max_insert_delayed_threads.................. 20 max_join_size............................... 4294967295 max_length_for_sort_data.................... 1024 max_prepared_stmt_count..................... 16382 max_relay_log_size.......................... 0 max_seeks_for_key........................... 4294967295 max_sort_length............................. 1024 max_sp_recursion_depth...................... 0 max_tmp_tables.............................. 32 max_user_connections........................ 0 max_write_lock_count........................ 4294967295 multi_range_count........................... 256 myisam_data_pointer_size.................... 6 myisam_max_sort_file_size................... 2146435072 myisam_mmap_size............................ 4294967295 myisam_recover_options...................... OFF myisam_repair_threads....................... 1 myisam_sort_buffer_size..................... 8388608 myisam_stats_method......................... nulls_unequal net_buffer_length........................... 16384 net_read_timeout............................ 30 net_retry_count............................. 10 net_write_timeout........................... 60 new......................................... OFF old_passwords............................... ON open_files_limit............................ 12500 optimizer_prune_level....................... 1 optimizer_search_depth...................... 62 pid_file.................................... /var/run/mysqld/mysqld.pid plugin_dir.................................. port........................................ 3306 preload_buffer_size......................... 32768 protocol_version............................ 10 query_alloc_block_size...................... 8192 query_cache_limit........................... 1048576 query_cache_min_res_unit.................... 4096 query_cache_size............................ 0 query_cache_type............................ ON query_cache_wlock_invalidate................ OFF query_prealloc_size......................... 8192 range_alloc_block_size...................... 4096 read_buffer_size............................ 131072 read_only................................... OFF read_rnd_buffer_size........................ 262144 relay_log................................... relay_log_index............................. 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............................ server_id................................... 0 skip_external_locking....................... ON skip_networking............................. OFF skip_show_database.......................... OFF slave_compressed_protocol................... OFF slave_load_tmpdir........................... /tmp/ slave_net_timeout........................... 3600 slave_skip_errors........................... OFF slave_transaction_retries................... 10 slow_launch_time............................ 2 socket...................................... /var/lib/mysql/mysql.sock sort_buffer_size............................ 2097144 sql_big_selects............................. ON sql_mode.................................... sql_notes................................... ON sql_warnings................................ OFF ssl_ca...................................... ssl_capath.................................. ssl_cert.................................... ssl_cipher.................................. ssl_key..................................... storage_engine.............................. MyISAM sync_binlog................................. 0 sync_frm.................................... ON system_time_zone............................ EDT table_cache................................. 64 table_lock_wait_timeout..................... 50 table_type.................................. MyISAM thread_cache_size........................... 35 thread_stack................................ 196608 time_format................................. %H:%i:%s time_zone................................... SYSTEM timed_mutexes............................... OFF tmp_table_size.............................. 1024 tmpdir...................................... /tmp/ transaction_alloc_block_size................ 8192 transaction_prealloc_size................... 4096 tx_isolation................................ REPEATABLE-READ updatable_views_with_limit.................. YES version..................................... 5.0.95 version_bdb................................. Sleepycat Software: Berkeley DB 4.1.24: (December 16, 2011) version_comment............................. Source distribution version_compile_machine..................... i686 version_compile_os.......................... redhat-linux-gnu wait_timeout................................ 28800 VARIAVEIS auto_increment_increment.................... 1 auto_increment_offset....................... 1 automatic_sp_privileges..................... ON back_log.................................... 50 basedir..................................... /usr/ bdb_cache_size.............................. 8384512 bdb_home.................................... /var/lib/mysql/ bdb_log_buffer_size......................... 262144 bdb_logdir.................................. bdb_max_lock................................ 10000 bdb_shared_data............................. OFF bdb_tmpdir.................................. /tmp/ binlog_cache_size........................... 32768 bulk_insert_buffer_size..................... 8388608 character_set_client........................ latin1 character_set_connection.................... latin1 character_set_database...................... latin1 character_set_filesystem.................... binary character_set_results....................... latin1 character_set_server........................ latin1 character_set_system........................ utf8 character_sets_dir.......................... /usr/share/mysql/charsets/ collation_connection........................ latin1_swedish_ci collation_database.......................... latin1_swedish_ci collation_server............................ latin1_swedish_ci completion_type............................. 0 concurrent_insert........................... 1 connect_timeout............................. 10 datadir..................................... /var/lib/mysql/ date_format................................. %Y-%m-%d datetime_format............................. %Y-%m-%d %H:%i:%s default_week_format......................... 0 delay_key_write............................. ON delayed_insert_limit........................ 100 delayed_insert_timeout...................... 300 delayed_queue_size.......................... 1000 div_precision_increment..................... 4 keep_files_on_create........................ OFF engine_condition_pushdown................... OFF expire_logs_days............................ 0 flush....................................... OFF flush_time.................................. 0 ft_boolean_syntax........................... + -><()~*:""&| ft_max_word_len............................. 84 ft_min_word_len............................. 4 ft_query_expansion_limit.................... 20 ft_stopword_file............................ (built-in) group_concat_max_len........................ 1024 have_archive................................ NO have_bdb.................................... YES have_blackhole_engine....................... NO have_compress............................... YES have_community_features..................... NO have_profiling.............................. NO have_crypt.................................. YES have_csv.................................... NO have_dynamic_loading........................ YES have_example_engine......................... NO have_federated_engine....................... NO have_geometry............................... YES have_innodb................................. YES have_isam................................... NO have_merge_engine........................... YES have_ndbcluster............................. NO have_openssl................................ DISABLED have_ssl.................................... DISABLED have_query_cache............................ YES have_raid................................... NO have_rtree_keys............................. YES have_symlink................................ YES hostname.................................... d7.d.de.static.xlhost.com init_connect................................ init_file................................... init_slave.................................. innodb_additional_mem_pool_size............. 1048576 innodb_autoextend_increment................. 8 innodb_buffer_pool_awe_mem_mb............... 0 innodb_buffer_pool_size..................... 8388608 innodb_checksums............................ ON innodb_commit_concurrency................... 0 innodb_concurrency_tickets.................. 500 innodb_data_file_path....................... ibdata1:10M:autoextend innodb_data_home_dir........................ 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......................... innodb_force_recovery....................... 0 innodb_lock_wait_timeout.................... 50 innodb_locks_unsafe_for_binlog.............. OFF innodb_log_arch_dir......................... innodb_log_archive.......................... OFF innodb_log_buffer_size...................... 1048576 innodb_log_file_size........................ 5242880 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............................. 8384512 key_cache_age_threshold..................... 300 key_cache_block_size........................ 1024 key_cache_division_limit.................... 100 language.................................... /usr/share/mysql/english/ large_files_support......................... ON large_page_size............................. 0 large_pages................................. OFF lc_time_names............................... en_US license..................................... GPL local_infile................................ ON locked_in_memory............................ OFF log......................................... OFF log_bin..................................... OFF log_bin_trust_function_creators............. OFF log_error................................... log_queries_not_using_indexes............... OFF log_slave_updates........................... OFF log_slow_queries............................ OFF log_warnings................................ 1 long_query_time............................. 10 low_priority_updates........................ OFF lower_case_file_system...................... OFF lower_case_table_names...................... 1 max_allowed_packet.......................... 1048576 max_binlog_cache_size....................... 4294963200 max_binlog_size............................. 1073741824 max_connect_errors.......................... 10 max_connections............................. 2500 max_delayed_threads......................... 20 max_error_count............................. 64 max_heap_table_size......................... 16777216 max_insert_delayed_threads.................. 20 max_join_size............................... 4294967295 max_length_for_sort_data.................... 1024 max_prepared_stmt_count..................... 16382 max_relay_log_size.......................... 0 max_seeks_for_key........................... 4294967295 max_sort_length............................. 1024 max_sp_recursion_depth...................... 0 max_tmp_tables.............................. 32 max_user_connections........................ 0 max_write_lock_count........................ 4294967295 multi_range_count........................... 256 myisam_data_pointer_size.................... 6 myisam_max_sort_file_size................... 2146435072 myisam_mmap_size............................ 4294967295 myisam_recover_options...................... OFF myisam_repair_threads....................... 1 myisam_sort_buffer_size..................... 8388608 myisam_stats_method......................... nulls_unequal net_buffer_length........................... 16384 net_read_timeout............................ 30 net_retry_count............................. 10 net_write_timeout........................... 60 new......................................... OFF old_passwords............................... ON open_files_limit............................ 12500 optimizer_prune_level....................... 1 optimizer_search_depth...................... 62 pid_file.................................... /var/run/mysqld/mysqld.pid plugin_dir.................................. port........................................ 3306 preload_buffer_size......................... 32768 protocol_version............................ 10 query_alloc_block_size...................... 8192 query_cache_limit........................... 1048576 query_cache_min_res_unit.................... 4096 query_cache_size............................ 0 query_cache_type............................ ON query_cache_wlock_invalidate................ OFF query_prealloc_size......................... 8192 range_alloc_block_size...................... 4096 read_buffer_size............................ 131072 read_only................................... OFF read_rnd_buffer_size........................ 262144 relay_log................................... relay_log_index............................. 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............................ server_id................................... 0 skip_external_locking....................... ON skip_networking............................. OFF skip_show_database.......................... OFF slave_compressed_protocol................... OFF slave_load_tmpdir........................... /tmp/ slave_net_timeout........................... 3600 slave_skip_errors........................... OFF slave_transaction_retries................... 10 slow_launch_time............................ 2 socket...................................... /var/lib/mysql/mysql.sock sort_buffer_size............................ 2097144 sql_big_selects............................. ON sql_mode.................................... sql_notes................................... ON sql_warnings................................ OFF ssl_ca...................................... ssl_capath.................................. ssl_cert.................................... ssl_cipher.................................. ssl_key..................................... storage_engine.............................. MyISAM sync_binlog................................. 0 sync_frm.................................... ON system_time_zone............................ EDT table_cache................................. 64 table_lock_wait_timeout..................... 50 table_type.................................. MyISAM thread_cache_size........................... 35 thread_stack................................ 196608 time_format................................. %H:%i:%s time_zone................................... SYSTEM timed_mutexes............................... OFF tmp_table_size.............................. 1024 tmpdir...................................... /tmp/ transaction_alloc_block_size................ 8192 transaction_prealloc_size................... 4096 tx_isolation................................ REPEATABLE-READ updatable_views_with_limit.................. YES version..................................... 5.0.95 version_bdb................................. Sleepycat Software: Berkeley DB 4.1.24: (December 16, 2011) version_comment............................. Source distribution version_compile_machine..................... i686 version_compile_os.......................... redhat-linux-gnu wait_timeout................................ 28800 Estou a disposição para passar maiore informações. Obrigado