On 21 Aug 2001 10:48:03 +0200, Erlend Stromsvik wrote:
> 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 could I force mysql to load the indexes into memory when you start the
> computer?
Ok, you can do it in many different ways. As most things are cached by
OS you can do just "cat /datadir/table.* > /dev/null" or execute some
query accessing all needed data:
mysql -e "SELECT something...." > /dev/null
But it still seems that you can optimize your queries and MySQL server,
not to do such weird things.
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
/_/ /_/\_, /___/\___\_\___/ Hong Kong, China
<___/ www.mysql.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