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]