1. François Van Lerberghe
  2. Valentina Server
  3. Суббота, Август 31 2019, 07:11 AM
  4.  Подписаться через email
Hello,

I want to set the optimum value of the CacheSize parameter for my embedded vServer. How can I find it ?
Currently the database have 60 tables.
Some of my customers have 3 tables with 100,000 to 200,000 records and 2 tables around 500,000 records.
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi,

there is no strict rules,

play with numbers 10 - 20 - 30 - 40 -50 Mb.
Usually this range of numbers is ok
Комментарий
There are no comments made yet.
François Van Lerberghe Ответ принят
Mmmh, thank you for your answer. But it doesn't me a lot...
Why should I use 10 or instead 30 Mb ? Are there some rules (witch ones) or no rules at all ?? Help me to understand the logic, please.
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят
You may do following SQL:


SHOW STATUS


And see many params there. For example "CACHE FLUSH". It is about how often the cache flushes pages to the disk.
Try to change the cache size, if you see less flushes, then this cache size more effective for your app.
Комментарий
There are no comments made yet.
François Van Lerberghe Ответ принят
Interesting. Thank you.
Комментарий
There are no comments made yet.
François Van Lerberghe Ответ принят
Mmmh, I tried 10, 20 and 30. Show status show exactly the same result for the tree CacheSize values.
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят
It means that 10 is enough
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories