1. François Van Lerberghe
  2. Valentina Server
  3. 土, 8月 31 2019, 07:11 AM
  4.  メールで購読
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories