Michiel,
Thank you VERY much for the info. I've got plenty of space
in my
filesystem for the database to grow. I'll implement your
recommendations, and let you know (and let the list users
know).
--
Doug Mortensen
Impala Networks
Network Consultant
-----Original Message-----
From: maia-users-bounces renaissoft.com
[mailto:maia-users-bouncesrenaissoft.com] On Behalf
Of
maia-users-requestrenaissoft.com
Sent: Friday, June 29, 2007 1:00 PM
To: maia-usersrenaissoft.com
Subject: Maia-users Digest, Vol 45, Issue 46
Send Maia-users mailing list submissions to
maia-usersrenaissoft.com
To subscribe or unsubscribe via the World Wide Web, visit
http://www.renaissoft.com/mailman/listinfo/maia-users
or, via email, send a message with subject or body 'help'
to
maia-users-requestrenaissoft.com
You can reach the person managing the list at
maia-users-ownerrenaissoft.com
When replying, please edit your Subject line so it is more
specific
than "Re: Contents of Maia-users digest..."
Today's Topics:
1. Re: Confirmed spam/ham not going away (Michiel van den
Berg)
------------------------------------------------------------
----------
Message: 1
Date: Fri, 29 Jun 2007 20:47:23 +0200
From: Michiel van den Berg <flashdaaw.org>
Subject: Re: [Maia-users] Confirmed spam/ham not going away
To: maia-usersrenaissoft.com
Message-ID: <468553BB.9060101daaw.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Douglas Mortensen wrote:
> Can you shed some light on how you adjusted the grow
size, and how you
"optimized your database"? I seem to still be
having this problem. I
have checked my /etc/my.cnf, and the only thing in there
relating to
size limits is max_allowed_packet=50M, which I don't think
you're
referring to.
>
> I'm using MySQL 5.0.22, and looking at some MySQL
documentation
(http://dev.mysql.com/doc/refman/5.0/en/innodb-co
nfiguration.html), it
looks like the default behavior for the database is for it
to
"auto-extend". Is this what we're looking for
here? This is what the
documentation above says about this:
>
>
>
> ... a setting that explicitly creates a tablespace
having the same
characteristics as the default is as follows:
> [mysqld]
> innodb_data_file_path=ibdata1:10M:autoextend
>
I have set that line to:
innodb_data_file_path=ibdata1:1024M:autoextend
so dbs can grow to 1GB make sure you have enough space in
your
filesystem. also make sure you have got enough RAM in your
box above 1GB
would be advisable. else set it to something lower.
be sure to restart mysql after you change this in my.cnf
>
>
> I'm currently not getting any errors in my httpd log
when I perform
this procedure (which still doesn't seem to be working
entirely).
>
> Also, can you point me in the right direction for
"Optimizing" the
database, as you previously mentioned? Are you talking about
the info in
this page: ht
tp://www.maiamailguard.com/maia/wiki/MySQLTuning ? If
so, I
have yet to carefully review & implement those
suggestions.
>
open mysql console or phpmyadmin go to the maia DB and do
the SQL query:
 PTIMIZE
TABLE maia_mail
|PTIMIZE
TABLE maia_mail_recipients
the first table tends to grow large, and 10mb in your
current
implementation is not much and only a few mails can already
blow this
one up (mine is right now around 300mb)
by optimising the table, your making sure all 'empty' space
in the table
is removed, after this you should be able to delete mails
again and also
let the table grow and allow new mails.
|
> Thanks in advance for the help!! 
>
> -
> Doug Mortensen
> Impala Networks
>
> -----Original Message-----
> From: Michiel van den Berg [mailto:mvdbergmooy.nl]
> Sent: Tuesday, June 26, 2007 12:20 AM
> To: David Morton; Douglas Mortensen
> Cc: maia-usersrenaissoft.com
> Subject: RE: [Maia-users] Confirmed spam/ham not going
away
>
>
>>> On Jun 25, 2007, at 6:06 PM, Douglas Mortensen
wrote:
>>>
>
>
>>> When I log into our Maia installation (which we
just setup within
>>> the last 2 weeks), and confirm spam as spam and
ham as ham, those
>>> messages remain in the "Unconfirmed
Non-spam" category. I'm pretty
>>> sure they are supposed to go away. In fact I
think the first day we
>>> got Maia running, those messages disappeared
from that list after I
>>> confirmed them. But that doesn't seem to be
happening anymore.
>>>
>>>
>>>
>>> Can anyone shed a little light on what may fix
this (as well as the
>>> cause)? I greatly appreciate it.
>>>
>
>
>
>
>> Sounds like something's not right with the DB...
Do you have any
>> error messages in your web server logs?
>>
>
> I had this same problem. My database ran full, I had to
increase the
> grow size. After that 'optimize' the table in mysql and
it would
> function again.
>
> Rgds,
>
> Michiel
>
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.9.6/863 -
Release Date:
6/23/2007 11:08 AM
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.9.6/863 -
Release Date:
6/23/2007 11:08 AM
>
> _______________________________________________
> Maia-users mailing list
> Maia-usersrenaissoft.com
> http://www.renaissoft.com/mailman/listinfo/maia-users
>
------------------------------
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
End of Maia-users Digest, Vol 45, Issue 46
******************************************
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|
