To see the Buffer Pool size in GB run this:
SELECT FORMAT(BufferPoolPages*PageSize/POWER(1024,3),2) BufferPoolDataGB FROM(SELECT variable_value BufferPoolPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_total') A,(SELECT variable_value PageSize FROM information_schema.global_status
WHERE variable_name ='Innodb_page_size') B;
Database pages 360515
This is the number of pages with data inside the Buffer Pool
To see the amount of data in the Buffer Pool size in GB run this:
SELECT FORMAT(BufferPoolPages*PageSize/POWER(1024,3),2) BufferPoolDataGB FROM(SELECT variable_value BufferPoolPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_data') A,(SELECT variable_value PageSize FROM information_schema.global_status
WHERE variable_name ='Innodb_page_size') B;
To see the percentage of the Buffer Pool in use, run this:
SELECT CONCAT(FORMAT(DataPages*100.0/TotalPages,2),' %') BufferPoolDataPercentage FROM(SELECT variable_value DataPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_data') A,(SELECT variable_value TotalPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_total') B;
Modified db pages 300
This is the number of pages in the Buffer Pool that have to be written back to the database. They are also referred to as dirty pages.
To see the Space Taken Up by Dirty Pages, run this:
SELECT FORMAT(DirtyPages*PageSize/POWER(1024,3),2) BufferPoolDirtyGB FROM(SELECT variable_value DirtyPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_dirty') A,(SELECT variable_value PageSize FROM information_schema.global_status
WHERE variable_name ='Innodb_page_size') B;
To see the Percentage of Dirty Pages, run this:
SELECT CONCAT(FORMAT(DirtyPages*100.0/TotalPages,2),' %') BufferPoolDirtyPercentage FROM(SELECT variable_value DirtyPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_dirty') A,(SELECT variable_value TotalPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_total') B;
As for the other things in the display, run this:
SHOW GLOBAL STATUS LIKE'Innodb_buffer_pool%';
相关推荐
To run in the same address space. In-process servers are loaded in the client’s address space because they are implemented as DLLs. The main advantage of running in-process is that the system usually...
pytorch-Learning-to-See-in-the-Dark代码,CVPR论文 亲测,可行
这是关于学术论文Learning to See in the Dark的相关代码
commons-pool-1.5.4 RELEASE NOTES This is a patch release containing a fix for POOL-152, a ...patches, or suggestions for improvement, see the commons-pool website: http://commons.apache.org/pool/
mongodb 命令行mongod启动报错 about to fork child ...To see additional information in this output, start without the "--fork" option. 可能的问题原因: 已经有mongd进程在运行了 配置错误(如dbpath log等)
这是关于论文Learning to See in the Dark. CVPR 2018的相关代码值得学习
The Definitive Guide to JSF in Java EE 8 pdf Learn and master the new features in the JSF 2.3 MVC web framework in this definitive guide written by two of the JavaServer Faces (JSF) specification ...
The Definitive Guide to Spring Batch covers how running finite tasks on cloud infrastructure in a standardized way has changed where batch applications are run. Additionally, you’ll discover how ...
In this document, the words "tablet" and "digitizer" are used interchange¬ably to mean all absolute point¬ing or digitizing devices that can be made to work with this interface. The definition is ...
If you are seeking fundamental Swift programming skills, in preparation for learning to develop native applications for iOS or macOS, this book is the best for you. You don’t need to have any prior ...
23. The five layers in the Internet protocol stack are – from top to bottom – the application layer, the transport layer, the network layer, the link layer, and the physical layer. The principal ...
In manyways, the first edition of See MIPS Run was a ground-breaking book on the MIPS architecture and its implementations. While other books covered similar material, See MIPS Run focused on what the...
- A printer to run the printer test, set-up as the default printer in Windows. - A CD ROM + 1 Music CD or Data CD to run the CD test. - A CD-RW to run the CD burn test. - A network connection and the ...
PLEASE TAKE A LOOK AT THE "WHAT's NEW IN THIS VERSION" LINK IN THE HELP FILE AS IT HAS CONVENIENT LINKS TO ALL OF THE NEW TOPICS. ==================== Version 3.10 Build 1 - Several bug fixes. - ...
The disassembler now emits a comment if a buffer appears to be a ResourceTemplate, but cannot be disassembled as such because the EndTag does not appear at the very end of the buffer. AcpiExec - ...
讲义+题目In this exercise, you will implement linear regression and get to see it work on data. Before starting on this programming exercise, we strongly recom- mend watching the video lectures and ...
This, combined with the vast amount of dependencies in the kernel and that it is not easy to see all the consequences of a kernel change, demands developers with a relative full understanding of the ...
Java中的look in dark
See the example that shows this opportunity in a project: <EhLib Archive> \ Demos \ DBGridEh.LoadingStatus \ Project1.dpr compiled project: <EhLib Archive> \ Demos \ Bin \ DBGridEh.LoadingStatus....
Written by the creators of the free open source OpenCV library, this book introduces you to computer vision and demonstrates how you can quickly build applications that enable computers to "see" and ...