xtrabackup timeout bug

iteye_17322

于 2010-06-13 10:21:34 发布

阅读量133

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql/postgresql 文章标签： MySQL

本文链接：https://blog.youkuaiyun.com/iteye_17322/article/details/81884560

mysql/postgresql 专栏收录该内容

45 篇文章

订阅专栏

I modified /usr/bin/innobackupex-1.5.1 like this:

    if (compare_versions($mysql_server_version, '4.0.22') == 0
        || compare_versions($mysql_server_version, '4.1.7') == 0) {
        # MySQL server version is 4.0.22 or 4.1.7
        mysql_send "COMMIT;";
        mysql_send "set interactive_timeout=28800;"; #added by gu lei
        mysql_send "set wait_timeout=28800;"; #added by gulei
        mysql_send "FLUSH TABLES WITH READ LOCK;";
    } else {
        # MySQL server version is other than 4.0.22 or 4.1.7
        mysql_send "set interactive_timeout=28800;"; #added by gu lei
        mysql_send "set wait_timeout=28800;"; #added by gu lei
        mysql_send "FLUSH TABLES WITH READ LOCK;";
        mysql_send "COMMIT;";
    }

Xtrabackup is successfully now.