Hello. On Sat 2002-12-07 at 03:36:56 -0500, [EMAIL PROTECTED] wrote: > Hi all, > > I'm going to run MySQL off a shared Unix server so I'm wondering what the > memory requirements are. I have about 15 tables are simple text columns > (~10 - 20 columns). The largest tables will be ~25MB.
You can make MySQL use (almost) as less memory as you want, except for the fixed offset of the executable size itself. Of course, that is a trade-off against performance. > I did a quick test on my Win32 Machine and the largest query only takes up > 18MB of RAM. > > Is there a way to minimize RAM usage? Yes. MySQL will only use memory as it is explicitly allowed to do. Some buffers are per-connection, some are shared (i.e. global). Have a look at http://www.mysql.com/doc/en/Memory_use.html http://www.mysql.com/doc/en/Server_parameters.html http://www.mysql.com/doc/en/Option_files.html HTH, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
