greatsql内存分配相对mysql差别
请问下，greatsql是不是内存方面相对mysql有做调整?目前看到的现象是这样：mysql的innodb_buffer_pool_size设置为10G，然后使用free -h，used使用2.4G，mysql并没有全部占用设置的内存；
而greatsql同样设置10G，free -h查看，used使用11G,查看top，这部分内存也正是greatsql使用的。
请先参考下面的文章思路排查分析一番，可以把分析过程回复到帖子中 https://mp.weixin.qq.com/s/TjwrHtH5JAVVZ-v7F7Sf3g 同时提供my.cnf配置文件内容 ###当前库为备库，没有任何业务连接，只配置了双向主从同步。
##设置innodb_buffer_pool_size为1G时
mysql> set global innodb_buffer_pool_size=1073741824;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> select @@innodb_buffer_pool_size;
+---------------------------+
| @@innodb_buffer_pool_size |
+---------------------------+
| 1073741824 |
+---------------------------+
1 row in set (0.00 sec)
mysql> SELECT EVENT_NAME, CURRENT_NUMBER_OF_BYTES_USED AS memory_bytes, CURRENT_NUMBER_OF_BYTES_USED / 1024 / 1024 AS memory_mb FROM performance_schema.memory_summary_global_by_event_name WHERE CURRENT_NUMBER_OF_BYTES_USED > 0 ORDER BY CURRENT_NUMBER_OF_BYTES_USED DESC LIMIT 10;
+-----------------------------------------------------------------------------+--------------+---------------+
| EVENT_NAME | memory_bytes | memory_mb |
+-----------------------------------------------------------------------------+--------------+---------------+
| memory/innodb/buf_buf_pool | 1097891840 | 1047.03125000 |
| memory/performance_schema/events_statements_summary_by_digest | 42240000 | 40.28320313 |
| memory/mysys/KEY_CACHE | 33556016 | 32.00151062 |
| memory/innodb/log_buffer_memory | 33555456 | 32.00097656 |
| memory/innodb/ut0link_buf | 25165888 | 24.00006104 |
| memory/innodb/lock0lock | 22440096 | 21.40054321 |
| memory/mysys/IO_CACHE | 16966928 | 16.18092346 |
| memory/performance_schema/events_statements_history_long | 15040000 | 14.34326172 |
| memory/performance_schema/events_errors_summary_by_thread_by_error | 14561280 | 13.88671875 |
| memory/performance_schema/events_statements_summary_by_thread_by_event_name | 14321664 | 13.65820313 |
+-----------------------------------------------------------------------------+--------------+---------------+
10 rows in set (0.00 sec)
$ free -h
total used free sharedbuff/cache available
Mem: 30Gi 1.9Gi 22Gi 226Mi 6.5Gi 28Gi
Swap: 0B 0B 0B
##设置innodb_buffer_pool_size改为10G时
mysql> set global innodb_buffer_pool_size=10737418240;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> select @@innodb_buffer_pool_size;
+---------------------------+
| @@innodb_buffer_pool_size |
+---------------------------+
| 10737418240 |
+---------------------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT EVENT_NAME, CURRENT_NUMBER_OF_BYTES_USED AS memory_bytes, CURRENT_NUMBER_OF_BYTES_USED / 1024 / 1024 AS memory_mb FROM performance_schema.memory_summary_global_by_event_name WHERE CURRENT_NUMBER_OF_BYTES_USED > 0 ORDER BY CURRENT_NUMBER_OF_BYTES_USED DESC LIMIT 10;
+--------------------------------------------------------------------+--------------+----------------+
| EVENT_NAME | memory_bytes | memory_mb |
+--------------------------------------------------------------------+--------------+----------------+
| memory/innodb/buf_buf_pool |10978918400 | 10470.31250000 |
| memory/innodb/os0event | 242960192 | 231.70489502 |
| memory/performance_schema/events_statements_summary_by_digest | 42240000 | 40.28320313 |
| memory/mysys/KEY_CACHE | 33556016 | 32.00151062 |
| memory/innodb/log_buffer_memory | 33555456 | 32.00097656 |
| memory/innodb/ut0link_buf | 25165888 | 24.00006104 |
| memory/innodb/lock0lock | 22440096 | 21.40054321 |
| memory/mysys/IO_CACHE | 16966928 | 16.18092346 |
| memory/performance_schema/events_statements_history_long | 15040000 | 14.34326172 |
| memory/performance_schema/events_errors_summary_by_thread_by_error | 14561280 | 13.88671875 |
+--------------------------------------------------------------------+--------------+----------------+
10 rows in set (0.01 sec)
$ free -h
total used free sharedbuff/cache available
Mem: 30Gi 11Gi 12Gi 226Mi 6.5Gi 18Gi
Swap: 0B 0B 0B
###内存设置从1G调整为10G时，主机上free -h 显示used部分的内存没几秒会直接增长9G大小，刚好和新增的，buffer pool大小一致，所以greatsql是不是设置的内存不管有没有使用都会直接被分配？my.cnf文件见附件。
wu999 发表于 2024-12-12 11:18
###当前库为备库，没有任何业务连接，只配置了双向主从同步。
##设置innodb_buffer_pool_size为1G时
mysql> ...
The innodb_buffer_pool_size configuration option can be set dynamically using a SET statement, allowing you to resize the buffer pool without restarting the server. For example:
该参数可以动态调整，调整了就会立刻生效的 KAiTO 发表于 2024-12-12 11:31
The innodb_buffer_pool_size configuration option can be set dynamically using a SET statement, all ...
mysql 设置不会出现这种情况，设置8G的buffer pool，used显示只使用了1.8G，mysql不会立即使用设置的全部内存，而greatsql会，所以我想确认下是不是greatsql本身有对这块做调整？ wu999 发表于 2024-12-12 11:18
###当前库为备库，没有任何业务连接，只配置了双向主从同步。
##设置innodb_buffer_pool_size为1G时
mysql> ...
请补充提供几个信息
1. mysqld进程状态
ps aux | grep mysqld
2. top结果
top -p $(pidof mysqld) -n 1
3. 使用 pmap 查看 mysqld 进程中的内存分布情况
pmap -x $(pidof mysqld) | sort -k3 -rn | head -n 20
4. 查看各线程的内存使用详情
SELECT* FROMsys.x$memory_by_thread_by_current_bytes ORDER BYtotal_allocated DESC LIMIT 20;
5. 是否启用了大页
可以参考这篇文章 https://mp.weixin.qq.com/s/Z5ktp3uZdkE9WfOi28bfow
P.S，我们现在对GreatSQL社区用户承诺提供5*8在线免费技术支持服务，只要填个问卷就行 https://wj.qq.com/s2/11543483/9e09/ ，只需1分钟即可完成，这对我们也很重要，感谢支持:handshake:handshake
yejr 发表于 2024-12-12 13:56
请补充提供几个信息
1. mysqld进程状态
1. mysqld进程状态
ps aux | grep mysqld
root 453490.00.0 114724 12532 ? SslDec04 0:09 /usr/local/mysqld_exporter/mysqld_exporter --web.listen-address=:9106 --collect.info_schema.processlist --collect.info_schema.innodb_tablespaces --collect.info_schema.innodb_metrics --collect.perf_schema.tableiowaits --collect.perf_schema.indexiowaits --collect.perf_schema.tablelocks --collect.engine_innodb_status --collect.perf_schema.file_events --collect.binlog_size --collect.info_schema.clientstats --collect.perf_schema.eventswaits --collect.slave_status --collect.global_status --collect.global_variables --collect.mysql.user --collect.auto_increment.columns --config.my-cnf=/usr/local/mysqld_exporter/.my-xxxxx-3306.cnf
root 462010.00.0229563836 ? S Dec04 0:00 /bin/sh /usr/local/greatsql/bin/mysqld_safe --defaults-file=/etc/my-xxxxx-3306.cnf --pid-file=/data/greatsql-xxxxx-3306/data/mysql.pid
mysql 477581.3 36.7 12955744 11896296 ? Sl Dec04 152:22 /usr/local/greatsql/bin/mysqld --defaults-file=/etc/my-xxxxx-3306.cnf --basedir=/usr/local/greatsql --datadir=/data/greatsql-xxxxx-3306/data --plugin-dir=/usr/local/greatsql/lib/plugin --user=mysql--log-error=/data/greatsql-xxxxx-3306/logs/error.log --open-files-limit=65535 --pid-file=/data/greatsql-xxxxx-3306/data/mysql.pid --socket=/data/greatsql-xxxxx-3306/data/mysql.sock --port=3306
2. top结果
top -p $(pidof mysqld) -n 1
top - 14:20:53 up 8 days, 23:05,1 user,load average: 0.00, 0.02, 0.00
Tasks: 1 total, 0 running, 1 sleeping, 0 stopped, 0 zombie
%Cpu(s):0.0 us,0.0 sy,0.0 ni,100.0 id,0.0 wa,0.0 hi,0.0 si,0.0 st
MiB Mem :31591.2 total,13032.8 free,11932.4 used, 6626.0 buff/cache
MiB Swap: 0.0 total, 0.0 free, 0.0 used.18867.1 avail Mem
PID USER PRNI VIRT RES SHR S%CPU%MEM TIME+ COMMAND
47758 mysql 20 0 12.4g11.3g40988 S 0.036.8 152:20.82 mysqld
3. 使用 pmap 查看 mysqld 进程中的内存分布情况
pmap -x $(pidof mysqld) | sort -k3 -rn | head -n 20
total kB 12955748 11907452 11866008
00007efecd87c000536080536080536080 rw--- [ anon ]
00007efeef75d000402060402060402060 rw--- [ anon ]
00007eff17800000339968252608252608 rw--- [ anon ]
00007efc59000000299008237516237516 rw--- [ anon ]
00007eff0891f000134020134020134020 rw--- [ anon ]
00007efec559b000134020134020134020 rw--- [ anon ]
00007efebd2ba000134020134020134020 rw--- [ anon ]
00007efeb4fd9000134020134020134020 rw--- [ anon ]
00007efeaccf8000134020134020134020 rw--- [ anon ]
00007efea4a17000134020134020134020 rw--- [ anon ]
00007efe9bd1f000134020134020134020 rw--- [ anon ]
00007efe9291f000134020134020134020 rw--- [ anon ]
00007efe8a63e000134020134020134020 rw--- [ anon ]
00007efe8235d000134020134020134020 rw--- [ anon ]
00007efe7991f000134020134020134020 rw--- [ anon ]
00007efe7163e000134020134020134020 rw--- [ anon ]
00007efe68fcf000134020134020134020 rw--- [ anon ]
00007efe6051f000134020134020134020 rw--- [ anon ]
00007efe5823e000134020134020134020 rw--- [ anon ]
4. 查看各线程的内存使用详情
SELECT* FROMsys.x$memory_by_thread_by_current_bytes ORDER BYtotal_allocated DESC LIMIT 20;
mysql> SELECT* FROMsys.x$memory_by_thread_by_current_bytes ORDER BYtotal_allocated DESC LIMIT 20;
+-----------+--------------------------------+--------------------+-------------------+-------------------+-------------------+-----------------+
| thread_id | user | current_count_used | current_allocated | current_avg_alloc | current_max_alloc | total_allocated |
+-----------+--------------------------------+--------------------+-------------------+-------------------+-------------------+-----------------+
| 50 | innodb/clone_gtid_thread | 1917 | 611872 | 319.1821 | 262720 | 825672637 |
| 39 | innodb/buf_resize_thread | 1769353 | 240661328 | 136.0166 | 240618816 | 481406688 |
| 57 | sql/replica_worker | 5215 | 4048916 | 776.3981 | 1600816 | 335777213 |
| 216 | root@localhost | 161 | 17109479 | 106270.0559 | 16777376 | 212270431 |
| 25 | innodb/srv_monitor_thread | 0 | 0 | 0.0000 | 0 | 126469920 |
| 40 | innodb/srv_master_thread | 21 | 1978 | 94.1905 | 1081 | 87710386 |
| 56 | sql/replica_sql | 125116 | 49279399 | 393.8697 | 47570457 | 79872021 |
| 41 | innodb/dict_stats_thread | 66 | 9466 | 143.4242 | 3784 | 31022128 |
| 72 | sql/replica_worker | 54257 | 28891289 | 532.4896 | 17353600 | 30461119 |
| 51 | innodb/srv_purge_thread | 24 | 2450 | 102.0833 | 1081 | 27978846 |
| 54 | innodb/srv_worker_thread | 24 | 2218 | 92.4167 | 1081 | 18369416 |
| 53 | innodb/srv_worker_thread | 22 | 2026 | 92.0909 | 1081 | 14151899 |
| 52 | innodb/srv_worker_thread | 26 | 2450 | 94.2308 | 1081 | 13647582 |
| 1 | sql/main | 4831 | 1351299 | 279.7141 | 437896 | 6544188 |
| 26 | innodb/log_checkpointer_thread | 0 | 0 | 0.0000 | 0 | 1396752 |
| 58 | sql/replica_worker | 182 | 293801 | 1614.2912 | 203208 | 654467 |
| 55 | sql/replica_io | 79 | 139210 | 1762.1519 | 86094 | 313466 |
| 127 | repl@xx.xx.xx.xx | 27 | 25880 | 958.5185 | 18480 | 264423 |
| 62 | sql/replica_worker | 58 | 82853 | 1428.5000 | 44488 | 151413 |
| 11 | innodb/io_write_thread | 0 | 0 | 0.0000 | 0 | 122584 |
+-----------+--------------------------------+--------------------+-------------------+-------------------+-------------------+-----------------+
20 rows in set (0.26 sec)
5. 是否启用了大页
可以参考这篇文章 https://mp.weixin.qq.com/s/Z5ktp3uZdkE9WfOi28bfow
没有启用大页
$ cat /proc/meminfo
MemTotal: 32349428 kB
MemFree: 13346028 kB
MemAvailable: 19320644 kB
Buffers: 661152 kB
Cached: 5866820 kB
SwapCached: 0 kB
Active: 1377132 kB
Inactive: 17167760 kB
Active(anon): 210124 kB
Inactive(anon): 12034920 kB
Active(file): 1167008 kB
Inactive(file):5132840 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 0 kB
SwapFree: 0 kB
Dirty: 8 kB
Writeback: 0 kB
AnonPages: 12016980 kB
Mapped: 139124 kB
Shmem: 231732 kB
KReclaimable: 257396 kB
Slab: 319608 kB
SReclaimable: 257396 kB
SUnreclaim: 62212 kB
KernelStack: 6864 kB
PageTables: 27536 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 16174712 kB
Committed_AS: 14007728 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 21652 kB
VmallocChunk: 0 kB
Percpu: 20768 kB
HardwareCorrupted: 0 kB
AnonHugePages: 12288 kB
ShmemHugePages: 0 kB
ShmemPmdMapped: 0 kB
FileHugePages: 0 kB
FilePmdMapped: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
Hugetlb: 0 kB
DirectMap4k: 214976 kB
DirectMap2M: 33339392 kB
mysql> showengine innodb status\G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
2024-12-12 14:55:26 140047534749248 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 11 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 8 srv_active, 0 srv_shutdown, 598 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 149
OS WAIT ARRAY INFO: signal count 106
RW-shared spins 0, rounds 0, OS waits 0
RW-excl spins 0, rounds 0, OS waits 0
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 15703
Purge done for trx's n:o < 15702 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421529099757576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099756728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099755880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099755032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099754184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099753336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099752488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099751640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099750792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099749944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099749096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099748248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099747400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099746552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099745704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099744856, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099744008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099743160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099742312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099741464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099740616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099739768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099738920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099738072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099737224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099736376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099735528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099734680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099733832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099732984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099732136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099731288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099730440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099729592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099728744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099727896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099727048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099726200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099725352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099724504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099723656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099722808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099721960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099721112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099720264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099719416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099718568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099717720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099716872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099716024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099715176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099714328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099713480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099712632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099711784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099710936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099710088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099709240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099708392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099707544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099706696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099705848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099705000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099704152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099703304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099700760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099702456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099701608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421529099699912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: , aio writes: ,
ibuf aio reads:, log i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
1333 OS file reads, 2154 OS file writes, 443 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 2656321, node heap has 0 buffer(s)
Hash table size 2656321, node heap has 0 buffer(s)
Hash table size 2656321, node heap has 0 buffer(s)
Hash table size 2656321, node heap has 0 buffer(s)
Hash table size 2656321, node heap has 0 buffer(s)
Hash table size 2656321, node heap has 0 buffer(s)
Hash table size 2656321, node heap has 0 buffer(s)
Hash table size 2656321, node heap has 0 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 37108105
Log buffer assigned up to 37108105
Log buffer completed up to 37108105
Log written up to 37108105
Log flushed up to 37108105
Added dirty pages up to 37108105
Pages flushed up to 37108105
Last checkpoint at 37108105
Log minimum file id is 0
Log maximum file id is 0
Modified age no less than 37108105
Checkpoint age 0
Max checkpoint age 5422668288
260 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 510082
Buffer pool size 655280
Buffer pool size, bytes 10736107520
Free buffers 653868
Database pages 1412
Old database pages 0
Modified db pages0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1263, created 150, written 685
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1412, unzip_LRU len: 0
I/O sum:cur, unzip sum:cur
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 81910
Buffer pool size, bytes 1342013440
Free buffers 81787
Database pages 123
Old database pages 0
Modified db pages0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 118, created 5, written 74
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 123, unzip_LRU len: 0
I/O sum:cur, unzip sum:cur
---BUFFER POOL 1
Buffer pool size 81910
Buffer pool size, bytes 1342013440
Free buffers 81822
Database pages 88
Old database pages 0
Modified db pages0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 86, created 2, written 15
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 88, unzip_LRU len: 0
I/O sum:cur, unzip sum:cur
---BUFFER POOL 2
Buffer pool size 81910
Buffer pool size, bytes 1342013440
Free buffers 81841
Database pages 69
Old database pages 0
Modified db pages0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 69, created 0, written 82
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 69, unzip_LRU len: 0
I/O sum:cur, unzip sum:cur
---BUFFER POOL 3
Buffer pool size 81910
Buffer pool size, bytes 1342013440
Free buffers 81589
Database pages 321
Old database pages 0
Modified db pages0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 320, created 1, written 69
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 321, unzip_LRU len: 0
I/O sum:cur, unzip sum:cur
---BUFFER POOL 4
Buffer pool size 81910
Buffer pool size, bytes 1342013440
Free buffers 81790
Database pages 120
Old database pages 0
Modified db pages0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 117, created 3, written 48
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 120, unzip_LRU len: 0
I/O sum:cur, unzip sum:cur
---BUFFER POOL 5
Buffer pool size 81910
Buffer pool size, bytes 1342013440
Free buffers 81872
Database pages 38
Old database pages 0
Modified db pages0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37, created 1, written 10
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 38, unzip_LRU len: 0
I/O sum:cur, unzip sum:cur
---BUFFER POOL 6
Buffer pool size 81910
Buffer pool size, bytes 1342013440
Free buffers 81637
Database pages 273
Old database pages 0
Modified db pages0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 205, created 68, written 158
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 273, unzip_LRU len: 0
I/O sum:cur, unzip sum:cur
---BUFFER POOL 7
Buffer pool size 81910
Buffer pool size, bytes 1342013440
Free buffers 81530
Database pages 380
Old database pages 0
Modified db pages0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 311, created 70, written 229
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 380, unzip_LRU len: 0
I/O sum:cur, unzip sum:cur
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
0 RW transactions active inside InnoDB
Process ID=2174063, Main thread ID=140041955309120 , state=sleeping
Number of rows inserted 0, updated 4, deleted 0, read 4
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Number of system rows inserted 41, updated 418, deleted 33, read 7612
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1 row in set (0.00 sec) wu999 发表于 2024-12-12 14:28
1. mysqld进程状态
show global status;
| Variable_name| Value |
| Aborted_clients| 0 |
| Aborted_connects | 0 |
| Acl_cache_items_count| 0 |
| Binlog_snapshot_file | mysql-bin.000007|
| Binlog_snapshot_position | 2784|
| Binlog_cache_disk_use| 0 |
| Binlog_cache_use | 5 |
| Binlog_snapshot_gtid_executed| not-in-consistent-snapshot|
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use| 0 |
| Bytes_received | 5700|
| Bytes_sent | 12127 |
| Caching_sha2_password_rsa_public_key | -----BEGIN PUBLIC KEY-----
| Com_admin_commands | 1 |
| Com_assign_to_keycache | 0 |
| Com_alter_db | 0 |
| Com_alter_event| 0 |
| Com_alter_function | 0 |
| Com_alter_instance | 0 |
| Com_alter_procedure| 0 |
| Com_alter_resource_group | 0 |
| Com_alter_server | 0 |
| Com_alter_table| 1 |
| Com_alter_tablespace | 0 |
| Com_alter_trigger| 0 |
| Com_alter_user | 0 |
| Com_alter_user_default_role| 0 |
| Com_analyze| 0 |
| Com_begin| 4 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db| 1 |
| Com_change_master| 0 |
| Com_change_repl_filter | 0 |
| Com_change_replication_source| 0 |
| Com_check| 0 |
| Com_checksum | 0 |
| Com_clone| 0 |
| Com_commit | 4 |
| Com_create_compression_dictionary| 0 |
| Com_create_db| 1 |
| Com_create_event | 0 |
| Com_create_function| 0 |
| Com_create_index | 0 |
| Com_create_package | 0 |
| Com_create_package_body| 0 |
| Com_create_type| 0 |
| Com_create_procedure | 0 |
| Com_create_role| 0 |
| Com_create_server| 0 |
| Com_create_table | 35|
| Com_create_resource_group| 0 |
| Com_create_trigger | 0 |
| Com_create_udf | 0 |
| Com_create_user| 0 |
| Com_create_view| 0 |
| Com_create_spatial_reference_system| 0 |
| Com_dealloc_sql| 0 |
| Com_delete | 0 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_compression_dictionary| 0 |
| Com_drop_db| 0 |
| Com_drop_event | 0 |
| Com_drop_function| 0 |
| Com_drop_index | 0 |
| Com_drop_package | 0 |
| Com_drop_package_body| 0 |
| Com_drop_type| 0 |
| Com_drop_procedure | 0 |
| Com_drop_resource_group| 0 |
| Com_drop_role| 0 |
| Com_drop_server| 0 |
| Com_drop_spatial_reference_system| 0 |
| Com_drop_table | 0 |
| Com_drop_trigger | 0 |
| Com_drop_user| 0 |
| Com_drop_view| 0 |
| Com_empty_query| 0 |
| Com_execute_sql| 0 |
| Com_execute_immediate| 0 |
| Com_compound_sql | 0 |
| Com_explain_other| 0 |
| Com_flush| 1 |
| Com_get_diagnostics| 0 |
| Com_grant| 0 |
| Com_grant_roles| 0 |
| Com_ha_close | 0 |
| Com_ha_open| 0 |
| Com_ha_read| 0 |
| Com_help | 0 |
| Com_import | 0 |
| Com_insert | 0 |
| Com_insert_select| 0 |
| Com_insert_all_select| 0 |
| Com_install_component| 0 |
| Com_install_plugin | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_lock_instance| 0 |
| Com_lock_tables| 0 |
| Com_lock_tables_for_backup | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql| 0 |
| Com_purge| 0 |
| Com_purge_before_date| 0 |
| Com_release_savepoint| 0 |
| Com_rename_table | 0 |
| Com_rename_user| 0 |
| Com_repair | 0 |
| Com_replace| 0 |
| Com_replace_select | 0 |
| Com_reset| 0 |
| Com_resignal | 0 |
| Com_restart| 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_revoke_roles | 0 |
| Com_rollback | 0 |
| Com_rollback_to_savepoint| 0 |
| Com_savepoint| 0 |
| Com_select | 7 |
| Com_set_option | 8 |
| Com_set_password | 0 |
| Com_set_resource_group | 0 |
| Com_set_role | 0 |
| Com_signal | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets| 0 |
| Com_show_client_statistics | 0 |
| Com_show_collations| 0 |
| Com_show_create_db | 0 |
| Com_show_create_event| 0 |
| Com_show_create_func | 0 |
| Com_show_create_package| 0 |
| Com_show_create_package_body | 0 |
| Com_show_create_type | 0 |
| Com_show_create_proc | 0 |
| Com_show_create_table| 0 |
| Com_show_create_trigger| 0 |
| Com_show_datamysqls | 0 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex| 0 |
| Com_show_engine_status | 0 |
| Com_show_events| 0 |
| Com_show_errors| 0 |
| Com_show_fields| 0 |
| Com_show_function_code | 0 |
| Com_show_function_status | 0 |
| Com_show_grants| 1 |
| Com_show_index_statistics| 0 |
| Com_show_keys| 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_package_status| 0 |
| Com_show_type_status | 0 |
| Com_show_package_body_code | 0 |
| Com_show_package_body_status | 0 |
| Com_show_plugins | 0 |
| Com_show_privileges| 0 |
| Com_show_procedure_code| 0 |
| Com_show_procedure_status| 0 |
| Com_show_processlist | 0 |
| Com_show_profile | 0 |
| Com_show_profiles| 0 |
| Com_show_relaylog_events | 0 |
| Com_show_replicas| 0 |
| Com_show_slave_hosts | 0 |
| Com_show_replica_status| 0 |
| Com_show_slave_status| 0 |
| Com_show_status| 1 |
| Com_show_storage_engines | 0 |
| Com_show_table_statistics| 0 |
| Com_show_table_status| 0 |
| Com_show_sequences | 0 |
| Com_show_tables| 0 |
| Com_show_thread_statistics | 0 |
| Com_show_triggers| 0 |
| Com_show_user_statistics | 0 |
| Com_show_variables | 1 |
| Com_show_warnings| 0 |
| Com_show_create_user | 0 |
| Com_shutdown | 0 |
| Com_replica_start| 0 |
| Com_slave_start| 0 |
| Com_replica_stop | 0 |
| Com_slave_stop | 0 |
| Com_group_replication_start| 0 |
| Com_group_replication_stop | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_close | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data| 0 |
| Com_truncate | 0 |
| Com_uninstall_component| 0 |
| Com_uninstall_plugin | 0 |
| Com_unlock_instance| 0 |
| Com_unlock_tables| 0 |
| Com_update | 4 |
| Com_update_multi | 0 |
| Com_xa_commit| 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback| 0 |
| Com_xa_start | 0 |
| Com_create_sequence| 0 |
| Com_drop_sequence| 0 |
| Com_alter_sequence | 0 |
| Com_stmt_reprepare | 0 |
| Connection_errors_accept | 0 |
| Connection_errors_internal | 0 |
| Connection_errors_max_connections| 0 |
| Connection_errors_peer_address | 0 |
| Connection_errors_select | 0 |
| Connection_errors_tcpwrap| 0 |
| Connections| 76|
| Created_tmp_disk_tables| 0 |
| Created_tmp_files| 4 |
| Created_tmp_tables | 2 |
| Current_tls_ca | ca.pem|
| Current_tls_capath | |
| Current_tls_cert | server-cert.pem |
| Current_tls_cipher | |
| Current_tls_ciphersuites | |
| Current_tls_crl| |
| Current_tls_crlpath| |
| Current_tls_key| server-key.pem|
| Current_tls_version| TLSv1.2,TLSv1.3 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Error_log_buffered_bytes | 627744|
| Error_log_buffered_events| 4842|
| Error_log_expired_events | 0 |
| Error_log_latest_write | 1733986124019658|
| Flush_commands | 3 |
| Global_connection_memory | 0 |
| Handler_commit | 1116|
| Handler_delete | 32|
| Handler_discover | 0 |
| Handler_external_lock| 8041|
| Handler_mrr_init | 0 |
| Handler_prepare| 20|
| Handler_read_first | 109 |
| Handler_read_key | 2272|
| Handler_read_last| 0 |
| Handler_read_next| 4433|
| Handler_read_prev| 0 |
| Handler_read_rnd | 4 |
| Handler_read_rnd_next| 3214|
| Handler_rollback | 1 |
| Handler_savepoint| 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 421 |
| Handler_write| 209 |
| Innodb_background_log_sync | 0 |
| Innodb_buffer_pool_dump_status | Dumping of buffer pool not started|
| Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 241212 14:45:20|
| Innodb_buffer_pool_resize_status | |
| Innodb_buffer_pool_resize_status_code| 0 |
| Innodb_buffer_pool_resize_status_progress| 0 |
| Innodb_buffer_pool_pages_data| 1412|
| Innodb_buffer_pool_bytes_data| 23134208|
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 684 |
| Innodb_buffer_pool_pages_free| 653868|
| Innodb_buffer_pool_pages_LRU_flushed | 0 |
| Innodb_buffer_pool_pages_made_not_young| 0 |
| Innodb_buffer_pool_pages_made_young| 0 |
| Innodb_buffer_pool_pages_misc| 80|
| Innodb_buffer_pool_pages_old | 0 |
| Innodb_buffer_pool_pages_total | 655360|
| Innodb_buffer_pool_read_ahead_rnd| 0 |
| Innodb_buffer_pool_read_ahead| 0 |
| Innodb_buffer_pool_read_ahead_evicted| 0 |
| Innodb_buffer_pool_read_requests | 22188 |
| Innodb_buffer_pool_reads | 1264|
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests| 3275|
| Innodb_checkpoint_age| 0 |
| Innodb_checkpoint_max_age| 5422668288|
| Innodb_data_fsyncs | 443 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads| 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 20777984|
| Innodb_data_reads| 1333|
| Innodb_data_writes | 2154|
| Innodb_data_written| 11509760|
| Innodb_dblwr_pages_written | 543 |
| Innodb_dblwr_writes| 162 |
| Innodb_ibuf_free_list| 0 |
| Innodb_ibuf_segment_size | 2 |
| Innodb_redo_log_read_only| OFF |
| Innodb_redo_log_uuid | 1075899837|
| Innodb_redo_log_checkpoint_lsn | 37108105|
| Innodb_redo_log_current_lsn| 37108105|
| Innodb_redo_log_flushed_to_disk_lsn| 37108105|
| Innodb_redo_log_logical_size | 512 |
| Innodb_redo_log_physical_size| 201326592 |
| Innodb_redo_log_capacity_resized | 6442450944|
| Innodb_redo_log_resize_status| OK|
| Innodb_log_waits | 0 |
| Innodb_log_write_requests| 1834|
| Innodb_log_writes| 258 |
| Innodb_lsn_current | 37108105|
| Innodb_lsn_flushed | 37108105|
| Innodb_lsn_last_checkpoint | 37108105|
| Innodb_master_thread_active_loops| 8 |
| Innodb_master_thread_idle_loops| 405 |
| Innodb_max_trx_id| 15703 |
| Innodb_oldest_view_low_limit_trx_id| 0 |
| Innodb_os_log_fsyncs | 190 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written| 194048|
| Innodb_page_size | 16384 |
| Innodb_pages_created | 150 |
| Innodb_pages_read| 1263|
| Innodb_pages0_read | 30|
| Innodb_pages_written | 685 |
| Innodb_purge_trx_id| 15702 |
| Innodb_purge_undo_no | 0 |
| Innodb_redo_log_enabled| ON|
| Innodb_row_lock_current_waits| 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits| 0 |
| Innodb_rows_deleted| 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 4 |
| Innodb_rows_updated| 4 |
| Innodb_system_rows_deleted | 33|
| Innodb_system_rows_inserted| 41|
| Innodb_system_rows_read| 7612|
| Innodb_system_rows_updated | 418 |
| Innodb_sampled_pages_read| 0 |
| Innodb_sampled_pages_skipped | 0 |
| Innodb_num_open_files| 38|
| Innodb_truncated_status_writes | 0 |
| Innodb_undo_tablespaces_total| 2 |
| Innodb_undo_tablespaces_implicit | 2 |
| Innodb_undo_tablespaces_explicit | 0 |
| Innodb_undo_tablespaces_active | 2 |
| Innodb_secondary_index_triggered_cluster_reads | 2192|
| Innodb_secondary_index_triggered_cluster_reads_avoided | 0 |
| Innodb_buffered_aio_submitted| 0 |
| Innodb_scan_pages_contiguous | 0 |
| Innodb_scan_pages_disjointed | 0 |
| Innodb_scan_pages_total_seek_distance| 0 |
| Innodb_scan_data_size| 0 |
| Innodb_scan_deleted_recs_size| 0 |
| Innodb_encryption_n_merge_blocks_encrypted | 0 |
| Innodb_encryption_n_merge_blocks_decrypted | 0 |
| Innodb_encryption_n_rowlog_blocks_encrypted| 0 |
| Innodb_encryption_n_rowlog_blocks_decrypted| 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused| 26792 |
| Key_blocks_used| 0 |
| Key_read_requests| 0 |
| Key_reads| 0 |
| Key_write_requests | 0 |
| Key_writes | 0 |
| Locked_connects| 0 |
| Max_execution_time_exceeded| 0 |
| Max_execution_time_set | 0 |
| Max_execution_time_set_failed| 0 |
| Max_used_connections | 3 |
| Max_used_connections_time| 2024-12-12 14:52:11 |
| Mysqlx_aborted_clients | 0 |
| Mysqlx_address | ::|
| Mysqlx_bytes_received| 0 |
| Mysqlx_bytes_received_compressed_payload | 0 |
| Mysqlx_bytes_received_uncompressed_frame | 0 |
| Mysqlx_bytes_sent| 0 |
| Mysqlx_bytes_sent_compressed_payload | 0 |
| Mysqlx_bytes_sent_uncompressed_frame | 0 |
| Mysqlx_compression_algorithm | |
| Mysqlx_compression_level | |
| Mysqlx_connection_accept_errors| 0 |
| Mysqlx_connection_errors | 0 |
| Mysqlx_connections_accepted| 0 |
| Mysqlx_connections_closed| 0 |
| Mysqlx_connections_rejected| 0 |
| Mysqlx_crud_create_view| 0 |
| Mysqlx_crud_delete | 0 |
| Mysqlx_crud_drop_view| 0 |
| Mysqlx_crud_find | 0 |
| Mysqlx_crud_insert | 0 |
| Mysqlx_crud_modify_view| 0 |
| Mysqlx_crud_update | 0 |
| Mysqlx_cursor_close| 0 |
| Mysqlx_cursor_fetch| 0 |
| Mysqlx_cursor_open | 0 |
| Mysqlx_errors_sent | 0 |
| Mysqlx_errors_unknown_message_type | 0 |
| Mysqlx_expect_close| 0 |
| Mysqlx_expect_open | 0 |
| Mysqlx_init_error| 0 |
| Mysqlx_messages_sent | 0 |
| Mysqlx_notice_global_sent| 0 |
| Mysqlx_notice_other_sent | 0 |
| Mysqlx_notice_warning_sent | 0 |
| Mysqlx_notified_by_group_replication | 0 |
| Mysqlx_port| 33060 |
| Mysqlx_prep_deallocate | 0 |
| Mysqlx_prep_execute| 0 |
| Mysqlx_prep_prepare| 0 |
| Mysqlx_rows_sent | 0 |
| Mysqlx_sessions| 0 |
| Mysqlx_sessions_accepted | 0 |
| Mysqlx_sessions_closed | 0 |
| Mysqlx_sessions_fatal_error| 0 |
| Mysqlx_sessions_killed | 0 |
| Mysqlx_sessions_rejected | 0 |
| Mysqlx_socket| /tmp/mysqlx.sock|
| Mysqlx_ssl_accepts | 0 |
| Mysqlx_ssl_active| |
| Mysqlx_ssl_cipher| |
| Mysqlx_ssl_cipher_list | |
| Mysqlx_ssl_ctx_verify_depth| 18446744073709551615|
| Mysqlx_ssl_ctx_verify_mode | 5 |
| Mysqlx_ssl_finished_accepts| 0 |
| Mysqlx_ssl_server_not_after| Dec2 03:33:20 2034 GMT|
| Mysqlx_ssl_server_not_before | Dec4 03:33:20 2024 GMT|
| Mysqlx_ssl_verify_depth| |
| Mysqlx_ssl_verify_mode | |
| Mysqlx_ssl_version | |
| Mysqlx_stmt_create_collection| 0 |
| Mysqlx_stmt_create_collection_index| 0 |
| Mysqlx_stmt_disable_notices| 0 |
| Mysqlx_stmt_drop_collection| 0 |
| Mysqlx_stmt_drop_collection_index| 0 |
| Mysqlx_stmt_enable_notices | 0 |
| Mysqlx_stmt_ensure_collection| 0 |
| Mysqlx_stmt_execute_mysqlx | 0 |
| Mysqlx_stmt_execute_sql| 0 |
| Mysqlx_stmt_execute_xplugin| 0 |
| Mysqlx_stmt_get_collection_options | 0 |
| Mysqlx_stmt_kill_client| 0 |
| Mysqlx_stmt_list_clients | 0 |
| Mysqlx_stmt_list_notices | 0 |
| Mysqlx_stmt_list_objects | 0 |
| Mysqlx_stmt_modify_collection_options| 0 |
| Mysqlx_stmt_ping | 0 |
| Mysqlx_worker_threads| 2 |
| Mysqlx_worker_threads_active | 0 |
| Net_buffer_length| 49152 |
| Not_flushed_delayed_rows | 0 |
| Ongoing_anonymous_transaction_count| 0 |
| Open_files | 7 |
| Open_streams | 0 |
| Open_table_definitions | 49|
| Open_tables| 111 |
| Opened_files | 7 |
| Opened_table_definitions | 80|
| Opened_tables| 193 |
| PQ_memory_refused| 0 |
| PQ_memory_used | 0 |
| PQ_threads_refused | 0 |
| PQ_threads_running | 0 |
| Performance_schema_accounts_lost | 0 |
| Performance_schema_cond_classes_lost | 0 |
| Performance_schema_cond_instances_lost | 0 |
| Performance_schema_digest_lost | 0 |
| Performance_schema_file_classes_lost | 0 |
| Performance_schema_file_handles_lost | 0 |
| Performance_schema_file_instances_lost | 0 |
| Performance_schema_hosts_lost| 0 |
| Performance_schema_index_stat_lost | 0 |
| Performance_schema_locker_lost | 0 |
| Performance_schema_memory_classes_lost | 0 |
| Performance_schema_metadata_lock_lost| 0 |
| Performance_schema_mutex_classes_lost| 0 |
| Performance_schema_mutex_instances_lost| 0 |
| Performance_schema_nested_statement_lost | 0 |
| Performance_schema_prepared_statements_lost| 0 |
| Performance_schema_program_lost| 0 |
| Performance_schema_rwlock_classes_lost | 0 |
| Performance_schema_rwlock_instances_lost | 0 |
| Performance_schema_session_connect_attrs_longest_seen| 173 |
| Performance_schema_session_connect_attrs_lost| 0 |
| Performance_schema_socket_classes_lost | 0 |
| Performance_schema_socket_instances_lost | 0 |
| Performance_schema_stage_classes_lost| 0 |
| Performance_schema_statement_classes_lost| 0 |
| Performance_schema_table_handles_lost| 0 |
| Performance_schema_table_instances_lost| 0 |
| Performance_schema_table_lock_stat_lost| 0 |
| Performance_schema_thread_classes_lost | 0 |
| Performance_schema_thread_instances_lost | 0 |
| Performance_schema_users_lost| 0 |
| Prepared_stmt_count| 0 |
| Queries| 26|
| Questions| 16|
| Replica_open_temp_tables | 0 |
| Resource_group_supported | ON|
| Rsa_public_key | -----BEGIN PUBLIC KEY-----
-----END PUBLIC KEY-----
|
| Sched_affinity_group_capacity| 8 |
| Sched_affinity_group_number| 1 |
| Sched_affinity_status| |
| Secondary_engine_execution_count | 0 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan| 4 |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads| 0 |
| Slow_queries | 0 |
| Sort_merge_passes| 0 |
| Sort_range | 0 |
| Sort_rows| 0 |
| Sort_scan| 0 |
| Ssl_accept_renegotiates| 0 |
| Ssl_accepts| 1 |
| Ssl_callback_cache_hits| 0 |
| Ssl_cipher | |
| Ssl_cipher_list| |
| Ssl_client_connects| 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 18446744073709551615|
| Ssl_ctx_verify_mode| 5 |
| Ssl_default_timeout| 0 |
| Ssl_finished_accepts | 1 |
| Ssl_finished_connects| 0 |
| Ssl_server_not_after | Dec2 03:33:20 2034 GMT|
| Ssl_server_not_before| Dec4 03:33:20 2024 GMT|
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | SERVER|
| Ssl_session_cache_overflows| 0 |
| Ssl_session_cache_size | 128 |
| Ssl_session_cache_timeout| 300 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused| 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode| 0 |
| Ssl_version| |
| Table_locks_immediate| 2 |
| Table_locks_waited | 0 |
| Table_open_cache_hits| 3829|
| Table_open_cache_misses| 193 |
| Table_open_cache_overflows | 0 |
| Table_open_cache_triggers_hits | 0 |
| Table_open_cache_triggers_misses | 0 |
| Table_open_cache_triggers_overflows| 0 |
| Tc_log_max_pages_used| 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits| 0 |
| Threadpool_idle_threads| 0 |
| Threadpool_threads | 0 |
| Threads_cached | 0 |
| Threads_connected| 3 |
| Threads_created| 3 |
| Threads_running| 3 |
| Tls_library_version| OpenSSL 1.1.1h22 Sep 2020 |
| Uptime | 425 |
| Uptime_since_flush_status| 425 |
| validate_password.dictionary_file_last_parsed| 2024-12-12 14:45:20 |
| validate_password.dictionary_file_words_count| 0 |
GreatSQL社区 发表于 2024-12-12 15:05
看起来不对劲啊，你的mysqld进程显示是12月4日启动的，但从global status里看到的才启动425秒，请先确认哪里有出入
mysql 477581.3 36.7 12955744 11896296 ? Sl Dec04 152:22 /usr/local/greatsql/bin/mysqld --defaults-file=/etc/my-xxxxx-3306.cnf --basedir=/usr/local/greatsql --datadir=/data/greatsql-xxxxx-3306/data --plugin-dir=/usr/local/greatsql/lib/plugin --user=mysql--log-error=/data/greatsql-xxxxx-3306/logs/error.log --open-files-limit=65535 --pid-file=/data/greatsql-xxxxx-3306/data/mysql.pid --socket=/data/greatsql-xxxxx-3306/data/mysql.sock --port=3306
| Uptime | 425 |
| Uptime_since_flush_status| 425 |
页:
[1]
2