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 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
