mySQL configuration (like PHP)

[iantresman]

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.

 

[SakibS]

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

 

[iantresman]

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.