MYSQL磁盘diskbusy怎么查,MySQL下perror工具查看System Error Code信息

柔光的暖阳◎ 2023-01-16 09:58 81阅读 0赞

在MySQL数据库的维护过程中，我们有时候会在MySQL的错误日志文件中看到一些关于Operating system error的错误信息，例如在MySQL的错误日志里面，有时候会看到关于

InnoDB: Operating system error number 0.

InnoDB: Check that your OS and file system support files of this size.

InnoDB: Check also that the disk is not full or a disk quota exceeded.

InnoDB: Operating system error number 5.

...........................................

那么这些System Error Code在Linux下分别代表什么意思呢？其实如果遇到错误日志里有这些对应的代码，使用MySQL自带的命令工具perror查看一下具体信息即可。非常简单方便。

\[root@DB-Server ~\]\# perror 2;

OS error code2:No such file or directory

\[root@DB-Server ~\]\# perror 3;

OS error code3:No such process

\[root@DB-Server ~\]\# perror 4;

OS error code4:Interrupted system call

\[root@DB-Server ~\]\# perror 5;

OS error code5:Input/output error

\[root@DB-Server ~\]\#

如果你要查看一个范围的Operating system error，可以使用下面命令

\[root@DB-Server ~\]\# perror \`seq 0 10\`

OS error code0:Success

OS error code1:Operation not permitted

OS error code2:No such file or directory

OS error code3:No such process

OS error code4:Interrupted system call

OS error code5:Input/output error

OS error code6:No such device or address

OS error code7:Argument list too long

OS error code8:Exec format error

OS error code9:Bad file descriptor

OS error code10:No child processes

\[root@DB-Server ~\]\#

如果是集群，那么可以shell> perror --ndb errorcode查看， 下面表格是关于Linux平台下通用的System Error Code列表，如下所示，完全没有必要硬性记住。遇到查看即可。

Number

Macro

Description

EPERM

Operation not permitted

ENOENT

No such file or directory

ESRCH

No such process

EINTR

Interrupted system call

EIO

I/O error

ENXIO

No such device or address

E2BIG

Arg list too long

ENOEXEC

Exec format error

EBADF

Bad file number

ECHILD

No child processes

EAGAIN

Try again

ENOMEM

Out of memory

EACCES

Permission denied

EFAULT

Bad address

ENOTBLK

Block device required

EBUSY

Device or resource busy

EEXIST

File exists

EXDEV

Cross-device link

ENODEV

No such device

ENOTDIR

Not a directory

EISDIR

Is a directory

EINVAL

Invalid argument

ENFILE

File table overflow

EMFILE

Too many open files

ENOTTY

Inappropriate ioctl for device

ETXTBSY

Text file busy

EFBIG

File too large

ENOSPC

No space left on device

ESPIPE

Illegal seek

EROFS

Read-only file system

EMLINK

Too many links

如果是Windows平台，那么也可以使用下面命令查看具体的System Error Code信息，另外，Windows平台下的System Error Code也远比Linux平台下要多，遇到了这些System Error Code，使用命令查看即可。

perror.exe 2

perror \`perl -e "print join ' ',1..100"\`

参考资料：

http://doc.docs.sk/mysql-refman-5.5/operating-system-error-codes.html

MYSQL磁盘diskbusy怎么查,MySQL下perror工具查看System Error Code信息

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关怎么查看mysql密码

相关 mysql磁盘占用查看

相关 MYSQL磁盘diskbusy怎么查,MySQL下perror工具查看System Error Code信息

相关 MySQL Error Code: 1175

相关【fdisk】查看磁盘信息

相关解决MySql Error Code: 2006

相关 linux下查看磁盘信息

相关 MySQL下perror工具查看System Error Code信息

相关 mysql 之 Error Code: 1175

相关 MySQL Error Code：1093，Error Code：1248