Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #898138: pt-variable-advisor doesn't recognize 5.5.3+ concurrent_insert values

Description

**Reported in Launchpad by Ryan Lowe last update 19-06-2012 20:02:51

mysql> SELECT @@version;
------------

@@version

------------

5.5.10-log

------------
1 row in set (0.00 sec)

mysql> show global variables like 'concurrent_insert';
--------------------------+

Variable_name

Value

--------------------------+

concurrent_insert

AUTO

--------------------------+
1 row in set (0.00 sec)
...
$ ./pt-variable-advisor --version
pt-variable-advisor 1.0.1
$ ./pt-variable-advisor localhost
Code for rule concurrent_insert caused an error: Argument "AUTO" isn't numeric in numeric gt (>) at ./pt-variable-advisor line 2766.
...

According to the docs (http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_concurrent_insert), this is a valid value.

Environment

None

Smart Checklist

Activity

lpjirasync January 24, 2018 at 3:00 PM

**Comment from Launchpad by: Daniel Nichter on: 24-05-2012 20:53:41

This was reported for 1.0.1 but that series is no longer supported, so WontFix that, and fixed in 2.0 and 2.1.

Done

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 3:00 PM
Updated January 24, 2018 at 3:00 PM
Resolved January 24, 2018 at 3:00 PM