URGENT: CI not releasing mysql processes and as such httpd is keeping the connections open - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: URGENT: CI not releasing mysql processes and as such httpd is keeping the connections open (/showthread.php?tid=18463) |
URGENT: CI not releasing mysql processes and as such httpd is keeping the connections open - El Forum - 05-07-2009 [eluser]tolyx[/eluser] Just gone live with a high traffic site which has ground to a halt because CI seems to be keeping connections open, despite pconnect being set to FALSE. What needs to happen to solve this? URGENT: CI not releasing mysql processes and as such httpd is keeping the connections open - El Forum - 05-07-2009 [eluser]xwero[/eluser] That seems odd to me as in the database/DB_driver.php file there is this line Code: $this->conn_id = ($this->pconnect == FALSE) ? $this->db_connect() : $this->db_pconnect(); Code: function db_connect() Try connecting to the database with php native functions and look if the connection is persistent too, or not. URGENT: CI not releasing mysql processes and as such httpd is keeping the connections open - El Forum - 05-07-2009 [eluser]tolyx[/eluser] Thanks - that is what I thought. Sadly I don't have access to the server it is on but I am being told codeigniter is responsible for creating tonnes of connections and/or locking queries. What would cause queries to be locked (sorry I don't understand a lot about this!). |