1. François Van Lerberghe
  2. Valentina Server
  3. Saturday, August 31 2019, 07:11 AM
  4.  Subscribe via 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.
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi,

there is no strict rules,

play with numbers 10 - 20 - 30 - 40 -50 Mb.
Usually this range of numbers is ok
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 1
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 2
Ivan Smahin Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 3
Interesting. Thank you.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 4
Mmmh, I tried 10, 20 and 30. Show status show exactly the same result for the tree CacheSize values.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 5
Ivan Smahin Accepted Answer
It means that 10 is enough
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 6
  • Page :
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories