piątek, 13 września 2013

when you have problem with mysql The partition with /var/lib/mysql is too full!

* Stopping MySQL database server mysqld [ OK ]
* /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full!


try to restart myql with sudo permissions and flush db logs
mysqladmin -u root -p flush-logs

of flush something more:

  flush-all-statistics    Flush all statistics tables
  flush-all-status        Flush status and statistics
  flush-client-statistics Flush client statistics
  flush-hosts             Flush all cached hosts
  flush-index-statistics  Flush index statistics
  flush-logs              Flush all logs
  flush-privileges        Reload grant tables (same as reload)
  flush-slow-log          Flush slow query log
  flush-status  Clear status variables
  flush-table-statistics  Clear table statistics
  flush-tables            Flush all tables
  flush-threads           Flush the thread cache
  flush-user-statistics   Flush user statistics
  kill id,id,... Kill mysql threads

Brak komentarzy:

Prześlij komentarz