Script ends at Join section

[Robert Sanchez]

The script ends with the following error:

/mysql_scripts/tuning-primer.sh: 401: local: 2097152: bad variable name

right after outputting the header for the JOIN section.

Relevant system information:

# mysql -V
mysql Ver 15.1 Distrib 5.5.31-MariaDB, for debian-linux-gnu (i686) using readline 5.1

Ubuntu 12.04.2 LTS

[massimo morselli (mmorselli)]

at line 401 tuning-primer attempt to get join_buffer_size doing:

mysql -Bse "show variables like 'join_buffer%'"

but unlike myslq, MariaDB have two variables that match:

join_buffer_size
join_buffer_space_limit

so, to fix, simply change line 943 from:

mysql_variable \'join_buffer%\' join_buffer_size

to

mysql_variable \'join_buffer_size%\' join_buffer_size