Hello.
> Is there any advantages to having one single ibdata file, or is it better to > have several, and if so, how many? As said at: http://dev.mysql.com/doc/mysql/en/innodb-configuration.html You may get some performance improving if you put the files on the different disks. I think that using several files on the same disk, doesn't give a great performance hit. Alfredo Cole <[EMAIL PROTECTED]> wrote: > 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. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
