Learn about Centmin Mod LEMP Stack today
Register Now

MariaDB 2013: Lost connection to MySQL when optimizing an InnoDB table

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by pamamolf, Feb 23, 2017.

  1. pamamolf

    pamamolf Premium Member Premium Member

    May 31, 2014
    Local Time:
    12:03 AM
    MariaDB 10.3.x
    Please fill in any relevant information that applies to you:
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed: 123.09beta01
    • Nginx Version Installed: 1.11.10
    • PHP Version Installed: 5.6.30
    • MariaDB MySQL Version Installed: 10.1.21
    • When was last time updated Centmin Mod code base ? :Today

    Hello :)

    I just try to optimize a big Innodb table from ssh and i got an error:

    mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'OPTIMIZE TABLE ... '
    table is 3GB in size....

    Checking on the net that maybe is related to max allowed packet.... ?

    If that's the case isn't better to have a higher value for it on default Centminmod installation?

  2. eva2000

    eva2000 Administrator Staff Member

    May 24, 2014
    Brisbane, Australia
    Local Time:
    7:03 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Centmin Mod is provide as is, so short of scripted related bugs or issues, any further optimisation to the web stack components - nginx, php-fpm, mariadb mysql, csf firewall etc or web app specific configurations are left to the Centmin Mod user to deal with. So I do not provide any free support for such.

    However, Centmin Mod users are free to help each other out and ask questions or give answers on this community forum. My hopes are that this community forum evolves so that more veteran long time Centmin Mod users help new Centmin Mod users out :)

    With that said, tuning for MariaDB MySQL for your specific usage patterns is left to you the end user https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html ;)