Re: Please I need inputs on Lost connection to MySQL server during query
On Thursday 01 September 2005 20:41, Pooly wrote: Hi, what is the error in your error log ? im using MySQL-client-4.1.12-1 binary from mysql website i got this.. 050901 14:50:44 [Warning] Asked for 196608 thread stack, but got 126976 -- im trying to fix this by adding set-variable thread_stack=192K but everytime I restart the server i still get the warning.. 050901 14:50:45 InnoDB: Started; log sequence number 0 43951 050901 14:50:45 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run if ill be doing what the log file says execute mysql_fix_privilege_tables .. would there be any draw backs or problems that ill be encountering.. Does your server crash for every query it makes ? Or only some ? the server doesnt crash i check the uptime for the DB and its up fror 12 days.. Are you using the official binary from MySQL or the one used for you distro vendor ? no i downloaded the binary from mysql website.. Are you using UDF ? no ... We need more inputs ;-) 2005/9/1, JM [EMAIL PROTECTED]: Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console shows-up after giving the password. Client and Server are connected through a LAN. Based on ping an average of .1 ms reply.. tia, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please I need inputs on Lost connection to MySQL server during query
On Thursday 01 September 2005 22:14, [EMAIL PROTECTED] wrote: JM [EMAIL PROTECTED] wrote on 09/01/2005 06:01:57 AM: Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away. html hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console shows-up after giving the password. Client and Server are connected through a LAN. Based on ping an average of .1 ms reply.. tia, OK, we have the error message (good). We know what you have looked at to solve the error (also good). What we don't have is what you did to create the error in the first place. the error is somehow unpredictable.. sometimes when i access the first page.. its works.. trying refreshing it.. after sometime its works. trying to do it every once so often then i encounter the problem... Please describe what you are doing to create the error, the data you are doing it with, and the tools involved in both ends of the process. Then we can understand your problem. Thanks! Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please I need inputs on Lost connection to MySQL server during query
Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console shows-up after giving the password. Client and Server are connected through a LAN. Based on ping an average of .1 ms reply.. tia, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please I need inputs on Lost connection to MySQL server during query
Hi, what is the error in your error log ? Does your server crash for every query it makes ? Or only some ? Are you using the official binary from MySQL or the one used for you distro vendor ? Are you using UDF ? ... We need more inputs ;-) 2005/9/1, JM [EMAIL PROTECTED]: Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console shows-up after giving the password. Client and Server are connected through a LAN. Based on ping an average of .1 ms reply.. tia, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please I need inputs on Lost connection to MySQL server during query
JM [EMAIL PROTECTED] wrote on 09/01/2005 06:01:57 AM: Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away. html hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console shows-up after giving the password. Client and Server are connected through a LAN. Based on ping an average of .1 ms reply.. tia, OK, we have the error message (good). We know what you have looked at to solve the error (also good). What we don't have is what you did to create the error in the first place. Please describe what you are doing to create the error, the data you are doing it with, and the tools involved in both ends of the process. Then we can understand your problem. Thanks! Shawn Green Database Administrator Unimin Corporation - Spruce Pine