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.
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
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.
