arnaldo_zyl Postado Maio 24, 2012 Denunciar Share Postado Maio 24, 2012 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: MyISAMConfigurações da maquina:[root@d7 ~]# cat /proc/cpuinfoprocessor : 0vendor_id : GenuineIntelcpu family : 6model : 23model name : Intel® Xeon® CPU X3360 @ 2.83GHzstepping : 7cpu MHz : 2000.000cache size : 6144 KBphysical id : 0siblings : 4core id : 0cpu cores : 4apicid : 0fdiv_bug : nohlt_bug : nof00f_bug : nocoma_bug : nofpu : yesfpu_exception : yescpuid level : 10wp : yesflags : 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_lmbogomips : 5652.80RAM 6 GBArquivo my.cnfmysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Default to using old password format for compatibility with mysql 3.x# clients (those using the mysqlclient10 compatibility package).old_passwords=1max_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 = 1tmp_table_size = 32thread_cache_size = 35[mysqld_safe]log-error=/var/log/mysqld.logid-file=/var/run/mysqld/mysqld.pdGLOBAL STATUS:Aborted_clients............................. 113Aborted_connects............................ 30Binlog_cache_disk_use....................... 0Binlog_cache_use............................ 0Bytes_received.............................. 47758626Bytes_sent.................................. 665286052Com_admin_commands.......................... 3656Com_alter_db................................ 0Com_alter_table............................. 0Com_analyze................................. 0Com_backup_table............................ 0Com_begin................................... 0Com_call_procedure.......................... 0Com_change_db............................... 105006Com_change_master........................... 0Com_check................................... 0Com_checksum................................ 0Com_commit.................................. 50Com_create_db............................... 0Com_create_function......................... 0Com_create_index............................ 0Com_create_table............................ 0Com_create_user............................. 0Com_dealloc_sql............................. 0Com_delete.................................. 199Com_delete_multi............................ 0Com_do...................................... 0Com_drop_db................................. 0Com_drop_function........................... 0Com_drop_index.............................. 0Com_drop_table.............................. 0Com_drop_user............................... 0Com_execute_sql............................. 0Com_flush................................... 0Com_grant................................... 0Com_ha_close................................ 0Com_ha_open................................. 0Com_ha_read................................. 0Com_help.................................... 0Com_insert.................................. 22968Com_insert_select........................... 0Com_kill.................................... 0Com_load.................................... 0Com_load_master_data........................ 0Com_load_master_table....................... 0Com_lock_tables............................. 0Com_optimize................................ 2Com_preload_keys............................ 0Com_prepare_sql............................. 0Com_purge................................... 0Com_purge_before_date....................... 0Com_rename_table............................ 0Com_repair.................................. 0Com_replace................................. 0Com_replace_select.......................... 0Com_reset................................... 0Com_restore_table........................... 0Com_revoke.................................. 0Com_revoke_all.............................. 0Com_rollback................................ 0Com_savepoint............................... 50Com_select.................................. 142142Com_set_option.............................. 772Com_show_binlog_events...................... 0Com_show_binlogs............................ 0Com_show_charsets........................... 7Com_show_collations......................... 7Com_show_column_types....................... 0Com_show_create_db.......................... 144Com_show_create_table....................... 270Com_show_databases.......................... 98Com_show_errors............................. 0Com_show_fields............................. 18025Com_show_grants............................. 0Com_show_innodb_status...................... 0Com_show_keys............................... 124Com_show_logs............................... 0Com_show_master_status...................... 93Com_show_ndb_status......................... 0Com_show_new_master......................... 0Com_show_open_tables........................ 0Com_show_privileges......................... 0Com_show_processlist........................ 3154Com_show_slave_hosts........................ 0Com_show_slave_status....................... 0Com_show_status............................. 4493Com_show_storage_engines.................... 2Com_show_tables............................. 15Com_show_triggers........................... 0Com_show_variables.......................... 204Com_show_warnings........................... 0Com_slave_start............................. 0Com_slave_stop.............................. 0Com_stmt_close.............................. 0Com_stmt_execute............................ 0Com_stmt_fetch.............................. 0Com_stmt_prepare............................ 0Com_stmt_reset.............................. 0Com_stmt_send_long_data..................... 0Com_truncate................................ 0Com_unlock_tables........................... 0Com_update.................................. 103112Com_update_multi............................ 0Com_xa_commit............................... 0Com_xa_end.................................. 0Com_xa_prepare.............................. 0Com_xa_recover.............................. 0Com_xa_rollback............................. 0Com_xa_start................................ 0Compression................................. OFFConnections................................. 105076Created_tmp_disk_tables..................... 23377Created_tmp_files........................... 33Created_tmp_tables.......................... 37068Delayed_errors.............................. 0Delayed_insert_threads...................... 0Delayed_writes.............................. 0Flush_commands.............................. 2Handler_commit.............................. 114Handler_delete.............................. 3187Handler_discover............................ 0Handler_prepare............................. 0Handler_read_first.......................... 13767Handler_read_key............................ 151560077Handler_read_next........................... 3567419038Handler_read_prev........................... 1987218Handler_read_rnd............................ 90591811Handler_read_rnd_next....................... 728044965Handler_rollback............................ 0Handler_savepoint........................... 0Handler_savepoint_rollback.................. 0Handler_update.............................. 155730634Handler_write............................... 9389443Innodb_buffer_pool_pages_data............... 90Innodb_buffer_pool_pages_dirty.............. 0Innodb_buffer_pool_pages_flushed............ 165Innodb_buffer_pool_pages_free............... 421Innodb_buffer_pool_pages_misc............... 1Innodb_buffer_pool_pages_total.............. 512Innodb_buffer_pool_read_ahead_rnd........... 5Innodb_buffer_pool_read_ahead_seq........... 0Innodb_buffer_pool_read_requests............ 7495112Innodb_buffer_pool_reads.................... 43Innodb_buffer_pool_wait_free................ 0Innodb_buffer_pool_write_requests........... 7281Innodb_data_fsyncs.......................... 304Innodb_data_pending_fsyncs.................. 0Innodb_data_pending_reads................... 0Innodb_data_pending_writes.................. 0Innodb_data_read............................ 3592192Innodb_data_reads........................... 70Innodb_data_writes.......................... 364Innodb_data_written......................... 5934592Innodb_dblwr_pages_written.................. 165Innodb_dblwr_writes......................... 46Innodb_log_waits............................ 0Innodb_log_write_requests................... 925Innodb_log_writes........................... 161Innodb_os_log_fsyncs........................ 208Innodb_os_log_pending_fsyncs................ 0Innodb_os_log_pending_writes................ 0Innodb_os_log_written....................... 503808Innodb_page_size............................ 16384Innodb_pages_created........................ 4Innodb_pages_read........................... 86Innodb_pages_written........................ 165Innodb_row_lock_current_waits............... 0Innodb_row_lock_time........................ 0Innodb_row_lock_time_avg.................... 0Innodb_row_lock_time_max.................... 0Innodb_row_lock_waits....................... 0Innodb_rows_deleted......................... 0Innodb_rows_inserted........................ 1698Innodb_rows_read............................ 2498350Innodb_rows_updated......................... 0Key_blocks_not_flushed...................... 0Key_blocks_unused........................... 1Key_blocks_used............................. 7245Key_read_requests........................... 118298349Key_reads................................... 7898186Key_write_requests.......................... 2480160Key_writes.................................. 398223Last_query_cost............................. 0.000000Max_used_connections........................ 123Not_flushed_delayed_rows.................... 0Open_files.................................. 58Open_streams................................ 0Open_tables................................. 64Opened_tables............................... 939Prepared_stmt_count......................... 0Qcache_free_blocks.......................... 0Qcache_free_memory.......................... 0Qcache_hits................................. 0Qcache_inserts.............................. 0Qcache_lowmem_prunes........................ 0Qcache_not_cached........................... 0Qcache_queries_in_cache..................... 0Qcache_total_blocks......................... 0Queries..................................... 506003Questions................................... 506003Rpl_status.................................. NULLSelect_full_join............................ 0Select_full_range_join...................... 0Select_range................................ 46Select_range_check.......................... 0Select_scan................................. 48835Slave_open_temp_tables...................... 0Slave_retried_transactions.................. 0Slave_running............................... OFFSlow_launch_threads......................... 0Slow_queries................................ 8Sort_merge_passes........................... 10Sort_range.................................. 47067Sort_rows................................... 556724Sort_scan................................... 20652Ssl_accept_renegotiates..................... 0Ssl_accepts................................. 0Ssl_callback_cache_hits..................... 0Ssl_cipher.................................. Ssl_cipher_list............................. Ssl_client_connects......................... 0Ssl_connect_renegotiates.................... 0Ssl_ctx_verify_depth........................ 0Ssl_ctx_verify_mode......................... 0Ssl_default_timeout......................... 0Ssl_finished_accepts........................ 0Ssl_finished_connects....................... 0Ssl_session_cache_hits...................... 0Ssl_session_cache_misses.................... 0Ssl_session_cache_mode...................... NONESsl_session_cache_overflows................. 0Ssl_session_cache_size...................... 0Ssl_session_cache_timeouts.................. 0Ssl_sessions_reused......................... 0Ssl_used_session_cache_entries.............. 0Ssl_verify_depth............................ 0Ssl_verify_mode............................. 0Ssl_version................................. Table_locks_immediate....................... 226341Table_locks_waited.......................... 46896Tc_log_max_pages_used....................... 0Tc_log_page_size............................ 0Tc_log_page_waits........................... 0Threads_cached.............................. 32Threads_connected........................... 19Threads_created............................. 345Threads_running............................. 1Uptime...................................... 28027GLOBAL VARIABLES:auto_increment_increment.................... 1auto_increment_offset....................... 1automatic_sp_privileges..................... ONback_log.................................... 50basedir..................................... /usr/bdb_cache_size.............................. 8384512bdb_home.................................... /var/lib/mysql/bdb_log_buffer_size......................... 262144bdb_logdir.................................. bdb_max_lock................................ 10000bdb_shared_data............................. OFFbdb_tmpdir.................................. /tmp/binlog_cache_size........................... 32768bulk_insert_buffer_size..................... 8388608character_set_client........................ latin1character_set_connection.................... latin1character_set_database...................... latin1character_set_filesystem.................... binarycharacter_set_results....................... latin1character_set_server........................ latin1character_set_system........................ utf8character_sets_dir.......................... /usr/share/mysql/charsets/collation_connection........................ latin1_swedish_cicollation_database.......................... latin1_swedish_cicollation_server............................ latin1_swedish_cicompletion_type............................. 0concurrent_insert........................... 1connect_timeout............................. 10datadir..................................... /var/lib/mysql/date_format................................. %Y-%m-%ddatetime_format............................. %Y-%m-%d %H:%i:%sdefault_week_format......................... 0delay_key_write............................. ONdelayed_insert_limit........................ 100delayed_insert_timeout...................... 300delayed_queue_size.......................... 1000div_precision_increment..................... 4keep_files_on_create........................ OFFengine_condition_pushdown................... OFFexpire_logs_days............................ 0flush....................................... OFFflush_time.................................. 0ft_boolean_syntax........................... + -><()~*:""&|ft_max_word_len............................. 84ft_min_word_len............................. 4ft_query_expansion_limit.................... 20ft_stopword_file............................ (built-in)group_concat_max_len........................ 1024have_archive................................ NOhave_bdb.................................... YEShave_blackhole_engine....................... NOhave_compress............................... YEShave_community_features..................... NOhave_profiling.............................. NOhave_crypt.................................. YEShave_csv.................................... NOhave_dynamic_loading........................ YEShave_example_engine......................... NOhave_federated_engine....................... NOhave_geometry............................... YEShave_innodb................................. YEShave_isam................................... NOhave_merge_engine........................... YEShave_ndbcluster............................. NOhave_openssl................................ DISABLEDhave_ssl.................................... DISABLEDhave_query_cache............................ YEShave_raid................................... NOhave_rtree_keys............................. YEShave_symlink................................ YEShostname.................................... d7.d.de.static.xlhost.cominit_connect................................ init_file................................... init_slave.................................. innodb_additional_mem_pool_size............. 1048576innodb_autoextend_increment................. 8innodb_buffer_pool_awe_mem_mb............... 0innodb_buffer_pool_size..................... 8388608innodb_checksums............................ ONinnodb_commit_concurrency................... 0innodb_concurrency_tickets.................. 500innodb_data_file_path....................... ibdata1:10M:autoextendinnodb_data_home_dir........................ innodb_adaptive_hash_index.................. ONinnodb_doublewrite.......................... ONinnodb_fast_shutdown........................ 1innodb_file_io_threads...................... 4innodb_file_per_table....................... OFFinnodb_flush_log_at_trx_commit.............. 1innodb_flush_method......................... innodb_force_recovery....................... 0innodb_lock_wait_timeout.................... 50innodb_locks_unsafe_for_binlog.............. OFFinnodb_log_arch_dir......................... innodb_log_archive.......................... OFFinnodb_log_buffer_size...................... 1048576innodb_log_file_size........................ 5242880innodb_log_files_in_group................... 2innodb_log_group_home_dir................... ./innodb_max_dirty_pages_pct.................. 90innodb_max_purge_lag........................ 0innodb_mirrored_log_groups.................. 1innodb_open_files........................... 300innodb_rollback_on_timeout.................. OFFinnodb_support_xa........................... ONinnodb_sync_spin_loops...................... 20innodb_table_locks.......................... ONinnodb_thread_concurrency................... 8innodb_thread_sleep_delay................... 10000innodb_use_legacy_cardinality_algorithm..... ONinteractive_timeout......................... 28800join_buffer_size............................ 131072key_buffer_size............................. 8384512key_cache_age_threshold..................... 300key_cache_block_size........................ 1024key_cache_division_limit.................... 100language.................................... /usr/share/mysql/english/large_files_support......................... ONlarge_page_size............................. 0large_pages................................. OFFlc_time_names............................... en_USlicense..................................... GPLlocal_infile................................ ONlocked_in_memory............................ OFFlog......................................... OFFlog_bin..................................... OFFlog_bin_trust_function_creators............. OFFlog_error................................... log_queries_not_using_indexes............... OFFlog_slave_updates........................... OFFlog_slow_queries............................ OFFlog_warnings................................ 1long_query_time............................. 10low_priority_updates........................ OFFlower_case_file_system...................... OFFlower_case_table_names...................... 1max_allowed_packet.......................... 1048576max_binlog_cache_size....................... 4294963200max_binlog_size............................. 1073741824max_connect_errors.......................... 10max_connections............................. 2500max_delayed_threads......................... 20max_error_count............................. 64max_heap_table_size......................... 16777216max_insert_delayed_threads.................. 20max_join_size............................... 4294967295max_length_for_sort_data.................... 1024max_prepared_stmt_count..................... 16382max_relay_log_size.......................... 0max_seeks_for_key........................... 4294967295max_sort_length............................. 1024max_sp_recursion_depth...................... 0max_tmp_tables.............................. 32max_user_connections........................ 0max_write_lock_count........................ 4294967295multi_range_count........................... 256myisam_data_pointer_size.................... 6myisam_max_sort_file_size................... 2146435072myisam_mmap_size............................ 4294967295myisam_recover_options...................... OFFmyisam_repair_threads....................... 1myisam_sort_buffer_size..................... 8388608myisam_stats_method......................... nulls_unequalnet_buffer_length........................... 16384net_read_timeout............................ 30net_retry_count............................. 10net_write_timeout........................... 60new......................................... OFFold_passwords............................... ONopen_files_limit............................ 12500optimizer_prune_level....................... 1optimizer_search_depth...................... 62pid_file.................................... /var/run/mysqld/mysqld.pidplugin_dir.................................. port........................................ 3306preload_buffer_size......................... 32768protocol_version............................ 10query_alloc_block_size...................... 8192query_cache_limit........................... 1048576query_cache_min_res_unit.................... 4096query_cache_size............................ 0query_cache_type............................ ONquery_cache_wlock_invalidate................ OFFquery_prealloc_size......................... 8192range_alloc_block_size...................... 4096read_buffer_size............................ 131072read_only................................... OFFread_rnd_buffer_size........................ 262144relay_log................................... relay_log_index............................. relay_log_info_file......................... relay-log.inforelay_log_purge............................. ONrelay_log_space_limit....................... 0rpl_recovery_rank........................... 0secure_auth................................. OFFsecure_file_priv............................ server_id................................... 0skip_external_locking....................... ONskip_networking............................. OFFskip_show_database.......................... OFFslave_compressed_protocol................... OFFslave_load_tmpdir........................... /tmp/slave_net_timeout........................... 3600slave_skip_errors........................... OFFslave_transaction_retries................... 10slow_launch_time............................ 2socket...................................... /var/lib/mysql/mysql.socksort_buffer_size............................ 2097144sql_big_selects............................. ONsql_mode.................................... sql_notes................................... ONsql_warnings................................ OFFssl_ca...................................... ssl_capath.................................. ssl_cert.................................... ssl_cipher.................................. ssl_key..................................... storage_engine.............................. MyISAMsync_binlog................................. 0sync_frm.................................... ONsystem_time_zone............................ EDTtable_cache................................. 64table_lock_wait_timeout..................... 50table_type.................................. MyISAMthread_cache_size........................... 35thread_stack................................ 196608time_format................................. %H:%i:%stime_zone................................... SYSTEMtimed_mutexes............................... OFFtmp_table_size.............................. 1024tmpdir...................................... /tmp/transaction_alloc_block_size................ 8192transaction_prealloc_size................... 4096tx_isolation................................ REPEATABLE-READupdatable_views_with_limit.................. YESversion..................................... 5.0.95version_bdb................................. Sleepycat Software: Berkeley DB 4.1.24: (December 16, 2011)version_comment............................. Source distributionversion_compile_machine..................... i686version_compile_os.......................... redhat-linux-gnuwait_timeout................................ 28800VARIAVEISauto_increment_increment.................... 1auto_increment_offset....................... 1automatic_sp_privileges..................... ONback_log.................................... 50basedir..................................... /usr/bdb_cache_size.............................. 8384512bdb_home.................................... /var/lib/mysql/bdb_log_buffer_size......................... 262144bdb_logdir.................................. bdb_max_lock................................ 10000bdb_shared_data............................. OFFbdb_tmpdir.................................. /tmp/binlog_cache_size........................... 32768bulk_insert_buffer_size..................... 8388608character_set_client........................ latin1character_set_connection.................... latin1character_set_database...................... latin1character_set_filesystem.................... binarycharacter_set_results....................... latin1character_set_server........................ latin1character_set_system........................ utf8character_sets_dir.......................... /usr/share/mysql/charsets/collation_connection........................ latin1_swedish_cicollation_database.......................... latin1_swedish_cicollation_server............................ latin1_swedish_cicompletion_type............................. 0concurrent_insert........................... 1connect_timeout............................. 10datadir..................................... /var/lib/mysql/date_format................................. %Y-%m-%ddatetime_format............................. %Y-%m-%d %H:%i:%sdefault_week_format......................... 0delay_key_write............................. ONdelayed_insert_limit........................ 100delayed_insert_timeout...................... 300delayed_queue_size.......................... 1000div_precision_increment..................... 4keep_files_on_create........................ OFFengine_condition_pushdown................... OFFexpire_logs_days............................ 0flush....................................... OFFflush_time.................................. 0ft_boolean_syntax........................... + -><()~*:""&|ft_max_word_len............................. 84ft_min_word_len............................. 4ft_query_expansion_limit.................... 20ft_stopword_file............................ (built-in)group_concat_max_len........................ 1024have_archive................................ NOhave_bdb.................................... YEShave_blackhole_engine....................... NOhave_compress............................... YEShave_community_features..................... NOhave_profiling.............................. NOhave_crypt.................................. YEShave_csv.................................... NOhave_dynamic_loading........................ YEShave_example_engine......................... NOhave_federated_engine....................... NOhave_geometry............................... YEShave_innodb................................. YEShave_isam................................... NOhave_merge_engine........................... YEShave_ndbcluster............................. NOhave_openssl................................ DISABLEDhave_ssl.................................... DISABLEDhave_query_cache............................ YEShave_raid................................... NOhave_rtree_keys............................. YEShave_symlink................................ YEShostname.................................... d7.d.de.static.xlhost.cominit_connect................................ init_file................................... init_slave.................................. innodb_additional_mem_pool_size............. 1048576innodb_autoextend_increment................. 8innodb_buffer_pool_awe_mem_mb............... 0innodb_buffer_pool_size..................... 8388608innodb_checksums............................ ONinnodb_commit_concurrency................... 0innodb_concurrency_tickets.................. 500innodb_data_file_path....................... ibdata1:10M:autoextendinnodb_data_home_dir........................ innodb_adaptive_hash_index.................. ONinnodb_doublewrite.......................... ONinnodb_fast_shutdown........................ 1innodb_file_io_threads...................... 4innodb_file_per_table....................... OFFinnodb_flush_log_at_trx_commit.............. 1innodb_flush_method......................... innodb_force_recovery....................... 0innodb_lock_wait_timeout.................... 50innodb_locks_unsafe_for_binlog.............. OFFinnodb_log_arch_dir......................... innodb_log_archive.......................... OFFinnodb_log_buffer_size...................... 1048576innodb_log_file_size........................ 5242880innodb_log_files_in_group................... 2innodb_log_group_home_dir................... ./innodb_max_dirty_pages_pct.................. 90innodb_max_purge_lag........................ 0innodb_mirrored_log_groups.................. 1innodb_open_files........................... 300innodb_rollback_on_timeout.................. OFFinnodb_support_xa........................... ONinnodb_sync_spin_loops...................... 20innodb_table_locks.......................... ONinnodb_thread_concurrency................... 8innodb_thread_sleep_delay................... 10000innodb_use_legacy_cardinality_algorithm..... ONinteractive_timeout......................... 28800join_buffer_size............................ 131072key_buffer_size............................. 8384512key_cache_age_threshold..................... 300key_cache_block_size........................ 1024key_cache_division_limit.................... 100language.................................... /usr/share/mysql/english/large_files_support......................... ONlarge_page_size............................. 0large_pages................................. OFFlc_time_names............................... en_USlicense..................................... GPLlocal_infile................................ ONlocked_in_memory............................ OFFlog......................................... OFFlog_bin..................................... OFFlog_bin_trust_function_creators............. OFFlog_error................................... log_queries_not_using_indexes............... OFFlog_slave_updates........................... OFFlog_slow_queries............................ OFFlog_warnings................................ 1long_query_time............................. 10low_priority_updates........................ OFFlower_case_file_system...................... OFFlower_case_table_names...................... 1max_allowed_packet.......................... 1048576max_binlog_cache_size....................... 4294963200max_binlog_size............................. 1073741824max_connect_errors.......................... 10max_connections............................. 2500max_delayed_threads......................... 20max_error_count............................. 64max_heap_table_size......................... 16777216max_insert_delayed_threads.................. 20max_join_size............................... 4294967295max_length_for_sort_data.................... 1024max_prepared_stmt_count..................... 16382max_relay_log_size.......................... 0max_seeks_for_key........................... 4294967295max_sort_length............................. 1024max_sp_recursion_depth...................... 0max_tmp_tables.............................. 32max_user_connections........................ 0max_write_lock_count........................ 4294967295multi_range_count........................... 256myisam_data_pointer_size.................... 6myisam_max_sort_file_size................... 2146435072myisam_mmap_size............................ 4294967295myisam_recover_options...................... OFFmyisam_repair_threads....................... 1myisam_sort_buffer_size..................... 8388608myisam_stats_method......................... nulls_unequalnet_buffer_length........................... 16384net_read_timeout............................ 30net_retry_count............................. 10net_write_timeout........................... 60new......................................... OFFold_passwords............................... ONopen_files_limit............................ 12500optimizer_prune_level....................... 1optimizer_search_depth...................... 62pid_file.................................... /var/run/mysqld/mysqld.pidplugin_dir.................................. port........................................ 3306preload_buffer_size......................... 32768protocol_version............................ 10query_alloc_block_size...................... 8192query_cache_limit........................... 1048576query_cache_min_res_unit.................... 4096query_cache_size............................ 0query_cache_type............................ ONquery_cache_wlock_invalidate................ OFFquery_prealloc_size......................... 8192range_alloc_block_size...................... 4096read_buffer_size............................ 131072read_only................................... OFFread_rnd_buffer_size........................ 262144relay_log................................... relay_log_index............................. relay_log_info_file......................... relay-log.inforelay_log_purge............................. ONrelay_log_space_limit....................... 0rpl_recovery_rank........................... 0secure_auth................................. OFFsecure_file_priv............................ server_id................................... 0skip_external_locking....................... ONskip_networking............................. OFFskip_show_database.......................... OFFslave_compressed_protocol................... OFFslave_load_tmpdir........................... /tmp/slave_net_timeout........................... 3600slave_skip_errors........................... OFFslave_transaction_retries................... 10slow_launch_time............................ 2socket...................................... /var/lib/mysql/mysql.socksort_buffer_size............................ 2097144sql_big_selects............................. ONsql_mode.................................... sql_notes................................... ONsql_warnings................................ OFFssl_ca...................................... ssl_capath.................................. ssl_cert.................................... ssl_cipher.................................. ssl_key..................................... storage_engine.............................. MyISAMsync_binlog................................. 0sync_frm.................................... ONsystem_time_zone............................ EDTtable_cache................................. 64table_lock_wait_timeout..................... 50table_type.................................. MyISAMthread_cache_size........................... 35thread_stack................................ 196608time_format................................. %H:%i:%stime_zone................................... SYSTEMtimed_mutexes............................... OFFtmp_table_size.............................. 1024tmpdir...................................... /tmp/transaction_alloc_block_size................ 8192transaction_prealloc_size................... 4096tx_isolation................................ REPEATABLE-READupdatable_views_with_limit.................. YESversion..................................... 5.0.95version_bdb................................. Sleepycat Software: Berkeley DB 4.1.24: (December 16, 2011)version_comment............................. Source distributionversion_compile_machine..................... i686version_compile_os.......................... redhat-linux-gnuwait_timeout................................ 28800Estou a disposição para passar maiore informações.Obrigado Citar Link para o comentário Compartilhar em outros sites More sharing options...
0 Jhonas Postado Maio 27, 2012 Denunciar Share Postado Maio 27, 2012 troque pela versão do mysql 5.1 e veja a diferençahttp://www.google.com.br/search?hl=pt-BR&a...0.0.GSfX67-A9fwabraço Citar Link para o comentário Compartilhar em outros sites More sharing options...
Pergunta
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
Link para o comentário
Compartilhar em outros sites
1 resposta a esta questão
Posts Recomendados
Participe da discussão
Você pode postar agora e se registrar depois. Se você já tem uma conta, acesse agora para postar com sua conta.