Mysql too many connection critical error

janke

With datatables 1.6.1 sometimes i have this error Mysql too many connection critical error
I try to add mysql_close(); at the end of the server side script but this error continue.
I need to restart the server.

allan

Sounds like your server is configured to not allow the required number of sessions. Perhaps looking up the MySQL documentation to increase the allowed number of sessions will help. Also you can implement the following which would help reduce the number of requests:

http://datatables.net/plug-ins/api#fnSetFilteringDelay
http://datatables.net/examples/server_side/pipeline.html

Allan

janke

In the server side i replace mysql_pconnect by mysql_connect and the error disappears
I try pipeline it works fine and reduce time rendering.
When i want to try fnSetFilteringDelay i have
line .. jQuery.fn.dataTableExt.oApi is null or not an object on ie on firefox jQuery.fn.dataTableExt is undefined