#2 Extending AuthMySQLKeepAlive funcionality
I haven't done much with mod_auth_mysql yet, but I already see
a possible improvement in the AuthMySQLKeepAlive option.
If I host multiple virtual clients, each one will have their own
database (with MySQL username and password) for storing login
information. Therefore, the server can't make use of
AuthMySQLKeepAlive (host stays the same, but User and Password
change).
Would it be possible to keep the connection open, and remember
the Host, User and Password used to establish the connection.
Then, when another request comes in, if the Host, User and
Password are the same, you can re-use the connection. If they
are different, then you close the connection and open a new one.
If a web browser is loading a page with a few dozen IMG files in a
protected directory, you're going to be opening a lot of connections
to MySQL. There could be a considerable performance
improvement by caching the open connection.
Logged In: YES
user_id=1049703
Yes, I think this would be possible. I'll investigate it
for the next release.
Another option which would be harder to implement but also
possible would be to keep a table of
database/username/password requests. However, the number of
connections could grow quite large with multiple virtual
users. I would want to put a maximum number of connections
option in there, also.
It's somthing I'll look into.