<mysql, Monday, November 11, 2002, 2:19:40 PM, you wrote: masdmdh> Greetings to everyone. I have trouble getting mysql shell to use masdmdh> mysql.sock file which is not located in /tmp. I fixed all entries in masdmdh> /etc/my.cnf but mysql shell still complains about /tmp/mysql.sock missing. masdmdh> The only workaround I have found is --socket. masdmdh> Is there a way to make the masdmdh> shell use the right socket file path by default, that is without masdmdh> explicitly specifying it with --socket?
What do you mean 'all entries'? You must spesify it for the server and for the client. masdmdh> Second, I am writting a small unix masdmdh> deamon to process email. It uses MySQL. The strategy I used with threads masdmdh> is that each thread on startup opens a connection to its database and use masdmdh> it throughout its lifetime. The problem is that it seems that the masdmdh> connection times out, since I get a few "MySQL server has gone away" masdmdh> messages here and there. What is the best fix to this? I cant decide masdmdh> between opening a connection each time i need to execute a query and masdmdh> trying to increase timeout settings. If yoyu think I should increase the masdmdh> timeouts I could use a few pointers on which options to change in my.cnf. If your daemon is making queries to the server rarely, may be opening/closing connection will be better for you. If you want to increase timeout, you should increase value of the wait_timeout variable. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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