- 论坛徽章:
- 0
|
本帖最后由 于仁洁 于 2010-07-22 09:18 编辑
mysql 运行一段时间后会把error文件清成空的,然后生成一个error-old的文件,里面多出了Status information:的信息,如下。
请问是什么原因造成的?这个信息是指mysql崩过一次了吗?
但是我用show global status ;看uptime,好像是没有崩过。
100721 15:18:50 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log' socket: '/usr/local/mysql/tmp/mysql.sock' port: 3306 Source distribution
Status information:
Current dir: /data/dbdata/
Running threads: 37 Stack size: 196608
Current locks:
lock: 0x1432bd90:
lock: 0x142cddf0:
lock: 0x141b1f50:
lock: 0x14388570:
lock: 0x143650f0:
lock: 0x143470e0:
lock: 0x145d3d60:
lock: 0x13fb3830:
lock: 0x145dad20:
lock: 0x145ded30:
lock: 0x145b7590:
lock: 0x1454bb20:
lock: 0x144e3860:
lock: 0x1454bf40:
lock: 0x13fe5f50:
lock: 0x1430e370:
lock: 0x142efbe0:
lock: 0x144e77b0:
lock: 0x142f0190:
lock: 0x141675a0:
lock: 0x1441f8a0:
lock: 0x14439640:
lock: 0x143f9c20:
lock: 0x143f2180:
lock: 0x14428000:
lock: 0x1442a7a0:
lock: 0x2aacd8006e50:
lock: 0x1442bda0:
lock: 0x143cfe70:
lock: 0x1433de30:
lock: 0x142ce030:
lock: 0x142c8af0:
lock: 0x142ce1e0:
lock: 0x141b4a10:
lock: 0x141b3fa0:
lock: 0x1433f190:
lock: 0x14331bb0:
lock: 0x14336300:
lock: 0x14310960:
lock: 0x142a2370:
lock: 0x142d3bd0:
lock: 0x1430a840:
lock: 0x14307b40:
lock: 0x142f2000:
lock: 0x142f1ee0:
lock: 0x142c59b0:
lock: 0x142ca370:
lock: 0x142d5250:
lock: 0x14294ce0:
lock: 0x142a3b40:
lock: 0x1423d590:
lock: 0x1425cc40:
lock: 0x14246740:
lock: 0x14244f10:
lock: 0x14242820:
lock: 0x142122f0:
lock: 0x1423f970:
lock: 0x1424b250:
lock: 0x14247920:
lock: 0x142161b0:
lock: 0x14213600:
lock: 0x1421bf10:
lock: 0x142175e0:
lock: 0x1422c680:
lock: 0x14227190:
lock: 0x142015e0:
lock: 0x141e4b10:
lock: 0x141805f0:
lock: 0x141edb20:
lock: 0x141ebc80:
lock: 0x141e5c00:
lock: 0x141b6690:
lock: 0x14189678:
lock: 0x141854b8:
lock: 0x140a8060:
lock: 0x14148710:
lock: 0x14145a60:
lock: 0x1411dff0:
lock: 0x1411eab0:
lock: 0x14123f98:
lock: 0x14119420:
lock: 0x14113c40:
lock: 0x140a9a10:
lock: 0x140b84d0:
lock: 0x1407e410:
lock: 0x140b2000:
lock: 0x140b4270:
lock: 0x140995f0:
lock: 0x14087260:
lock: 0x1409c190:
lock: 0x140631a0:
lock: 0x14062f50:
lock: 0x140660c0:
lock: 0x1401bdc0:
lock: 0x1452c280:
lock: 0x1403afe0:
lock: 0x1403d820:
lock: 0x1404b940:
lock: 0x1454ed00:
lock: 0x1400f290:
Key caches:
default
Buffer_size: 8388608
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 1
not flushed: 0
w_requests: 26
writes: 17
r_requests: 106
reads: 1
handler status:
read_key: 11617309
read_next: 1332521
read_rnd 161039
read_first: 5607
write: 2636291
delete 197
update: 1799308
Table status:
Opened tables: 165
Open tables: 158
Open files: 25
Open streams: 0
Alarm status:
Active alarms: 37
Max used alarms: 50
Next alarm time: 22093 |
|