Re: Reg...My Hung MYSQL instance

2011-08-23 Thread Johan De Meersman
- Original Message - > From: "Suresh Kuna" > > Can you paste your error log and configuration file with the total > memory you have on the server. Hey, someone posting something actually useful. You must be new here :-D Ahmed, do you have more connections than you used to? Some of the m

Re: mysql

2011-08-23 Thread madu...@gmail.com
Thanks Suresh, Problem solved it was the bind address. On Tue, Aug 23, 2011 at 12:47 PM, Suresh Kuna wrote: > Hello, > > Can you comment this line "bind-address            = 10.5.1.100" in the > configuration file and start the mysqld sever. > > On Tue, Aug 23, 2011 at 3:10 PM, madu...@gmail.com

Re: mysql

2011-08-23 Thread Suresh Kuna
Hello, Can you comment this line "bind-address= 10.5.1.100" in the configuration file and start the mysqld sever. On Tue, Aug 23, 2011 at 3:10 PM, madu...@gmail.com wrote: > [client] > port= 3306 > socket = /var/run/mysqld/mysqld.sock > #socket = /tmp/mys

Re: mysql

2011-08-23 Thread madu...@gmail.com
[client] port= 3306 socket = /var/run/mysqld/mysqld.sock #socket = /tmp/mysqld.sock user= "root" pass= "%password%" # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known a

Re: mysql

2011-08-23 Thread Adarsh Sharma
Follow the steps :- 1. Check mysqld is running or not > /etc/init.d/mysql status 2. If not > /etc/init.d/mysql start If error occurs , check the logs & usually this error means ur server is not running at the moment. Good Luck ! Claudio Nanni wrote: You have 2 options: use tcp/ip or find

Re: Reg...My Hung MYSQL instance

2011-08-23 Thread Suresh Kuna
Hello Shafi, Can you paste your error log and configuration file with the total memory you have on the server. On Tue, Aug 23, 2011 at 2:04 PM, Andrew Moore wrote: > It will only do what you let it. If your server ui consuming too much > memory > it because you've let it. > On Aug 23, 2011 9:22

Re: Reg...My Hung MYSQL instance

2011-08-23 Thread Dhaval Jaiswal
Kill the Mysql process as of now & set the proper buffer parameters as per the usage. start the mysql instance. On Tue, Aug 23, 2011 at 2:04 PM, Andrew Moore wrote: > It will only do what you let it. If your server ui consuming too much > memory > it because you've let it. > On Aug 23, 2011 9:

Re: mysql

2011-08-23 Thread Claudio Nanni
You have 2 options: use tcp/ip or find the right .sock file use this: mysql -uUSER -p -h127.0.0.1 -P3306 or check in the my.cnf where the server creates the .sock file you have to use the same with the local client. Ciao Mad! Claudio 2011/8/23 Andrew Moore > That's too bad. How did you con

Re: Reg...My Hung MYSQL instance

2011-08-23 Thread Andrew Moore
It will only do what you let it. If your server ui consuming too much memory it because you've let it. On Aug 23, 2011 9:22 AM, "Shafi AHMED" wrote: > Dear, Today suddenly my database went into hung state due to Out of Memory > [ Killed process 1330 (mysqld) ]. > > Please advise me folks.This happ

Re: mysql

2011-08-23 Thread Andrew Moore
That's too bad. How did you configure things? What trouble shooting have you done so far? On Aug 23, 2011 9:18 AM, "madu...@gmail.com" wrote: > When I try to start my mysql DB I keep getting the following message: > "Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock

Reg...My Hung MYSQL instance

2011-08-23 Thread Shafi AHMED
Dear, Today suddenly my database went into hung state due to Out of Memory [ Killed process 1330 (mysqld) ]. Please advise me folks.This happens now often Shafi Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on

mysql

2011-08-23 Thread madu...@gmail.com
When I try to start my mysql DB I keep getting the following message: "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'" Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch