Results 1 to 3 of 3
Enjoy an ad free experience by logging in. Not a member yet? Register.
- Join Date
- Dec 2002
- New Delhi
MySQL Services Restart and Connection pointer
Thanks for your help uptil now.
I've one serious problem, i don't know why but my MySQL server stops and then starts automatically. Can anybody help me by telling why this happens???
How can I counter this problem in my program which interacts with MySQL. Does the connection pointer gets destroys (i.e. it equates with NULL). How can I check whether there is connection available at the stage when I'm doing
One more thing friends,
how many connections can MySQL handle simultaniousy
- Join Date
- Oct 2001
- Täby, Sweden
How do you mean the MySQL server stops and starts? Does the process actually die, or does it just temporarily hang?
What do you mean when you're asking if the connection pointer gets destroyed? It seems by the wording of your question that you seem to think that the pointer itself gets set to NULL, which cannot happen, since the mysql routines don't know where it's stored. Maybe I misunderstood you.
About checking for writability: I haven't done any actual C programming with MySQL, but there has to be a way to find out which file descriptor the connection structure uses. Then, when you have the file descriptor, poll it for reading and/or writing, whichever you want. See poll(2).
I don't think MySQL has a hard coded maximum on connnections. It probably accepts new connections until it runs out of memory.
Re: MySQL Services Restart and Connection pointerOriginally Posted by Kumar Saurabh
Originally Posted by Kumar Saurabh
In this case, variable would be max_connections. The default value is 100.
Hope this helps.