Is closing the mysql connection important?

by

From the documentation:

Note: The link to the server will be closed as soon as the execution of the script ends, unless it’s closed earlier by explicitly calling mysql_close().

If your script has a fair amount of processing to perform after fetching the result and has retrieved the full result set, you definitely should close the connection. If you don’t, there’s a chance the MySQL server will reach it’s connection limit when the web server is under heavy usage. If you can’t close the MySQL connection until near the end of the script, it’s cleaner though unnecessary to do so explicitly.

I’m not certain how fastcgi affects things. One page claims that a build of PHP that supports fastcgi will create persistent connections, even for mysql_connect. This contradicts the documentation in that the connection is closed when the process, rather than the script, ends. Rather than testing it, I’m going to recommend using mysql_close(). Actually, I recommend using PDO, if it’s available.

More Related Contents:

  1. PHP DateTime supported formats
  2. Can I call a PHP function in a JavaScript click handler?
  3. How to create a chat program using php and mysqli for chatting [closed]
  4. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  5. Can I store images in MySQL [duplicate]
  6. Get table column names in MySQL?
  7. PHP code to convert a MySQL query to CSV [closed]
  8. MySQL and PHP: UTF-8 with Cyrillic characters [duplicate]
  9. Use bound parameter multiple times
  10. Are mysql_real_escape_string() and mysql_escape_string() sufficient for app security?
  11. how safe are PDO prepared statements
  12. How to join three table by laravel eloquent model
  13. Secure files for download
  14. Hiding true database object ID in url’s
  15. Mysql No connection could be made because the target machine actively refused it
  16. Replacing mysql_* functions with PDO and prepared statements
  17. How to connect to MySQL database in PHP using mysqli extension?
  18. Laravel 5.4 field doesn’t have a default value
  19. org.json.JSONException: Value
  20. PHP Check for NULL
  21. How to store .pdf files into MySQL as BLOBs using PHP?
  22. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  23. PDO MySQL: Insert multiple rows in one query
  24. Outputting all PHP errors to database not error_log
  25. Laravel nested relationships
  26. getting the value of an extra pivot table column laravel
  27. php sample script for pagination [closed]
  28. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  29. How to check if a value already exists to avoid duplicates?
  30. How to use MySQL Found_Rows() in PHP?

Leave a Comment