匿名用户如何在不重启MYSQL情况下,让MYSQL 释放共享内存呢?
MYSQL 采用默认RPM安装,以及默认参数下, INNODB BUF SIZE 也是默认。现在MYSQL 内存占用太多
我来答
添加附件
收藏
分享
问题补充
4条回答
默认
最新
mysql> select event_name,current_alloc from sys.memory_global_by_current_bytes limit 10;
+---------------------------------------------------------------------------+---------------+
| event_name | current_alloc |
+---------------------------------------------------------------------------+---------------+
| memory/innodb/buf_buf_pool | 4.08 GiB |
| memory/performance_schema/events_statements_history.digest_text | 2.44 GiB |
| memory/performance_schema/events_statements_history.sql_text | 2.44 GiB |
| memory/performance_schema/events_statements_history | 355.47 MiB |
| memory/innodb/hash0hash | 114.83 MiB |
| memory/performance_schema/events_statements_history_long.sql_text | 97.66 MiB |
| memory/performance_schema/events_statements_summary_by_digest.digest_text | 97.66 MiB |
| memory/performance_schema/events_statements_history_long.digest_text | 97.66 MiB |
| memory/sql/TABLE | 73.76 MiB |
| memory/performance_schema/events_statements_summary_by_digest | 39.67 MiB |
+---------------------------------------------------------------------------+---------------+
10 rows in set (0.01 sec)
如何释放performance_schema内存 不重启情况下?
评论
有用 0 打赏 0
mysql> select event_name,current_alloc from sys.memory_global_by_current_bytes limit 10; +---------------------------------------------------------------------------+---------------+ | event_name | current_alloc | +---------------------------------------------------------------------------+---------------+ | memory/innodb/buf_buf_pool | 4.08 GiB | | memory/performance_schema/events_statements_history.digest_text | 2.44 GiB | | memory/performance_schema/events_statements_history.sql_text | 2.44 GiB | | memory/performance_schema/events_statements_history | 355.47 MiB | | memory/innodb/hash0hash | 114.83 MiB | | memory/performance_schema/events_statements_history_long.sql_text | 97.66 MiB | | memory/performance_schema/events_statements_summary_by_digest.digest_text | 97.66 MiB | | memory/performance_schema/events_statements_history_long.digest_text | 97.66 MiB | | memory/sql/TABLE | 73.76 MiB | | memory/performance_schema/events_statements_summary_by_digest | 39.67 MiB | +---------------------------------------------------------------------------+---------------+ 10 rows in set (0.01 sec)复制 打赏 0
mysql> select event_name,current_alloc from sys.memory_global_by_current_bytes limit 10;
+---------------------------------------------------------------------------+---------------+ | event_name | current_alloc | +---------------------------------------------------------------------------+---------------+ | memory/innodb/buf_buf_pool | 4.08 GiB | | memory/performance_schema/events_statements_history.digest_text | 2.44 GiB | | memory/performance_schema/events_statements_history.sql_text | 2.44 GiB | | memory/performance_schema/events_statements_history | 355.47 MiB | | memory/innodb/hash0hash | 114.83 MiB | | memory/performance_schema/events_statements_history_long.sql_text | 97.66 MiB | | memory/performance_schema/events_statements_summary_by_digest.digest_text | 97.66 MiB | | memory/performance_schema/events_statements_history_long.digest_text | 97.66 MiB | | memory/sql/TABLE | 73.76 MiB | | memory/performance_schema/events_statements_summary_by_digest | 39.67 MiB | +---------------------------------------------------------------------------+---------------+ 10 rows in set (0.01 sec)复制 打赏 0
回答交流
Markdown
请输入正文
提交
相关推荐
MySQL 8.0 ，服务器8c16g，myini要如何配置才是最佳性能？
回答 1
已采纳
innodbbufferpoolsize尽量给大点，比如12g其它参数根据实际需要修改
mysql开启SSL问题
回答 3
2020051509:20:36[ERROR]Failedtoaccessdirectorypointedbydatadir.Pleasemakesurethatdirectoryexistsandi
MySQL 单表查询慢 5000万条记录，需要分区吗？
回答 3
1000万以下的表，查询慢的主要原因是：1SQL语句写的不好 2没有索引 3索引列顺序不对4索引没用到
MySQL 拼音查询中如何区分声调？
回答 1
是想要这种效果？这里用到的是gb2312bin
MySQL 加上强制索引后查询反而更慢
回答 5
如果能贴一个慢的查询计划就好了。难道是因为回表与排序花了更多时间？可以试试建一个联合索引，完成上述语句的所有列，完成索引覆盖
mysql主备延迟问题
回答 3
你这种办法只能作为参考，不能作为依据，MySQL主从延迟引起的因素是多方面的，除了常见的主机性能、网络延迟等因素外，还有事物大小的影响，比如主库执行一个操作近1个小时的事物，备库这1个小时只能等待，等
无法通过Dbeaver连接到MySQL RDS。收到连接超时的错误消息。通讯链路故障
回答 1
已采纳
Dbeaver版本有点低了我用21的版本，连接是没有问题的
MySQL在查询处理的哪个阶段创建查询的执行计划??
回答 4
已采纳
1.语法分析阶段：将SQL查询语句经词法和语法分析后变换为一颗查询树stselectlex传给优化器，并对SQL表达的语义进行检查。2.生成逻辑查询执行计划阶段：优化器在查询树中遍历每个关系，确定关系
请教用ogg同步mysql到kafka的问题
回答 1
参考官方文档如下:https://docs.oracle.com/en/middleware/goldengate/core/18.1/hetergeneousdb/preparingandconfi
执行了analyze更新统计信息后，如何确认我收集的时间呢？那个系统表的那个字段来记录？
回答 1
INFORMATIONSCHEMA.STATISTICS的UPDATETIME
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
