Always i'm seeing posts on requesting to change mysql variables to make vB working better.
Like :
key_buffer=20M
max_connections=200
sort_buffer=4000000
But, how to modify the mysql variables guys.
This is my mysql variables
+----------------------------+------------------
Variable_name Value
+----------------------------+------------------
back_log 5
connect_timeout 5
basedir /
datadir /var/lib/mysql/
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
join_buffer 131072
flush_time 0
key_buffer 20967424
language /usr/share/mysql/english/
log OFF
log_update OFF
long_query_time 10
low_priority_updates OFF
max_allowed_packet 1048576
max_connections 100
max_connect_errors 10
max_delayed_insert_threads 20
max_join_size 4294967295
max_sort_length 1024
max_write_lock_count 4294967295
net_buffer_length 16384
port 3306
protocol_version 10
record_buffer 131072
skip_locking ON
skip_networking OFF
socket /var/lib/mysql/mysql.sock
sort_buffer 2097144
table_cache 64
thread_stack 65536
tmp_table_size 1048576
tmpdir /tmp/
version 3.22.32
wait_timeout 4000 ---------------------------------
What commands i need to use to change the variable
#If you have any other info about this subject , Please add it free.# |
