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
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] &#x
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_re
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: authenticatio
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]
Su
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
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
ing 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]
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 B
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.
---
riginal 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. Y
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
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 val
[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
ECTED]
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: 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
fail
ndleton [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_c
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
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
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
20 matches
Mail list logo
