RE: slow response time
Are you running spam assassin? I'm finding that my slow query log is showing the spam queries to really be dragging. -Original Message- From: Charles Sprickman [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 2:29 PM To: [EMAIL PROTECTED] Cc: Egor Egorov Subject: Re: slow response time On Tue, 6 Jul 2004, Jeremy Zawodny wrote: Do you have a summary of the poor performance somewhere? Or at least a sense of where you think the bottleneck is? The best I can tell you is that mysql + moderate qmail load on the same box causes problems. I don't know if this is a scheduler issue with FreeBSD, or just qmail telling me that I should be using Postfix. Out of the blue mysql will start logging stuff like this in the slow query log: # administrator command: Ping; # [EMAIL PROTECTED]: squirrelmail[squirrelmail] @ localhost [] # Query_time: 47 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 # administrator command: Ping; # [EMAIL PROTECTED]: vpopmail[vpopmail] @ localhost [] # Query_time: 48 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 Load is moderate, but not so bad that any other services on here are affected in any perceptible way. Thanks, Charles Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.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
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
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
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
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
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
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: Server tuning
Victor, Thanks for all your help with the authentication issue. I still have it, but at least I know what to look for. My server is running RH9 with 3 gigs ram, PIII. I have about 150 users at any given time and they're all coming via IMAP or HTTPD. They all authenticate against MySQL but the mail is not stored there, it's in virtual domain files. My /etc/my.cnf Set-variabe = max_connections=1000 Key_buffer_size=512M Sort_buffer=20M Join_buffer=1M Record_buffer=1M Max_allowed_packet=2M Table_cache=1024 Innodb_buffer_pool_size=256M Are these variables ok? Reading my MySql manual, these were the best I could come up with. Thanks! -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 4:41 PM To: 'João Paulo Vasconcellos '; 'Mysql-general Mailing List ' Subject: RE: Server tuning max_memory is roughly equivalent to == key_buffer_size + (read_buffer_size + sort_buffer_size) * max_connections -Original Message- From: João Paulo Vasconcellos To: Mysql-general Mailing List Sent: 6/29/04 1:09 PM Subject: Server tuning Hello everybody, I am setting up a server to do POP/SMTP authentication using vpopmail. I took a look at the variables at global my.cnf and wondered what would be the best values for things like key_buffer, read_buffer_size and table_cache. I searched the manual, but it does not go deep in this subject, or I was not capable of finding the right place. What I want to know is how can I calculate how much memory I should give to key_buffer before I start to give away too much memory. That's because I got only 1GB of RAM and I have about 34k domains in my database, averaging from 8 to 15 accounts each. In a normal situation, there are ~400 simultaneous clients. I was wanting to know how can I estimate the memory usage for this scenario, if exists some kind of formula to answer this, like: clients * total size of key fields used in query or if this is some thing that is clear in the manual (if so, my apologies, but I could not find). TIA, -- João Paulo Vasconcellos -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
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
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
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
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]
Please help..
Hello, I have a Red Hat 9 server which runs a qmail/toaster software package. It allows webmail to authenticate against a mysql db and stores mail there too. K, the issue.. Every once in a while, the web client just SITS at authentication. The client just sits there forever. The login can take up to 85 seconds. Once you are logged into webmail however, it's very very fast. Another note, when myself and my admin are waiting to login, it seems we both finally get through at the same exact time. I don't know where to look to see what's causing this but everything points to my database. A restart of the server will fix the issue...but that's just a workaround. Hardware: P3 1ghz, 3gigs ram, Ultra3 Scsi (Raid 5) I appreciate ANY help you can give. This is a production box and it's causing problems! /etc/my.cnf set-variable = max_connections=1000 set-variable = key_buffer_size=1024M set-variable = sort_buffer=20M #set-variable = read_buffer_size=2M set-variable = join_buffer=1M set-variable = record_buffer=1M set-variable = max_allowed_packet=2M set-variable = table_cache=1024 set-variable = innodb_buffer_pool_size=256M #set-variable = query_cache_limit=1048576 #set-variable = query_cache_size=0 Mysql 3.23.58-1.9