List Info

Thread: Re: mysql db's hosed? Help needed badly
Re: mysql db's hosed? Help needed badly
country flaguser name
United States		 2007-10-11 10:59:45 
Hi,

  What does 'top' show you while this is running? Also,
please have a look
at ht
tp://www.maiamailguard.com/maia/wiki/MySQLTuning to see
if that
provides any clues. 'free' will show you both memory and
swap usage....
I would think that this must be a MySQL tuning issue of some
sort, but I
do not know what the specific issue might be.... Anything in
the MySQL log
file?

Dave
************************************************************
********


On Thu, 11 Oct 2007, Rick Zeman wrote:

> >>> David Morton <mortondadgrmm.net> 10/11/2007 1:06 AM >>>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> On Oct 10, 2007, at 12:12 PM, David Sims wrote:
>
> > Hi,
> >
> >   As I recall, this machine ran for a while
without running
> > process-quarantine.pl.... I am thinking that you
need to process the
> > quarantine to remove LOTS of mail.... If it's
offline, then why not
> > just
>
> I'd start by turning down the cache expry time, and
running the
> expire script first, to narrow down the file.
>
> We can also drop and re-add just the tables that hold
the mail, but
> keep the user settings... if we come to that point.
>
> ________
>
> That was a superb idea, David.  Changed both values to
1 and then ran the
> expire script and it dropped over 12,000 messages. 
Reran quarantine and
> it's pluging away (and bogging down again after 60
messages).  BUT, other
> than a couple of system generated mails, there should
be none newer than 2
> days because the server isn't processing any new mail
(and hasn't for over
> 7 days).  If I wasn't confused before I am now!
>
> This entire session.  Look at the time stamps:
>
> ./process-quarantine.pl
> 2007-10-11 09:39:43 Maia: [process-quarantine-sub]
Warning: --report not
> specified, reporting is disabled.
> 2007-10-11 09:39:49 Maia: [process-quarantine-sub]
Learned mail item
> 18115 as spam
> 2007-10-11 09:39:55 Maia: [process-quarantine-sub]
Learned mail item
> 18116 as spam
> 2007-10-11 09:40:00 Maia: [process-quarantine-sub]
Learned mail item
> 18118 as spam
> 2007-10-11 09:40:18 Maia: [process-quarantine-sub]
Learned mail item
> 18122 as spam
> 2007-10-11 09:40:29 Maia: [process-quarantine-sub]
Learned mail item
> 18125 as spam
> 2007-10-11 09:40:29 Maia: [process-quarantine-sub] 5
spam items processed
> (5 learned, 0 reported)
> 2007-10-11 09:41:20 Maia: [process-quarantine-sub]
Learned mail item
> 190499 as non-spam
> 2007-10-11 09:42:26 Maia: [process-quarantine-sub]
Learned mail item
> 190504 as non-spam
> 2007-10-11 09:42:35 Maia: [process-quarantine-sub]
Learned mail item
> 190506 as non-spam
> 2007-10-11 09:42:55 Maia: [process-quarantine-sub]
Learned mail item
> 190512 as non-spam
> 2007-10-11 09:54:56 Maia: [process-quarantine-sub]
Learned mail item
> 190515 as non-spam
> 2007-10-11 09:54:56 Maia: [process-quarantine-sub] 5
non-spam items
> processed (5 learned)
> 2007-10-11 09:54:56 Maia: [process-quarantine-sub]
Warning: --report not
> specified, reporting is disabled.
> 2007-10-11 09:55:20 Maia: [process-quarantine-sub]
Learned mail item
> 18126 as spam
> 2007-10-11 09:55:53 Maia: [process-quarantine-sub]
Learned mail item
> 18127 as spam
> 2007-10-11 09:56:14 Maia: [process-quarantine-sub]
Learned mail item
> 18128 as spam
> 2007-10-11 09:56:30 Maia: [process-quarantine-sub]
Learned mail item
> 18131 as spam
> 2007-10-11 09:56:51 Maia: [process-quarantine-sub]
Learned mail item
> 18133 as spam
> 2007-10-11 09:56:51 Maia: [process-quarantine-sub] 5
spam items processed
> (5 learned, 0 reported)
> 2007-10-11 09:57:10 Maia: [process-quarantine-sub]
Learned mail item
> 190517 as non-spam
> 2007-10-11 09:57:26 Maia: [process-quarantine-sub]
Learned mail item
> 190524 as non-spam
> 2007-10-11 09:57:53 Maia: [process-quarantine-sub]
Learned mail item
> 190534 as non-spam
> 2007-10-11 09:59:22 Maia: [process-quarantine-sub]
Learned mail item
> 190536 as non-spam
> 2007-10-11 10:02:53 Maia: [process-quarantine-sub]
Learned mail item
> 190543 as non-spam
> 2007-10-11 10:02:54 Maia: [process-quarantine-sub] 5
non-spam items
> processed (5 learned)
> 2007-10-11 10:02:54 Maia: [process-quarantine-sub]
Warning: --report not
> specified, reporting is disabled.
> 2007-10-11 10:03:05 Maia: [process-quarantine-sub]
Learned mail item
> 18138 as spam
> 2007-10-11 10:03:19 Maia: [process-quarantine-sub]
Learned mail item
> 18139 as spam
> 2007-10-11 10:03:32 Maia: [process-quarantine-sub]
Learned mail item
> 18140 as spam
> 2007-10-11 10:03:50 Maia: [process-quarantine-sub]
Learned mail item
> 18141 as spam
> 2007-10-11 10:04:34 Maia: [process-quarantine-sub]
Learned mail item
> 18142 as spam
> 2007-10-11 10:04:34 Maia: [process-quarantine-sub] 5
spam items processed
> (5 learned, 0 reported)
> 2007-10-11 10:05:20 Maia: [process-quarantine-sub]
Learned mail item
> 190551 as non-spam
> 2007-10-11 10:06:16 Maia: [process-quarantine-sub]
Learned mail item
> 190552 as non-spam
> 2007-10-11 10:08:46 Maia: [process-quarantine-sub]
Learned mail item
> 190559 as non-spam
> 2007-10-11 10:10:21 Maia: [process-quarantine-sub]
Learned mail item
> 190566 as non-spam
> 2007-10-11 10:11:25 Maia: [process-quarantine-sub]
Learned mail item
> 190571 as non-spam
> 2007-10-11 10:11:26 Maia: [process-quarantine-sub] 5
non-spam items
> processed (5 learned)
> 2007-10-11 10:11:26 Maia: [process-quarantine-sub]
Warning: --report not
> specified, reporting is disabled.
> 2007-10-11 10:11:36 Maia: [process-quarantine-sub]
Learned mail item
> 18144 as spam
> 2007-10-11 10:11:57 Maia: [process-quarantine-sub]
Learned mail item
> 18146 as spam
> 2007-10-11 10:12:13 Maia: [process-quarantine-sub]
Learned mail item
> 18148 as spam
> 2007-10-11 10:12:23 Maia: [process-quarantine-sub]
Learned mail item
> 18149 as spam
> 2007-10-11 10:12:53 Maia: [process-quarantine-sub]
Learned mail item
> 18153 as spam
> 2007-10-11 10:12:53 Maia: [process-quarantine-sub] 5
spam items processed
> (5 learned, 0 reported)
> 2007-10-11 10:13:47 Maia: [process-quarantine-sub]
Learned mail item
> 190574 as non-spam
> 2007-10-11 10:14:09 Maia: [process-quarantine-sub]
Learned mail item
> 190575 as non-spam
> 2007-10-11 10:14:09 Maia: [process-quarantine-sub]
Skipping mail item
> 190577 (too big: 9073816 > 262144)
> 2007-10-11 10:14:13 Maia: [process-quarantine-sub] 5
non-spam items
> processed (2 learned)
> 2007-10-11 10:14:13 Maia: [process-quarantine-sub]
Warning: --report not
> specified, reporting is disabled.
> 2007-10-11 10:14:28 Maia: [process-quarantine-sub]
Learned mail item
> 18157 as spam
> 2007-10-11 10:15:07 Maia: [process-quarantine-sub]
Learned mail item
> 18162 as spam
> 2007-10-11 10:15:41 Maia: [process-quarantine-sub]
Learned mail item
> 18163 as spam
> 2007-10-11 10:15:47 Maia: [process-quarantine-sub]
Learned mail item
> 18164 as spam
> 2007-10-11 10:16:34 Maia: [process-quarantine-sub]
Learned mail item
> 18165 as spam
> 2007-10-11 10:16:34 Maia: [process-quarantine-sub] 5
spam items processed
> (5 learned, 0 reported)
> 2007-10-11 10:25:29 Maia: [process-quarantine-sub]
Learned mail item
> 190579 as non-spam
> 2007-10-11 10:25:42 Maia: [process-quarantine-sub]
Learned mail item
> 190588 as non-spam
> 2007-10-11 10:25:42 Maia: [process-quarantine-sub]
Skipping mail item
> 190596 (too big: 3701512 > 262144)
> 2007-10-11 10:25:46 Maia: [process-quarantine-sub]
Skipping mail item
> 190597 (too big: 6338040 > 262144)
> 2007-10-11 10:26:21 Maia: [process-quarantine-sub]
Learned mail item
> 190606 as non-spam
> 2007-10-11 10:26:21 Maia: [process-quarantine-sub] 5
non-spam items
> processed (3 learned)
> 2007-10-11 10:26:21 Maia: [process-quarantine-sub]
Warning: --report not
> specified, reporting is disabled.
> 2007-10-11 10:26:48 Maia: [process-quarantine-sub]
Learned mail item
> 18170 as spam
> 2007-10-11 10:27:07 Maia: [process-quarantine-sub]
Learned mail item
> 18171 as spam
> 2007-10-11 10:27:55 Maia: [process-quarantine-sub]
Learned mail item
> 18172 as spam
> 2007-10-11 10:28:23 Maia: [process-quarantine-sub]
Learned mail item
> 18174 as spam
> 2007-10-11 10:28:51 Maia: [process-quarantine-sub]
Learned mail item
> 18175 as spam
> 2007-10-11 10:28:51 Maia: [process-quarantine-sub] 5
spam items processed
> (5 learned, 0 reported)
> 2007-10-11 10:29:14 Maia: [process-quarantine-sub]
Learned mail item
> 190608 as non-spam
> 2007-10-11 10:29:26 Maia: [process-quarantine-sub]
Learned mail item
> 190620 as non-spam
> 2007-10-11 10:29:46 Maia: [process-quarantine-sub]
Learned mail item
> 190623 as non-spam
> 2007-10-11 10:30:03 Maia: [process-quarantine-sub]
Learned mail item
> 190625 as non-spam
> 2007-10-11 10:30:27 Maia: [process-quarantine-sub]
Learned mail item
> 190633 as non-spam
> 2007-10-11 10:30:27 Maia: [process-quarantine-sub] 5
non-spam items
> processed (5 learned)
> 2007-10-11 10:30:27 Maia: [process-quarantine-sub]
Warning: --report not
> specified, reporting is disabled.
> 2007-10-11 10:30:44 Maia: [process-quarantine-sub]
Learned mail item
> 18176 as spam
> 2007-10-11 10:31:02 Maia: [process-quarantine-sub]
Learned mail item
> 18180 as spam
> 2007-10-11 10:31:39 Maia: [process-quarantine-sub]
Learned mail item
> 18181 as spam
> 2007-10-11 10:31:51 Maia: [process-quarantine-sub]
Learned mail item
> 18184 as spam
> 2007-10-11 10:32:06 Maia: [process-quarantine-sub]
Learned mail item
> 18187 as spam
> 2007-10-11 10:32:07 Maia: [process-quarantine-sub] 5
spam items processed
> (5 learned, 0 reported)
> 2007-10-11 10:33:18 Maia: [process-quarantine-sub]
Learned mail item
> 190635 as non-spam
> 2007-10-11 10:40:21 Maia: [process-quarantine-sub]
Learned mail item
> 190642 as non-spam
> 2007-10-11 11:14:18 Maia: [process-quarantine-sub]
Learned mail item
> 190643 as non-spam
>
>
> --
> Rick Zeman
> Manager of Information Technology
> Melwood Horticultural Training Center
> 301.599.4574 - HelpDesk
> 301.599.4560 - MyDesk
> http://www.melwood.org
>
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )