mysql error log里面的一些debug信息

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

posted on 2011-05-31 11:55  andrefun  阅读(957)  评论(0)    收藏  举报

导航