mysql_connect VS mysql_pconnect [closed]

by

Persistent connections should be unnecessary for MySQL. In other databases (such as Oracle), making a connection is expensive and time-consuming, so if you can re-use a connection it’s a big win. But those brands of database offer connection pooling, which solves the problem in a better way.

Making a connection to a MySQL database is quick compared to those other brands, so using persistent connections gives proportionally less benefit for MySQL than it would for another brand of database.

Persistent connections have a downside too. The database server allocates resources to each connection, whether the connections are needed or not. So you see a lot of wasted resources for no purpose if the connections are idle. I don’t know if you’ll reach 10,000 idle connections, but even a couple of hundred is costly.

Connections have state, and it would be inappropriate for a PHP request to “inherit” information from a session previously used by another PHP request. For example, temporary tables and user variables are normally cleaned up as a connection closes, but not if you use persistent connections. Likewise session-based settings like character set and collation. Also, LAST_INSERT_ID() would report the id last generated during the session — even if that was during a prior PHP request.

For MySQL at least, the downside of persistent connections probably outweighs their benefits. And there are other, better techniques to achieve high scalability.

Update March 2014:

MySQL connection speed was always low compared to other brands of RDBMS, but it’s getting even better.

See http://mysqlserverteam.com/improving-connectdisconnect-performance/

In MySQL 5.6 we started working on optimizing the code handling connects and disconnects. And this work has accelerated in MySQL 5.7. In this blog post I will first show the results we have achieved and then describe what we have done to get them.

Read the blog for more details and speed comparisons.

More Related Contents:

  1. Undefined function mysql_connect()
  2. Connecting to remote MySQL server using PHP
  3. how to write php code for the key press enter button when fill the form?
  4. Create hyperlink from html table row to open record on a new page
  5. mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
  6. I don’t know what’s wrong with my code. I’m a newbie. The prob is – Notice: Undefined variable: result [duplicate]
  7. How to run deprecated php codes on the latest XAMPP [duplicate]
  8. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  9. Is closing the mysql connection important?
  10. selecting unique values from a column
  11. Shortcomings of mysql_real_escape_string?
  12. Alternative to mysql_real_escape_string without connecting to DB
  13. HTML – Change\Update page contents without refreshing\reloading the page
  14. Create a dynamic mysql query using php variables
  15. How to enable mysqlnd for php?
  16. Mysql event error using php
  17. How to separate DATE and TIME from DATETIME in MySQL?
  18. How do I count unique visitors to my site?
  19. php code to test pdo is available?
  20. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  21. PHP / MySQL build tree menu
  22. Long integer is transformed when inserted in shorter column, not truncated. Why? What is the formula?
  23. How to create Codeigniter language files from database?
  24. Laravel $q->where() between dates
  25. MySQL statement takes more than minute to execute
  26. Binding parameters for WHERE IN clause with PDO [duplicate]
  27. WordPress prepared statement with IN() condition
  28. PHP: Inserting Values from the Form into MySQL
  29. Select MYSQL rows but rows into columns and column into rows
  30. How to run multiple insert query in SQL using PHP in one go?

Leave a Comment