SHOW PROCESSLIST State "Locked" - what does this mean?

Hi, Currently, I have a situation where an app makes connections (via JDBC) to a mysql server, 50 connections at once, and everything just becomes super-slow. For instance, a SELECT that should take 0.01 sec takes several minutes. SHOW PROCESSLIST says that these threads that are connections

RE: What Does This Mean

OK I got the database created and stuff; When in the MySQLAdmin screen under databases it doesn't show under databases. That is the first problem. And for some reason the MYSQLadmin screen list the local user name as Administrator and will not let me change it. But I can get into the mysql shell

RE: What Does This Mean

Chris L. White said: > You know what is even more screwed up now. I did this command and when > it prompted me for the password I just hit enter and wallah look what I > got. But I am sure there is other stuff messed up now: > SET YOUR ROOT PASSWORD it its blank it will behave as you describe. So

RE: What Does This Mean

You know what is even more screwed up now. I did this command and when it prompted me for the password I just hit enter and wallah look what I got. But I am sure there is other stuff messed up now: C:\MySQL\bin>mysql -u root -p Enter password: ** ERROR 1045 (28000): Access denied fo

Re: What does this Mean

Chris L. White said: > C:\MySQL\bin>mysql show > > ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using > password: > > YES) > > > > C:\MySQL\bin>mysql show -u root > > ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using > password: > > YES) Your musql setup requi

Re: What does this Mean

C:\MySQL\bin>mysql show ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using password: YES) C:\MySQL\bin>mysql show -u root ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) C:\MySQL\bin>mysql show -u root -p Enter password: *

Re: What Does This Mean

Did you set a password for the root account? MySQL comes with a root user that (initially) has no password and all privileges. Most setup instructions have you assign a password to the root account pretty early on. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

What Does This Mean

It says I am not allowed to connect to the mySQL server. I am trying root and admin and it won't let me in. Have I done something wrong and what do I check? Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED]

What does this mean? : Warning: thr_alarm queue is full

Hi! > "Chung" == Chung Ha-nyung <[EMAIL PROTECTED]> writes: Chung> query. Chung> I happened to find out that the lots of following error messages are Chung> stored Chung> error log file: Chung> Warning: thr_alarm queue is full Chung> What's this? Is it serious problem? The above is a v

Re: What does this mean? : Warning: thr_alarm queue is full

PROTECTED]> Sent: Friday, December 27, 2002 3:49 AM Subject: What does this mean? : Warning: thr_alarm queue is full > query. > > I happened to find out that the lots of following error messages are > stored > error log file: > Warning: thr_alarm queue is full > > W

What does this mean? : Warning: thr_alarm queue is full

query. I happened to find out that the lots of following error messages are stored error log file: Warning: thr_alarm queue is full What's this? Is it serious problem? -- Chung Ha-nyung Sayclub NeoWiz --

Re: what does this mean please?

> ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > > and how you fix it? It means you have no local socket for mysql to connect through. Meaning, something/someone either deleted or mangled /tmp/mysql.sock or mysqld isn't running to begin with. Try to co

what does this mean please?

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and how you fix it? thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: What does this mean

On Fri, 16 Mar 2001 13:35:18 -0500, Hardy Merrill ([EMAIL PROTECTED]) wrote: >Sure it's easier, but which is safer? > >I don't have Charles first message on this topic, but I believe >his error message was from logrotate which is a cron job. >If Charles put > > mysqladmin -uuser -ppassword > >

Re: What does this mean

Sure it's easier, but which is safer? I don't have Charles first message on this topic, but I believe his error message was from logrotate which is a cron job. If Charles put mysqladmin -uuser -ppassword into a cron job, then the user's(root?) password would be in open view to anybody who

Re: What does this mean

I think it would be easier to just go: mysqladmin -uuser -ppassword On Fri, 16 Mar 2001 11:09:37 -0500, Hardy Merrill ([EMAIL PROTECTED]) wrote: >Charles, > >I think I know what's happening - your MySQL "root" user has >a password, and "mysqladmin" wants a password before it will >execute for "r

Re: What does this mean

Charles, I think I know what's happening - your MySQL "root" user has a password, and "mysqladmin" wants a password before it will execute for "root". If you want to run mysqladmin through cron(as a part of logrotate), you'll need to use an option file in the unix "root" user's home account(.my

What does this mean

Found this message from mysql in my root mailbox. What does it mean? "errors occured while rotating /var/lib/mysql/mysqld.log { ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' error running postrotate script"

Re: [PHP] What Does This Mean?

India - Original Message - From: "Ben Ocean" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 3:28 PM Subject: [PHP] What Does This Mean? > Hi; > I'm getting this error: > >>> > Un

What Does This Mean?

Hi; I'm getting this error: >>> Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-php3 >= 3.0.8 <<< What does it mean and what should I do about it (if anything)? TIA, BenO - Before posting, please check: http://www.m

RE: [PHP-DEV] RE: mysql_pconnect still broken (was: RE: What does this mean ?)

y 17, 2001 12:48 AM > To: Steven Roussey > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Mysql > Subject: Re: [PHP-DEV] RE: mysql_pconnect still broken (was: RE: > What does this mean ?) > > > Yep, you're right. Fixed. > > Thanks, > > Zeev > >

Re: [PHP-DEV] RE: mysql_pconnect still broken (was: RE: What does this mean ?)

Looks like this was my bad :) Sorry, Andi At 01:47 AM 1/17/2001 +0200, Zeev Suraski wrote: >Yep, you're right. Fixed. > >Thanks, > >Zeev > >At 23:24 16/1/2001, Steven Roussey wrote: >> > OK. Look at a quick report. I've just installed php4-200101152345. It runs >> > with mysql-3.23.27-beta. Apac

Re: [PHP-DEV] RE: mysql_pconnect still broken (was: RE: What does this mean ?)

Yep, you're right. Fixed. Thanks, Zeev At 23:24 16/1/2001, Steven Roussey wrote: > > OK. Look at a quick report. I've just installed php4-200101152345. It runs > > with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4 > > (remote connection). > > > > What I can see is: the o

RE: mysql_pconnect still broken (was: RE: What does this mean ?)

> OK. Look at a quick report. I've just installed php4-200101152345. It runs > with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4 > (remote connection). > > What I can see is: the offending messages didn't vanish at all (both hosts > are involved): > So, I think it's not fixe

mysql_pconnect still broken (was: RE: What does this mean ?)

OK. Look at a quick report. I've just installed php4-200101152345. It runs with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4 (remote connection). What I can see is: the offending messages didn't vanish at all (both hosts are involved): 010116 20:52:30 Aborted connection 3

RE: What does this mean ?

's patches haven't been > incorporated into PHP 4.0.4pl1. Maybe Andi (Cc:ed) could explain this? > > Maciek > > > -Original Message- > > From: Denis Gasparin [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 16, 2001 8:50 AM > > To: [EMAIL

RE: What does this mean ?

> From: Denis Gasparin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 16, 2001 8:50 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: What does this mean ? > > > I use php 4.0.3 with persistent connections. MySQL is installed on Linux > RedHat 7.0. > The p

RE: What does this mean ?

MySQL in your case? > >Maciek > > > -Original Message- > > From: Denis Gasparin [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 15, 2001 6:00 PM > > To: [EMAIL PROTECTED] > > Subject: What does this mean ? > > > > > > From when I

RE: What does this mean ?

Could you describe what exactly software connects to MySQL in your case? Maciek > -Original Message- > From: Denis Gasparin [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 15, 2001 6:00 PM > To: [EMAIL PROTECTED] > Subject: What does this mean ? > > > F

What does this mean ?

From when I installed the mysql 3.23.30gamma I have mysql reporting these warnings: 10115 17:51:22 Aborted connection 2886 to db: 'db_name' user: 'user' host: `www.host' (Got an error reading communication packets) 010115 17:51:36 Aborted connection 3754 to db: 'db_name' user: 'user' host: