Using MySQL 4.1.10, SuSE 8.2 Pro, reiser file system.

Hi:

I have been trying to locate a reference which would provide guidelines to 
determine if one ibdata should be used, or when to use several (two, three, 
etc.), but I can not seem to find anything in the manual. I have tried a 
single ibdata file for my 5 Gb database (which is going to grow as history 
gets added to it), two and even three ibdata files, the last with the 
autoextend argument. I have not seen a difference in performance so far.

Is there any advantages to having one single ibdata file, or is it better to 
have several, and if so, how many? If you could point me to a url where I can 
read about this, I would greatly appreciate it.

Thank you and regards.

-- 
Alfredo J. Cole
Grupo ACyC
www.acyc.com - www.clshonduras.com - SolCom - www.acycdomains.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to