I have been using this for a while. Now all of a sudden the database is not avaliable. the host said it was not closing connections to the server. I need help asap as we are using it live for 2 customers that need to do payroll for this week. If you can help please contact me directly at webmaster@northwoods.net I can give you more details.
Here is what my server host says:
Your database was causing too many connection on server for mysql. It seems your database is not closing its connection after firing queries.
Please look into the coding so that it should close connection just after firing queries.
Yes, case is same with both domains.
We are unable to find exact queries as processes are kept in sleep mode after firing queries.
So, you will need to contact your developer who has coded both sites.
Variables in php.ini are already set.
Still if you do not close any query in mysql, it does not going to be affected by php as it is fully function of mysql so you need to write code to close mysql queries as soon as they are done.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have been using this for a while. Now all of a sudden the database is not avaliable. the host said it was not closing connections to the server. I need help asap as we are using it live for 2 customers that need to do payroll for this week. If you can help please contact me directly at webmaster@northwoods.net I can give you more details.
Here is what my server host says:
Your database was causing too many connection on server for mysql. It seems your database is not closing its connection after firing queries.
Please look into the coding so that it should close connection just after firing queries.
Yes, case is same with both domains.
We are unable to find exact queries as processes are kept in sleep mode after firing queries.
So, you will need to contact your developer who has coded both sites.
Variables in php.ini are already set.
Still if you do not close any query in mysql, it does not going to be affected by php as it is fully function of mysql so you need to write code to close mysql queries as soon as they are done.