>From my experience: don't do anything. Linux filesystem cache is really efficient and as soon as all your database will be in the cache, you wont get any disk read anymore; only writes when you INSERT/UPDATE data.
Our main database server has 2Gb RAM and the total size of all databases is around 1.2 Gb. It is currently serving more than 300 queries/s and 'vmstat 1' output is: procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy id 0 0 0 0 83044 22216 1189764 0 0 0 0 1 0 1 1 1 0 0 0 0 83044 22216 1189764 0 0 0 312 633 613 1 3 96 0 0 0 0 83044 22216 1189768 0 0 0 0 927 928 6 6 88 1 0 0 0 83044 22216 1189768 0 0 0 0 853 910 7 4 89 0 0 0 0 83044 22216 1189768 0 0 0 0 625 672 0 1 99 0 0 0 0 83044 22216 1189768 0 0 0 0 1067 1106 13 5 83 0 0 0 0 82788 22216 1189768 0 0 0 92 952 935 11 3 85 0 0 0 0 82788 22216 1189768 0 0 0 0 861 878 4 6 90 0 1 0 0 82788 22216 1189832 0 0 0 136 2811 4834 8 9 83 0 0 0 0 82788 22216 1189832 0 0 0 0 822 833 5 4 91 0 0 0 0 82788 22216 1189832 0 0 0 0 822 877 2 2 96 0 0 0 0 82788 22216 1189832 0 0 0 324 1036 1055 4 4 92 0 0 0 0 82788 22216 1189836 0 0 0 0 1059 1124 7 3 90 0 0 0 0 82788 22216 1189836 0 0 0 0 1115 1137 7 4 89 2 0 0 0 82548 22216 1189836 0 0 0 0 975 1099 28 13 59 1 0 0 0 83100 22216 1189840 0 0 0 0 1359 1768 25 12 63 As you can see, no disk reads (bi) and a few disk writes (bo) Hope this helps, Joseph Bueno Steve Quezadas wrote: > I have a mySQL database that is about 240 megabytes. I am loading it on > a Linux server with 2 gigs of RAM. I would like to have the whole table > reside in memory to save time from disk access. Is there any way to load > the tables into RAM on startup? I am thinking about creating a heap > table, but I need the heap table to be lodaed when mysql gets loaded. Is > there anyway to do this? Or perhaps it is best to put the table in a RAM > disk or something? > > Anyone know a generally recommended solution? > > -Steve > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
