点击参与 GreatSQL 8.0.32-26 文档捉虫~~~

GreatSQL社区

搜索

[待回复] 凝思6.0.99欧拉融合版使用万里导入数据很慢

936 17 2025-3-17 09:18
全部回复(17)
只看楼主
Yep. 2025-3-18 11:36:10
caihe.li 发表于 2025-3-18 10:06
冒昧留言，我看了下。配置文件一和配置文件二分别都是MGR 配置文件三是单机 这个是不是已经排除掉了。MGR ...

我目前都是在配置文件三的基础上测的
回复 采纳

举报

yejr 2025-3-18 14:22:31
Yep. 发表于 2025-3-18 09:24
我修改了innodb_flush_log_at_trx_commit=0，虚拟机内存16G，innodb_buffer_pool_size由10G改为了12G，再 ...

CPU 的%user和%sys非常高，需要再深入排查下原因，perf尽量搞定吧

另外，再在数据库中多执行几次 show engine innodb status\G ，也贴结果
回复 采纳

举报

Yep. 2025-3-18 15:09:19
yejr 发表于 2025-3-18 14:22
CPU 的%user和%sys非常高，需要再深入排查下原因，perf尽量搞定吧

另外，再在数据库中多执行几次 show e ...

导入前：

  1. (Tue Mar 18 08:46:09 2025)[root@GreatSQL][(none)]> show engine innodb status\G;                                                                                          
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 2025-03-18 14:31:31 140459658831616 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 26 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 3949 srv_active, 0 srv_shutdown, 62058 srv_idle
  14. srv_master_thread log flush and writes: 0
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 43396
  19. OS WAIT ARRAY INFO: signal count 53258
  20. RW-shared spins 0, rounds 0, OS waits 0
  21. RW-excl spins 0, rounds 0, OS waits 0
  22. RW-sx spins 0, rounds 0, OS waits 0
  23. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 47156
  28. Purge done for trx's n:o < 47156 undo n:o < 0 state: running but idle
  29. History list length 0
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421936924462440, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. ---TRANSACTION 421936924469224, not started
  34. 0 lock struct(s), heap size 1128, 0 row lock(s)
  35. ---TRANSACTION 421936924461592, not started
  36. 0 lock struct(s), heap size 1128, 0 row lock(s)
  37. ---TRANSACTION 421936924460744, not started
  38. 0 lock struct(s), heap size 1128, 0 row lock(s)
  39. --------
  40. FILE I/O
  41. --------
  42. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  43. I/O thread 1 state: waiting for completed aio requests (log thread)
  44. I/O thread 2 state: waiting for completed aio requests (read thread)
  45. I/O thread 3 state: waiting for completed aio requests (read thread)
  46. I/O thread 4 state: waiting for completed aio requests (read thread)
  47. I/O thread 5 state: waiting for completed aio requests (read thread)
  48. I/O thread 6 state: waiting for completed aio requests (write thread)
  49. I/O thread 7 state: waiting for completed aio requests (write thread)
  50. I/O thread 8 state: waiting for completed aio requests (write thread)
  51. I/O thread 9 state: waiting for completed aio requests (write thread)
  52. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  53. ibuf aio reads:, log i/o's:
  54. Pending flushes (fsync) log: 0; buffer pool: 0
  55. 1051 OS file reads, 6185759 OS file writes, 398189 OS fsyncs
  56. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  57. -------------------------------------
  58. INSERT BUFFER AND ADAPTIVE HASH INDEX
  59. -------------------------------------
  60. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  61. merged operations:
  62. insert 0, delete mark 0, delete 0
  63. discarded operations:
  64. insert 0, delete mark 0, delete 0
  65. Hash table size 2656321, node heap has 0 buffer(s)
  66. Hash table size 2656321, node heap has 12 buffer(s)
  67. Hash table size 2656321, node heap has 2 buffer(s)
  68. Hash table size 2656321, node heap has 1 buffer(s)
  69. Hash table size 2656321, node heap has 0 buffer(s)
  70. Hash table size 2656321, node heap has 5 buffer(s)
  71. Hash table size 2656321, node heap has 2 buffer(s)
  72. Hash table size 2656321, node heap has 1 buffer(s)
  73. 0.00 hash searches/s, 0.00 non-hash searches/s
  74. ---
  75. LOG
  76. ---
  77. Log sequence number          9751095836
  78. Log buffer assigned up to    9751095836
  79. Log buffer completed up to   9751095836
  80. Log written up to            9751095836
  81. Log flushed up to            9751095836
  82. Added dirty pages up to      9751095836
  83. Pages flushed up to          9751095836
  84. Last checkpoint at           9751095836
  85. Log minimum file id is       118
  86. Log maximum file id is       145
  87. Modified age no less than    9751095836
  88. Checkpoint age               0
  89. Max checkpoint age           1806985216
  90. 5258103 log i/o's done, 0.00 log i/o's/second
  91. ----------------------
  92. BUFFER POOL AND MEMORY
  93. ----------------------
  94. Total large memory allocated 0
  95. Dictionary memory allocated 2818205
  96. Buffer pool size   786336
  97. Buffer pool size, bytes 12883329024
  98. Free buffers       631767
  99. Database pages     154546
  100. Old database pages 56886
  101. Modified db pages  0
  102. Pending reads      0
  103. Pending writes: LRU 0, flush list 0, single page 0
  104. Pages made young 0, not young 0
  105. 0.00 youngs/s, 0.00 non-youngs/s
  106. Pages read 1009, created 153537, written 724965
  107. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  108. No buffer pool page gets since the last printout
  109. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  110. LRU len: 154546, unzip_LRU len: 0
  111. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  112. ----------------------
  113. INDIVIDUAL BUFFER POOL INFO
  114. ----------------------
  115. ---BUFFER POOL 0
  116. Buffer pool size   98292
  117. Buffer pool size, bytes 1610416128
  118. Free buffers       77973
  119. Database pages     20316
  120. Old database pages 7479
  121. Modified db pages  0
  122. Pending reads      0
  123. Pending writes: LRU 0, flush list 0, single page 0
  124. Pages made young 0, not young 0
  125. 0.00 youngs/s, 0.00 non-youngs/s
  126. Pages read 108, created 20208, written 94025
  127. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  128. No buffer pool page gets since the last printout
  129. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  130. LRU len: 20316, unzip_LRU len: 0
  131. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  132. ---BUFFER POOL 1
  133. Buffer pool size   98292
  134. Buffer pool size, bytes 1610416128
  135. Free buffers       79437
  136. Database pages     18853
  137. Old database pages 6940
  138. Modified db pages  0
  139. Pending reads      0
  140. Pending writes: LRU 0, flush list 0, single page 0
  141. Pages made young 0, not young 0
  142. 0.00 youngs/s, 0.00 non-youngs/s
  143. Pages read 86, created 18767, written 88913
  144. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  145. No buffer pool page gets since the last printout
  146. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  147. LRU len: 18853, unzip_LRU len: 0
  148. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  149. ---BUFFER POOL 2
  150. Buffer pool size   98292
  151. Buffer pool size, bytes 1610416128
  152. Free buffers       77935
  153. Database pages     20355
  154. Old database pages 7493
  155. Modified db pages  0
  156. Pending reads      0
  157. Pending writes: LRU 0, flush list 0, single page 0
  158. Pages made young 0, not young 0
  159. 0.00 youngs/s, 0.00 non-youngs/s
  160. Pages read 85, created 20270, written 96903
  161. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  162. No buffer pool page gets since the last printout
  163. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  164. LRU len: 20355, unzip_LRU len: 0
  165. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  166. ---BUFFER POOL 3
  167. Buffer pool size   98292
  168. Buffer pool size, bytes 1610416128
  169. Free buffers       79061
  170. Database pages     19229
  171. Old database pages 7078
  172. Modified db pages  0
  173. Pending reads      0
  174. Pending writes: LRU 0, flush list 0, single page 0
  175. Pages made young 0, not young 0
  176. 0.00 youngs/s, 0.00 non-youngs/s
  177. Pages read 227, created 19002, written 88464
  178. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  179. No buffer pool page gets since the last printout
  180. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  181. LRU len: 19229, unzip_LRU len: 0
  182. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  183. ---BUFFER POOL 4
  184. Buffer pool size   98292
  185. Buffer pool size, bytes 1610416128
  186. Free buffers       79551
  187. Database pages     18737
  188. Old database pages 6896
  189. Modified db pages  0
  190. Pending reads      0
  191. Pending writes: LRU 0, flush list 0, single page 0
  192. Pages made young 0, not young 0
  193. 0.00 youngs/s, 0.00 non-youngs/s
  194. Pages read 68, created 18669, written 88488
  195. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  196. No buffer pool page gets since the last printout
  197. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  198. LRU len: 18737, unzip_LRU len: 0
  199. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  200. ---BUFFER POOL 5
  201. Buffer pool size   98292
  202. Buffer pool size, bytes 1610416128
  203. Free buffers       80284
  204. Database pages     18005
  205. Old database pages 6626
  206. Modified db pages  0
  207. Pending reads      0
  208. Pending writes: LRU 0, flush list 0, single page 0
  209. Pages made young 0, not young 0
  210. 0.00 youngs/s, 0.00 non-youngs/s
  211. Pages read 58, created 17947, written 83096
  212. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  213. No buffer pool page gets since the last printout
  214. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  215. LRU len: 18005, unzip_LRU len: 0
  216. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  217. ---BUFFER POOL 6
  218. Buffer pool size   98292
  219. Buffer pool size, bytes 1610416128
  220. Free buffers       78293
  221. Database pages     19996
  222. Old database pages 7361
  223. Modified db pages  0
  224. Pending reads      0
  225. Pending writes: LRU 0, flush list 0, single page 0
  226. Pages made young 0, not young 0
  227. 0.00 youngs/s, 0.00 non-youngs/s
  228. Pages read 86, created 19910, written 94461
  229. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  230. No buffer pool page gets since the last printout
  231. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  232. LRU len: 19996, unzip_LRU len: 0
  233. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  234. ---BUFFER POOL 7
  235. Buffer pool size   98292
  236. Buffer pool size, bytes 1610416128
  237. Free buffers       79233
  238. Database pages     19055
  239. Old database pages 7013
  240. Modified db pages  0
  241. Pending reads      0
  242. Pending writes: LRU 0, flush list 0, single page 0
  243. Pages made young 0, not young 0
  244. 0.00 youngs/s, 0.00 non-youngs/s
  245. Pages read 291, created 18764, written 90615
  246. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  247. No buffer pool page gets since the last printout
  248. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  249. LRU len: 19055, unzip_LRU len: 0
  250. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  251. --------------
  252. ROW OPERATIONS
  253. --------------
  254. 0 queries inside InnoDB, 0 queries in queue
  255. 0 read views open inside InnoDB
  256. 0 RW transactions active inside InnoDB
  257. Process ID=39345, Main thread ID=140449788454656 , state=sleeping
  258. Number of rows inserted 6006421, updated 17499, deleted 4002307, read 19069758
  259. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  260. Number of system rows inserted 6515, updated 6012, deleted 55, read 18243
  261. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  262. ----------------------------
  263. END OF INNODB MONITOR OUTPUT
  264. ============================

  266. 1 row in set (0.08 sec)

  268. ERROR:
  269. No query specified
复制代码
导入过程中查询一：
  1. (Tue Mar 18 14:38:40 2025)[root@GreatSQL][(none)]> show engine innodb status\G;
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 2025-03-18 14:43:08 140459658831616 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 19 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 4335 srv_active, 0 srv_shutdown, 62369 srv_idle
  14. srv_master_thread log flush and writes: 0
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 45721
  19. OS WAIT ARRAY INFO: signal count 55296
  20. RW-shared spins 0, rounds 0, OS waits 0
  21. RW-excl spins 0, rounds 0, OS waits 0
  22. RW-sx spins 0, rounds 0, OS waits 0
  23. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 47705
  28. Purge done for trx's n:o < 47702 undo n:o < 0 state: running but idle
  29. History list length 8
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421936924462440, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. ---TRANSACTION 421936924461592, not started
  34. 0 lock struct(s), heap size 1128, 0 row lock(s)
  35. ---TRANSACTION 421936924460744, not started
  36. 0 lock struct(s), heap size 1128, 0 row lock(s)
  37. ---TRANSACTION 47704, ACTIVE 1 sec
  38. mysql tables in use 1, locked 1
  39. 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1578
  40. MySQL thread id 73, OS thread handle 140460799682304, query id 15182338 192.168.200.15 root waiting for handler commit
  41. insert into dlsoftdb.teleindication values('yx-123-2417','YX-2417',0,'1','1',123,2417,400,'',0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,'','','',0,0,0,0,'','','','','','','','','','','','',0,'','','' )
  42. --------
  43. FILE I/O
  44. --------
  45. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  46. I/O thread 1 state: waiting for completed aio requests (log thread)
  47. I/O thread 2 state: waiting for completed aio requests (read thread)
  48. I/O thread 3 state: waiting for completed aio requests (read thread)
  49. I/O thread 4 state: waiting for completed aio requests (read thread)
  50. I/O thread 5 state: waiting for completed aio requests (read thread)
  51. I/O thread 6 state: waiting for completed aio requests (write thread)
  52. I/O thread 7 state: waiting for completed aio requests (write thread)
  53. I/O thread 8 state: waiting for completed aio requests (write thread)
  54. I/O thread 9 state: waiting for completed aio requests (write thread)
  55. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  56. ibuf aio reads:, log i/o's:
  57. Pending flushes (fsync) log: 0; buffer pool: 0
  58. 1051 OS file reads, 7023134 OS file writes, 454369 OS fsyncs
  59. 0.00 reads/s, 0 avg bytes/read, 1510.86 writes/s, 110.82 fsyncs/s
  60. -------------------------------------
  61. INSERT BUFFER AND ADAPTIVE HASH INDEX
  62. -------------------------------------
  63. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  64. merged operations:
  65. insert 0, delete mark 0, delete 0
  66. discarded operations:
  67. insert 0, delete mark 0, delete 0
  68. Hash table size 2656321, node heap has 1 buffer(s)
  69. Hash table size 2656321, node heap has 2 buffer(s)
  70. Hash table size 2656321, node heap has 2 buffer(s)
  71. Hash table size 2656321, node heap has 1 buffer(s)
  72. Hash table size 2656321, node heap has 1 buffer(s)
  73. Hash table size 2656321, node heap has 1 buffer(s)
  74. Hash table size 2656321, node heap has 2 buffer(s)
  75. Hash table size 2656321, node heap has 1 buffer(s)
  76. 1.89 hash searches/s, 2390.51 non-hash searches/s
  77. ---
  78. LOG
  79. ---
  80. Log sequence number          11058810800
  81. Log buffer assigned up to    11058810800
  82. Log buffer completed up to   11058810800
  83. Log written up to            11058810800
  84. Log flushed up to            11058128052
  85. Added dirty pages up to      11058810800
  86. Pages flushed up to          10422956987
  87. Last checkpoint at           10421433957
  88. Log minimum file id is       145
  89. Log maximum file id is       164
  90. Modified age no less than    634633877
  91. Checkpoint age               637376843
  92. Max checkpoint age           1806985216
  93. 5969175 log i/o's done, 1286.95 log i/o's/second
  94. ----------------------
  95. BUFFER POOL AND MEMORY
  96. ----------------------
  97. Total large memory allocated 0
  98. Dictionary memory allocated 2818205
  99. Buffer pool size   786336
  100. Buffer pool size, bytes 12883329024
  101. Free buffers       631736
  102. Database pages     154589
  103. Old database pages 56905
  104. Modified db pages  69325
  105. Pending reads      0
  106. Pending writes: LRU 0, flush list 0, single page 0
  107. Pages made young 0, not young 0
  108. 0.00 youngs/s, 0.00 non-youngs/s
  109. Pages read 1009, created 153580, written 823971
  110. 0.00 reads/s, 0.00 creates/s, 207.80 writes/s
  111. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  112. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  113. LRU len: 154589, unzip_LRU len: 0
  114. I/O sum[0]:cur[264], unzip sum[0]:cur[0]
  115. ----------------------
  116. INDIVIDUAL BUFFER POOL INFO
  117. ----------------------
  118. ---BUFFER POOL 0
  119. Buffer pool size   98292
  120. Buffer pool size, bytes 1610416128
  121. Free buffers       77975
  122. Database pages     20316
  123. Old database pages 7479
  124. Modified db pages  9022
  125. Pending reads      0
  126. Pending writes: LRU 0, flush list 0, single page 0
  127. Pages made young 0, not young 0
  128. 0.00 youngs/s, 0.00 non-youngs/s
  129. Pages read 108, created 20208, written 106744
  130. 0.00 reads/s, 0.00 creates/s, 25.66 writes/s
  131. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  132. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  133. LRU len: 20316, unzip_LRU len: 0
  134. I/O sum[0]:cur[33], unzip sum[0]:cur[0]
  135. ---BUFFER POOL 1
  136. Buffer pool size   98292
  137. Buffer pool size, bytes 1610416128
  138. Free buffers       79438
  139. Database pages     18853
  140. Old database pages 6940
  141. Modified db pages  8457
  142. Pending reads      0
  143. Pending writes: LRU 0, flush list 0, single page 0
  144. Pages made young 0, not young 0
  145. 0.00 youngs/s, 0.00 non-youngs/s
  146. Pages read 86, created 18767, written 100851
  147. 0.00 reads/s, 0.00 creates/s, 43.78 writes/s
  148. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  149. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  150. LRU len: 18853, unzip_LRU len: 0
  151. I/O sum[0]:cur[33], unzip sum[0]:cur[0]
  152. ---BUFFER POOL 2
  153. Buffer pool size   98292
  154. Buffer pool size, bytes 1610416128
  155. Free buffers       77928
  156. Database pages     20362
  157. Old database pages 7497
  158. Modified db pages  9122
  159. Pending reads      0
  160. Pending writes: LRU 0, flush list 0, single page 0
  161. Pages made young 0, not young 0
  162. 0.00 youngs/s, 0.00 non-youngs/s
  163. Pages read 85, created 20277, written 110073
  164. 0.00 reads/s, 0.00 creates/s, 18.11 writes/s
  165. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  166. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  167. LRU len: 20362, unzip_LRU len: 0
  168. I/O sum[0]:cur[33], unzip sum[0]:cur[0]
  169. ---BUFFER POOL 3
  170. Buffer pool size   98292
  171. Buffer pool size, bytes 1610416128
  172. Free buffers       79062
  173. Database pages     19229
  174. Old database pages 7078
  175. Modified db pages  8572
  176. Pending reads      0
  177. Pending writes: LRU 0, flush list 0, single page 0
  178. Pages made young 0, not young 0
  179. 0.00 youngs/s, 0.00 non-youngs/s
  180. Pages read 227, created 19002, written 101065
  181. 0.00 reads/s, 0.00 creates/s, 29.34 writes/s
  182. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  183. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  184. LRU len: 19229, unzip_LRU len: 0
  185. I/O sum[0]:cur[33], unzip sum[0]:cur[0]
  186. ---BUFFER POOL 4
  187. Buffer pool size   98292
  188. Buffer pool size, bytes 1610416128
  189. Free buffers       79553
  190. Database pages     18737
  191. Old database pages 6896
  192. Modified db pages  8556
  193. Pending reads      0
  194. Pending writes: LRU 0, flush list 0, single page 0
  195. Pages made young 0, not young 0
  196. 0.00 youngs/s, 0.00 non-youngs/s
  197. Pages read 68, created 18669, written 100377
  198. 0.00 reads/s, 0.00 creates/s, 31.79 writes/s
  199. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  200. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  201. LRU len: 18737, unzip_LRU len: 0
  202. I/O sum[0]:cur[33], unzip sum[0]:cur[0]
  203. ---BUFFER POOL 5
  204. Buffer pool size   98292
  205. Buffer pool size, bytes 1610416128
  206. Free buffers       80286
  207. Database pages     18005
  208. Old database pages 6626
  209. Modified db pages  7926
  210. Pending reads      0
  211. Pending writes: LRU 0, flush list 0, single page 0
  212. Pages made young 0, not young 0
  213. 0.00 youngs/s, 0.00 non-youngs/s
  214. Pages read 58, created 17947, written 95330
  215. 0.00 reads/s, 0.00 creates/s, 25.10 writes/s
  216. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  217. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  218. LRU len: 18005, unzip_LRU len: 0
  219. I/O sum[0]:cur[33], unzip sum[0]:cur[0]
  220. ---BUFFER POOL 6
  221. Buffer pool size   98292
  222. Buffer pool size, bytes 1610416128
  223. Free buffers       78289
  224. Database pages     20002
  225. Old database pages 7364
  226. Modified db pages  9214
  227. Pending reads      0
  228. Pending writes: LRU 0, flush list 0, single page 0
  229. Pages made young 0, not young 0
  230. 0.00 youngs/s, 0.00 non-youngs/s
  231. Pages read 86, created 19916, written 107200
  232. 0.00 reads/s, 0.00 creates/s, 12.40 writes/s
  233. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  234. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  235. LRU len: 20002, unzip_LRU len: 0
  236. I/O sum[0]:cur[33], unzip sum[0]:cur[0]
  237. ---BUFFER POOL 7
  238. Buffer pool size   98292
  239. Buffer pool size, bytes 1610416128
  240. Free buffers       79205
  241. Database pages     19085
  242. Old database pages 7025
  243. Modified db pages  8456
  244. Pending reads      0
  245. Pending writes: LRU 0, flush list 0, single page 0
  246. Pages made young 0, not young 0
  247. 0.00 youngs/s, 0.00 non-youngs/s
  248. Pages read 291, created 18794, written 102331
  249. 0.00 reads/s, 0.00 creates/s, 21.63 writes/s
  250. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  251. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  252. LRU len: 19085, unzip_LRU len: 0
  253. I/O sum[0]:cur[33], unzip sum[0]:cur[0]
  254. --------------
  255. ROW OPERATIONS
  256. --------------
  257. 0 queries inside InnoDB, 0 queries in queue
  258. 0 read views open inside InnoDB
  259. 1 RW transactions active inside InnoDB
  260. Process ID=39345, Main thread ID=140449788454656 , state=sleeping
  261. Number of rows inserted 6081396, updated 17499, deleted 6005404, read 21573183
  262. 2091.36 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  263. Number of system rows inserted 6515, updated 6012, deleted 55, read 18631
  264. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  265. ----------------------------
  266. END OF INNODB MONITOR OUTPUT
  267. ============================

  269. 1 row in set (0.00 sec)

  271. ERROR:
  272. No query specified
复制代码



导入过程中查询二：
  1. (Tue Mar 18 14:43:08 2025)[root@GreatSQL][(none)]> show engine innodb status\G;
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 2025-03-18 14:47:04 140459658831616 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 0 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 4571 srv_active, 0 srv_shutdown, 62369 srv_idle
  14. srv_master_thread log flush and writes: 0
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 48229
  19. OS WAIT ARRAY INFO: signal count 57437
  20. RW-shared spins 0, rounds 0, OS waits 0
  21. RW-excl spins 0, rounds 0, OS waits 0
  22. RW-sx spins 0, rounds 0, OS waits 0
  23. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 47990
  28. Purge done for trx's n:o < 47986 undo n:o < 0 state: running but idle
  29. History list length 5
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421936924462440, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. ---TRANSACTION 421936924461592, not started
  34. 0 lock struct(s), heap size 1128, 0 row lock(s)
  35. ---TRANSACTION 421936924460744, not started
  36. 0 lock struct(s), heap size 1128, 0 row lock(s)
  37. ---TRANSACTION 47989, ACTIVE 1 sec
  38. mysql tables in use 2, locked 2
  39. 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1549
  40. MySQL thread id 73, OS thread handle 140460799682304, query id 15627496 192.168.200.15 root update
  41. insert into dlsoftdb.telemetering values('yc-1-1040','YC-1040',0,'1','1',0,0,'',1,1040,1,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',0,0,0,0,'','','','','','','',0,0,'','','' )
  42. --------
  43. FILE I/O
  44. --------
  45. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  46. I/O thread 1 state: waiting for completed aio requests (log thread)
  47. I/O thread 2 state: waiting for completed aio requests (read thread)
  48. I/O thread 3 state: waiting for completed aio requests (read thread)
  49. I/O thread 4 state: waiting for completed aio requests (read thread)
  50. I/O thread 5 state: waiting for completed aio requests (read thread)
  51. I/O thread 6 state: waiting for completed aio requests (write thread)
  52. I/O thread 7 state: waiting for completed aio requests (write thread)
  53. I/O thread 8 state: waiting for completed aio requests (write thread)
  54. I/O thread 9 state: waiting for completed aio requests (write thread)
  55. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  56. ibuf aio reads:, log i/o's:
  57. Pending flushes (fsync) log: 0; buffer pool: 0
  58. 1051 OS file reads, 7397301 OS file writes, 494330 OS fsyncs
  59. 0.00 reads/s, 0 avg bytes/read, 1682.59 writes/s, 0.00 fsyncs/s
  60. -------------------------------------
  61. INSERT BUFFER AND ADAPTIVE HASH INDEX
  62. -------------------------------------
  63. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  64. merged operations:
  65. insert 0, delete mark 0, delete 0
  66. discarded operations:
  67. insert 0, delete mark 0, delete 0
  68. Hash table size 2656321, node heap has 1 buffer(s)
  69. Hash table size 2656321, node heap has 1 buffer(s)
  70. Hash table size 2656321, node heap has 2 buffer(s)
  71. Hash table size 2656321, node heap has 1 buffer(s)
  72. Hash table size 2656321, node heap has 1 buffer(s)
  73. Hash table size 2656321, node heap has 1 buffer(s)
  74. Hash table size 2656321, node heap has 2 buffer(s)
  75. Hash table size 2656321, node heap has 1 buffer(s)
  76. 0.00 hash searches/s, 508000.00 non-hash searches/s
  77. ---
  78. LOG
  79. ---
  80. Log sequence number          11605861220
  81. Log buffer assigned up to    11605861220
  82. Log buffer completed up to   11605861220
  83. Log written up to            11605861220
  84. Log flushed up to            11605079956
  85. Added dirty pages up to      11605861220
  86. Pages flushed up to          11212772258
  87. Last checkpoint at           11212772258
  88. Log minimum file id is       145
  89. Log maximum file id is       172
  90. Modified age no less than    393088962
  91. Checkpoint age               393088962
  92. Max checkpoint age           1806985216
  93. 6244486 log i/o's done, 280.00 log i/o's/second
  94. ----------------------
  95. BUFFER POOL AND MEMORY
  96. ----------------------
  97. Total large memory allocated 0
  98. Dictionary memory allocated 2818205
  99. Buffer pool size   786336
  100. Buffer pool size, bytes 12883329024
  101. Free buffers       631737
  102. Database pages     154589
  103. Old database pages 56905
  104. Modified db pages  22244
  105. Pending reads      0
  106. Pending writes: LRU 0, flush list 0, single page 0
  107. Pages made young 0, not young 0
  108. 0.00 youngs/s, 0.00 non-youngs/s
  109. Pages read 1009, created 153580, written 902450
  110. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  111. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  112. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  113. LRU len: 154589, unzip_LRU len: 0
  114. I/O sum[0]:cur[1368], unzip sum[0]:cur[0]
  115. ----------------------
  116. INDIVIDUAL BUFFER POOL INFO
  117. ----------------------
  118. ---BUFFER POOL 0
  119. Buffer pool size   98292
  120. Buffer pool size, bytes 1610416128
  121. Free buffers       77975
  122. Database pages     20316
  123. Old database pages 7479
  124. Modified db pages  3447
  125. Pending reads      0
  126. Pending writes: LRU 0, flush list 0, single page 0
  127. Pages made young 0, not young 0
  128. 0.00 youngs/s, 0.00 non-youngs/s
  129. Pages read 108, created 20208, written 117001
  130. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  131. No buffer pool page gets since the last printout
  132. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  133. LRU len: 20316, unzip_LRU len: 0
  134. I/O sum[0]:cur[171], unzip sum[0]:cur[0]
  135. ---BUFFER POOL 1
  136. Buffer pool size   98292
  137. Buffer pool size, bytes 1610416128
  138. Free buffers       79438
  139. Database pages     18853
  140. Old database pages 6940
  141. Modified db pages  2166
  142. Pending reads      0
  143. Pending writes: LRU 0, flush list 0, single page 0
  144. Pages made young 0, not young 0
  145. 0.00 youngs/s, 0.00 non-youngs/s
  146. Pages read 86, created 18767, written 110197
  147. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  148. No buffer pool page gets since the last printout
  149. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  150. LRU len: 18853, unzip_LRU len: 0
  151. I/O sum[0]:cur[171], unzip sum[0]:cur[0]
  152. ---BUFFER POOL 2
  153. Buffer pool size   98292
  154. Buffer pool size, bytes 1610416128
  155. Free buffers       77928
  156. Database pages     20362
  157. Old database pages 7497
  158. Modified db pages  3271
  159. Pending reads      0
  160. Pending writes: LRU 0, flush list 0, single page 0
  161. Pages made young 0, not young 0
  162. 0.00 youngs/s, 0.00 non-youngs/s
  163. Pages read 85, created 20277, written 120254
  164. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  165. No buffer pool page gets since the last printout
  166. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  167. LRU len: 20362, unzip_LRU len: 0
  168. I/O sum[0]:cur[171], unzip sum[0]:cur[0]
  169. ---BUFFER POOL 3
  170. Buffer pool size   98292
  171. Buffer pool size, bytes 1610416128
  172. Free buffers       79062
  173. Database pages     19229
  174. Old database pages 7078
  175. Modified db pages  2621
  176. Pending reads      0
  177. Pending writes: LRU 0, flush list 0, single page 0
  178. Pages made young 0, not young 0
  179. 0.00 youngs/s, 0.00 non-youngs/s
  180. Pages read 227, created 19002, written 110717
  181. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  182. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  183. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  184. LRU len: 19229, unzip_LRU len: 0
  185. I/O sum[0]:cur[171], unzip sum[0]:cur[0]
  186. ---BUFFER POOL 4
  187. Buffer pool size   98292
  188. Buffer pool size, bytes 1610416128
  189. Free buffers       79554
  190. Database pages     18737
  191. Old database pages 6896
  192. Modified db pages  2244
  193. Pending reads      0
  194. Pending writes: LRU 0, flush list 0, single page 0
  195. Pages made young 0, not young 0
  196. 0.00 youngs/s, 0.00 non-youngs/s
  197. Pages read 68, created 18669, written 110274
  198. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  199. No buffer pool page gets since the last printout
  200. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  201. LRU len: 18737, unzip_LRU len: 0
  202. I/O sum[0]:cur[171], unzip sum[0]:cur[0]
  203. ---BUFFER POOL 5
  204. Buffer pool size   98292
  205. Buffer pool size, bytes 1610416128
  206. Free buffers       80286
  207. Database pages     18005
  208. Old database pages 6626
  209. Modified db pages  2580
  210. Pending reads      0
  211. Pending writes: LRU 0, flush list 0, single page 0
  212. Pages made young 0, not young 0
  213. 0.00 youngs/s, 0.00 non-youngs/s
  214. Pages read 58, created 17947, written 104363
  215. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  216. No buffer pool page gets since the last printout
  217. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  218. LRU len: 18005, unzip_LRU len: 0
  219. I/O sum[0]:cur[171], unzip sum[0]:cur[0]
  220. ---BUFFER POOL 6
  221. Buffer pool size   98292
  222. Buffer pool size, bytes 1610416128
  223. Free buffers       78289
  224. Database pages     20002
  225. Old database pages 7364
  226. Modified db pages  2961
  227. Pending reads      0
  228. Pending writes: LRU 0, flush list 0, single page 0
  229. Pages made young 0, not young 0
  230. 0.00 youngs/s, 0.00 non-youngs/s
  231. Pages read 86, created 19916, written 118004
  232. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  233. No buffer pool page gets since the last printout
  234. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  235. LRU len: 20002, unzip_LRU len: 0
  236. I/O sum[0]:cur[171], unzip sum[0]:cur[0]
  237. ---BUFFER POOL 7
  238. Buffer pool size   98292
  239. Buffer pool size, bytes 1610416128
  240. Free buffers       79205
  241. Database pages     19085
  242. Old database pages 7025
  243. Modified db pages  2954
  244. Pending reads      0
  245. Pending writes: LRU 0, flush list 0, single page 0
  246. Pages made young 0, not young 0
  247. 0.00 youngs/s, 0.00 non-youngs/s
  248. Pages read 291, created 18794, written 111640
  249. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  250. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  251. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  252. LRU len: 19085, unzip_LRU len: 0
  253. I/O sum[0]:cur[171], unzip sum[0]:cur[0]
  254. --------------
  255. ROW OPERATIONS
  256. --------------
  257. 0 queries inside InnoDB, 0 queries in queue
  258. 0 read views open inside InnoDB
  259. 1 RW transactions active inside InnoDB
  260. Process ID=39345, Main thread ID=140449788454656 , state=sleeping
  261. Number of rows inserted 6517367, updated 17499, deleted 6005704, read 21573483
  262. 452000.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  263. Number of system rows inserted 6515, updated 6012, deleted 55, read 18631
  264. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  265. ----------------------------
  266. END OF INNODB MONITOR OUTPUT
  267. ============================

  269. 1 row in set (0.00 sec)

  271. ERROR:
  272. No query specified
复制代码


导入过程中查询三：
  1. (Tue Mar 18 14:51:01 2025)[root@GreatSQL][(none)]> show engine innodb status\G;
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 2025-03-18 14:51:06 140459658831616 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 2 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 4813 srv_active, 0 srv_shutdown, 62369 srv_idle
  14. srv_master_thread log flush and writes: 0
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 49345
  19. OS WAIT ARRAY INFO: signal count 58361
  20. RW-shared spins 0, rounds 0, OS waits 0
  21. RW-excl spins 0, rounds 0, OS waits 0
  22. RW-sx spins 0, rounds 0, OS waits 0
  23. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 48267
  28. Purge done for trx's n:o < 48254 undo n:o < 0 state: running but idle
  29. History list length 6
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421936924462440, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. ---TRANSACTION 421936924461592, not started
  34. 0 lock struct(s), heap size 1128, 0 row lock(s)
  35. ---TRANSACTION 421936924460744, not started
  36. 0 lock struct(s), heap size 1128, 0 row lock(s)
  37. ---TRANSACTION 48266, ACTIVE 1 sec
  38. 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1921
  39. MySQL thread id 73, OS thread handle 140460799682304, query id 16481547 192.168.200.15 root closing tables
  40. insert into dlsoftdb.telemetering values('yc-15-6777','YC-6777',0,'1','1',0,0,'',15,6777,1,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',0,0,0,0,'','','','','','','',0,0,'','','' )
  41. --------
  42. FILE I/O
  43. --------
  44. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  45. I/O thread 1 state: waiting for completed aio requests (log thread)
  46. I/O thread 2 state: waiting for completed aio requests (read thread)
  47. I/O thread 3 state: waiting for completed aio requests (read thread)
  48. I/O thread 4 state: waiting for completed aio requests (read thread)
  49. I/O thread 5 state: waiting for completed aio requests (read thread)
  50. I/O thread 6 state: waiting for completed aio requests (write thread)
  51. I/O thread 7 state: waiting for completed aio requests (write thread)
  52. I/O thread 8 state: waiting for completed aio requests (write thread)
  53. I/O thread 9 state: waiting for completed aio requests (write thread)
  54. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  55. ibuf aio reads:, log i/o's:
  56. Pending flushes (fsync) log: 0; buffer pool: 0
  57. 1051 OS file reads, 7756198 OS file writes, 509661 OS fsyncs
  58. 0.00 reads/s, 0 avg bytes/read, 1529.58 writes/s, 49.74 fsyncs/s
  59. -------------------------------------
  60. INSERT BUFFER AND ADAPTIVE HASH INDEX
  61. -------------------------------------
  62. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  63. merged operations:
  64. insert 0, delete mark 0, delete 0
  65. discarded operations:
  66. insert 0, delete mark 0, delete 0
  67. Hash table size 2656321, node heap has 1 buffer(s)
  68. Hash table size 2656321, node heap has 1 buffer(s)
  69. Hash table size 2656321, node heap has 2 buffer(s)
  70. Hash table size 2656321, node heap has 1 buffer(s)
  71. Hash table size 2656321, node heap has 1 buffer(s)
  72. Hash table size 2656321, node heap has 1 buffer(s)
  73. Hash table size 2656321, node heap has 2 buffer(s)
  74. Hash table size 2656321, node heap has 1 buffer(s)
  75. 0.00 hash searches/s, 2204.40 non-hash searches/s
  76. ---
  77. LOG
  78. ---
  79. Log sequence number          12087728664
  80. Log buffer assigned up to    12087728664
  81. Log buffer completed up to   12087728664
  82. Log written up to            12087728664
  83. Log flushed up to            12086951391
  84. Added dirty pages up to      12087728664
  85. Pages flushed up to          11694063902
  86. Last checkpoint at           11693341289
  87. Log minimum file id is       170
  88. Log maximum file id is       180
  89. Modified age no less than    387300509
  90. Checkpoint age               394387375
  91. Max checkpoint age           1806985216
  92. 6567917 log i/o's done, 1558.00 log i/o's/second
  93. ----------------------
  94. BUFFER POOL AND MEMORY
  95. ----------------------
  96. Total large memory allocated 0
  97. Dictionary memory allocated 2818205
  98. Buffer pool size   786336
  99. Buffer pool size, bytes 12883329024
  100. Free buffers       631737
  101. Database pages     154589
  102. Old database pages 56905
  103. Modified db pages  21550
  104. Pending reads      0
  105. Pending writes: LRU 0, flush list 0, single page 0
  106. Pages made young 0, not young 0
  107. 0.00 youngs/s, 0.00 non-youngs/s
  108. Pages read 1009, created 153580, written 930148
  109. 0.00 reads/s, 0.00 creates/s, 83.05 writes/s
  110. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  111. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  112. LRU len: 154589, unzip_LRU len: 0
  113. I/O sum[0]:cur[744], unzip sum[0]:cur[0]
  114. ----------------------
  115. INDIVIDUAL BUFFER POOL INFO
  116. ----------------------
  117. ---BUFFER POOL 0
  118. Buffer pool size   98292
  119. Buffer pool size, bytes 1610416128
  120. Free buffers       77975
  121. Database pages     20316
  122. Old database pages 7479
  123. Modified db pages  2875
  124. Pending reads      0
  125. Pending writes: LRU 0, flush list 0, single page 0
  126. Pages made young 0, not young 0
  127. 0.00 youngs/s, 0.00 non-youngs/s
  128. Pages read 108, created 20208, written 121027
  129. 0.00 reads/s, 0.00 creates/s, 9.13 writes/s
  130. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  131. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  132. LRU len: 20316, unzip_LRU len: 0
  133. I/O sum[0]:cur[93], unzip sum[0]:cur[0]
  134. ---BUFFER POOL 1
  135. Buffer pool size   98292
  136. Buffer pool size, bytes 1610416128
  137. Free buffers       79438
  138. Database pages     18853
  139. Old database pages 6940
  140. Modified db pages  2602
  141. Pending reads      0
  142. Pending writes: LRU 0, flush list 0, single page 0
  143. Pages made young 0, not young 0
  144. 0.00 youngs/s, 0.00 non-youngs/s
  145. Pages read 86, created 18767, written 113485
  146. 0.00 reads/s, 0.00 creates/s, 3.19 writes/s
  147. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  148. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  149. LRU len: 18853, unzip_LRU len: 0
  150. I/O sum[0]:cur[93], unzip sum[0]:cur[0]
  151. ---BUFFER POOL 2
  152. Buffer pool size   98292
  153. Buffer pool size, bytes 1610416128
  154. Free buffers       77928
  155. Database pages     20362
  156. Old database pages 7497
  157. Modified db pages  2836
  158. Pending reads      0
  159. Pending writes: LRU 0, flush list 0, single page 0
  160. Pages made young 0, not young 0
  161. 0.00 youngs/s, 0.00 non-youngs/s
  162. Pages read 85, created 20277, written 123977
  163. 0.00 reads/s, 0.00 creates/s, 5.02 writes/s
  164. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  165. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  166. LRU len: 20362, unzip_LRU len: 0
  167. I/O sum[0]:cur[93], unzip sum[0]:cur[0]
  168. ---BUFFER POOL 3
  169. Buffer pool size   98292
  170. Buffer pool size, bytes 1610416128
  171. Free buffers       79062
  172. Database pages     19229
  173. Old database pages 7078
  174. Modified db pages  2374
  175. Pending reads      0
  176. Pending writes: LRU 0, flush list 0, single page 0
  177. Pages made young 0, not young 0
  178. 0.00 youngs/s, 0.00 non-youngs/s
  179. Pages read 227, created 19002, written 114135
  180. 0.00 reads/s, 0.00 creates/s, 22.36 writes/s
  181. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  182. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  183. LRU len: 19229, unzip_LRU len: 0
  184. I/O sum[0]:cur[93], unzip sum[0]:cur[0]
  185. ---BUFFER POOL 4
  186. Buffer pool size   98292
  187. Buffer pool size, bytes 1610416128
  188. Free buffers       79554
  189. Database pages     18737
  190. Old database pages 6896
  191. Modified db pages  2649
  192. Pending reads      0
  193. Pending writes: LRU 0, flush list 0, single page 0
  194. Pages made young 0, not young 0
  195. 0.00 youngs/s, 0.00 non-youngs/s
  196. Pages read 68, created 18669, written 113188
  197. 0.00 reads/s, 0.00 creates/s, 12.78 writes/s
  198. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  199. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  200. LRU len: 18737, unzip_LRU len: 0
  201. I/O sum[0]:cur[93], unzip sum[0]:cur[0]
  202. ---BUFFER POOL 5
  203. Buffer pool size   98292
  204. Buffer pool size, bytes 1610416128
  205. Free buffers       80286
  206. Database pages     18005
  207. Old database pages 6626
  208. Modified db pages  2299
  209. Pending reads      0
  210. Pending writes: LRU 0, flush list 0, single page 0
  211. Pages made young 0, not young 0
  212. 0.00 youngs/s, 0.00 non-youngs/s
  213. Pages read 58, created 17947, written 107587
  214. 0.00 reads/s, 0.00 creates/s, 14.60 writes/s
  215. No buffer pool page gets since the last printout
  216. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  217. LRU len: 18005, unzip_LRU len: 0
  218. I/O sum[0]:cur[93], unzip sum[0]:cur[0]
  219. ---BUFFER POOL 6
  220. Buffer pool size   98292
  221. Buffer pool size, bytes 1610416128
  222. Free buffers       78289
  223. Database pages     20002
  224. Old database pages 7364
  225. Modified db pages  2815
  226. Pending reads      0
  227. Pending writes: LRU 0, flush list 0, single page 0
  228. Pages made young 0, not young 0
  229. 0.00 youngs/s, 0.00 non-youngs/s
  230. Pages read 86, created 19916, written 121489
  231. 0.00 reads/s, 0.00 creates/s, 3.19 writes/s
  232. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  233. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  234. LRU len: 20002, unzip_LRU len: 0
  235. I/O sum[0]:cur[93], unzip sum[0]:cur[0]
  236. ---BUFFER POOL 7
  237. Buffer pool size   98292
  238. Buffer pool size, bytes 1610416128
  239. Free buffers       79205
  240. Database pages     19085
  241. Old database pages 7025
  242. Modified db pages  3100
  243. Pending reads      0
  244. Pending writes: LRU 0, flush list 0, single page 0
  245. Pages made young 0, not young 0
  246. 0.00 youngs/s, 0.00 non-youngs/s
  247. Pages read 291, created 18794, written 115260
  248. 0.00 reads/s, 0.00 creates/s, 12.78 writes/s
  249. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  250. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  251. LRU len: 19085, unzip_LRU len: 0
  252. I/O sum[0]:cur[93], unzip sum[0]:cur[0]
  253. --------------
  254. ROW OPERATIONS
  255. --------------
  256. 0 queries inside InnoDB, 0 queries in queue
  257. 0 read views open inside InnoDB
  258. 1 RW transactions active inside InnoDB
  259. Process ID=39345, Main thread ID=140449788454656 , state=sleeping
  260. Number of rows inserted 6943739, updated 17499, deleted 6005704, read 21573483
  261. 1959.52 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  262. Number of system rows inserted 6515, updated 6012, deleted 55, read 18631
  263. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  264. ----------------------------
  265. END OF INNODB MONITOR OUTPUT
  266. ============================

  268. 1 row in set (0.00 sec)

  270. ERROR:
  271. No query specified
复制代码


导入过程中查询四：
  1. (Tue Mar 18 14:54:32 2025)[root@GreatSQL][(none)]>show engine innodb status\G;
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 2025-03-18 14:54:47 140459658831616 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 27 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 5034 srv_active, 0 srv_shutdown, 62369 srv_idle
  14. srv_master_thread log flush and writes: 0
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 50251
  19. OS WAIT ARRAY INFO: signal count 59105
  20. RW-shared spins 0, rounds 0, OS waits 0
  21. RW-excl spins 0, rounds 0, OS waits 0
  22. RW-sx spins 0, rounds 0, OS waits 0
  23. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 48488
  28. Purge done for trx's n:o < 48485 undo n:o < 0 state: running but idle
  29. History list length 4
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421936924462440, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. ---TRANSACTION 421936924461592, not started
  34. 0 lock struct(s), heap size 1128, 0 row lock(s)
  35. ---TRANSACTION 421936924460744, not started
  36. 0 lock struct(s), heap size 1128, 0 row lock(s)
  37. ---TRANSACTION 48487, ACTIVE 1 sec
  38. mysql tables in use 2, locked 2
  39. 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 822
  40. MySQL thread id 73, OS thread handle 140460799682304, query id 17252538 192.168.200.15 root update
  41. insert into dlsoftdb.telemetering values('yc-197-2187','YC-2187',0,'1','1',0,0,'',197,2187,1,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',0,0,0,0,'','','','','','','',0,0,'','','' )
  42. --------
  43. FILE I/O
  44. --------
  45. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  46. I/O thread 1 state: waiting for completed aio requests (log thread)
  47. I/O thread 2 state: waiting for completed aio requests (read thread)
  48. I/O thread 3 state: waiting for completed aio requests (read thread)
  49. I/O thread 4 state: waiting for completed aio requests (read thread)
  50. I/O thread 5 state: waiting for completed aio requests (read thread)
  51. I/O thread 6 state: waiting for completed aio requests (write thread)
  52. I/O thread 7 state: waiting for completed aio requests (write thread)
  53. I/O thread 8 state: waiting for completed aio requests (write thread)
  54. I/O thread 9 state: complete io for buf page (write thread)
  55. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 4] ,
  56. ibuf aio reads:, log i/o's:
  57. Pending flushes (fsync) log: 0; buffer pool: 1
  58. 1051 OS file reads, 8076752 OS file writes, 522236 OS fsyncs
  59. 0.00 reads/s, 0 avg bytes/read, 1490.02 writes/s, 60.47 fsyncs/s
  60. -------------------------------------
  61. INSERT BUFFER AND ADAPTIVE HASH INDEX
  62. -------------------------------------
  63. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  64. merged operations:
  65. insert 0, delete mark 0, delete 0
  66. discarded operations:
  67. insert 0, delete mark 0, delete 0
  68. Hash table size 2656321, node heap has 1 buffer(s)
  69. Hash table size 2656321, node heap has 1 buffer(s)
  70. Hash table size 2656321, node heap has 2 buffer(s)
  71. Hash table size 2656321, node heap has 1 buffer(s)
  72. Hash table size 2656321, node heap has 1 buffer(s)
  73. Hash table size 2656321, node heap has 1 buffer(s)
  74. Hash table size 2656321, node heap has 2 buffer(s)
  75. Hash table size 2656321, node heap has 1 buffer(s)
  76. 0.44 hash searches/s, 2117.70 non-hash searches/s
  77. ---
  78. LOG
  79. ---
  80. Log sequence number          12522714945
  81. Log buffer assigned up to    12522714945
  82. Log buffer completed up to   12522714945
  83. Log written up to            12522714945
  84. Log flushed up to            12522710485
  85. Added dirty pages up to      12522714945
  86. Pages flushed up to          12097176539
  87. Last checkpoint at           12097176539
  88. Log minimum file id is       170
  89. Log maximum file id is       186
  90. Modified age no less than    425411954
  91. Checkpoint age               425538406
  92. Max checkpoint age           1806985216
  93. 6859829 log i/o's done, 1342.75 log i/o's/second
  94. ----------------------
  95. BUFFER POOL AND MEMORY
  96. ----------------------
  97. Total large memory allocated 0
  98. Dictionary memory allocated 2818205
  99. Buffer pool size   786336
  100. Buffer pool size, bytes 12883329024
  101. Free buffers       631737
  102. Database pages     154589
  103. Old database pages 56905
  104. Modified db pages  23628
  105. Pending reads      0
  106. Pending writes: LRU 0, flush list 28, single page 0
  107. Pages made young 0, not young 0
  108. 0.00 youngs/s, 0.00 non-youngs/s
  109. Pages read 1009, created 153580, written 952417
  110. 0.00 reads/s, 0.00 creates/s, 107.50 writes/s
  111. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  112. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  113. LRU len: 154589, unzip_LRU len: 0
  114. I/O sum[0]:cur[400], unzip sum[0]:cur[0]
  115. ----------------------
  116. INDIVIDUAL BUFFER POOL INFO
  117. ----------------------
  118. ---BUFFER POOL 0
  119. Buffer pool size   98292
  120. Buffer pool size, bytes 1610416128
  121. Free buffers       77975
  122. Database pages     20316
  123. Old database pages 7479
  124. Modified db pages  2745
  125. Pending reads      0
  126. Pending writes: LRU 0, flush list 0, single page 0
  127. Pages made young 0, not young 0
  128. 0.00 youngs/s, 0.00 non-youngs/s
  129. Pages read 108, created 20208, written 123972
  130. 0.00 reads/s, 0.00 creates/s, 10.50 writes/s
  131. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  132. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  133. LRU len: 20316, unzip_LRU len: 0
  134. I/O sum[0]:cur[50], unzip sum[0]:cur[0]
  135. ---BUFFER POOL 1
  136. Buffer pool size   98292
  137. Buffer pool size, bytes 1610416128
  138. Free buffers       79438
  139. Database pages     18853
  140. Old database pages 6940
  141. Modified db pages  2991
  142. Pending reads      0
  143. Pending writes: LRU 0, flush list 7, single page 0
  144. Pages made young 0, not young 0
  145. 0.00 youngs/s, 0.00 non-youngs/s
  146. Pages read 86, created 18767, written 116223
  147. 0.00 reads/s, 0.00 creates/s, 14.02 writes/s
  148. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  149. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  150. LRU len: 18853, unzip_LRU len: 0
  151. I/O sum[0]:cur[50], unzip sum[0]:cur[0]
  152. ---BUFFER POOL 2
  153. Buffer pool size   98292
  154. Buffer pool size, bytes 1610416128
  155. Free buffers       77928
  156. Database pages     20362
  157. Old database pages 7497
  158. Modified db pages  3307
  159. Pending reads      0
  160. Pending writes: LRU 0, flush list 7, single page 0
  161. Pages made young 0, not young 0
  162. 0.00 youngs/s, 0.00 non-youngs/s
  163. Pages read 85, created 20277, written 126855
  164. 0.00 reads/s, 0.00 creates/s, 5.82 writes/s
  165. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  166. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  167. LRU len: 20362, unzip_LRU len: 0
  168. I/O sum[0]:cur[50], unzip sum[0]:cur[0]
  169. ---BUFFER POOL 3
  170. Buffer pool size   98292
  171. Buffer pool size, bytes 1610416128
  172. Free buffers       79062
  173. Database pages     19229
  174. Old database pages 7078
  175. Modified db pages  2819
  176. Pending reads      0
  177. Pending writes: LRU 0, flush list 7, single page 0
  178. Pages made young 0, not young 0
  179. 0.00 youngs/s, 0.00 non-youngs/s
  180. Pages read 227, created 19002, written 116582
  181. 0.00 reads/s, 0.00 creates/s, 15.03 writes/s
  182. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  183. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  184. LRU len: 19229, unzip_LRU len: 0
  185. I/O sum[0]:cur[50], unzip sum[0]:cur[0]
  186. ---BUFFER POOL 4
  187. Buffer pool size   98292
  188. Buffer pool size, bytes 1610416128
  189. Free buffers       79554
  190. Database pages     18737
  191. Old database pages 6896
  192. Modified db pages  2479
  193. Pending reads      0
  194. Pending writes: LRU 0, flush list 7, single page 0
  195. Pages made young 0, not young 0
  196. 0.00 youngs/s, 0.00 non-youngs/s
  197. Pages read 68, created 18669, written 115976
  198. 0.00 reads/s, 0.00 creates/s, 18.01 writes/s
  199. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  200. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  201. LRU len: 18737, unzip_LRU len: 0
  202. I/O sum[0]:cur[50], unzip sum[0]:cur[0]
  203. ---BUFFER POOL 5
  204. Buffer pool size   98292
  205. Buffer pool size, bytes 1610416128
  206. Free buffers       80286
  207. Database pages     18005
  208. Old database pages 6626
  209. Modified db pages  3071
  210. Pending reads      0
  211. Pending writes: LRU 0, flush list 0, single page 0
  212. Pages made young 0, not young 0
  213. 0.00 youngs/s, 0.00 non-youngs/s
  214. Pages read 58, created 17947, written 109951
  215. 0.00 reads/s, 0.00 creates/s, 10.89 writes/s
  216. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  217. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  218. LRU len: 18005, unzip_LRU len: 0
  219. I/O sum[0]:cur[50], unzip sum[0]:cur[0]
  220. ---BUFFER POOL 6
  221. Buffer pool size   98292
  222. Buffer pool size, bytes 1610416128
  223. Free buffers       78289
  224. Database pages     20002
  225. Old database pages 7364
  226. Modified db pages  2820
  227. Pending reads      0
  228. Pending writes: LRU 0, flush list 0, single page 0
  229. Pages made young 0, not young 0
  230. 0.00 youngs/s, 0.00 non-youngs/s
  231. Pages read 86, created 19916, written 124432
  232. 0.00 reads/s, 0.00 creates/s, 20.31 writes/s
  233. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  234. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  235. LRU len: 20002, unzip_LRU len: 0
  236. I/O sum[0]:cur[50], unzip sum[0]:cur[0]
  237. ---BUFFER POOL 7
  238. Buffer pool size   98292
  239. Buffer pool size, bytes 1610416128
  240. Free buffers       79205
  241. Database pages     19085
  242. Old database pages 7025
  243. Modified db pages  3396
  244. Pending reads      0
  245. Pending writes: LRU 0, flush list 0, single page 0
  246. Pages made young 0, not young 0
  247. 0.00 youngs/s, 0.00 non-youngs/s
  248. Pages read 291, created 18794, written 118426
  249. 0.00 reads/s, 0.00 creates/s, 12.91 writes/s
  250. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  251. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  252. LRU len: 19085, unzip_LRU len: 0
  253. I/O sum[0]:cur[50], unzip sum[0]:cur[0]
  254. --------------
  255. ROW OPERATIONS
  256. --------------
  257. 0 queries inside InnoDB, 0 queries in queue
  258. 0 read views open inside InnoDB
  259. 1 RW transactions active inside InnoDB
  260. Process ID=39345, Main thread ID=140449788454656 , state=sleeping
  261. Number of rows inserted 7328640, updated 17499, deleted 6005704, read 21573483
  262. 1882.23 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  263. Number of system rows inserted 6515, updated 6012, deleted 55, read 18631
  264. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  265. ----------------------------
  266. END OF INNODB MONITOR OUTPUT
  267. ============================

  269. 1 row in set (0.00 sec)

  271. ERROR:
  272. No query specified
复制代码
查询五：
  1. LIST OF TRANSACTIONS FOR EACH SESSION:
  2. ---TRANSACTION 421936924462440, not started
  3. 0 lock struct(s), heap size 1128, 0 row lock(s)
  4. ---TRANSACTION 421936924469224, not started
  5. 0 lock struct(s), heap size 1128, 0 row lock(s)
  6. ---TRANSACTION 421936924461592, not started
  7. 0 lock struct(s), heap size 1128, 0 row lock(s)
  8. ---TRANSACTION 421936924460744, not started
  9. 0 lock struct(s), heap size 1128, 0 row lock(s)
  10. --------
  11. FILE I/O
  12. --------
  13. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  14. I/O thread 1 state: waiting for completed aio requests (log thread)
  15. I/O thread 2 state: waiting for completed aio requests (read thread)
  16. I/O thread 3 state: waiting for completed aio requests (read thread)
  17. I/O thread 4 state: waiting for completed aio requests (read thread)
  18. I/O thread 5 state: waiting for completed aio requests (read thread)
  19. I/O thread 6 state: waiting for completed aio requests (write thread)
  20. I/O thread 7 state: waiting for completed aio requests (write thread)
  21. I/O thread 8 state: waiting for completed aio requests (write thread)
  22. I/O thread 9 state: waiting for completed aio requests (write thread)
  23. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  24. ibuf aio reads:, log i/o's:
  25. Pending flushes (fsync) log: 0; buffer pool: 0
  26. 1051 OS file reads, 8654935 OS file writes, 547287 OS fsyncs
  27. 0.00 reads/s, 0 avg bytes/read, 983.13 writes/s, 78.25 fsyncs/s
  28. -------------------------------------
  29. INSERT BUFFER AND ADAPTIVE HASH INDEX
  30. -------------------------------------
  31. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  32. merged operations:
  33. insert 0, delete mark 0, delete 0
  34. discarded operations:
  35. insert 0, delete mark 0, delete 0
  36. Hash table size 2656321, node heap has 1 buffer(s)
  37. Hash table size 2656321, node heap has 1 buffer(s)
  38. Hash table size 2656321, node heap has 2 buffer(s)
  39. Hash table size 2656321, node heap has 1 buffer(s)
  40. Hash table size 2656321, node heap has 1 buffer(s)
  41. Hash table size 2656321, node heap has 1 buffer(s)
  42. Hash table size 2656321, node heap has 2 buffer(s)
  43. Hash table size 2656321, node heap has 1 buffer(s)
  44. 1.62 hash searches/s, 1200.34 non-hash searches/s
  45. ---
  46. LOG
  47. ---
  48. Log sequence number          13292052573
  49. Log buffer assigned up to    13292052573
  50. Log buffer completed up to   13292052573
  51. Log written up to            13292052573
  52. Log flushed up to            13292052573
  53. Added dirty pages up to      13292052573
  54. Pages flushed up to          12889903764
  55. Last checkpoint at           12889452726
  56. Log minimum file id is       170
  57. Log maximum file id is       198
  58. Modified age no less than    402148809
  59. Checkpoint age               402599847
  60. Max checkpoint age           1806985216
  61. 7379938 log i/o's done, 812.23 log i/o's/second
  62. ----------------------
  63. BUFFER POOL AND MEMORY
  64. ----------------------
  65. Total large memory allocated 0
  66. Dictionary memory allocated 2818205
  67. Buffer pool size   786336
  68. Buffer pool size, bytes 12883329024
  69. Free buffers       631729
  70. Database pages     154597
  71. Old database pages 56908
  72. Modified db pages  21397
  73. Pending reads      0
  74. Pending writes: LRU 0, flush list 0, single page 0
  75. Pages made young 0, not young 0
  76. 0.00 youngs/s, 0.00 non-youngs/s
  77. Pages read 1009, created 153588, written 997735
  78. 0.00 reads/s, 0.00 creates/s, 138.19 writes/s
  79. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  80. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  81. LRU len: 154597, unzip_LRU len: 0
  82. I/O sum[0]:cur[1600], unzip sum[0]:cur[0]
  83. ----------------------
  84. INDIVIDUAL BUFFER POOL INFO
  85. ----------------------
  86. ---BUFFER POOL 0
  87. Buffer pool size   98292
  88. Buffer pool size, bytes 1610416128
  89. Free buffers       77975
  90. Database pages     20316
  91. Old database pages 7479
  92. Modified db pages  3203
  93. Pending reads      0
  94. Pending writes: LRU 0, flush list 0, single page 0
  95. Pages made young 0, not young 0
  96. 0.00 youngs/s, 0.00 non-youngs/s
  97. Pages read 108, created 20208, written 129852
  98. 0.00 reads/s, 0.00 creates/s, 12.17 writes/s
  99. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  100. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  101. LRU len: 20316, unzip_LRU len: 0
  102. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  103. ---BUFFER POOL 1
  104. Buffer pool size   98292
  105. Buffer pool size, bytes 1610416128
  106. Free buffers       79438
  107. Database pages     18853
  108. Old database pages 6940
  109. Modified db pages  2468
  110. Pending reads      0
  111. Pending writes: LRU 0, flush list 0, single page 0
  112. Pages made young 0, not young 0
  113. 0.00 youngs/s, 0.00 non-youngs/s
  114. Pages read 86, created 18767, written 121781
  115. 0.00 reads/s, 0.00 creates/s, 16.48 writes/s
  116. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  117. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  118. LRU len: 18853, unzip_LRU len: 0
  119. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  120. ---BUFFER POOL 2
  121. Buffer pool size   98292
  122. Buffer pool size, bytes 1610416128
  123. Free buffers       77928
  124. Database pages     20362
  125. Old database pages 7497
  126. Modified db pages  2395
  127. Pending reads      0
  128. Pending writes: LRU 0, flush list 0, single page 0
  129. Pages made young 0, not young 0
  130. 0.00 youngs/s, 0.00 non-youngs/s
  131. Pages read 85, created 20277, written 132969
  132. 0.00 reads/s, 0.00 creates/s, 15.49 writes/s
  133. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  134. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  135. LRU len: 20362, unzip_LRU len: 0
  136. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  137. ---BUFFER POOL 3
  138. Buffer pool size   98292
  139. Buffer pool size, bytes 1610416128
  140. Free buffers       79054
  141. Database pages     19237
  142. Old database pages 7081
  143. Modified db pages  2671
  144. Pending reads      0
  145. Pending writes: LRU 0, flush list 0, single page 0
  146. Pages made young 0, not young 0
  147. 0.00 youngs/s, 0.00 non-youngs/s
  148. Pages read 227, created 19010, written 122081
  149. 0.00 reads/s, 0.00 creates/s, 20.41 writes/s
  150. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  151. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  152. LRU len: 19237, unzip_LRU len: 0
  153. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  154. ---BUFFER POOL 4
  155. Buffer pool size   98292
  156. Buffer pool size, bytes 1610416128
  157. Free buffers       79554
  158. Database pages     18737
  159. Old database pages 6896
  160. Modified db pages  3131
  161. Pending reads      0
  162. Pending writes: LRU 0, flush list 0, single page 0
  163. Pages made young 0, not young 0
  164. 0.00 youngs/s, 0.00 non-youngs/s
  165. Pages read 68, created 18669, written 121275
  166. 0.00 reads/s, 0.00 creates/s, 19.88 writes/s
  167. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  168. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  169. LRU len: 18737, unzip_LRU len: 0
  170. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  171. ---BUFFER POOL 5
  172. Buffer pool size   98292
  173. Buffer pool size, bytes 1610416128
  174. Free buffers       80286
  175. Database pages     18005
  176. Old database pages 6626
  177. Modified db pages  2332
  178. Pending reads      0
  179. Pending writes: LRU 0, flush list 0, single page 0
  180. Pages made young 0, not young 0
  181. 0.00 youngs/s, 0.00 non-youngs/s
  182. Pages read 58, created 17947, written 115619
  183. 0.00 reads/s, 0.00 creates/s, 14.61 writes/s
  184. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  185. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  186. LRU len: 18005, unzip_LRU len: 0
  187. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  188. ---BUFFER POOL 6
  189. Buffer pool size   98292
  190. Buffer pool size, bytes 1610416128
  191. Free buffers       78289
  192. Database pages     20002
  193. Old database pages 7364
  194. Modified db pages  2275
  195. Pending reads      0
  196. Pending writes: LRU 0, flush list 0, single page 0
  197. Pages made young 0, not young 0
  198. 0.00 youngs/s, 0.00 non-youngs/s
  199. Pages read 86, created 19916, written 129850
  200. 0.00 reads/s, 0.00 creates/s, 17.93 writes/s
  201. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  202. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  203. LRU len: 20002, unzip_LRU len: 0
  204. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  205. ---BUFFER POOL 7
  206. Buffer pool size   98292
  207. Buffer pool size, bytes 1610416128
  208. Free buffers       79205
  209. Database pages     19085
  210. Old database pages 7025
  211. Modified db pages  2922
  212. Pending reads      0
  213. Pending writes: LRU 0, flush list 0, single page 0
  214. Pages made young 0, not young 0
  215. 0.00 youngs/s, 0.00 non-youngs/s
  216. Pages read 291, created 18794, written 124308
  217. 0.00 reads/s, 0.00 creates/s, 21.21 writes/s
  218. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  219. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  220. LRU len: 19085, unzip_LRU len: 0
  221. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  222. --------------
  223. ROW OPERATIONS
  224. --------------
  225. 0 queries inside InnoDB, 0 queries in queue
  226. 0 read views open inside InnoDB
  227. 0 RW transactions active inside InnoDB
  228. Process ID=39345, Main thread ID=140449788454656 , state=sleeping
  229. Number of rows inserted 8009821, updated 17499, deleted 6005707, read 21573486
  230. 1066.65 inserts/s, 0.00 updates/s, 0.12 deletes/s, 0.12 reads/s
  231. Number of system rows inserted 6515, updated 6012, deleted 55, read 18631
  232. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  233. ----------------------------
  234. END OF INNODB MONITOR OUTPUT
  235. ============================

  237. 1 row in set (0.00 sec)

  239. ERROR:
  240. No query specified
复制代码

导入结束后查询：
  1. (Tue Mar 18 15:01:30 2025)[root@GreatSQL][(none)]>show engine innodb status\G;
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 2025-03-18 15:01:50 140459658831616 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 19 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 5427 srv_active, 0 srv_shutdown, 62399 srv_idle
  14. srv_master_thread log flush and writes: 0
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 52168
  19. OS WAIT ARRAY INFO: signal count 60674
  20. RW-shared spins 0, rounds 0, OS waits 0
  21. RW-excl spins 0, rounds 0, OS waits 0
  22. RW-sx spins 0, rounds 0, OS waits 0
  23. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 48881
  28. Purge done for trx's n:o < 48879 undo n:o < 0 state: running but idle
  29. History list length 13
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421936924462440, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. ---TRANSACTION 421936924469224, not started
  34. 0 lock struct(s), heap size 1128, 0 row lock(s)
  35. ---TRANSACTION 421936924461592, not started
  36. 0 lock struct(s), heap size 1128, 0 row lock(s)
  37. ---TRANSACTION 421936924460744, not started
  38. 0 lock struct(s), heap size 1128, 0 row lock(s)
  39. --------
  40. FILE I/O
  41. --------
  42. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  43. I/O thread 1 state: waiting for completed aio requests (log thread)
  44. I/O thread 2 state: waiting for completed aio requests (read thread)
  45. I/O thread 3 state: waiting for completed aio requests (read thread)
  46. I/O thread 4 state: waiting for completed aio requests (read thread)
  47. I/O thread 5 state: waiting for completed aio requests (read thread)
  48. I/O thread 6 state: waiting for completed aio requests (write thread)
  49. I/O thread 7 state: waiting for completed aio requests (write thread)
  50. I/O thread 8 state: waiting for completed aio requests (write thread)
  51. I/O thread 9 state: waiting for completed aio requests (write thread)
  52. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  53. ibuf aio reads:, log i/o's:
  54. Pending flushes (fsync) log: 0; buffer pool: 0
  55. 1051 OS file reads, 8660075 OS file writes, 549590 OS fsyncs
  56. 0.00 reads/s, 0 avg bytes/read, 259.31 writes/s, 116.19 fsyncs/s
  57. -------------------------------------
  58. INSERT BUFFER AND ADAPTIVE HASH INDEX
  59. -------------------------------------
  60. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  61. merged operations:
  62. insert 0, delete mark 0, delete 0
  63. discarded operations:
  64. insert 0, delete mark 0, delete 0
  65. Hash table size 2656321, node heap has 1 buffer(s)
  66. Hash table size 2656321, node heap has 1 buffer(s)
  67. Hash table size 2656321, node heap has 2 buffer(s)
  68. Hash table size 2656321, node heap has 1 buffer(s)
  69. Hash table size 2656321, node heap has 1 buffer(s)
  70. Hash table size 2656321, node heap has 1 buffer(s)
  71. Hash table size 2656321, node heap has 2 buffer(s)
  72. Hash table size 2656321, node heap has 1 buffer(s)
  73. 0.00 hash searches/s, 0.00 non-hash searches/s
  74. ---
  75. LOG
  76. ---
  77. Log sequence number          13292052573
  78. Log buffer assigned up to    13292052573
  79. Log buffer completed up to   13292052573
  80. Log written up to            13292052573
  81. Log flushed up to            13292052573
  82. Added dirty pages up to      13292052573
  83. Pages flushed up to          12949820851
  84. Last checkpoint at           12949369610
  85. Log minimum file id is       170
  86. Log maximum file id is       198
  87. Modified age no less than    342231722
  88. Checkpoint age               342682963
  89. Max checkpoint age           1806985216
  90. 7379938 log i/o's done, 0.00 log i/o's/second
  91. ----------------------
  92. BUFFER POOL AND MEMORY
  93. ----------------------
  94. Total large memory allocated 0
  95. Dictionary memory allocated 2818205
  96. Buffer pool size   786336
  97. Buffer pool size, bytes 12883329024
  98. Free buffers       631729
  99. Database pages     154597
  100. Old database pages 56908
  101. Modified db pages  17397
  102. Pending reads      0
  103. Pending writes: LRU 0, flush list 0, single page 0
  104. Pages made young 0, not young 0
  105. 0.00 youngs/s, 0.00 non-youngs/s
  106. Pages read 1009, created 153588, written 1001735
  107. 0.00 reads/s, 0.00 creates/s, 201.80 writes/s
  108. No buffer pool page gets since the last printout
  109. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  110. LRU len: 154597, unzip_LRU len: 0
  111. I/O sum[0]:cur[1600], unzip sum[0]:cur[0]
  112. ----------------------
  113. INDIVIDUAL BUFFER POOL INFO
  114. ----------------------
  115. ---BUFFER POOL 0
  116. Buffer pool size   98292
  117. Buffer pool size, bytes 1610416128
  118. Free buffers       77975
  119. Database pages     20316
  120. Old database pages 7479
  121. Modified db pages  2703
  122. Pending reads      0
  123. Pending writes: LRU 0, flush list 0, single page 0
  124. Pages made young 0, not young 0
  125. 0.00 youngs/s, 0.00 non-youngs/s
  126. Pages read 108, created 20208, written 130352
  127. 0.00 reads/s, 0.00 creates/s, 25.23 writes/s
  128. No buffer pool page gets since the last printout
  129. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  130. LRU len: 20316, unzip_LRU len: 0
  131. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  132. ---BUFFER POOL 1
  133. Buffer pool size   98292
  134. Buffer pool size, bytes 1610416128
  135. Free buffers       79438
  136. Database pages     18853
  137. Old database pages 6940
  138. Modified db pages  1968
  139. Pending reads      0
  140. Pending writes: LRU 0, flush list 0, single page 0
  141. Pages made young 0, not young 0
  142. 0.00 youngs/s, 0.00 non-youngs/s
  143. Pages read 86, created 18767, written 122281
  144. 0.00 reads/s, 0.00 creates/s, 25.23 writes/s
  145. No buffer pool page gets since the last printout
  146. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  147. LRU len: 18853, unzip_LRU len: 0
  148. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  149. ---BUFFER POOL 2
  150. Buffer pool size   98292
  151. Buffer pool size, bytes 1610416128
  152. Free buffers       77928
  153. Database pages     20362
  154. Old database pages 7497
  155. Modified db pages  1895
  156. Pending reads      0
  157. Pending writes: LRU 0, flush list 0, single page 0
  158. Pages made young 0, not young 0
  159. 0.00 youngs/s, 0.00 non-youngs/s
  160. Pages read 85, created 20277, written 133469
  161. 0.00 reads/s, 0.00 creates/s, 25.23 writes/s
  162. No buffer pool page gets since the last printout
  163. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  164. LRU len: 20362, unzip_LRU len: 0
  165. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  166. ---BUFFER POOL 3
  167. Buffer pool size   98292
  168. Buffer pool size, bytes 1610416128
  169. Free buffers       79054
  170. Database pages     19237
  171. Old database pages 7081
  172. Modified db pages  2171
  173. Pending reads      0
  174. Pending writes: LRU 0, flush list 0, single page 0
  175. Pages made young 0, not young 0
  176. 0.00 youngs/s, 0.00 non-youngs/s
  177. Pages read 227, created 19010, written 122581
  178. 0.00 reads/s, 0.00 creates/s, 25.23 writes/s
  179. No buffer pool page gets since the last printout
  180. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  181. LRU len: 19237, unzip_LRU len: 0
  182. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  183. ---BUFFER POOL 4
  184. Buffer pool size   98292
  185. Buffer pool size, bytes 1610416128
  186. Free buffers       79554
  187. Database pages     18737
  188. Old database pages 6896
  189. Modified db pages  2631
  190. Pending reads      0
  191. Pending writes: LRU 0, flush list 0, single page 0
  192. Pages made young 0, not young 0
  193. 0.00 youngs/s, 0.00 non-youngs/s
  194. Pages read 68, created 18669, written 121775
  195. 0.00 reads/s, 0.00 creates/s, 25.23 writes/s
  196. No buffer pool page gets since the last printout
  197. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  198. LRU len: 18737, unzip_LRU len: 0
  199. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  200. ---BUFFER POOL 5
  201. Buffer pool size   98292
  202. Buffer pool size, bytes 1610416128
  203. Free buffers       80286
  204. Database pages     18005
  205. Old database pages 6626
  206. Modified db pages  1832
  207. Pending reads      0
  208. Pending writes: LRU 0, flush list 0, single page 0
  209. Pages made young 0, not young 0
  210. 0.00 youngs/s, 0.00 non-youngs/s
  211. Pages read 58, created 17947, written 116119
  212. 0.00 reads/s, 0.00 creates/s, 25.23 writes/s
  213. No buffer pool page gets since the last printout
  214. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  215. LRU len: 18005, unzip_LRU len: 0
  216. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  217. ---BUFFER POOL 6
  218. Buffer pool size   98292
  219. Buffer pool size, bytes 1610416128
  220. Free buffers       78289
  221. Database pages     20002
  222. Old database pages 7364
  223. Modified db pages  1775
  224. Pending reads      0
  225. Pending writes: LRU 0, flush list 0, single page 0
  226. Pages made young 0, not young 0
  227. 0.00 youngs/s, 0.00 non-youngs/s
  228. Pages read 86, created 19916, written 130350
  229. 0.00 reads/s, 0.00 creates/s, 25.23 writes/s
  230. No buffer pool page gets since the last printout
  231. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  232. LRU len: 20002, unzip_LRU len: 0
  233. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  234. ---BUFFER POOL 7
  235. Buffer pool size   98292
  236. Buffer pool size, bytes 1610416128
  237. Free buffers       79205
  238. Database pages     19085
  239. Old database pages 7025
  240. Modified db pages  2422
  241. Pending reads      0
  242. Pending writes: LRU 0, flush list 0, single page 0
  243. Pages made young 0, not young 0
  244. 0.00 youngs/s, 0.00 non-youngs/s
  245. Pages read 291, created 18794, written 124808
  246. 0.00 reads/s, 0.00 creates/s, 25.23 writes/s
  247. No buffer pool page gets since the last printout
  248. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  249. LRU len: 19085, unzip_LRU len: 0
  250. I/O sum[0]:cur[200], unzip sum[0]:cur[0]
  251. --------------
  252. ROW OPERATIONS
  253. --------------
  254. 0 queries inside InnoDB, 0 queries in queue
  255. 0 read views open inside InnoDB
  256. 0 RW transactions active inside InnoDB
  257. Process ID=39345, Main thread ID=140449788454656 , state=sleeping
  258. Number of rows inserted 8009821, updated 17499, deleted 6005707, read 21573486
  259. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  260. Number of system rows inserted 6515, updated 6012, deleted 55, read 18631
  261. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  262. ----------------------------
  263. END OF INNODB MONITOR OUTPUT
  264. ============================

  266. 1 row in set (0.00 sec)

  268. ERROR:
  269. No query specified

复制代码


回复 采纳

举报

yejr 2025-3-18 15:54:36
Yep. 发表于 2025-3-18 15:09
导入前：

导入过程中查询一：

不要在虚机+凝思环境下跑GreatSQL，改成在物理机环境下测试，先排除虚机包了一层可能受到的影响
回复 采纳

举报

Yep. 2025-3-18 16:44:24
yejr 发表于 2025-3-18 15:54
不要在虚机+凝思环境下跑GreatSQL，改成在物理机环境下测试，先排除虚机包了一层可能受到的影响 ...

好的谢谢叶老师，我得协调下机器，另外您可以看下我的安装过程吗，我想使用systemd管理，但是按照用户手册的这个方法：使用systemd管理GreatSQL，配置如下：
  1. [Unit]
  2. Description=GreatSQL Server
  3. Documentation=man:mysqld(8)
  4. Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
  5. After=network.target
  6. After=syslog.target
  7. [Install]
  8. WantedBy=multi-user.target
  9. [Service]

  11. # some limits
  12. # file size
  13. LimitFSIZE=infinity
  14. # cpu time
  15. LimitCPU=infinity
  16. # virtual memory size
  17. LimitAS=infinity
  18. # open files
  19. LimitNOFILE=65535
  20. # processes/threads
  21. LimitNPROC=65535
  22. # locked memory
  23. LimitMEMLOCK=infinity
  24. # total threads (user+kernel)
  25. TasksMax=infinity
  26. TasksAccounting=false

  28. User=mysql
  29. Group=mysql
  30. #如果是GreatSQL 5.7版本，此处需要改成simple模式，否则可能服务启用异常
  31. #如果是GreatSQL 8.0版本则可以使用notify模式
  32. #Type=simple
  33. Type=notify
  34. TimeoutSec=0
  35. PermissionsStartOnly=true
  36. ExecStartPre=/usr/local/mysql/bin/mysqld_pre_systemd
  37. ExecStart=/usr/local/mysql_64/bin/mysqld $MYSQLD_OPTS
  38. EnvironmentFile=-/etc/sysconfig/mysql
  39. Restart=on-failure
  40. RestartPreventExitStatus=1
  41. Environment=MYSQLD_PARENT_PID=1
  42. PrivateTmp=false
复制代码
mysqld_pre_system中旧的安装包名称也已改为了mysql，systemctl daemon-reload没有报错，但是依旧不能使用systemctl start greatsql，提示Failed to start greatsql.service: Unit greatsql.service failed to load: No such file or directory.
我觉得安装手册中对于像凝思系统系列的安装不够清晰，安装过程中遇到很多与安装说明不一样的指令、目录和预期结果


回复 采纳

举报

yejr 2025-3-18 16:59:13
Yep. 发表于 2025-3-18 16:44
好的谢谢叶老师，我得协调下机器，另外您可以看下我的安装过程吗，我想使用systemd管理，但是按照用户手 ...

执行  systemctl status greatsql 或 journalctl -ex 查看具体信息才知道启动失败的原因
回复 采纳

举报

Yep. 2025-3-19 15:00:40
yejr 发表于 2025-3-18 16:59
执行  systemctl status greatsql 或 journalctl -ex 查看具体信息才知道启动失败的原因 ...

以下是执行结果
  1. root@server:/etc/mysql# systemctl daemon-reload
  2. root@server:/etc/mysql# systemctl start mysqld.service
  3. Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.
  4. root@server:/etc/mysql# systemctl status mysqld.service
  5. ● mysqld.service - GreatSQL Server
  6.    Loaded: loaded (/lib/systemd/system/mysqld.service; disabled)
  7.    Active: failed (Result: exit-code) since 三 2025-03-19 22:55:54 CST; 14s ago
  8.      Docs: man:mysqld(8)
  9.            http://dev.mysql.com/doc/refman/en/using-systemd.html
  10.   Process: 11166 ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/mysql/my.cnf $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  11.   Process: 11136 ExecStartPre=/usr/local/mysql/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
  12. Main PID: 11166 (code=exited, status=1/FAILURE)
  13.    Status: "Server shutdown complete"
  14. root@server:/etc/mysql# journalctl -xn
  15. No journal files were found.
  16. root@server:/etc/mysql# journalctl -ex
  17. No journal files were found.
  18. ~
  19. ~
  20. ~
  21. ~
  22. ~
  23. ~
  24. ~
  25. ~
  26. ~
  27. ~
  28. ~
  29. ~
  30. ~
  31. ~
  32. ~
  33. ~
  34. ~
  35. ~
  36. ~
  37. ~
  38. ~
  39. ~
  40. ~
  41. ...skipping...
  42. ~
  43. ~
  44. ~
  45. ~
  46. ~
  47. ~
  48. ~
  49. ~
  50. ~
  51. ~
  52. ~
  53. ~
  54. ~
  55. ~
  56. ~
  57. ~
  58. ~
  59. ~
  60. ~
  61. ~
  62. ~
  63. ~
  64. ~
复制代码
回复 采纳

举报

Yep. 2025-3-19 16:26:52
Yep. 发表于 2025-3-19 15:00
以下是执行结果

谢谢已经解决了，是有进程在所以没办法管理，关闭后可以正常使用systemd
回复 采纳

举报

12
Yep.
发消息
互动与交流
社区活动
论坛问答
加入社区
贡献者指南
学习与应用
文章博客
文档资料
视频资料
常见问题
发现社区
社区准则
建议反馈
社区之星

合作电话：010-64087828

社区邮箱：greatsql@greatdb.com

社区公众号
社区小助手
QQ群
友情链接
万里数据库开源中国墨天轮开放原子开源基金会OpenEuler
©2022 GreatSQL All Rights Reserved. ( 京ICP备06057874号 )
GMT+8, 2025-4-4 16:51 , Processed in 0.019959 second(s), 14 queries , Redis On.
快速回复 返回顶部 返回列表