Illegal division by zero

[vesatoivonen]

Running freshly cloned repo and mariadb 10.3.12

 Illegal division by zero at mysqltuner.pl line 2573 (#1)
    (F) You tried to divide a number by 0.  Either something was wrong in
    your logic, or you need to put a conditional in to guard against
    meaningless input.
    
Uncaught exception from user code:
    Illegal division by zero at mysqltuner.pl line 2573.
    main::calculations() called at mysqltuner.pl line 6307

[jmrenouard]

Hi @vesatoivonen

Do you restart your server just before running mysqltuner ?

This expression $mystat{'Uptime'} returns 0.

So, this means that you don't let mariaDb run during enougth time in order to get accurated information.

[jmrenouard]

Adding a test for uptime = 0 and set up uptime to 1 sec. at least

[vesatoivonen]

Actually, yes.
I have since lost the command chain used, but it was something like sudo systemctl restart mysql.service && perl mysqltuner.pl

[jmrenouard]

You should wait at least a complete day to see useful information in your status.

[jmrenouard]

So, I fixed it.

I also push a notification on README. Don't use mysqltuner on a fresh restarted server and wait at least one day of full production to get accurated results.

[vesatoivonen]

OK, thanks a lot!