当前位置:Gxlcms > mysql > mysqlerrorlog里面的一些debug信息_MySQL

mysqlerrorlog里面的一些debug信息_MySQL

时间:2021-07-01 10:21:17 帮助过:69人阅读

/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信息。

欢迎上网易彩票买彩票啊~

人气教程排行