mysql debug log_mysqlerrorlog里面的一些debug信息_MySQL

/tmp/a.html

今天看到MySQL的error log里面出现了下面的内容:

1 Current dir: /home/database/data/

2 Running threads: 0 Stack size: 262144

3 Current locks:

4 lock: 0x125a0a0:

5

6 lock: 0x125a9a0:

7

8 lock: 0x125a8a0:

9

10 lock: 0x125a7a0:

11

12 lock: 0x125a2a0:

13

14 lock: 0x125a1a0:

15

16 lock: 0x1259fa0:

17

18 lock: 0x1259ea0:

19

20 lock: 0x1259da0:

21

22 lock: 0x125aaa0:

23

24 lock: 0x125a3a0:

25

26 lock: 0x125a6a0:

27

28 lock: 0x125a5a0:

29

30 lock: 0x125a4a0:

31

32 lock: 0x1259ca0:

33

34 lock: 0x1259ba0:

35

36 lock: 0x1259aa0:

37

38 DB Table Version Thread Open Lock

39

40 Current refresh version: 2

41

42 Key caches:

43 default

44 Buffer_size: 16777216

45 Block_size: 1024

46 Division_limit: 100

47 Age_limit: 300

48 blocks used: 0

49 not flushed: 0

50 w_requests: 0

51 writes: 0

52 r_requests: 0

53 reads: 0

54

55

56 handler status:

57 read_key: 0

58 read_next: 0

59 read_rnd 0

60 read_first: 5

61 write: 0

62 delete 0

63 update: 0

64

65 Table status:

66 Opened tables: 33

67 Open tables: 0

68 Open files: 2

69 Open streams: 0

70

71 Alarm status:

72 Active alarms: 0

73 Max used alarms: 0

74 Next alarm time: 0

75

76 Memory status:

77 Non-mmapped space allocated from system: 20590592

78 Number of free chunks: 32

79 Number of fastbin blocks: 0

80 Number of mmapped regions: 17

81 Space in mmapped regions: 36880384

82 Maximum total allocated space: 0

83 Space available in freed fastbin blocks: 0

84 Total allocated space: 16146816

85 Total free space: 4443776

86 Top-most, releasable space: 3953856

87 Estimated memory (with thread stack): 57470976

88

89

90

91 Events status:

92 LLA = Last Locked At LUA = Last Unlocked At

93 WOC = Waiting On Condition DL = Data Locked

94

95 Event scheduler status:

96 State : INITIALIZED

97 Thread id : 0

98 LLA : n/a:0

99 LUA : n/a:0

100 WOC : NO

101 Workers : 0

102 Executed : 0

103 Data locked: NO

104

105 Event queue status:

106 Element count : 0

107 Data locked : NO

108 Attempting lock : NO

109 LLA : init_queue:139

110 LUA : init_queue:149

111 WOC : NO

112 Next activation : never

相当惊讶,第一次见到这样的信息。速度去阅读文档,但是没有找到资料。

最后通过阅读代码,发现是在mysqladmin debug和kill -1 ${pid}的时候会出现这个信息,会打印出一些debug信息。欢迎上网易彩票买彩票啊~

本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源:php中文网

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值