论坛 › MySQL › Mysql启动出错各位帮忙分析一下

独孤天血 发表于 2009-07-06 18:58

Mysql启动出错各位帮忙分析一下

Mysql启动出错各位帮忙分析一下
BSDUnix# /usr/local/bin/mysqld_safe &
16149
BSDUnix# 090706 16:05:39 mysqld_safe Logging to '/var/db/mysql/BSDUnix.localdomain.err'.
090706 16:05:39 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
090706 16:05:40 mysqld_safe mysqld from pid file /var/db/mysql/BSDUnix.localdomain.pid ended

    Done                        /usr/local/bin/mysqld_safe
错误日志
# cat /var/db/mysql/BSDUnix.localdomain.err
090706 18:38:01 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
090706 18:38:02InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090706 18:38:02InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090706 18:38:02InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090706 18:38:03InnoDB: Started; log sequence number 0 0
090706 18:38:03 Event Scheduler: Loaded 0 events
090706 18:38:03 /usr/local/libexec/mysqld: ready for connections.
Version: '5.1.35-log'socket: '/tmp/mysql.sock'port: 3306FreeBSD port: mysql-server-5.1.35
#
日志好像说是什么东西不能写入.

小小稻草人 发表于 2009-07-06 20:04

回复 #1 独孤天血 的帖子

看一下文件权限及设备是不是没有空间了。

phphp 发表于 2009-07-07 11:25

上面的日志没错, 错误日志没帖全或分日志了(如BSDUnix.localdomain.err-old)
090706 16:05:40 mysqld_safe mysqld from pid file /var/db/mysql/BSDUnix.localdomain.pid ended
-----------------------
090706 18:38:03 /usr/local/libexec/mysqld: ready for connections.

ruochen 发表于 2009-07-07 12:57

090706 18:38:03 /usr/local/libexec/mysqld: ready for connections.
Version: '5.1.35-log'socket: '/tmp/mysql.sock'port: 3306FreeBSD port: mysql-server-5.1.35


启动很正常呀
没看到什么错误日志

Coolriver 发表于 2009-07-07 18:18

看看你的空间。
ps axu |grep mysql

voxxu 发表于 2009-07-08 09:48

你贴的日志不对啊，出问题的是16点的，你贴18点的日志有啥用啊

ruochen 发表于 2009-07-08 12:13

原帖由 voxxu 于 2009-7-8 09:48 发表 http://bbs3.chinaunix.net/images/common/back.gif
你贴的日志不对啊，出问题的是16点的，你贴18点的日志有啥用啊


94

bitterness 发表于 2009-07-08 15:26

哈哈，:mrgreen:

查看完整版本: Mysql启动出错各位帮忙分析一下