Toggle Submenu
  1. Forums
  2. Recent
  3. カテゴリ
  4. タグ
  5. ユーザ
返信を追加 返信を表示 (6)

解決済み How to find the best value for CacheSize parameter in Server

  1. François Van Lerberghe
    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.
返信 (6)
Ivan Smahin
Ivan Smahin 承諾済みの回答
It means that 10 is enough
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
François Van Lerberghe
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
François Van Lerberghe
François Van Lerberghe 承諾済みの回答
Interesting. Thank you.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Ivan Smahin
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
François Van Lerberghe
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Ruslan Zasukhin
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
  • ページ :
  • 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