Hi ALL,
We are using MySQL 4.0.21 with InnoDB. For creating the
tablespace mentioned as innodb_data_file_path = ibdata1:10M:autoextend
in my.cnf file. Here, is there a facility to know the table space name?.
Shall we create multiple table spaces like the above in MySQL 4.0.21
and assign different tables to different table spaces?.
Actually if we set autocommit=0, we are able to do the perform rollback
and commit and is working as expected in different sessions. I think
rollback segments are creating internally. Is there any facility to
mention the rollback segment size?. Shall we create our own rollback
segments in MYSQL 4.0.21?
PS: Whenever Oracle Database is created Rollback segments were created
in the "System" tablespace". Also, have the option of creating more
Rollback segments in the non system tablespace. Do we have the same
facility in MySQL 4.0.21?
Please advise us for the solution.
Thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and any attachments to
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL
PROTECTED] immediately
and destroy all copies of this message and any attachments.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
