MySQL is Stop
Log file
160106 17:43:14 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160106 17:43:14 [Note] InnoDB: Completed initialization of buffer pool
160106 17:43:14 [Note] InnoDB: Highest supported file format is Barracuda.
160106 17:43:14 [Note] InnoDB: The log sequence numbers 159528416482 and 159528416482 in ibdata files do not match the log sequence number 162756977297 in the ib_logfiles!
160106 17:43:14 [Note] InnoDB: Database was not shutdown normally!
160106 17:43:14 [Note] InnoDB: Starting crash recovery.
160106 17:43:14 [Note] InnoDB: Reading tablespace information from the .ibd files...
160106 17:43:14 [Note] InnoDB: Restoring possible half-written data pages
160106 17:43:14 [Note] InnoDB: from the doublewrite buffer...
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 21706496
160106 17:43:14 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2016-01-06 17:43:14 7f16943ff700 InnoDB: Rolling back trx with id 21706000, 1 rows to undo
160106 17:43:14 [Note] InnoDB: Waiting for purge to start
2016-01-06 17:43:14 7f16943ff700 InnoDB: Error: Write to file ./bachngoc_bnsdru/cache_menu.ibd failed at offset 16840130560.
InnoDB: 1048576 bytes should have been written, only 307200 were written.
InnoDB: Operating system error number 28.
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: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB:
http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.htmlFAIL160106 17:43:14 [Note] InnoDB: Percona XtraDB (
http://www.percona.com) 5.6.24-72.2 started; log sequence number 162756977297
160106 17:43:14 [Note] Plugin 'FEEDBACK' is disabled.
160106 17:43:14 [Note] Server socket created on IP: '::'.
160106 17:43:14 [ERROR] mysqld: Error writing file '/var/lib/mysql/bns.bachngocsach.com.pid' (Errcode: 28 "No space left on device")
160106 17:43:14 [ERROR] Can't start server: can't create PID file: No space left on device
160106 17:43:14 mysqld_safe Number of processes running now: 0
160106 17:43:14 mysqld_safe mysqld restarted
160106 17:43:14 [Note] /usr/sbin/mysqld (mysqld 10.0.20-MariaDB) starting as process 28619 ...
160106 17:43:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160106 17:43:14 [Note] InnoDB: The InnoDB memory heap is disabled
160106 17:43:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160106 17:43:14 [Note] InnoDB: Memory barrier is not used
160106 17:43:14 [Note] InnoDB: Compressed tables use zlib 1.2.3
160106 17:43:14 [Note] InnoDB: Using CPU crc32 instructions
160106 17:43:14 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160106 17:43:14 [Note] InnoDB: Completed initialization of buffer pool
160106 17:43:14 [Note] InnoDB: Highest supported file format is Barracuda.
160106 17:43:14 [Note] InnoDB: The log sequence numbers 159528416482 and 159528416482 in ibdata files do not match the log sequence number 162756977297 in the ib_logfiles!
160106 17:43:14 [Note] InnoDB: Database was not shutdown normally!
160106 17:43:14 [Note] InnoDB: Starting crash recovery.
160106 17:43:14 [Note] InnoDB: Reading tablespace information from the .ibd files...
160106 17:43:14 [Note] InnoDB: Restoring possible half-written data pages
16010[root@bns ~]# service mysql restart
ERROR! MySQL server PID file could not be found!
Starting MySQL...^C
Please help me!