bad variable name

Bug #1781697 reported by Inspired on 2018-07-14
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
MySQL Tuning Primer Script
Undecided
Unassigned

Bug Description

This same error was reported here https://bugs.launchpad.net/bugs/1202940. However, this is a over 4 years later, so I am submitting a fresh report.

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.

mysql -v provides:

Your MariaDB connection id is 15324930
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1

Is it not possible for the script to do some fault handling / testing with regard to which `join_buffer` variation to use, depending on the MySQL environment?

Inspired (inspired) on 2018-07-14
description: updated
Jack Holborn (jackho) wrote :

Trying to debug I could get rid of the error by replacing as so on line 943 :

- mysql_variable \'join_buffer%\' join_buffer_size
+ mysql_variable \'join_buffer_size\' join_buffer_size

I'm not sure why '%' was used here, but it seems to work.

This script is no longer maintained

On Tue, Aug 7, 2018 at 11:46 AM, Jack Holborn <email address hidden>
wrote:

> Trying to debug I could get rid of the error by replacing as so on line
> 943 :
>
> - mysql_variable \'join_buffer%\' join_buffer_size
> + mysql_variable \'join_buffer_size\' join_buffer_size
>
> I'm not sure why '%' was used here, but it seems to work.
>
> --
> You received this bug notification because you are subscribed to MySQL
> Tuning Primer Script.
> https://bugs.launchpad.net/bugs/1781697
>
> Title:
> bad variable name
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/mysql-tuning-primer/+bug/1781697/+subscriptions
>

TodoInTX (matt-day32) wrote :

Older versions of MySQL (<4.0) named the variable simply join_buffer. The
% was a compatibility requirement.

On Tue, Aug 7, 2018 at 1:40 PM, Matthew Montgomery <email address hidden> wrote:

> This script is no longer maintained
>
> On Tue, Aug 7, 2018 at 11:46 AM, Jack Holborn <email address hidden>
> wrote:
>
>> Trying to debug I could get rid of the error by replacing as so on line
>> 943 :
>>
>> - mysql_variable \'join_buffer%\' join_buffer_size
>> + mysql_variable \'join_buffer_size\' join_buffer_size
>>
>> I'm not sure why '%' was used here, but it seems to work.
>>
>> --
>> You received this bug notification because you are subscribed to MySQL
>> Tuning Primer Script.
>> https://bugs.launchpad.net/bugs/1781697
>>
>> Title:
>> bad variable name
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/mysql-tuning-primer/+bug/1781697/
>> +subscriptions
>>
>
>

TodoInTX (matt-day32) wrote :

Please use : https://github.com/major/MySQLTuner-perl

On Tue, Aug 7, 2018 at 1:45 PM, Matthew Montgomery <email address hidden> wrote:

> Older versions of MySQL (<4.0) named the variable simply join_buffer. The
> % was a compatibility requirement.
>
> On Tue, Aug 7, 2018 at 1:40 PM, Matthew Montgomery <email address hidden> wrote:
>
>> This script is no longer maintained
>>
>> On Tue, Aug 7, 2018 at 11:46 AM, Jack Holborn <<email address hidden>
>> > wrote:
>>
>>> Trying to debug I could get rid of the error by replacing as so on line
>>> 943 :
>>>
>>> - mysql_variable \'join_buffer%\' join_buffer_size
>>> + mysql_variable \'join_buffer_size\' join_buffer_size
>>>
>>> I'm not sure why '%' was used here, but it seems to work.
>>>
>>> --
>>> You received this bug notification because you are subscribed to MySQL
>>> Tuning Primer Script.
>>> https://bugs.launchpad.net/bugs/1781697
>>>
>>> Title:
>>> bad variable name
>>>
>>> To manage notifications about this bug go to:
>>> https://bugs.launchpad.net/mysql-tuning-primer/+bug/1781697/
>>> +subscriptions
>>>
>>
>>
>

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers