mySQL configuration (like PHP)

Discussion in 'Feature Suggestions' started by iantresman, Feb 6, 2012.

  1. iantresman

    iantresman Junior Member

    Messages:
    19
    The newly added ability to globally configure PHP, would be nice to extend to mySQL. I recently had the need to change MAX_ALLOWED_PACKET in etc/my.cnf, which required SSH and a knowledge of my.cnf file.

    Would be great to have a (a) global (b) per subscription, ability to do this via the Control Panel.
     
  2. SakibS

    SakibS Hunter

    Messages:
    102
    Open your my.cnf file in pico or some kind of proper code/text editor:

    Your my.cnf file may look like this:
    [mysqld]
    max_connections = 150
    max_user_connections = 150
    key_buffer = 36M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 2M
    read_buffer_size = 2M
    sort_buffer_size = 3M
    table_cache = 1024
    thread_cache_size = 286
    interactive_timeout = 25
    wait_timeout = 1800
    connect_timeout = 10
    max_allowed_packet = 1M
    max_connect_errors = 1000
    query_cache_limit = 1M
    query_cache_size = 16M
    query_cache_type = 1
    tmp_table_size = 16M

    ______________

    SakibS [​IMG]
     
  3. iantresman

    iantresman Junior Member

    Messages:
    19
    Thanks for the info. Looks scary! Hopefully Parallel's will add a mySQL control panel like they have for PHP. For now, I'll contact my host to tweak the necessary files. Thanks again.
     

Share This Page