Hi
Is it possible to have mysql load indexes into memory after a restart or
reboot?
The computer has 768mb memory, and after a reboot/restart I have like 700mb
of free memory.
Then when someone clicks a link on a page which runs a 'huge' query agains
the server you get a pretty long loading time. The next time someone clicks
the same link it's a fraction of a second of loading. And I see that I have
a few mb's less of free memory. Same thing happens for every link that
activates queries agains the database.
So mysql is obviously loading either the entire index(?) or that specific
query into memory, and as long as nothing else need lots of memory it will
also stay in memory for future use.
I still haven't run out of memory... I have made a swap drive of 768mb too,
but I have never seen the computer use more than 32k of the swap space.
So could I force mysql to load the indexes into memory when you start the
computer?
---------------------------------------------------------------------
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
