Re: R: [Dbmail] Advantages of innodb_file_per_table (was: Table dbmail_messages is full)

Andrea Brancatelli wrote: Summarizing everything: - If you have a single DB server: use a shared InnoDB tablespace preallocating the space and disabling the autoextend. Using the optimize table will give you a better optimization of the tables, and you'll have no problem with the space as it

R: [Dbmail] Advantages of innodb_file_per_table (was: Table dbmail_messages is full)

reclaim your space back whenever you delete anything or whenever any table will significantly decrease in size. Doubt? Question? Fear? Panic? -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Peter Rabbitson Inviato: martedì 31 luglio 2007 16.52 A: DBMail ma

[Dbmail] Advantages of innodb_file_per_table (was: Table dbmail_messages is full)

Hi, Sorry for hijacking the thread. Can someone clarify what is the advantage of using innodb_file_per_table versus one infinitely growing tablespace? Thanks Peter ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/