Description of problem: It is not possible to the the MySQL variable "max_allowed_packet" in /etc/my.cnf Version-Release number of selected component (if applicable): How reproducible: Install MySQL, check the mysql cartridge Steps to Reproduce: 1. Install MySQL 2. 3. Actual results: n/a Expected results: There should be an environment variable OPENSHIFT_MYSQL_MAX_ALLOWED_PACKET Additional info:
config option added here: https://github.com/openshift/origin-server/pull/6088
Commit pushed to master at https://github.com/openshift/origin-server https://github.com/openshift/origin-server/commit/4fc13e4797e1fb0ae5521807c8d9967ec02e51db Bug 1197825 - Unable to set max_allowed_packet for MySQL https://bugzilla.redhat.com/show_bug.cgi?id=1197825 It is not possible to the the MySQL variable "max_allowed_packet" in /etc/my.cnf
Verified on devenv_5455: 1. Create an app with mysql5.5/5.1 embbed 2. rhc env set OPENSHIFT_MYSQL_MAX_ALLOWED_PACKET=123M -a app 3. Restart app 4. SSH to app and check the value of max_allowed_packet: mysql>show variables like 'max%' ; 5. It will display the updated value as below: +----------------------------+----------------------+ | Variable_name | Value | +----------------------------+----------------------+ | max_allowed_packet | 128974848 | Instead of its original value: +----------------------------+----------------------+ | Variable_name | Value | +----------------------------+----------------------+ | max_allowed_packet | 209715200 |
Wow, that was fast! Thanks! :)
np, however due to our production release cycle this change won't be in openshift online for about 6 weeks.