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
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.