* Emmanuel van der Meulen > Roger, I attempted adding additional space with a new file under > innodb_data_file_path as follows; > Before: innodb_data_file_path = ibdata1:50M;ibdata2:50M > After : innodb_data_file_path = ibdata1:50M;ibdata2:50M;ibdata3:50M > Stopped and restarted MySQL, but this did nothing. Could you please point > me!
I have no idea, try <URL: http://www.mysql.com/doc/I/n/InnoDB.html > Maybe someone on the list who have actually used the inndb tables could give you a hint...? > Knowing almost nothing about MySQL & InnoDB, I looked at the .frm file, > thinking they are the data files, and they have a file size of 9kb. :) Mystery solved. > This is also my understanding. It scares me. Thus when using MySQL with > InnoDB, all data of all databases on my different website stages, viz., > PROD, QA, DEV would share the same InnoDB dataspace for data. yes, but this is not so bad, is it...? > Thus PROD data is at risk. why? > And furthermore, data cannot be backed up separately. Yes, it can, the mysqldump utility will address the _database_, but you can not do backups of individual databases by simply copying the files on the OS level, like you can with myisam tables. > I feel this is an oversight of MySQL & InnoDB. And let me add further, my > concern is that when I eventually go live, with a HSP, that my data would > thus be shared further with other websites hosted on the same server. It is not a very big difference between one 'tablespace' (or multiple, possibly spanning multiple disks) sharing multiple databases, and one (or more) disks with separate databases in separate files. The database partition can be seen as a kind of filesystem... > Surely I'm overlooking something. Could this please be logged as a major > issue? It is an issue, but I don't think it is a big issue. > InnoDB sharing the same dataspace, and therefore different unrelated > databases's data being at risk. What exactly do you see as a risk? -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
