More memory you give faster it would be. I do following estimation: mysqld process size usually 30-50MB (small) Other memory consumed by cache.
It is important to cache all index data. Index *must* be in memory. Linux will cache other data as well (DB and non-DB files) So total cache should be bigger then index. If you will have much bigger cache than index size then more data would be cached then faster server will work. On Jan 13, 10:49 am, "Frédéric Sidler" <[email protected]> wrote: > Try mysql tuner scripts herehttp://day32.com/MySQL/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
