Selasa, 04 September 2018

Mysql ubuntu status checking for tables which need an upgrade, are corrupt or were not closed

  Tidak ada komentar
Some day i find a status of MySQL [info] checking for tables which need an upgrade, are corrupt or were not closed cleanly. after i upgrade the MySQL to 5.5.60. i am worry if the status info is an error, the i search on google about this problem although i can login MySQL normally , and i got the answer on bellow
maswachid@vta-cloud:~$ sudo service mysql status
[sudo] password for sysop:
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
   Active: active (running) since Sun 2018-09-02 16:58:11 WIB; 2 days ago
     Docs: man:systemd-sysv-generator(8)
    Tasks: 19
   Memory: 42.8M
      CPU: 1min 11.554s
   CGroup: /system.slice/mysql.service
           ├─75195 /bin/sh /usr/bin/mysqld_safe
           ├─75535 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --u
           └─75536 logger -t mysqld -p daemon error

Sep 02 16:58:11 vta-cloud mysql[75162]:    ...done.
Sep 02 16:58:11 vta-cloud mysql[75162]:  * Checking for tables which need an upgrade, are corrupt or were not closed cleanly.
Sep 02 16:58:11 vta-cloud mysql[75162]: not closed cleanly.
Sep 02 16:58:11 vta-cloud systemd[1]: Started LSB: Start and stop the mysql database server daemon.
Sep 02 16:58:12 vta-cloud /etc/mysql/debian-start[75595]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignore
Sep 02 16:58:12 vta-cloud /etc/mysql/debian-start[75595]: Looking for 'mysql' as: /usr/bin/mysql
Sep 02 16:58:12 vta-cloud /etc/mysql/debian-start[75595]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 02 16:58:12 vta-cloud /etc/mysql/debian-start[75595]: This installation of MySQL is already upgraded to 5.5.60
Sep 02 16:58:12 vta-cloud /etc/mysql/debian-start[75606]: Checking for insecure root accounts.
Sep 02 16:58:12 vta-cloud /etc/mysql/debian-start[75611]: Triggering myisam-recover for all MyISAM tables

This is an [info] message and displays due to the steps taken by the Debian mysql startup script. It is not an error.

If you read the line correctly you will see there is NO problem cause not corrupt table or anything else can be found
"Checking for corrupt, not cleanly closed and upgrade needing tables" so everything is ok.
Sources :
https://dba.stackexchange.com/questions/66214/moving-mysql-datadir-cause-info-checking-for-tables-which-need-an-upgrade
https://serverfault.com/questions/613533/how-to-fix-corrupt-not-cleanly-closed-and-upgrade-needing-tables-in-mysql

Tidak ada komentar :

Posting Komentar