Do you have a high number of temp tables being created or high i/o?
-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/30/04 3:44 PM
Subject: RE: authentication error
No sir...
-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped]
Sent: Wednesday, June 30, 2004 4:43 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error
I would check to see if your server is swapping at this point.
-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/30/04 3:27 PM
Subject: RE: authentication error
Hi Victor,
I have stumbled on to something. The server is bouncing back and forth
b/t fast and slow. When I do "show processlist" and its above 100, it's
slow. When it's below, it's fine.
What variable is wrong? I have Max_connections = 250?
Thanks
Chip
-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped]
Sent: Tuesday, June 29, 2004 3:12 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error
You should just become familiar with your data and the queries that are
sent
to the database. You could turn on the slow query log and after a few
days
or hours or whatever see what queries are logged.
-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 1:03 PM
Subject: RE: authentication error
Is there anything I should set in my startup options to accommodate
this?
-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped]
Sent: Tuesday, June 29, 2004 1:54 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error
The values in the `State` and `Command` fields of the queries are what
you
should be looking at. For example if you have a select statement that is
running over an acceptable threshold you should look into that. If you
have
a query that is taking a `long` time to create a temp table , you should
look at that one. You just need to identify what is acceptable and
normal
behaviour and correct where possible.
-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 12:43 PM
Subject: RE: authentication error
Ok, we might be on to something. Right now, the server is running fine.
I did a "show processlist" and got back 138 rows. There are times
ranging from 0-14556. Granted, it's an email server so people are
staying logged in...
-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped]
Sent: Tuesday, June 29, 2004 1:31 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error
Do you have an `execessive` numer of processes running? Do you have any
processes that have been running for an `abnormal` length of time?
-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 12:12 PM
Subject: RE: authentication error
It's all on the same box. I'm familiar with the "show processlist" but
I don't know what to look for. See what I mean lol? I know most of the
commands, but not quite what I'm looking for.
-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped]
Sent: Tuesday, June 29, 2004 1:11 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error
What is the connection like between the two servers? Once you are logged
in
can you do a show processlist and see if anything is bottelnecking the
database?
-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 12:05 PM
Subject: RE: authentication error
I ran the FLUSH HOSTS and it said "0 rows affected" The authentication
goes against the mysql table, which is where I'm guessing the errors
would show. When I try to log in during the "slow down" of the server,
it just hangs and hangs and finally will let me through.
-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped]
Sent: Tuesday, June 29, 2004 1:02 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error
From the mysql monitor it is `FLUSH HOSTS;` . Does the email server not
log
failed connection attempts?
-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 11:55 AM
Subject: RE: authentication error
Ok, I tried to run "flush-hosts" from both # and inside mysql..nada.
How can I do this exactly? Sorry about my lack of knowledge, I'm still
green. I have my books though and am feverishly trying to find the
answer!
Thanks for your help!!
-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped]
Sent: Tuesday, June 29, 2004 12:53 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error
Can you view or log the errors that imap and the web authentication are
getting? Try issuing a flush-hosts to see if the max_connect_errors was
reached.
-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 11:47 AM
Subject: RE: authentication error
Nothing actually. I'm guessing I don't have "enough" logging turned on.
The only thing my servername.err files shows is
Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you
do do not.....etc
-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped]
Sent: Tuesday, June 29, 2004 12:04 PM
To: Chip Bell; 'mysql@stripped '
Subject: RE: authentication error
What does the error log say?
-----Original Message-----
From: Chip Bell
To: mysql@stripped
Sent: 6/29/04 9:03 AM
Subject: authentication error
Hello, I run a toaster email server which is having trouble
authenticating at times. Both methods of authentication, imap AND web
for some reason just hang. I'm pretty new to MySql but I figure if both
methods are trying to authenticate against the same table, the problem
is there. I activated binary logging, what else can I do to find the
issue?
Thanks
