Question : I am trying to understand the memory management of SQL Server. I have a Windows Server 2019 on […]
Tag: buffer-pool
memory leaks in innodb
Question : I have MySQL server 5.6 and I use stress test to evaluate the performance of it. after the […]
MEMORYCLERK SQLBUFFERPOOL
Question : SQL Buffer pool is consuming more memory in sql server 2017. Is there any way to reduce it?? […]
Sum of all Memory Clerks and Total Server Memory (KB)
Question : I am trying to understand the memory management of SQL Server. I have a Windows Server 2019 on […]
Amount of used cache / free cache
Question : I need to find out how much cache is used, and if there is free cache available. Background: […]
Can we set the fixed size for both plan cache and data cache?
Question : As far as I know, SQL Server automatically manages the size for the components of buffer pool. I […]
Optimal Number of MySQL InnoDB Buffer Pool Instances
Question : Server Characteristics Total system RAM: 8GB (running MySQL + other stuff than MySQL on it i.e. not dedicated […]
Cannot set innodb_buffer_pool_size above 1023M in my.ini
Question : Windows server 2012 R2 with 64GB RAM, MySQL 8. The Database is about 5GB. I am using a […]
Assign different RAM usage (buffer pool size) per db in mysql
Question : I have quite some very large mysql databases (dev, production, staging, etc.) on a single server. Total size […]
warning”
Question : No, increase in innodb_buffer_pool_size would be helpful. When innodb_data_reads / uptime result is < 1.00 there is no […]