InnoDB tablespace Question.

[Dave Juntgen]

Hello!
 
I have what seems to be a trivial question, but have not been able to
find a definite answer and your help would be greatly appreciated.
 
Question:
 
When creating InnoDB table spaces, are there any advantages to using
multi table spaces for each table or is it better to create a few large
table spaces for all tables?
 
If the latter, then is it best to create a very large table space, say
30G, (my OS supports LFS) rather then using the auto extend feature for
table spaces in InnoDB?  What is the over head of the InnoDB auto
extend?
 
Thanks!
 
--Dave J.
 
David W. Juntgen
Medical Informatics Engineering Inc.
Phone: [phone]
Fax  : [phone]