The ibdata1 file is 5.75GB. I tried to get cute and compact
it (from
http://valery.bgit.net/blog-en/2007/02/22/mysql
-reducing-ibdata1/)
figuring the drive wouldn't have to work so hard, but that
procedure ended
up recreating the replacement db as as much smaller set of
MyISAM files,
not innodb. Being adventurous (and since I had a backup of
the innodb'd
mysql folder), I ran the content-quarantine.pl script on
THAT. After
running like gangbusters for 24 hours (it had to have
processed over 25k
messages) (processing 1-3 messages per second), processing
would slow
down to a crawl (the aformentioned disk I/O slowdown) and
even stopping
restarting the script after letting the server catch up
didn't help. So I
surrendered.
SO, I've reverted back to my InnoDB version. What I'd like
to do is just
drop all of the tables in the database that contain mail, as
David M.
suggested (easy, if I knew which ones they were) and then
re-add them. I
suspect that there's more to it than just rerunning the
original import
script that originally set up the database, right?
Any suggestions on how to do the above? Any SQL gurus have
a query so I
can see just how many messages there are in the quarantine?
I'm slowly learning about MySQL, but I have maybe 30 minutes
a day tops
to devote to this and it's not enough, and I'd really like
to get this
server back online.
Thanks!
>>> "Todd" <todd smart-mail.net>
10/16/2007 1:09 PM >>>
How big is your MySQL database?
-----Original Message-----
From: maia-users-bouncesrenaissoft.com
[mailto:maia-users-bouncesrenaissoft.com] On Behalf
Of Rick Zeman
Sent: Monday, October 15, 2007 9:06 AM
To: David Morton; maia-usersrenaissoft.com
Subject: Re: [Maia-users] mysql db's hosed? Help needed
badly
>>> 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.
______________
I think we're at that point. Even after running the expire
script with
the values lowered to 1 for both, the quarantine script
still just
churns
and churns and churns and never finishes. Dunno. :-(
--
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
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|
