Greetings to everyone. I have trouble getting mysql shell to use
mysql.sock file which is not located in /tmp. I fixed all entries in
/etc/my.cnf but mysql shell still complains about /tmp/mysql.sock missing.
The only workaround I have found is --socket. Is there a way to make the
shell use the right socket file path by default, that is without
explicitly specifying it with --socket? Second, I am writting a small unix
deamon to process email. It uses MySQL. The strategy I used with threads
is that each thread on startup opens a connection to its database and use
it throughout its lifetime. The problem is that it seems that the
connection times out, since I get a few "MySQL server has gone away"
messages here and there. What is the best fix to this? I cant decide
between opening a connection each time i need to execute a query and
trying to increase timeout settings. If yoyu think I should increase the
timeouts I could use a few pointers on which options to change in my.cnf.
Thanks to everyone, you have been very helpfull so far, I hope I'm going
to start helping out others soon.
Vlatko
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
