Hello Dan On 2006-11-06 Dan Jacobson wrote: > Package: mysql-client-5.0 > Version: 5.0.24a-5 > Severity: wishlist > File: /usr/bin/mysql > Tags: upstream > > There could be a switch, > $ mysql --readonly > that turns on all kinds of optimizations if we know we won't be > needing to change any database.
Optimisations are done on a per-query base so there's hardly anything to improve compared to a session where you simply only use SELECTs. For security, MySQL has a pretty fine grained security model and you can easily create a user that may only read :-) As a safeguard if you have to connect as "root" there already is "mysql --i-am-a-dummy". So no need for a "--readonly", I'm closing the bug (you might want to submit this to http://bugs.mysql.com/ but I really don't see much hope for it) bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
