2006/4/7, Charles Q. Shen <[EMAIL PROTECTED]>: > The OS used are Mandriva and Fedora. > > Can you explain more? >
I'll make it quick, there is plenty of doc on a web that will explain this better than I can. Once you read few things from your hard drive (let's say the index file for your table), it's kept in memory. Next time you access it it's directly retrived from memory, not the hard drive, thus low response time. shutting down MySQL won't clear that cache. If you want to circumvent that, you need to umount the partition where data and index are stored. HIMH http://www.tldp.org/LDP/tlk/fs/filesystem.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]