Re: authentication error
Chip Bell [EMAIL PROTECTED] wrote: The email users authenticate against a MySQL table... Then it's not about MySQL, it's about the imap/pop3 server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: authentication error
Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
Re: authentication error
Chip Bell [EMAIL PROTECTED] wrote: 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? Are you talking about MySQL user auth OR about some kind of email user authentication against data stored in MySQL database? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: authentication error
The email users authenticate against a MySQL table... -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 6:12 AM To: [EMAIL PROTECTED] Subject: Re: authentication error Chip Bell [EMAIL PROTECTED] wrote: 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? Are you talking about MySQL user auth OR about some kind of email user authentication against data stored in MySQL database? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: authentication error
Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
Ok, I have no read_buffer anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 connections is 2356M. I'm going to guess that I should shave that down a bit?? -Original Message- From: Chip Bell Sent: Thursday, July 01, 2004 10:17 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: RE: authentication error Ok, I have no read_buffer anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
Can you tweak your key_buffer and see what results you get? -Original Message- From: Chip Bell To: Chip Bell; Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 9:38 AM Subject: RE: authentication error My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 connections is 2356M. I'm going to guess that I should shave that down a bit?? -Original Message- From: Chip Bell Sent: Thursday, July 01, 2004 10:17 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: RE: authentication error Ok, I have no read_buffer anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
I had my admin turn it down from 256M to 50M and it started just dogging at 40 connections. We're now at 128M and checking. How do I set the key_buffer appropriately? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:51 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Can you tweak your key_buffer and see what results you get? -Original Message- From: Chip Bell To: Chip Bell; Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 9:38 AM Subject: RE: authentication error My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 connections is 2356M. I'm going to guess that I should shave that down a bit?? -Original Message- From: Chip Bell Sent: Thursday, July 01, 2004 10:17 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: RE: authentication error Ok, I have no read_buffer anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
What is the value of key_reads/key_read_request? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 12:11 PM Subject: RE: authentication error I had my admin turn it down from 256M to 50M and it started just dogging at 40 connections. We're now at 128M and checking. How do I set the key_buffer appropriately? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:51 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Can you tweak your key_buffer and see what results you get? -Original Message- From: Chip Bell To: Chip Bell; Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 9:38 AM Subject: RE: authentication error My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 connections is 2356M. I'm going to guess that I should shave that down a bit?? -Original Message- From: Chip Bell Sent: Thursday, July 01, 2004 10:17 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: RE: authentication error Ok, I have no read_buffer anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
Key_Reads 57 Key_read_request 16218 -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:17 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error What is the value of key_reads/key_read_request? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 12:11 PM Subject: RE: authentication error I had my admin turn it down from 256M to 50M and it started just dogging at 40 connections. We're now at 128M and checking. How do I set the key_buffer appropriately? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:51 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Can you tweak your key_buffer and see what results you get? -Original Message- From: Chip Bell To: Chip Bell; Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 9:38 AM Subject: RE: authentication error My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 connections is 2356M. I'm going to guess that I should shave that down a bit?? -Original Message- From: Chip Bell Sent: Thursday, July 01, 2004 10:17 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: RE: authentication error Ok, I have no read_buffer anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
Those values are good. What query is being run when the users are authenticating? Have you looked at the explain plan for that query? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 12:22 PM Subject: RE: authentication error Key_Reads 57 Key_read_request 16218 -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:17 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error What is the value of key_reads/key_read_request? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 12:11 PM Subject: RE: authentication error I had my admin turn it down from 256M to 50M and it started just dogging at 40 connections. We're now at 128M and checking. How do I set the key_buffer appropriately? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:51 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Can you tweak your key_buffer and see what results you get? -Original Message- From: Chip Bell To: Chip Bell; Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 9:38 AM Subject: RE: authentication error My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 connections is 2356M. I'm going to guess that I should shave that down a bit?? -Original Message- From: Chip Bell Sent: Thursday, July 01, 2004 10:17 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: RE: authentication error Ok, I have no read_buffer anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] Sent
RE: authentication error
I don't know how to look at the explain plan for that query..or how to find out what query is being run. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:29 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Those values are good. What query is being run when the users are authenticating? Have you looked at the explain plan for that query? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 12:22 PM Subject: RE: authentication error Key_Reads 57 Key_read_request 16218 -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:17 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error What is the value of key_reads/key_read_request? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 12:11 PM Subject: RE: authentication error I had my admin turn it down from 256M to 50M and it started just dogging at 40 connections. We're now at 128M and checking. How do I set the key_buffer appropriately? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:51 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Can you tweak your key_buffer and see what results you get? -Original Message- From: Chip Bell To: Chip Bell; Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 9:38 AM Subject: RE: authentication error My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 connections is 2356M. I'm going to guess that I should shave that down a bit?? -Original Message- From: Chip Bell Sent: Thursday, July 01, 2004 10:17 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: RE: authentication error Ok, I have no read_buffer anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the show processlist was 100 or above, it hung. The ONLY variable I can find with a setting of 100 is that delayed_insert_limit. Obviously I was thinking of just changing that and watching, but you guys seem to know A LOT more than I do so I thought someone may have seen this...or have an idea. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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
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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
I would check to see if your server is swapping at this point. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
After looking through, show variables; the only one I found with a value of 100 is the delayed_insert_limit Could this be the issue? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
RE: authentication error
Are you using delayed insert statements? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:50 PM Subject: RE: authentication error After looking through, show variables; the only one I found with a value of 100 is the delayed_insert_limit Could this be the issue? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:45 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error Do you have a high number of temp tables being created or high i/o? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 6/30/04 3:44 PM Subject: RE: authentication error No sir... -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 4:43 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 3:12 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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; [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]
RE: authentication error
Is there anything I should set in my startup options to accommodate this? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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]
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; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:54 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' 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; [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
