在重新启动服务器之后,除了"mysql“之外,一切都正常启动,我尝试手动启动"/etc/init.d/mysql restart”,或者使用"service mysql restart“启动它,它失败了在日志文件中写着:
Jul 16 08:13:38 localhost /etc/init.d/mysql[18136]: error: 'Can't connect to local My
mysqldump: Couldn't execute 'show fields from `tablename`': Out of resources when opening file './databasename/tablename#P#p125.MYD' (Errcode: 24) (23)>>perror 24
我该如何解决这个问题?
有关版本的信息: mysql 8.0.21-0ubuntu0.20.04.4 for Linuxonx86_64 ((Ubuntu))/etc/mysql/mysql.conf.d/mysqld.cnf
user = mysqlkey_buffer_size= 16M
myisam-recover-options
Installing new version of config file /etc/init.d/mysql ...Processing triggers for libc-bin (2.19-0ubuntu6.6) ...alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
/etc/ini