设为首页收藏本站

LinuxTone | 运维专家网论坛 - 最棒的Linux运维与开源架构技术交流社区!

 找回密码
 注册

用新浪微博连接

一步搞定

QQ登录

只需一步,快速开始

查看: 1516|回复: 1

大家帮我分析下mysql的一个localhost.localdomain.err日志??? [复制链接]

Rank: 3Rank: 3

签到
4
注册时间
2010-5-13
最后登录
2012-1-11
在线时间
37 小时
阅读权限
30
积分
499
帖子
36
主题
6
精华
0
UID
9212
发表于 2010-9-6 17:19:31 |显示全部楼层
Current dir: /usr/local/mysql/data/
Running threads: 333  Stack size: 196608
Current locks:
lock: 0x862b7f28:

lock: 0x862891f8:

lock: 0x84287988:

lock: 0x7e104e50:

lock: 0x82007b58:

lock: 0x86288130:

lock: 0x7a0042f8:

lock: 0x862857c8:

lock: 0x862768c0:

lock: 0x8627a500:

lock: 0x8623e968:

lock: 0x86291b90:

lock: 0x9111e6c8:

lock: 0x8060ef80:

lock: 0x7f100468:

lock: 0x862468b0:

lock: 0xa59bbd8:

lock: 0x90a01ac0:

lock: 0x7e80dfe0:

lock: 0x8b704f38:

lock: 0x8e43fcd8:

lock: 0x8e4849e8:

lock: 0x80e08208:

lock: 0x894038a8:

lock: 0x8b10cf80:

lock: 0x863083a8:

lock: 0x9247a778:

lock: 0x97457e98:

lock: 0x93919bb8:

lock: 0xa590fe8:

lock: 0xa58d910:

lock: 0xa52c6b8:

lock: 0xa4b2770:

lock: 0xa49f698:

lock: 0xa4ad310:

lock: 0xa492810:

lock: 0xa4711b0:

lock: 0xa46ce38:

lock: 0xa463e60: read
read      : 0x84906dd0 (155:2); 0x842927e0 (874:2);

lock: 0xa45ee58: read
read      : 0x862390a8 (155:2); 0x94e765e0 (874:2); 0x84286680 (112:2);

lock: 0xa4545e8:

lock: 0xa44f600:

lock: 0xa4413d4:

lock: 0xa3f2148:

lock: 0xa3cb6b8:

lock: 0xa3ce058:

lock: 0xa3c8238:

lock: 0xa3c5090:

lock: 0xa3a27c0:

lock: 0xa3a0fe0:

lock: 0xa377da8:


Key caches:
default
Buffer_size:     402653184
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:         34803
not flushed:             0
w_requests:         452014
writes:               7619
r_requests:       48172268
reads:               35662


handler status:
read_key:     11056494
read_next:    20691601
read_rnd       1796495
read_first:       1965
write:          808620
delete            6467
update:        1660662

Table status:
Opened tables:       1866
Open tables:          512
Open files:           513
Open streams:           0

Alarm status:
Active alarms:   330
Max used alarms: 338
Next alarm time: 25588

Thread database.table_name          Locked/Waiting        Lock_type

155     imbabbs.bsl_forums          Locked - read         Low priority read lock
155     imbabbs.bsl_threads         Locked - read         Low priority read lock




Begin safemalloc memory dump:

End safemalloc memory dump.

Memory status:
Non-mmapped space allocated from system: 24678400
Number of free chunks:                   641
Number of fastbin blocks:                0
Number of mmapped regions:               -37
Space in mmapped regions:                436289536
Maximum total allocated space:           0
Space available in freed fastbin blocks: 0
Total allocated space:                   20965312
Total free space:                        3713088
Top-most, releasable space:              650352
Estimated memory (with thread stack):    526438400



Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked

Event scheduler status:
State      : INITIALIZED
Thread id  : 0
LLA        : n/a:0
LUA        : n/a:0
WOC        : NO
Workers    : 0
Executed   : 0
Data locked: NO

Event queue status:
Element count   : 0
Data locked     : NO
Attempting lock : NO
LLA             : init_queue:132
LUA             : init_queue:142
WOC             : NO
Next activation : never

Rank: 7Rank: 7Rank: 7

注册时间
2008-11-27
最后登录
2012-2-1
在线时间
196 小时
阅读权限
100
积分
2585
帖子
498
主题
103
精华
1
UID
632

LT同学

发表于 2010-9-30 17:57:02 |显示全部楼层
哥们,你这是干撒了?
http://hi.baidu.com/ytjwt/

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

IT运维专家网感谢红之盟网络提供带宽支持

合作联系: QQ:67888954/MSN:cnseek@msn.com/mail:netseek@linuxtone.org

Archiver|手机版|感谢所有关心和支持过LinuxTone的朋友们 转载本站内容请注明原作者名及出处 ( 京ICP备08103151 )   |

GMT+8, 2012-2-4 19:35 , Processed in 0.061389 second(s), 12 queries , Memcache On.

Powered by Discuz! X2

© 2001-2011 Comsenz Inc.

回顶部