[问题]mysql启动问题

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: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

[问题]mysql启动问题

在线用户