I got a question a while ago about how Percona Server handles corrupted data more gracefully than the standard MySQL server from Oracle. The short version is that it won’t crash the whole server. With standard MySQL from Oracle, if any page of data in InnoDB is found to be corrupt, the entire instance will [...] [...more]
Working with customer, I faced pretty nasty bug, which is actually not rare situation , but in this particular there are some lessons I would like to share. The case is pretty much described in bug 55981, or in pastebin. Everything below is related to InnoDB-plugin/XtraDB, but not to regular InnoDB ( i.e in MySQL [...] [...more]
In Linux and other Unix-like operating system, you can detect and repair hard drive errors using fsck command. This command runs in 5 phases. In the first phase, it checks data blocks and their size while in second phase file and directory pathnames are checked. In the remaining three phases, the connectivity, file reference counts [...] [...more]
In Linux and other Unix-like operating system, you can detect and repair hard drive errors using fsck command. This command runs in 5 phases. In the first phase, it checks data blocks and their size while in second phase file and directory pathnames are checked. In the remaining three phases, the connectivity, file reference counts [...] [...more]
In Linux operating system, FSCK (File System Check) is a useful utility that allows you to examine the integrity and consistency of your Linux file system. The utility also offers you an alternative method to repair damaged file system and review the problems that have to be fixed on your file system. Though, this tool [...] [...more]