MySQL check warning

[LotharSee]

In the info page:

Warning: Cannot compute mysql version assuming older than 5.0.2: 'MySql' object has no attribute 'db'

Happened on MySQL 5.1.x on Red Hat but also Debian Squeeze.

[conorbranagan]

Did this cause any other issues other than just not being able to get the version number? What do we use the version number for?

[LotharSee]

As a result, some metrics were wrong.

Some commands changed between <5.0.2 and >5.0.2. We use this version number to know which command to execute.
Exemple: SHOW STATUS LIKE 'Slow_queries' became SHOW GLOBAL STATUS LIKE 'Slow_queries'.

Are concerned:
'mysql.performance.created_tmp_disk_tables', 'mysql.performance.slow_queries', 'mysql.performance.questions', 'mysql.performance.queries'
Without this fix, those 4 metrics are wrong (value 0) on all 5.0.2+ MySQL.

[miketheman]

Can we determine what version this was introduced in, so we can reliably state 'any users with dd-agent version X--Y using MySQL 5.1.x should use version 3.8.1'?

[LotharSee]

It is hard to say because I fixed multiple bugs in the same time, and for sure one of them was here since this check was moved to checks.d (Agent 3.6.2). I didn't check if it also concerns the old MySQL check (i.e. before 3.6.2).

Because we probably have other bugs (at least this one: #559), I will probably review the whole check.

[olidb2]

Can we binary-search the versions of the agent by testing them?

On Mon, Jul 1, 2013 at 1:50 PM, Benjamin Fernandes <notifications@github.com

wrote:

It is hard to say because I fixed multiple bugs in the same time, and for
sure one of them was here since this check was moved to checks.d (Agent
3.6.2). I didn't check if it also concerns the old MySQL check.

Because we probably have other bugs (at least this one: #559#559),
I will probably review the whole check.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/558#issuecomment-20298316
.

[zorkian]

I'm getting this right now. I have 5.5.31-30.3-log from Percona, and a fresh Datadog Agent installed today (just signed up).