mysql资源限制_超出了MariaDB / MySQL资源限制

我正在尝试连接到我的CentOS 7上安装的MariaDB / Mysql，并在尝试连接时遇到以下错误： mysql -u root -p .

ERROR 2002(HY000)：无法通过套接字'/var/lib/mysql/mysql.sock'连接到本地MySQL服务器(111)

我尝试通过指定IP地址而不是使用localhost来连接它，但我得到了同样的错误 .

当我尝试获取MariaDB状态时，我收到以下消息( /bin/systemctl status mariadb.service )：

mariadb.service - MariaDB数据库服务器已加载：已加载(/usr/lib/systemd/system/mariadb.service;已启用;供应商预设：已禁用)活动：失败(结果：资源)

并启动它会产生以下错误( /bin/systemctl start mariadb.service )：

mariadb.service的作业失败，因为超出了配置的资源限制 . 有关详细信息，请参阅“systemctl status mariadb.service”和“journalctl -xe” .

我还查看了位于/var/log/mariadb/mariadb.log的日志

160408 12:21:00 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended

160408 16:11:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

160408 16:11:01 [Note] /usr/libexec/mysqld (mysqld 5.5.47-MariaDB) starting as process 3054 ...

160408 16:11:02 InnoDB: The InnoDB memory heap is disabled

160408 16:11:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins

160408 16:11:02 InnoDB: Compressed tables use zlib 1.2.7

160408 16:11:02 InnoDB: Using Linux native AIO

160408 16:11:02 InnoDB: Initializing buffer pool, size = 128.0M

160408 16:11:02 InnoDB: Completed initialization of buffer pool

160408 16:11:02 InnoDB: highest supported file format is Barracuda.

160408 16:11:04 InnoDB: Waiting for the background threads to start

160408 16:11:05 Percona XtraDB (http://www.percona.com) 5.5.46-MariaDB-37.6 started; log sequence number 54018416776

160408 16:11:06 [Note] Plugin 'FEEDBACK' is disabled.

160408 16:11:07 [Note] Server socket created on IP: '0.0.0.0'.

160408 16:11:07 [Note] Event Scheduler: Loaded 0 events

160408 16:11:07 [Note] /usr/libexec/mysqld: ready for connections.

Version: '5.5.47-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server

160409 6:26:06 InnoDB: Error: Write to file ./ibdata1 failed at offset 9 615514112.

InnoDB: 1048576 bytes should have been written, only 585728 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.5/en/operating-system-error-codes.html

160409 6:26:06 InnoDB: Assertion failure in thread 140463216400128 in file os0file.c line 4377

任何人对如何解决此错误有任何想法？

谢谢 ：)