Announcement

Collapse
No announcement yet.

how to modify mysql variables

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to modify mysql variables

    Hi...

    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

  • #2
    If you want the variable to be global (ie. all databases are affected) then edit /etc/my.cnf.
    Interested in Linux?
    Have a question?
    http://www.linuxquestions.org

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X