无标题文档
wdCP系统 (介绍,功能特性,运行环境,安装说明,演示,常见问题,使用教程) wdCDN系统 (介绍,功能特性,运行环境,安装说明,演示,常见问题,使用手册)
wdOS系统 (介绍,功能特性,运行环境,安装说明,演示,常见问题,使用教程) wdDNS系统 (介绍,功能特性,运行环境,安装说明,演示,常见问题,使用手册)
注册 发贴 提问 回复-必看必看 wddns免费智能 DNS 开通 本地或虚拟机使 用wdcp 一键包在mysql编 译时"卡住"
AI导航网AI应用网站大全 wdcp官方技术支持/服务 阿里云8折优惠券 无敌云 腾讯云优惠中,现注册更有260代金额券赠送
返回列表 发帖
提问三步曲: 提问先看教程/FAQ索引(wdcp,wdcp_v3,一键包)及搜索,会让你更快解决问题
1 提供详细,如系统版本,wdcp版本,软件版本等及错误的详细信息,贴上论坛或截图发论坛
2 做过哪些操作或改动设置等

温馨提示:信息不详,很可能会没人理你!论坛有教程说明的,也可能没人理!因为,你懂的

[求助] 惨了,升级mysql5.5,启动不了了

按admin的方法,wget http://down.wdlinux.cn/in/mysql_up55.sh
sh mysql_up55.sh
然后 改写mysqld
basedir=/www/wdlinux/mysql
datadir=/www/wdlinux/mysql/var
然后
。。。。。

150519 21:47:08 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql/var
/www/wdlinux/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
150519 21:47:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
150519 21:47:08 InnoDB: The InnoDB memory heap is disabled
150519 21:47:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150519 21:47:08 InnoDB: Compressed tables use zlib 1.2.3
150519 21:47:08 InnoDB: Initializing buffer pool, size = 2.0G
150519 21:47:08 InnoDB: Completed initialization of buffer pool
150519 21:47:08  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
150519 21:47:08 mysqld_safe mysqld from pid file /www/wdlinux/mysql/var/west11237.pid ended


怎样处理呢?求大神指教

努力抢修以后
变成这样了

150520 07:11:59 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql/var
150520  7:11:59 InnoDB: The InnoDB memory heap is disabled
150520  7:11:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150520  7:11:59 InnoDB: Compressed tables use zlib 1.2.3
150520  7:11:59 InnoDB: Initializing buffer pool, size = 2.0G
150520  7:11:59 InnoDB: Completed initialization of buffer pool
150520  7:11:59  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB:150520  7:11:59  InnoDB: Error: Write to file ./ib_logfile0 failed at offset 0 0.
InnoDB: 1048576 bytes should have been written, only -1 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
InnoDB: Error in creating ./ib_logfile0: probably out of disk space
150520  7:11:59 [ERROR] Plugin 'InnoDB' init function returned error.
150520  7:11:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/www/wdlinux/mysql/bin/mysqld: Error writing file '/www/wdlinux/mysql/var/west11237-slow.log' (Errcode: 28)
150520  7:11:59 [ERROR] Could not use /www/wdlinux/mysql/var/west11237-slow.log for logging (error 28). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
/www/wdlinux/mysql/bin/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/www/wdlinux/mysql/bin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

TOP

[root@west11237 ~]# df -h
文件系统              容量  已用  可用 挂载点
/dev/sda1             9.9G  9.7G     0 100% /
tmpfs                 1.9G     0  1.9G   0% /dev/shm
/dev/sdb1             483G   62G  397G  14% /home

发现空间满了

TOP

解决了
一个是mysql目录最好放在home里,很容易占满空间
二是/var/lib/mysql/目录权限不正确,造成sock文件无法创建
还做了几个修改,见招拆招,在服务商客服帮助下搞定了。

TOP

楼主好样的。

TOP

学习了不错
风帆股份

TOP

返回列表