Edugeek Database

[PEO]

I have about 8GB installed on the server. I cant see anything in mysql or joomla that would allow me to set min and max cache sizes so I am assuming it is all done auto magically

[SYNACK]

I have about 8GB installed on the server. I cant see anything in mysql or joomla that would allow me to set min and max cache sizes so I am assuming it is all done auto magically

Looks like it is configurable in the mysqld service config, here are some guides:

MySQL Server Memory Usage | MySQL Performance Blog
MySQL :: MySQL 5.0 Reference Manual :: 7.5.8 How MySQL Uses Memory
Troubleshooting Memory Usage - RimuHosting

[Michael]

All those numbers aside, I believe youtube uses MySQL, which goes to show how scaleable it really is.

I know with MS SQL you can specify memory limits, but by default it will use as much as possible to speed everything up. I suspect MySQL behaves the same by default. Only on very large configurations you may need to tweak accordingly.
A good example with MS SQL is when using Sims. It will quite easily use anywhere between 600MB to 1200MB with a server with 2GB of memory installed.