Buy Percona ServicesBuy Now!

Mysql data archiving with percona getting Lost connection to MySQL server

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql data archiving with percona getting Lost connection to MySQL server

    Data base is MYSQL and enabled constraints while arching the data . archiving is going smooth and after some time getting error at some table
    " DBD::mysql::st execute failed: Lost connection to MySQL server during query [for Statement "SELECT ............................"" .

    I increased the following mysql properties and tried but no luck getting same error,

    connect_timeout=31536000;
    interactive_timeout=31536000;
    wait_timeout=31536000;
    max_allowed_packet=1073741824;

    DBD::mysql::st execute failed: Lost connection to MySQL server during query [for Statement "SELECT /*!40001 SQL_NO_CACHE */ ........'] at /usr/bin/pt-archiver line 6773.

    TIME ELAPSED COUNT
    2018-07-12T03:49:24 0 0
    2018-07-12T04:08:21 1136 1000
    .
    .
    .
    2018-07-12T04:09:54 1229 55000
    2018-07-12T04:19:21 1797 56000

    real 150m2.297s
    user 0m4.776s
    sys 0m1.296s

    but no luck . can anybody help on this ? in advance i appreciate you.
Working...
X