Learn about Centmin Mod LEMP Stack today
Register Now

Beta Branch update cminfo command & mytop config/routine in 123.09beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Nov 23, 2019.

  1. eva2000

    eva2000 Administrator Staff Member

    45,405
    10,302
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,980
    Local Time:
    12:47 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    update cminfo command & mytop config/routine in 123.09beta01

    - If MariaDB MySQL server is running, the running 'cminfo top' command will also now display InnoDB Engine Status output for short ~10 seconds interval sample
    - If you run a newly added command via cronjob, 'cminfo top-cron' will do the same just the sample interval will be <= 60 seconds
    - Add mysql extended status output & variables output
    - Updated mytop v1.91 at /usr/local/bin/mytop when running cminfo top command otherwise system mytop v1.7 will be used at /usr/bin/mytop
    - Ensure mytop /root/.mytop is properly configured and will be displayed in 'cminfo top' command output if variable CMINFO_MYTOP='y' is set in persistent config file /etc/centminmod/custom_config.inc. The mytop output will include process list info which may contain sensitive info like database names, database table names etc. So be careful posting 'cminfo top' output publicly online, forums etc. This process list info is useful for private troubleshooting if you set CMINFO_MYTOP='y' in persistent config file. The mytop display via cminto top command isn't as useful as batch mode doesn't show full mysql queries and is cut off unlike non-batch mode via running mytop manually so CMINFO_MYTOP variable isn't enabled by default.
    - Add variable CMINFO_MYSQL_PROCLIST='y' to persistent config file /etc/centminmod/custom_config.inc will enable 'cminfo top' command to display actual MySQL process list output at 1 second intervals for 5 runs or if 'cminfo top-cron', then for 20 runs. Disabled by default. The process list info may contain sensitive info like database names, database table names etc. So be careful posting 'cminfo top' output publicly online, forums etc. This process list info is useful for private troubleshooting if you set CMINFO_MYSQL_PROCLIST='y' in persistent config file
    - Update pidstat output so 'cminfo top' output has 10 seconds pidstat interval and 'cminfo top-cron' output has 20 seconds pidstat interval

    Continue reading...

    123.09beta01 branch