We have limited experience on monitoring memory with solidDB as our tables are not that large. Some of our in-memory tables will be growing and looking to be about 300gig in memory size. Monitoring memory is going to be more important now. In reading about monitoring solidDB, the manual points out to monitor:
- - the amount of physical memory in the computer
- - the amount of memory used by the operating system
- - the amount of memory used by solidDB® (the program itself)
- - the amount of memory set aside for the solidDB server's cache (the CacheSize solid.iniconfiguration parameter)
- - the amount of memory required by the connections, transactions and statements running concurrently in the server. The more concurrent connections and active statements there are in the server, the more working memory the server requires. Typically, you should allocate at least 0.5 MB of memory for each client connection in the server.
- - the memory used by other processes (programs and data) that are running in the computer
Does anyone have some sort of shell script you can share that will display this information? We are running AIX. We are a mainframe support group with limited knowledge of AIX. From a solidDB perspective, I can find the following:
ADMIN COMMAND 'info imdbsize';
ADMIN COMMAND 'memory'
Any other commands we should be using? Or the shell script should be using?