hi,all
can i get how long the client(s) in sleep staus after the client
connected to mysql server
how can i do it ?
thanks very much
tiredboy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--001485e984d5fdc0e10472c010a0
Content-Type: text/plain; charset=ISO-8859-1
mysqladmin processlist -v
or
mysql> show processlist;
Cheers
Claudio
2009/9/4 stutiredboy
> hi,all
>
> can i get how long the client(s) in sleep staus after the client
> connected to mysql server
>
> how can i do it ?
>
> thanks very much
>
> tiredboy
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>
>
--
Claudio
--001485e984d5fdc0e10472c010a0--
I upgraded to MAC OS 10.6 Snow Leopard over the weekend and now I find that
upgrade appears to have broken MySQL (5.1.31 MySQL Community Server (GPL)).
When I attempt to start MySQL I get:
ERROR 2002: (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock (2)
Has anyone else had this issue and do you know of a fix or work around?
Hagen Finley
Boulder, CO
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
I don't appear to have a /etc/my.cnf file - could the upgrade have removed
it?
Here is the error string I get when I try and start MySQL:
finhagens-macbook-pro:bin finhagen$ ./mysqld &
[1] 4697
finhagens-macbook-pro:bin finhagen$
090904 10:25:18 [ERROR] Can't find messagefile
'/usr/local/mysql/share/english/errmsg.sys'
090904 10:25:18 [Warning] Can't create test file
/usr/local/mysql/data/finhagens-macbook-pro.lower-test
090904 10:25:18 [Warning] Can't create test file
/usr/local/mysql/data/finhagens-macbook-pro.lower-test
../mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2)
090904 10:25:18 [ERROR] Aborting
I have noted that a new path was created for mysql during the upgrade:
/usr/local/mysql-5.1.31-osx10.5-86/ ...bin ...share ...data etc.
Obviously that new path is resulting in the errors above.
-What's the best way to inform MySQL the direct structure changed?
-Is there a 5.4 version for MAC OS 10.6?
-Would it make sense to reinstall with that version? (my data base
is tiny and its relatively easy to export and import it and I am the only
user)
Hagen
-----Original Message-----
Sent: Friday, September 04, 2009 11:03 AM
To: Hagen
Subject: RE: MAC OS 10.6 Snow Leopard Breaks MySQL
What is the connect string in the /etc/my.cnf file?
-----Original Message-----
From: Hagen [mailto:finhagen@comcast.net]
Sent: Friday, September 04, 2009 9:45 AM
To: mysql@lists.mysql.com
Subject: MAC OS 10.6 Snow Leopard Breaks MySQL
I upgraded to MAC OS 10.6 Snow Leopard over the weekend and now I find
that
upgrade appears to have broken MySQL (5.1.31 MySQL Community Server
(GPL)).
When I attempt to start MySQL I get:
ERROR 2002: (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock (2)
Has anyone else had this issue and do you know of a fix or work around?
Hagen Finley
Boulder, CO
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=jgordon@westernwats.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
I tried creating a soft link to the /usr/local/bin/mysql but that didn't
address the issues I was having. However, following a little more research I
found a discussion of this problem at:
http://stackoverflow.com/questions/1334272/cant-start-mysql- in-mac-os-10-6-s
now-leopard
which said:
"YOU MUST REINSTALL mySQL after upgrading to Snow Leopard and remove any
previous versions as well as previous startup from the preference panel.
install 86_64 10.5...I find the others did not work for me."
Bummer.
However, there was also a discussion suggesting the use of MacPorts:
"Have you considered installing MacPorts 1.8.0 (release candidate), and
keeping MySQL up-to-date that way? That will build MySQL for the
architecture and OS that you're using, rather than installing a 10.5 version
on 10.6."
I installed MacPorts http://www.macports.org/ (had to reboot) and ran the
following commands:
sudo port -v self update
sudo port list
sudo port install mysql5
The MacPort script reinstalled mysql 5 on my Mac and mysql came up properly
apparently with everything where it belonged. Pretty slick and almost
effortless.
Hagen
-----Original Message-----
From: Hagen [mailto:finhagen@comcast.net]
Sent: Friday, September 04, 2009 12:24 PM
To: mysql@lists.mysql.com
Subject: RE: MAC OS 10.6 Snow Leopard Breaks MySQL
I don't appear to have a /etc/my.cnf file - could the upgrade have removed
it?
Here is the error string I get when I try and start MySQL:
finhagens-macbook-pro:bin finhagen$ ./mysqld &
[1] 4697
finhagens-macbook-pro:bin finhagen$
090904 10:25:18 [ERROR] Can't find messagefile
'/usr/local/mysql/share/english/errmsg.sys'
090904 10:25:18 [Warning] Can't create test file
/usr/local/mysql/data/finhagens-macbook-pro.lower-test
090904 10:25:18 [Warning] Can't create test file
/usr/local/mysql/data/finhagens-macbook-pro.lower-test
../mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2)
090904 10:25:18 [ERROR] Aborting
I have noted that a new path was created for mysql during the upgrade:
/usr/local/mysql-5.1.31-osx10.5-86/ ...bin ...share ...data etc.
Obviously that new path is resulting in the errors above.
-What's the best way to inform MySQL the direct structure changed?
-Is there a 5.4 version for MAC OS 10.6?
-Would it make sense to reinstall with that version? (my data base
is tiny and its relatively easy to export and import it and I am the only
user)
Hagen
-----Original Message-----
Sent: Friday, September 04, 2009 11:03 AM
To: Hagen
Subject: RE: MAC OS 10.6 Snow Leopard Breaks MySQL
What is the connect string in the /etc/my.cnf file?
-----Original Message-----
From: Hagen [mailto:finhagen@comcast.net]
Sent: Friday, September 04, 2009 9:45 AM
To: mysql@lists.mysql.com
Subject: MAC OS 10.6 Snow Leopard Breaks MySQL
I upgraded to MAC OS 10.6 Snow Leopard over the weekend and now I find
that
upgrade appears to have broken MySQL (5.1.31 MySQL Community Server
(GPL)).
When I attempt to start MySQL I get:
ERROR 2002: (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock (2)
Has anyone else had this issue and do you know of a fix or work around?
Hagen Finley
Boulder, CO
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=jgordon@westernwats.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=finhagen@comcast.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org