如何从查询数据库中获取mysql服务器内存利用率？ [英] How to get mysql server memory utilization from a query database?

问题描述

大家好，

我有Mysql服务器和visual studio 2013 winform。

通过我的winform应用程序，我希望以百分比的形式获得Mysql服务器内存利用率。

要知道Mysql服务器的内存消耗了什么？

将内存使用率视为最大服务器内存的百分比？

和

知道物理内存使用量与总系统内存量之比？



我尝试过：



选择转换（float，memory_utilization_percentage）/ 100作为memory_usage
来自sys.dm_os_process_memory的
;



select * from sys.dm_os_sys_info;

hi guys,
i have Mysql server and visual studio 2013 winform.
Via my winform app i would like to get Mysql server memory utilization in terms of percentage.
To know what is consuming by Mysql server's memory ?
to see memory usage as a percent of theMaximum server memory ?
and
to know the physical memory use vs total system memory?

What I have tried:

select convert(float, memory_utilization_percentage) / 100 as memory_usage
from sys.dm_os_process_memory;

select * from sys.dm_os_sys_info;

推荐答案

这可能是一个很好的起点：

第23章MySQL性能架构 [ ^ ]



我不知道你是否还通过了它;如果你没有，你应该看看它。乍一看，这看起来可能很大，但如果你读到23.1到23.5只有你已经拥有这样一个愉快的游乐场。

This may be a good starting point:
Chapter 23 MySQL Performance Schema[^]

I don't know if you went through it yet; if you did not, you should have a look at it. That may seem huge at first glance, but if you read 23.1 to 23.5 only you will already have such a pleasant playground.

这篇关于如何从查询数据库中获取mysql服务器内存利用率？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！