Hi, I wonder which is the best filesystem to use with MySQL (to increase performances). And which mounting option should be used ? According to the documentation, the best system is SuSE Linux 7.1, 2.4 kernel, and ReiserFS. I currently use ReiserFs with noatime option. But it seems (according to benchmarks) that this filesystem is slower for big files and reading opération ?
I believe that MySQL needs fast creating/deleting files operation during temporary table creation by example but also needs fast reading when extracting lots of rows from a big table. What's your opinion ? Is Reiser the best or may it be ext3, xfs or another FS? Thanks, Sébastien sql, query --------------------------------------------------------------------- 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
