I've been reading (and reading...) the innodb documentation about using the innodb_file_per_table directive, and one thing still confuses me. If i use this directive, then is it correct that the setting innodb_data_file_path will specify the shared innodb information? Also, when i create databases, there will be a directory created off of datadir that will hold all the separate innodb table files for that database. I.E. when i do: > Create database innodb_test; # this creates a directory [datadir]/innodb_test/
and when i issue: > use database innodb_test; > Create table test_1 (... )type=InnoDB; # this creates files: # [datadir]/innodb_test/test_1.frm # [datadir]/innodb_test/test_1.ibd And when i create a separate db, say innodb_test_2 then basically the same thing happens, but in directory innodb_test_2 ? What i want to do is have separate physical drives mounted in subdirectories of [datadir], so each physical disk holds separate databases. There will also be smaller DBs on the physical drive that [datadir] is on. Am i understanding all of this correctly? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
