I do not know whether this is a mysql(version 5.6.11) bug, the case is as following. today when i update mysql conf and kill -9 and restart mysqld, i find that it can't restart anymore. after having a look at the error log, i find the following:
2013-07-09 17:04:21 7872 [ERROR] InnoDB: Tried to read 1048576 bytes at offset 2097152. Was only able to read 917504.
then i make a strace to trace which file has the problem. the result is ibdata1.
-rw-rw----. 1 mysql mysql 79691776 7月 9 16:51 ibdata1
well, for performance i change log commit as following.
innodb_flush_log_at_trx_commit = 2
but i do not think this can cause data lost since OS does not reboot during mysql restart. so can anybody help me out on what's the reason(maybe the kill -9?) that makes data corrupt and how to restore the data, thank you very much.