Hello Roger, Thank you for your note and replies. Please see my further points inline;
On 29 December 2001 16:21, Roger Baklund wrote; > * Emmanuel van der Meulen > > 1. Assuming the website grows very large with high volumes and > a database > > exceeds disk space, please advise what is the remedy? > > Add HW or remove data...? Not sure if I understand your question... Roger, assuming the database space as allocated is used up and I do not want to remove the data, but I have lots more space to allocate, is there a way to extend allocated space in flight? Or, does MySQL automatically (and inflight) extend beyond allocated space upto as much space which is physically available; I'm referring to the space for the ibdata files. > > 2. Seeing as for the said website I use transactions, thus also > the innodb > > options, please advise whether I can place individual databases > > at different locations. > > Yes, you can. Thank you, please see next point. > > Note; it seems the filename.sym, does not apply to the innodb > > files, therefore only the database table definitions are placed in the > > filename.sym redirecting location. > > I don't understand this, sorry. Roger, I managed to place different databases each at alltogether different locations using the filename.sym option. However, no matter how much data I loaded, the table sizes stay at 9kb. This lead me to assume that when using the innodb option (for transactions), that the data is loaded in the ibdata files. If this is the case then how do I place the ibdata files (related to the innodb option) at different locations for different databases? > > 3. When using innodb options (for transactions), please advise > > whether data is stored in the tables or the innodb files? > > ehhh... don't know if I understand this... the data is stored in > tables (db > teminology) and the tables (thus also the data) are stored in files (os > terminology). Roger, it seems you are not familiar with the innodb option when using transactions. Note from the MySQL PDF format manual, P. 58. "MySQL supports transactions with the InnoDB and BDB Transactional table handlers. See Chapter 7 [Table types], page 441". Or let me rephrase the question; when using the innodb option, ibdata files get used, and my question is; when using the innodb option is the data stored in the table files in the database folder (which do not seem to increase in size no matter how much data I load), or is the data stored in the ibdata files for which I cannot see a way to declare them individually per database. > > 4. Please advise, with different databases do they all share one set of > > innodb files - > > No, each database is stored in separate file folders. Roger again I'm referring to the ibdata files, and if they are stored in a different location, please advise how their location is declared (say each database on a different HDD)? > > thus if this is the case, how is data for > > different databases backed up separately? > > Not a problem. Please advise how I can declare the ibdata files to be at different locations. Thank you again for your assistance. Kind regards Emmanuel --------------------------------------------------------------------- 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
