>>>>> "Alexander" == Alexander Keremidarski <salle@stripped>
Alexander> Running mysqld for every user is not an option at all. For 3-5 users
Alexander> maybe it is possible, maybe you can run up to 8 mysqld, but regular
Alexander> hosting server can have hundreds of users.
It will not take notable more resources to run 100 different mysqld
servers than 100*X threads, where each users uses X connections.
Alexander> With 'Complex Setups' - many DB, different DBA for every DB, several
Alexander> Users per DB, Complex Privileges it would be better if Privileges can be
Alexander> somehow moved to DB.
This is a problem, because:
- The user may access many DB's in the same query
- He may not be connect to a DB when he executes a command
(for example executing 'show variables').
- Many of the current MySQL clients doesn't supply the database name
when connecting to MySQL; (We don't want to break old clients
without a very good reason).
Alexander> With many considerations like "If user has File_Priv - it is 'chrooted'
Alexander> at some_dir like PHP open_basedir option
This could be done by adding a new option to the user table, which
would be the base root for the users 'LOAD DATA INFILE' files.
Alexander> And this can be done easily (I hope) if there is VIEWS support in MySQL.
Alexander> Sounds like total revising of current MySQL behaviour isn't it?
Alexander> Monty, remember in other thread:
Alexander> To say it different mysql.* is Admin space not User space
Monty> In practice there isn't really a big difference.
Alexander> Don't you think cases like this become more and more common?
Alexander> MySQL used as Webserver back-end on Hosting server.
Because MySQL allow queries across databases, things are not that easy.
What we could also do would be to add some shared memory segment for
global big caches used by MySQL.
This would make the overhead much smaller between running one MySQL
server with many users and one MySQL server per user....
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <monty@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland