Skip to Content.
Sympa Menu

en - Re: [sympa-users] MySQL and InnoDB

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • 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!

 
David Verdin
Infrastructure pour les Services Informatiques
 

Tél : +33 2 23 23 69 71
Fax : +33 2 23 23 71 21
 

www.renater.fr
RENATER
263 Avenue du Gal Leclerc
35042 Rennes Cedex



PNG image

Attachment: smime.p7s
Description: Signature cryptographique S/MIME




Archive powered by MHonArc 2.6.19+.

Top of Page