[问题]mysql启动问题

Web、Mail、Ftp、DNS、Proxy、VPN、Samba、LDAP 等基础网络服务
回复
blackthought
帖子: 57
注册时间: 2007-02-05 13:07

[问题]mysql启动问题

#1

帖子 blackthought » 2008-05-28 16:41

mysql-5.0.37-linux-i686-icc-glibc23,解压后放在 /home/username/下
... ...
终端输入以下命令
./bin/mysqld_safe --user=mysql
则显示如下信息,一直停留在这一步,不能继续完成下去。
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /home/username/mysql-5.0.37/data

此时后台mysqld和mysqld_safe已经运行了

在data目录下的*.err产生如下内容

代码: 全选

080528 16:22:34  mysqld started
nohup: ignoring input
080528 16:22:34  MyISAM: Started; log sequence number 0 43665
080528 16:22:34 [Note] /home/username/mysql-5.0.37/bin/mysqld: ready for connections.
Version: '5.0.37'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)
请教大家是什么原因?是不是默认应该放在/usr/local目录下,放在这个目录下需要改一些东西?
上次由 blackthought 在 2008-05-28 16:46,总共编辑 1 次。
blackthought
帖子: 57
注册时间: 2007-02-05 13:07

#2

帖子 blackthought » 2008-05-28 16:45

强行把这个窗口关掉则在*.err中产生如下信息

代码: 全选

Status information:

Current dir: /home/username/mysql-5.0.37/data/
Running threads: 0  Stack size: 196608
Current locks:
lock: 0x8b00548:

lock: 0x8afeee8:

lock: 0x8adfe00:

lock: 0x8ada960:

lock: 0x8ad63c0:

lock: 0x8ac9448:

lock: 0x8ac5c08:

lock: 0x8ac0d88:


Key caches:
default
Buffer_size:       8388600
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:             0
not flushed:             0
w_requests:              0
writes:                  0
r_requests:              0
reads:                   0


handler status:
read_key:            0
read_next:           0
read_rnd             0
read_first:          5
write:               6
delete               0
update:              0

Table status:
Opened tables:         15
Open tables:            9
Open files:            17
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 1
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 4546560
Number of free chunks:			 18
Number of fastbin blocks:		 0
Number of mmapped regions:		 10
Space in mmapped regions:		 22040576
Maximum total allocated space:		 0
Space available in freed fastbin blocks: 0
Total allocated space:			 4255480
Total free space:			 291080
Top-most, releasable space:		 203888
Estimated memory (with thread stack):    26587136


Status information:

Current dir: /home/username/mysql-5.0.37/data/
Running threads: 0  Stack size: 196608
Current locks:

Key caches:
default
Buffer_size:       8388600
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:             0
not flushed:             0
w_requests:              0
writes:                  0
r_requests:              0
reads:                   0


handler status:
read_key:            0
read_next:           0
read_rnd             0
read_first:          7
write:               6
delete               0
update:              0

Table status:
Opened tables:         15
Open tables:            0
Open files:             0
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 1
Next alarm time: 0
回复