port load and unload commands with respect to MySql
talklists at newgeo.com
Fri Mar 5 08:54:50 PST 2010
On Mar 5, 2010, at 7:51 AM, Chris Janton <face at CentosPrime.COM> wrote:
> The logs will wind up in the "vendor" specified places. The data is
> on your "data" volume.
> For further "goodness" you should specify --innodb_file_per_table
> and keep the InnoDB tables from all "magically" winding up in the
> same file!
Is innoDB really that binary a decision? Its been a while, but I used
to decide based purely on need of transactions.
However, I don't imagine the large amount of storage space I would
need to hold all those data logs innoDB needs has gone away.
There was also some maintenance of those logs, as they grow and grow.
I've never had performance issues with MyISSAM, and never really had
to clean up after it. It still is not the default engine is it?
I've got a few large databases, adding a GB a day now, willing to
convert them, but will have to start some pretty serious research. We
already have a hard time keeping up with the data, and are looking
towards Amazon and all the other providers of database in that cloud
thing I hear about.
Scott * If you contact me off list replace talklists@ with scott@ *
(Sent from a mobile device)
More information about the macports-users