line 402: export: `2097152': not a valid identifier

[1x6PY78]

Hi,

when using tuning-primer 1.6r1 together with 5.5.28-MariaDB-mariadb1~squeeze-log on a debian squeeze server this message is shown in the JOINS section of the tuning primer output:

./tuning-primer.sh: line 402: export: `2097152': not a valid identifier

[Horst Schirmeier (horst)]

Same here, mariadb-server (and -client) 5.5.30-mariadb1~squeeze.

[Horst Schirmeier (horst)]

This bug is harmless (the script works perfectly besides showing this error message), but easily fixable. MariaDB introduces a second server variable that starts with 'join_buffer' (namely join_buffer_space_limit), and the mysql_variable() function in tuning-primer.sh cannot handle mysql returning multiple variable/value pairs.

Fix attached. Available MySQL documentation doesn't talk about any other server variable starting with 'join_buffer%' besides join_buffer_size (there's no older documentation online than this one: http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html#sysvar_join_buffer_size), so I guess it's safe to replace the wildcard with the complete variable name.

[1x6PY78 (1x6py78)]

Thanks for this information,

i can confirm that the attached patch fixes the output of this error on my system.

[pamamold (jimspiti)]

Why not add this to default download?