Hi, I would like to tune the performance of my database. The database is rather small about 80 MB altogether. (with 20 Mb indexes) The most complex selections open 32 tables at ones. The database is mostly readonly (99%). What settings show I use to maximize the speed of the queries? What would happen if I equip the computer with very much RAM? Will all the tables be cached and the speed of the harddrives not matter anymore? Is there a way to hold all tables in memory and only regularly (every x min) sync them to disk to improve the speed of reads? thanks for *any* answer Gunnar von Boehn --------------------------------------------------------------------- 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
