Skip to content

Mysql tunner compatibility with mysql 8.4 #824

@Lucas-atabey

Description

@Lucas-atabey

We have this error on using mysqltunner (version 2.6.2) with a mysql 8.4.0-1 version database

Image

I fixed the error with this code (mysqltuner.pl -> line 1431):

    my @mysqlslave;
    if ( mysql_version_eq(8) or mysql_version_ge( 10, 5 ) ) {
        @mysqlslave = select_array("SHOW REPLICA STATUS\\G");
    }
    else {
        @mysqlslave = select_array("SHOW SLAVE STATUS\\G");
    }
    arr2hash( \%myrepl, \@mysqlslave, ':' );
    $result{'Replication'}{'Status'} = \%myrepl;

    my @mysqlslaves;
    if ( mysql_version_eq(8) or mysql_version_ge( 10, 5 ) ) {
        @mysqlslaves = select_array "SHOW REPLICAS\\G";
    }
    else {
        @mysqlslaves = select_array("SHOW SLAVE HOSTS\\G");
    }

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions