How to Increase MySQL Buffer Pool Memory Usage

Last updated by brian on May 18, 2017 In MySQL This knowledge base article has 4,634 views

When Variphy Insight's Call Data searches become very slow, it is often caused by a shortage of available memory on the SQL database server. This typically happens when the size of the database outgrows the ammount of memory made avaialable to cache it. The larger the ratio of database size to database cache grows, the more search performance will slow down.  Ideally, for every gigabyte of data of the database size, you would want to allocate and equal ammount of memory to cache it, so for...

Login for Full Article >