99精品国产综合久久久久五月天,免费观看欧美大片毛片不用播放器 ,AV无码理论片在线观看免费网站,国产精品国产成人国产三级

Board logo

標(biāo)題: [求助] 慘了,升級(jí)mysql5.5,啟動(dòng)不了了 [打印本頁(yè)]

作者: testu    時(shí)間: 2015-5-19 22:15     標(biāo)題: 慘了,升級(jí)mysql5.5,啟動(dòng)不了了

按admin的方法,wget http://down.wdlinux.cn/in/mysql_up55.sh
sh mysql_up55.sh
然后 改寫(xiě)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


怎樣處理呢?求大神指教
作者: testu    時(shí)間: 2015-5-20 07:37

努力搶修以后
變成這樣了

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
作者: testu    時(shí)間: 2015-5-20 08:40

[root@west11237 ~]# df -h
文件系統(tǒng)              容量  已用  可用 掛載點(diǎn)
/dev/sda1             9.9G  9.7G     0 100% /
tmpfs                 1.9G     0  1.9G   0% /dev/shm
/dev/sdb1             483G   62G  397G  14% /home

發(fā)現(xiàn)空間滿了
作者: testu    時(shí)間: 2015-5-20 11:12

解決了
一個(gè)是mysql目錄最好放在home里,很容易占滿空間
二是/var/lib/mysql/目錄權(quán)限不正確,造成sock文件無(wú)法創(chuàng)建
還做了幾個(gè)修改,見(jiàn)招拆招,在服務(wù)商客服幫助下搞定了。
作者: yueyanwen    時(shí)間: 2015-5-20 18:48

樓主好樣的。
作者: meinvba    時(shí)間: 2015-8-11 19:50

學(xué)習(xí)了不錯(cuò)




歡迎光臨 WDlinux官方論壇 (http://fudaan.com/bbs/) Powered by Discuz! 7.2