G
Gareth Vincent
Guest
Its 9am now and i'm already seeing a great improvement in performance. You were spot on about the memory. Just by reducing the Buffer pool (not ideal, if anything I would like to allocate more) the server is no longer swapping. At least 70% improvement in overall performance. As I was providing you with the shared memory allocations along with the temp table Bt param its was quite obvious that I was over committing on memory. I just need to convince the customer to invest in new hardware or at least upgrade the memory. I would appreciate if you could provide me with more insight into "meminfo", I would really like to get a better understanding on the memory allocation on an OS level.
Continue reading...
Continue reading...