ES> Hi
ES> Is it possible to have mysql load indexes into memory after a restart or
ES> reboot?
ES> The computer has 768mb memory, and after a reboot/restart I have like 700mb
ES> of free memory.
ES> Then when someone clicks a link on a page which runs a 'huge' query agains
ES> the server you get a pretty long loading time. The next time someone clicks
ES> the same link it's a fraction of a second of loading. And I see that I have
ES> a few mb's less of free memory. Same thing happens for every link that
ES> activates queries agains the database.
ES> So mysql is obviously loading either the entire index(?) or that specific
ES> query into memory, and as long as nothing else need lots of memory it will
ES> also stay in memory for future use.
ES> I still haven't run out of memory... I have made a swap drive of 768mb too,
ES> but I have never seen the computer use more than 32k of the swap space.
ES> So could I force mysql to load the indexes into memory when you start the
ES> computer?
Run your queries manually on startup?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/) |
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software Company (http://www.agava.com/) |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
---------------------------------------------------------------------
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