Hello, I'm currently building a free mySQL database service. I have managed to solve the quota problem with this list. Thanks to all!
Now I have another problem: If a large number of databases have been created (>1000) it takes some time to change a database. I do know that I can ommit the problem with -A at mysql> . Because I will open the service for all I think not everyone knows all options to tune performance. I hope to reduce the time a database change takes by using suffix for the database dirs like $datadir/a/al/alex for the database alex Can I get this transparent to users so if a user do "CREATE DATABASE alex" it will work? Thanks, Alexander Newald btw: - I can't use reiserfs - I use linux kernel 2.4.17 - I use IDE disks - I have a PIII 500 with 256 ram with more 50% free - I use mySQL 3.23.43 --------------------------------------------------------------------- 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
