MySQL Bugs: #52797: MySQL Manager truncates long my.cnf values

Bug #52797	MySQL Manager truncates long my.cnf values
Submitted:	14 Apr 2010 0:22	Modified:	21 Mar 2011 23:42
Reporter:	Adam Dixon	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	Instance Manager	Severity:	S3 (Non-critical)
Version:	1.0-beta	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
When using a very large setting for innodb_data_file_path - it is truncated in mysqlmanager from version 5.1 -- where this previously worked in mysqlmanager provided with 5.0 (verified).

The configuration looks like this;
innodb_data_file_path =  d1/dat/i001:32M;d1/dat/i002:32M;d1/dat/i003:32M;d1/dat/i004:32M;d1/dat/i005:32M;d1/dat/i006:32M;d1/dat/i007:32M;d1/dat/i008:32M;d1/dat/i009:32M;d1/dat/i010:32M;d1/dat/i011:32M;d1/dat/i012:32M;d1/dat/i013:32M;d1/dat/i014:32M;d1/dat/i015:32M;d1/dat/i016:32M;d1/dat/i017:32M;d1/dat/i018:32M;d1/dat/i019:32M;d1/dat/i020:32M;d1/dat/i021:32M;d1/dat/i022:32M;d1/dat/i023:32M;d1/dat/i024:32M;d1/dat/i025:32M;d1/dat/i026:32M;d1/dat/i027:32M;d1/dat/i028:32M;d1/dat/i029:32M;d1/dat/i030:32M;d1/dat/i031:32M;d1/dat/i032:32M;d1/dat/i033:32M;d1/dat/i034:32M;d1/dat/i035:32M;d1/dat/i036:32M;d1/dat/i037:32M;d1/dat/i038:32M;d1/dat/i039:32M;d1/dat/i040:32M;d1/dat/i041:32M;d1/dat/i042:32M;d1/dat/i043:32M;d1/dat/i044:32M;d1/dat/i045:32M;d1/dat/i046:32M;d1/dat/i047:32M;d1/dat/i048:32M;d1/dat/i049:32M;d1/dat/i050:32M;d1/dat/i051:32M;d1/dat/i052:32M;d1/dat/i053:32M;d1/dat/i054:32M;d1/dat/i055:32M;d1/dat/i056:32M;d1/dat/i057:32M;d1/dat/i058:32M;d1/dat/i059:32M;d1/dat/i060:32M;d1/dat/i061:32M;d1/dat/i062:32M;d1/dat/i063:32M;d1/dat/i064:32M;d1/dat/i065:32M;d1/dat/i066:32M;d1/dat/i067:32M;d1/dat/i068:32M;d1/dat/i069:32M;d1/dat/i070:32M;d1/dat/i071:32M;d1/dat/i072:32M;d1/dat/i073:32M;d1/dat/i074:32M;d1/dat/i075:32M;d1/dat/i076:32M;d1/dat/i077:32M;d1/dat/i078:32M;d1/dat/i079:32M;d1/dat/i080:32M;d1/dat/i081:32M;d1/dat/i082:32M;d1/dat/i083:32M;d1/dat/i084:32M;d1/dat/i085:32M;d1/dat/i086:32M;d1/dat/i087:32M;d1/dat/i088:32M;d1/dat/i089:32M;d1/dat/i090:32M;d1/dat/i091:32M;d1/dat/i092:32M;d1/dat/i093:32M;d1/dat/i094:32M;d1/dat/i095:32M;d1/dat/i096:32M;d1/dat/i097:32M;d1/dat/i098:32M

When you start it with mysqlmanager it stops at file 64.

mysql    28232  0.1  0.0  29944  1692 pts/1    Sl   09:43   0:00 ./bin/mysqlmanager --mysqld-safe-compatible --user=mysql --pid-file=/tmp/manager.pid
mysql    28252  4.1  0.6 204952 22472 pts/1    Sl   09:43   0:08 /usr/local/mysql5144/bin/mysqld --no-defaults --socket=/tmp/mysql.sock --port=3306 --server_id=1 --datadir=/usr/local/mysql5144/data/ --log-error --basedir=/usr/local/mysql5144/ --innodb_data_home_dir=/usr/local/mysql5144/data/ --innodb_data_file_path=d1/dat/i001:32M;d1/dat/i002:32M;d1/dat/i003:32M;d1/dat/i004:32M;d1/dat/i005:32M;d1/dat/i006:32M;d1/dat/i007:32M;d1/dat/i008:32M;d1/dat/i009:32M;d1/dat/i010:32M;d1/dat/i011:32M;d1/dat/i012:32M;d1/dat/i013:32M;d1/dat/i014:32M;d1/dat/i015:32M;d1/dat/i016:32M;d1/dat/i017:32M;d1/dat/i018:32M;d1/dat/i019:32M;d1/dat/i020:32M;d1/dat/i021:32M;d1/dat/i022:32M;d1/dat/i023:32M;d1/dat/i024:32M;d1/dat/i025:32M;d1/dat/i026:32M;d1/dat/i027:32M;d1/dat/i028:32M;d1/dat/i029:32M;d1/dat/i030:32M;d1/dat/i031:32M;d1/dat/i032:32M;d1/dat/i033:32M;d1/dat/i034:32M;d1/dat/i035:32M;d1/dat/i036:32M;d1/dat/i037:32M;d1/dat/i038:32M;d1/dat/i039:32M;d1/dat/i040:32M;d1/dat/i041:32M;d1/dat/i042:32M;d1/dat/i043:32M;d1/dat/i044:32M;d1/dat/i045:32M;d1/dat/i046:32M;d1/dat/i047:32M;d1/dat/i048:32M;d1/dat/i049:32M;d1/dat/i050:32M;d1/dat/i051:32M;d1/dat/i052:32M;d1/dat/i053:32M;d1/dat/i054:32M;d1/dat/i055:32M;d1/dat/i056:32M;d1/dat/i057:32M;d1/dat/i058:32M;d1/dat/i059:32M;d1/dat/i060:32M;d1/dat/i061:32M;d1/dat/i062:32M;d1/dat/i063:32M;d1/dat/i064:32M; --pid-file=mysqld1-dixon.pid

How to repeat:
Use the attached my.cnf and switch between versions by changing references to 5144 binary distribution to the 5.0 on your filesystem.

Watch 5.0 work and 5.1 stop at 64.

Limit appears to be 1024 chars.

Attachment: my.cnf (application/octet-stream, text), 2.00 KiB.

If I added basedir to mysql.server in my.cnf it used mysqlmanager binary from 5.0 and started 5.1 -- this worked.

mysql      457  0.0  0.0  29616  1396 pts/2    Sl   10:01   0:00 /usr/local/mysql5087//bin/mysqlmanager --user=mysql --pid-file=/tmp/manager.pid
mysql      468  9.4  0.4  94372 16016 pts/2    Dl   10:01   0:10 /usr/local/mysql5144/bin/mysqld --no-defaults --socket=/tmp/mysql.sock --port=3306 --server_id=1 --datadir=/usr/local/mysql5144/data/ --log-error --basedir=/usr/local/mysql5144/ --innodb_data_home_dir=/usr/local/mysql5144/data/ --innodb_data_file_path=d1/dat/i001:32M;d1/dat/i002:32M;d1/dat/i003:32M;d1/dat/i004:32M;d1/dat/i005:32M;d1/dat/i006:32M;d1/dat/i007:32M;d1/dat/i008:32M;d1/dat/i009:32M;d1/dat/i010:32M;d1/dat/i011:32M;d1/dat/i012:32M;d1/dat/i013:32M;d1/dat/i014:32M;d1/dat/i015:32M;d1/dat/i016:32M;d1/dat/i017:32M;d1/dat/i018:32M;d1/dat/i019:32M;d1/dat/i020:32M;d1/dat/i021:32M;d1/dat/i022:32M;d1/dat/i023:32M;d1/dat/i024:32M;d1/dat/i025:32M;d1/dat/i026:32M;d1/dat/i027:32M;d1/dat/i028:32M;d1/dat/i029:32M;d1/dat/i030:32M;d1/dat/i031:32M;d1/dat/i032:32M;d1/dat/i033:32M;d1/dat/i034:32M;d1/dat/i035:32M;d1/dat/i036:32M;d1/dat/i037:32M;d1/dat/i038:32M;d1/dat/i039:32M;d1/dat/i040:32M;d1/dat/i041:32M;d1/dat/i042:32M;d1/dat/i043:32M;d1/dat/i044:32M;d1/dat/i045:32M;d1/dat/i046:32M;d1/dat/i047:32M;d1/dat/i048:32M;d1/dat/i049:32M;d1/dat/i050:32M;d1/dat/i051:32M;d1/dat/i052:32M;d1/dat/i053:32M;d1/dat/i054:32M;d1/dat/i055:32M;d1/dat/i056:32M;d1/dat/i057:32M;d1/dat/i058:32M;d1/dat/i059:32M;d1/dat/i060:32M;d1/dat/i061:32M;d1/dat/i062:32M;d1/dat/i063:32M;d1/dat/i064:32M;d1/dat/i065:32M;d1/dat/i066:32M;d1/dat/i067:32M;d1/dat/i068:32M;d1/dat/i069:32M;d1/dat/i070:32M;d1/dat/i071:32M;d1/dat/i072:32M;d1/dat/i073:32M;d1/dat/i074:32M;d1/dat/i075:32M;d1/dat/i076:32M;d1/dat/i077:32M;d1/dat/i078:32M;d1/dat/i079:32M;d1/dat/i080:32M;d1/dat/i081:32M;d1/dat/i082:32M;d1/dat/i083:32M;d1/dat/i084:32M;d1/dat/i085:32M;d1/dat/i086:32M;d1/dat/i087:32M;d1/dat/i088:32M;d1/dat/i089:32M;d1/dat/i090:32M;d1/dat/i091:32M;d1/dat/i092:32M;d1/dat/i093:32M;d1/dat/i094:32M;d1/dat/i095:32M;d1/dat/i096:32M;d1/dat/i097:32M;d1/dat/i098:32M --pid-file=mysqld1-dixon.pid

Mysqlmanager is deprecated in 5.5 - this issue will not be fixed in 5.1.