有没有办法在PHP中保持与mysql数据库的连接？

Question

Im trying to optimize some of my PHP code. I found out that most time of my PHP script is spent during the connection to my mysql database at the beginning of the script.

I only connect to the database once at the beginning and close the database connection at the end of the script.

But for each user requesting this page a new connection has to be established.

Is there a way to hold a reference to the database and share it for all requests?

Answer 1

You can make your connection persistent (for PDO use PDO::ATTR_PERSISTENT => true), but my recomandation is to find out why your script is spending a lot of time connecting to mysql and make some improvments there.

Consider this:

• Use MySQL server IP instead of hostname, to eliminate time needed to resolve dns.
• Disable mysql autocompletition: (comment skip-auto-rehash from my.cnf)
• If you make a lot of queries which will return the same thing over and over again, consider using a caching system to cache for query results.
• Post your code on codereview.stackexchange.com to benefit from others expertise on further improving your code.
• To further debug the problem, connect from console to MySQL server and check the time needed to open connection, change database, select, etc.