• 0
Sign in to follow this  
arnaldo_zyl

MYSQL - CONFIGURAÇÃO

Question

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:

[[email protected] ~]# 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

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this