Subject: The mailing list for listmasters using Sympa
List archive
- From: David Verdin <address@concealed>
- To: address@concealed
- Subject: Re: [sympa-users] MySQL and InnoDB
- Date: Thu, 04 Apr 2013 14:56:22 +0200
Also make sure you use
innodb only. We use MySQL hotcopy to backup database and didn't
work out a mean to backup databases using both engines. Actually, innodb is not really needed by Sympa. We don't enforce referential integrity through foreign kay and, as far as I remember, it was the main advantage of innodb. Why do you want to use this engine? Regards, David Le 02/04/13 20:38, C. Morgan Hamill a
écrit :
Excerpts from Todd Merritt's message of 2013-04-02 12:57:58 -0400: We're hosting about 3000 lists with that set up and haven't had any issues. If you use innodb_per_table it will greatly improve your innodb performance. You need to set that prior to creating the tables. Thanks for the quick reply. We've already set innodb_file_per_table globally, so this works out nicely. -- C. Morgan Hamill <address@concealed> --
A bug in Sympa? Quick! To the bug tracker!
|
Attachment:
smime.p7s
Description: Signature cryptographique S/MIME
-
[sympa-users] MySQL and InnoDB,
C. Morgan Hamill, 04/02/2013
-
Re: [sympa-users] MySQL and InnoDB,
Todd Merritt, 04/02/2013
-
Re: [sympa-users] MySQL and InnoDB,
C. Morgan Hamill, 04/02/2013
- Re: [sympa-users] MySQL and InnoDB, David Verdin, 04/04/2013
-
Re: [sympa-users] MySQL and InnoDB,
C. Morgan Hamill, 04/02/2013
-
Re: [sympa-users] MySQL and InnoDB,
Todd Merritt, 04/02/2013
Archive powered by MHonArc 2.6.19+.