mysql意外停止

linux 3.5

centos7

特定的数据表只要一查询mysql就死

我把错误日志放上来

我没看出来毛病 菜鸡跪谢各位大佬

1. 
   
2. Status information:
   
3. 
   
4. Current dir: /www/server/data/
   
5. Running threads: 0  Stack size: 262144
   
6. Current locks:
   
7. lock: 0x7f37a8046830:
   
8. 
   
9. lock: 0x7f37a803e9b0:
   
10. 
    
11. lock: 0x7f37a8035970:
    
12. 
    
13. lock: 0x7f37a802cd90:
    
14. 
    
15. lock: 0x7f37a80270a0:
    
16. 
    
17. lock: 0x7f37a801e420:
    
18. 
    
19. lock: 0x7f37a80174b0:
    
20. 
    
21. lock: 0x236b970:
    
22. 
    
23. lock: 0x23644d0:
    
24. 
    
25. lock: 0x235fac0:
    
26. 
    
27. lock: 0x13b8e40:
    
28. 
    
29. lock: 0x13b8d80:
    
30. 
    
31. lock: 0x13b8000:
    
32. 
    
33. lock: 0x13b7f40:
    
34. 
    
35. lock: 0x13b7e80:
    
36. 
    
37. lock: 0x13b8180:
    
38. 
    
39. lock: 0x13b6800:
    
40. 
    
41. lock: 0x13b8cc0:
    
42. 
    
43. lock: 0x13b6e00:
    
44. 
    
45. lock: 0x13b7040:
    
46. 
    
47. lock: 0x13b6d40:
    
48. 
    
49. lock: 0x13b6f80:
    
50. 
    
51. lock: 0x13b6c80:
    
52. 
    
53. lock: 0x13b6ec0:
    
54. 
    
55. lock: 0x13b7340:
    
56. 
    
57. lock: 0x13b7400:
    
58. 
    
59. lock: 0x13b74c0:
    
60. 
    
61. lock: 0x13b6bc0:
    
62. 
    
63. lock: 0x13b6980:
    
64. 
    
65. lock: 0x13b6b00:
    
66. 
    
67. lock: 0x13b68c0:
    
68. 
    
69. lock: 0x13b6a40:
    
70. 
    
71. lock: 0x13b7100:
    
72. 
    
73. lock: 0x13b71c0:
    
74. 
    
75. lock: 0x13b7280:
    
76. 
    
77. lock: 0x13b89c0:
    
78. 
    
79. lock: 0x13b8c00:
    
80. 
    
81. lock: 0x13b8b40:
    
82. 
    
83. lock: 0x13b8a80:
    
84. 
    
85. lock: 0x13b86c0:
    
86. 
    
87. lock: 0x13b8600:
    
88. 
    
89. lock: 0x13b8540:
    
90. 
    
91. lock: 0x13b8480:
    
92. 
    
93. lock: 0x13b83c0:
    
94. 
    
95. lock: 0x13b8840:
    
96. 
    
97. lock: 0x13b8300:
    
98. 
    
99. lock: 0x13b8240:
    
100. 
     
101. lock: 0x13b8900:
     
102. 
     
103. lock: 0x13b80c0:
     
104. 
     
105. lock: 0x13b7d00:
     
106. 
     
107. lock: 0x13b7dc0:
     
108. 
     
109. lock: 0x13b7c40:
     
110. 
     
111. lock: 0x13b7b80:
     
112. 
     
113. lock: 0x13b7880:
     
114. 
     
115. lock: 0x13b7ac0:
     
116. 
     
117. lock: 0x13b7a00:
     
118. 
     
119. lock: 0x13b77c0:
     
120. 
     
121. lock: 0x13b7940:
     
122. 
     
123. lock: 0x13b7580:
     
124. 
     
125. lock: 0x13b7640:
     
126. 
     
127. lock: 0x13b7700:
     
128. 
     
129. lock: 0x13b8780:
     
130. 
     
131. 
     
132. Key caches:
     
133. default
     
134. Buffer_size:       8388608
     
135. Block_size:           1024
     
136. Division_limit:        100
     
137. Age_limit:             300
     
138. blocks used:           443
     
139. not flushed:             0
     
140. w_requests:              0
     
141. writes:                  0
     
142. r_requests:          18705
     
143. reads:                 443
     
144. 
     
145. 
     
146. handler status:
     
147. read_key:        39853
     
148. read_next:       42784
     
149. read_rnd          1835
     
150. read_first:          8
     
151. write:           33166
     
152. delete               0
     
153. update:              3
     
154. 
     
155. Table status:
     
156. Opened tables:         79
     
157. Open tables:           32
     
158. Open files:            22
     
159. Open streams:           0
     
160. 
     
161. Alarm status:
     
162. Active alarms:   0
     
163. Max used alarms: 0
     
164. Next alarm time: 0
     
165. 
     
166. Memory status:
     
167. <malloc version="1">
     
168. <heap nr="0">
     
169. <sizes>
     
170. <size from="17" to="32" total="32" count="1"/>
     
171. <size from="65" to="80" total="160" count="2"/>
     
172. <size from="33" to="33" total="957" count="29"/>
     
173. <size from="49" to="49" total="147" count="3"/>
     
174. <size from="65" to="65" total="585" count="9"/>
     
175. <size from="81" to="81" total="2025" count="25"/>
     
176. <size from="97" to="97" total="582" count="6"/>
     
177. <size from="113" to="113" total="678" count="6"/>
     
178. <size from="129" to="129" total="1419" count="11"/>
     
179. <size from="161" to="161" total="161" count="1"/>
     
180. <size from="193" to="193" total="386" count="2"/>
     
181. <size from="209" to="209" total="209" count="1"/>
     
182. <size from="225" to="225" total="225" count="1"/>
     
183. <size from="481" to="481" total="481" count="1"/>
     
184. <size from="561" to="561" total="561" count="1"/>
     
185. <size from="1009" to="1009" total="3027" count="3"/>
     
186. <size from="2033" to="2033" total="2033" count="1"/>
     
187. <size from="2113" to="2113" total="2113" count="1"/>
     
188. <size from="3329" to="3329" total="3329" count="1"/>
     
189. <size from="3585" to="3857" total="7442" count="2"/>
     
190. <size from="4289" to="4289" total="8578" count="2"/>
     
191. <size from="6609" to="6609" total="6609" count="1"/>
     
192. <size from="7985" to="7985" total="7985" count="1"/>
     
193. <unsorted from="0" to="14321" total="51810" count="18"/>
     
194. </sizes>
     
195. <total type="fast" count="3" size="192"/>
     
196. <total type="rest" count="126" size="101342"/>
     
197. <system type="current" size="22216704"/>
     
198. <system type="max" size="22216704"/>
     
199. <aspace type="total" size="22216704"/>
     
200. <aspace type="mprotect" size="22216704"/>
     
201. </heap>
     
202. <heap nr="1">
     
203. <sizes>
     
204. <size from="33" to="33" total="198" count="6"/>
     
205. <size from="529" to="529" total="529" count="1"/>
     
206. <size from="817" to="817" total="817" count="1"/>
     
207. <size from="1009" to="1009" total="1009" count="1"/>
     
208. <size from="1041" to="1041" total="1041" count="1"/>
     
209. <size from="12353" to="12353" total="12353" count="1"/>
     
210. <size from="65553" to="65553" total="65553" count="1"/>
     
211. <size from="313345" to="313345" total="313345" count="1"/>
     
212. <unsorted from="0" to="14321" total="73484" count="28"/>
     
213. </sizes>
     
214. <total type="fast" count="0" size="0"/>
     
215. <total type="rest" count="41" size="468329"/>
     
216. <system type="current" size="999424"/>
     
217. <system type="max" size="999424"/>
     
218. <aspace type="total" size="999424"/>
     
219. <aspace type="mprotect" size="999424"/>
     
220. </heap>
     
221. <heap nr="2">
     
222. <sizes>
     
223. <size from="33" to="33" total="33" count="1"/>
     
224. <unsorted from="0" to="14321" total="97346" count="34"/>
     
225. </sizes>
     
226. <total type="fast" count="0" size="0"/>
     
227. <total type="rest" count="35" size="97379"/>
     
228. <system type="current" size="561152"/>
     
229. <system type="max" size="561152"/>
     
230. <aspace type="total" size="561152"/>
     
231. <aspace type="mprotect" size="561152"/>
     
232. </heap>
     
233. <heap nr="3">
     
234. <sizes>
     
235. <size from="49" to="49" total="49" count="1"/>
     
236. <unsorted from="0" to="14321" total="97346" count="34"/>
     
237. </sizes>
     
238. <total type="fast" count="0" size="0"/>
     
239. <total type="rest" count="35" size="97395"/>
     
240. <system type="current" size="135168"/>
     
241. <system type="max" size="135168"/>
     
242. <aspace type="total" size="135168"/>
     
243. <aspace type="mprotect" size="135168"/>
     
244. </heap>
     
245. <heap nr="4">
     
246. <sizes>
     
247. <size from="113" to="128" total="128" count="1"/>
     
248. <unsorted from="0" to="14321" total="97346" count="34"/>
     
249. </sizes>
     
250. <total type="fast" count="1" size="128"/>
     
251. <total type="rest" count="34" size="97346"/>
     
252. <system type="current" size="135168"/>
     
253. <system type="max" size="135168"/>
     
254. <aspace type="total" size="135168"/>
     
255. <aspace type="mprotect" size="135168"/>
     
256. </heap>
     
257. <heap nr="5">
     
258. <sizes>
     
259. <unsorted from="0" to="14321" total="97346" count="34"/>
     
260. </sizes>
     
261. <total type="fast" count="0" size="0"/>
     
262. <total type="rest" count="34" size="97346"/>
     
263. <system type="current" size="135168"/>
     
264. <system type="max" size="135168"/>
     
265. <aspace type="total" size="135168"/>
     
266. <aspace type="mprotect" size="135168"/>
     
267. </heap>
     
268. <total type="fast" count="4" size="320"/>
     
269. <total type="rest" count="305" size="959137"/>
     
270. <total type="mmap" count="48" size="269717504"/>
     
271. <system type="current" size="24182784"/>
     
272. <system type="max" size="24182784"/>
     
273. <aspace type="total" size="24182784"/>
     
274. <aspace type="mprotect" size="24182784"/>
     
275. </malloc>
     

复制代码

还没完、、、、、、、、

1. 
   
2. Events status:
   
3. LLA = Last Locked At  LUA = Last Unlocked At
   
4. WOC = Waiting On Condition  DL = Data Locked
   
5. 
   
6. Event scheduler status:
   
7. State      : INITIALIZED
   
8. Thread id  : 0
   
9. LLA        : n/a:0
   
10. LUA        : n/a:0
    
11. WOC        : NO
    
12. Workers    : 0
    
13. Executed   : 0
    
14. Data locked: NO
    
15. 
    
16. Event queue status:
    
17. Element count   : 0
    
18. Data locked     : NO
    
19. Attempting lock : NO
    
20. LLA             : init_queue:139
    
21. LUA             : init_queue:149
    
22. WOC             : NO
    
23. Next activation : never
    
24. 2017-04-08 12:34:34 24232 [Note] Plugin 'FEDERATED' is disabled.
    
25. 2017-04-08 12:34:35 24232 [Note] InnoDB: Using atomics to ref count buffer pool pages
    
26. 2017-04-08 12:34:35 24232 [Note] InnoDB: The InnoDB memory heap is disabled
    
27. 2017-04-08 12:34:35 24232 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
28. 2017-04-08 12:34:35 24232 [Note] InnoDB: Memory barrier is not used
    
29. 2017-04-08 12:34:35 24232 [Note] InnoDB: Compressed tables use zlib 1.2.3
    
30. 2017-04-08 12:34:35 24232 [Note] InnoDB: Using Linux native AIO
    
31. 2017-04-08 12:34:35 24232 [Note] InnoDB: Using CPU crc32 instructions
    
32. 2017-04-08 12:34:35 24232 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    
33. 2017-04-08 12:34:35 24232 [Note] InnoDB: Completed initialization of buffer pool
    
34. 2017-04-08 12:34:35 24232 [Note] InnoDB: Highest supported file format is Barracuda.
    
35. 2017-04-08 12:34:35 24232 [Note] InnoDB: The log sequence numbers 1626004 and 1626004 in ibdata files do not match the log sequence number 1626094 in the ib_logfiles!
    
36. 2017-04-08 12:34:35 24232 [Note] InnoDB: Database was not shutdown normally!
    
37. 2017-04-08 12:34:35 24232 [Note] InnoDB: Starting crash recovery.
    
38. 2017-04-08 12:34:35 24232 [Note] InnoDB: Reading tablespace information from the .ibd files...
    
39. 2017-04-08 12:34:35 24232 [Note] InnoDB: Restoring possible half-written data pages
    
40. 2017-04-08 12:34:35 24232 [Note] InnoDB: from the doublewrite buffer...
    
41. 2017-04-08 12:47:04 24864 [Note] Plugin 'FEDERATED' is disabled.
    
42. 2017-04-08 12:47:04 24864 [Note] InnoDB: Using atomics to ref count buffer pool pages
    
43. 2017-04-08 12:47:04 24864 [Note] InnoDB: The InnoDB memory heap is disabled
    
44. 2017-04-08 12:47:04 24864 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
45. 2017-04-08 12:47:04 24864 [Note] InnoDB: Memory barrier is not used
    
46. 2017-04-08 12:47:04 24864 [Note] InnoDB: Compressed tables use zlib 1.2.3
    
47. 2017-04-08 12:47:04 24864 [Note] InnoDB: Using Linux native AIO
    
48. 2017-04-08 12:47:04 24864 [Note] InnoDB: Using CPU crc32 instructions
    
49. 2017-04-08 12:47:04 24864 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    
50. 2017-04-08 12:47:04 24864 [Note] InnoDB: Completed initialization of buffer pool
    
51. 2017-04-08 12:47:04 24864 [Note] InnoDB: Highest supported file format is Barracuda.
    
52. 2017-04-08 12:47:04 24864 [Note] InnoDB: The log sequence numbers 1626004 and 1626004 in ibdata files do not match the log sequence number 1626094 in the ib_logfiles!
    
53. 2017-04-08 12:47:04 24864 [Note] InnoDB: Database was not shutdown normally!
    
54. 2017-04-08 12:47:04 24864 [Note] InnoDB: Starting crash recovery.
    
55. 2017-04-08 12:47:04 24864 [Note] InnoDB: Reading tablespace information from the .ibd files...
    
56. 2017-04-08 12:47:04 24864 [Note] InnoDB: Restoring possible half-written data pages
    
57. 2017-04-08 12:47:04 24864 [Note] InnoDB: from the doublewrite buffer...
    
58. 2017-04-08 12:47:05 24864 [Note] InnoDB: 128 rollback segment(s) are active.
    
59. 2017-04-08 12:47:05 24864 [Note] InnoDB: Waiting for purge to start
    
60. 2017-04-08 12:47:05 24864 [Note] InnoDB: 5.6.35 started; log sequence number 1626094
    
61. 2017-04-08 12:47:05 24864 [Note] Recovering after a crash using mysql-bin
    
62. 2017-04-08 12:47:05 24864 [Note] Starting crash recovery...
    
63. 2017-04-08 12:47:05 24864 [Note] Crash recovery finished.
    
64. 2017-04-08 12:47:05 24864 [Note] Server hostname (bind-address): '*'; port: 3306
    
65. 2017-04-08 12:47:05 24864 [Note] IPv6 is available.
    
66. 2017-04-08 12:47:05 24864 [Note]   - '::' resolves to '::';

复制代码

1. 
   
2. 2017-04-08 12:47:05 24864 [Note] Server socket created on IP: '::'.
   
3. 2017-04-08 12:47:05 24864 [Note] Event Scheduler: Loaded 0 events
   
4. 2017-04-08 12:47:05 24864 [Note] /www/server/mysql/bin/mysqld: ready for connections.
   
5. Version: '5.6.35-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
   
6. 2017-04-08 12:56:24 25530 [Note] Plugin 'FEDERATED' is disabled.
   
7. 2017-04-08 12:56:24 25530 [Note] InnoDB: Using atomics to ref count buffer pool pages
   
8. 2017-04-08 12:56:24 25530 [Note] InnoDB: The InnoDB memory heap is disabled
   
9. 2017-04-08 12:56:24 25530 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
10. 2017-04-08 12:56:24 25530 [Note] InnoDB: Memory barrier is not used
    
11. 2017-04-08 12:56:24 25530 [Note] InnoDB: Compressed tables use zlib 1.2.3
    
12. 2017-04-08 12:56:24 25530 [Note] InnoDB: Using Linux native AIO
    
13. 2017-04-08 12:56:24 25530 [Note] InnoDB: Using CPU crc32 instructions
    
14. 2017-04-08 12:56:24 25530 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    
15. 2017-04-08 12:56:24 25530 [Note] InnoDB: Completed initialization of buffer pool
    
16. 2017-04-08 12:56:24 25530 [Note] InnoDB: Highest supported file format is Barracuda.
    
17. 2017-04-08 12:56:24 25530 [Note] InnoDB: The log sequence numbers 1626004 and 1626004 in ibdata files do not match the log sequence number 1626104 in the ib_logfiles!
    
18. 2017-04-08 12:56:24 25530 [Note] InnoDB: Database was not shutdown normally!
    
19. 2017-04-08 12:56:24 25530 [Note] InnoDB: Starting crash recovery.
    
20. 2017-04-08 12:56:24 25530 [Note] InnoDB: Reading tablespace information from the .ibd files...
    
21. 2017-04-08 12:56:24 25530 [Note] InnoDB: Restoring possible half-written data pages
    
22. 2017-04-08 12:56:24 25530 [Note] InnoDB: from the doublewrite buffer...
    
23. 2017-04-08 12:56:24 25530 [Note] InnoDB: 128 rollback segment(s) are active.
    
24. 2017-04-08 12:56:24 25530 [Note] InnoDB: Waiting for purge to start
    
25. 2017-04-08 12:56:24 25530 [Note] InnoDB: 5.6.35 started; log sequence number 1626104
    
26. 2017-04-08 12:56:24 25530 [Note] Recovering after a crash using mysql-bin
    
27. 2017-04-08 12:56:24 25530 [Note] Starting crash recovery...
    
28. 2017-04-08 12:56:24 25530 [Note] Crash recovery finished.
    
29. 2017-04-08 12:56:24 25530 [Note] Server hostname (bind-address): '*'; port: 3306
    
30. 2017-04-08 12:56:24 25530 [Note] IPv6 is available.
    
31. 2017-04-08 12:56:24 25530 [Note]   - '::' resolves to '::';
    
32. 2017-04-08 12:56:24 25530 [Note] Server socket created on IP: '::'.
    
33. 2017-04-08 12:56:25 25530 [Note] Event Scheduler: Loaded 0 events
    
34. 2017-04-08 12:56:25 25530 [Note] /www/server/mysql/bin/mysqld: ready for connections.
    
35. Version: '5.6.35-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
    
36. 2017-04-08 12:59:38 25585 [Note] Plugin 'FEDERATED' is disabled.
    
37. 2017-04-08 12:59:38 25585 [Note] InnoDB: Using atomics to ref count buffer pool pages
    
38. 2017-04-08 12:59:38 25585 [Note] InnoDB: The InnoDB memory heap is disabled
    
39. 2017-04-08 12:59:38 25585 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
40. 2017-04-08 12:59:38 25585 [Note] InnoDB: Memory barrier is not used
    
41. 2017-04-08 12:59:38 25585 [Note] InnoDB: Compressed tables use zlib 1.2.3
    
42. 2017-04-08 12:59:38 25585 [Note] InnoDB: Using Linux native AIO
    
43. 2017-04-08 12:59:38 25585 [Note] InnoDB: Using CPU crc32 instructions
    
44. 2017-04-08 12:59:38 25585 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    
45. 2017-04-08 12:59:38 25585 [Note] InnoDB: Completed initialization of buffer pool
    
46. 2017-04-08 12:59:45 25585 [Note] InnoDB: Highest supported file format is Barracuda.
    
47. 2017-04-08 12:59:45 25585 [Note] InnoDB: The log sequence numbers 1626004 and 1626004 in ibdata files do not match the log sequence number 1626130 in the ib_logfiles!
    
48. 2017-04-08 12:59:45 25585 [Note] InnoDB: Database was not shutdown normally!
    
49. 2017-04-08 12:59:45 25585 [Note] InnoDB: Starting crash recovery.

复制代码

1. 
   
2. 2017-04-08 12:59:45 25585 [Note] InnoDB: Reading tablespace information from the .ibd files...
   
3. 2017-04-08 12:59:45 25585 [Note] InnoDB: Restoring possible half-written data pages
   
4. 2017-04-08 12:59:45 25585 [Note] InnoDB: from the doublewrite buffer...
   
5. 2017-04-08 13:00:03 26174 [Note] Plugin 'FEDERATED' is disabled.
   
6. 2017-04-08 13:00:04 26174 [Note] InnoDB: Using atomics to ref count buffer pool pages
   
7. 2017-04-08 13:00:04 26174 [Note] InnoDB: The InnoDB memory heap is disabled
   
8. 2017-04-08 13:00:04 26174 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
9. 2017-04-08 13:00:04 26174 [Note] InnoDB: Memory barrier is not used
   
10. 2017-04-08 13:00:04 26174 [Note] InnoDB: Compressed tables use zlib 1.2.3
    
11. 2017-04-08 13:00:04 26174 [Note] InnoDB: Using Linux native AIO
    
12. 2017-04-08 13:00:04 26174 [Note] InnoDB: Using CPU crc32 instructions
    
13. 2017-04-08 13:00:04 26174 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    
14. 2017-04-08 13:00:04 26174 [Note] InnoDB: Completed initialization of buffer pool
    
15. 2017-04-08 13:00:04 26174 [Note] InnoDB: Highest supported file format is Barracuda.
    
16. 2017-04-08 13:00:04 26174 [Note] InnoDB: The log sequence numbers 1626004 and 1626004 in ibdata files do not match the log sequence number 1626130 in the ib_logfiles!
    
17. 2017-04-08 13:00:04 26174 [Note] InnoDB: Database was not shutdown normally!
    
18. 2017-04-08 13:00:04 26174 [Note] InnoDB: Starting crash recovery.
    
19. 2017-04-08 13:00:04 26174 [Note] InnoDB: Reading tablespace information from the .ibd files...
    
20. 2017-04-08 13:00:04 26174 [Note] InnoDB: Restoring possible half-written data pages
    
21. 2017-04-08 13:00:04 26174 [Note] InnoDB: from the doublewrite buffer...
    
22. 2017-04-08 13:00:10 26174 [Note] InnoDB: 128 rollback segment(s) are active.
    
23. 2017-04-08 13:00:10 26174 [Note] InnoDB: Waiting for purge to start
    
24. 2017-04-08 13:00:10 26174 [Note] InnoDB: 5.6.35 started; log sequence number 1626130
    
25. 2017-04-08 13:01:29 26799 [Note] Plugin 'FEDERATED' is disabled.
    
26. 2017-04-08 13:01:29 26799 [Note] InnoDB: Using atomics to ref count buffer pool pages
    
27. 2017-04-08 13:01:29 26799 [Note] InnoDB: The InnoDB memory heap is disabled
    
28. 2017-04-08 13:01:29 26799 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
29. 2017-04-08 13:01:29 26799 [Note] InnoDB: Memory barrier is not used
    
30. 2017-04-08 13:01:29 26799 [Note] InnoDB: Compressed tables use zlib 1.2.3
    
31. 2017-04-08 13:01:29 26799 [Note] InnoDB: Using Linux native AIO
    
32. 2017-04-08 13:01:29 26799 [Note] InnoDB: Using CPU crc32 instructions
    
33. 2017-04-08 13:01:29 26799 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    
34. 2017-04-08 13:01:29 26799 [Note] InnoDB: Completed initialization of buffer pool
    
35. 2017-04-08 13:01:54 26799 [Note] InnoDB: Highest supported file format is Barracuda.
    
36. 2017-04-08 13:01:54 26799 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1626130
    
37. 2017-04-08 13:01:54 26799 [Note] InnoDB: Database was not shutdown normally!
    
38. 2017-04-08 13:01:54 26799 [Note] InnoDB: Starting crash recovery.
    
39. 2017-04-08 13:01:54 26799 [Note] InnoDB: Reading tablespace information from the .ibd files...
    
40. 2017-04-08 13:03:12 27429 [Note] Plugin 'FEDERATED' is disabled.
    
41. 2017-04-08 13:03:13 27429 [Note] InnoDB: Using atomics to ref count buffer pool pages
    
42. 2017-04-08 13:03:13 27429 [Note] InnoDB: The InnoDB memory heap is disabled
    
43. 2017-04-08 13:03:13 27429 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
44. 2017-04-08 13:03:13 27429 [Note] InnoDB: Memory barrier is not used
    
45. 2017-04-08 13:03:13 27429 [Note] InnoDB: Compressed tables use zlib 1.2.3
    
46. 2017-04-08 13:03:13 27429 [Note] InnoDB: Using Linux native AIO
    
47. 2017-04-08 13:03:13 27429 [Note] InnoDB: Using CPU crc32 instructions
    
48. 2017-04-08 13:03:13 27429 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    
49. 2017-04-08 13:03:13 27429 [Note] InnoDB: Completed initialization of buffer pool
    
50. 2017-04-08 13:03:14 27429 [Note] InnoDB: Highest supported file format is Barracuda.
    
51. 2017-04-08 13:03:14 27429 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1626130
    
52. 2017-04-08 13:03:14 27429 [Note] InnoDB: Database was not shutdown normally!
    
53. 2017-04-08 13:03:14 27429 [Note] InnoDB: Starting crash recovery.
    
54. 2017-04-08 13:03:14 27429 [Note] InnoDB: Reading tablespace information from the .ibd files...
    
55. 2017-04-08 13:03:14 27429 [Note] InnoDB: Restoring possible half-written data pages
    
56. 2017-04-08 13:03:14 27429 [Note] InnoDB: from the doublewrite buffer...
    
57. InnoDB: Doing recovery: scanned up to log sequence number 1626140
    
58. 2017-04-08 13:03:15 27429 [Note] InnoDB: 128 rollback segment(s) are active.
    
59. 2017-04-08 13:03:15 27429 [Note] InnoDB: Waiting for purge to start
    
60. 2017-04-08 13:03:16 27429 [Note] InnoDB: 5.6.35 started; log sequence number 1626140
    
61. 2017-04-08 13:03:16 27429 [Note] Recovering after a crash using mysql-bin
    
62. 2017-04-08 13:03:16 27429 [Note] Starting crash recovery...
    
63. 2017-04-08 13:03:16 27429 [Note] Crash recovery finished.
    
64. 2017-04-08 13:03:16 27429 [Note] Server hostname (bind-address): '*'; port: 3306
    
65. 2017-04-08 13:03:16 27429 [Note] IPv6 is available.
    
66. 2017-04-08 13:03:16 27429 [Note]   - '::' resolves to '::';
    
67. 2017-04-08 13:03:16 27429 [Note] Server socket created on IP: '::'.
    
68. 2017-04-08 13:03:30 27475 [Note] Plugin 'FEDERATED' is disabled.
    
69. 2017-04-08 13:03:30 27475 [Note] InnoDB: Using atomics to ref count buffer pool pages
    
70. 2017-04-08 13:03:30 27475 [Note] InnoDB: The InnoDB memory heap is disabled
    
71. 2017-04-08 13:03:30 27475 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
72. 2017-04-08 13:03:30 27475 [Note] InnoDB: Memory barrier is not used
    
73. 2017-04-08 13:03:30 27475 [Note] InnoDB: Compressed tables use zlib 1.2.3
    
74. 2017-04-08 13:03:30 27475 [Note] InnoDB: Using Linux native AIO
    
75. 2017-04-08 13:03:30 27475 [Note] InnoDB: Using CPU crc32 instructions
    
76. 2017-04-08 13:03:30 27475 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    
77. 2017-04-08 13:03:30 27475 [Note] InnoDB: Completed initialization of buffer pool
    
78. 2017-04-08 13:03:31 27475 [Note] InnoDB: Highest supported file format is Barracuda.
    
79. 2017-04-08 13:03:31 27475 [Note] InnoDB: The log sequence numbers 1626004 and 1626004 in ibdata files do not match the log sequence number 1626150 in the ib_logfiles!
    
80. 2017-04-08 13:03:31 27475 [Note] InnoDB: Database was not shutdown normally!
    
81. 2017-04-08 13:03:31 27475 [Note] InnoDB: Starting crash recovery.
    
82. 2017-04-08 13:03:31 27475 [Note] InnoDB: Reading tablespace information from the .ibd files...
    
83. 2017-04-08 13:03:32 27475 [Note] InnoDB: Restoring possible half-written data pages
    
84. 2017-04-08 13:03:32 27475 [Note] InnoDB: from the doublewrite buffer...

复制代码

这会数据库直接启不来了