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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:31 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:11 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:02 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 12:53 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 12:04 PM To: Chip Bell; '[EMAIL PROTECTED] ' Subject: RE: authentication error What does the error log say? -----Original Message----- From: Chip Bell To: [EMAIL PROTECTED] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
