Toggle Submenu
  1. Forums
  2. Recent
  3. Kategorien
  4. Tags
  5. Benutzer
Antwort hinzufügen Antworten ansehen (6)

Gelöst How to find the best value for CacheSize parameter in Server

  1. François Van Lerberghe
    François Van Lerberghe
  2. Valentina Server
  3. Samstag, August 31 2019, 07:11 AM
  4.  Abonnieren via E-Mail
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.
Kommentar
There are no comments made yet.
Antworten (6)
Ruslan Zasukhin
Ruslan Zasukhin Akzeptierte Antwort
Hi,

there is no strict rules,

play with numbers 10 - 20 - 30 - 40 -50 Mb.
Usually this range of numbers is ok
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
François Van Lerberghe
François Van Lerberghe Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Ivan Smahin
Ivan Smahin Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
François Van Lerberghe
François Van Lerberghe Akzeptierte Antwort
Interesting. Thank you.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
François Van Lerberghe
François Van Lerberghe Akzeptierte Antwort
Mmmh, I tried 10, 20 and 30. Show status show exactly the same result for the tree CacheSize values.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Ivan Smahin
Ivan Smahin Akzeptierte Antwort
It means that 10 is enough
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
  • Seite :
  • 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