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:mvdberg mooy.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
|
