/ Register

Learn about Centmin Mod LEMP Stack today
Become a Member

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

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

Previous Thread Next Thread
Loading...
  1. Feb 23, 2017 #1
    pamamolf

    pamamolf Premium Member Premium Member

    4,086
    428
    83
    May 31, 2014
    Ratings:
    +834
    Local Time:
    8:26 AM
    Nginx-1.25.x
    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:

    Code:
    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?

    Thanks
     
  2. Feb 23, 2017 #2
    eva2000

    eva2000 Administrator Staff Member

    54,892
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    4:26 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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 ;)
     
Previous Thread Next Thread
Loading...

.