Lakshmi,
----- Original Message ----- From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 18, 2004 1:07 PM
Subject: Reg Table spaces and Rollback segments in MySQL 4.0.21
Hi ALL, We are using MySQL 4.0.21 with InnoDB. For creating the tablespace mentioned as innodb_data_file_path =3D 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?.
in MySQL-4.0, there is just one tablespace. It consists of the ibdata files, that are thought of as catenated.
Actually if we set autocommit=3D0, 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?
No need to create them. InnoDB creates the 'rollback segment' automatically in the ibdata files.
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?
In Oracle, rollback segments can become a bottleneck, but not in InnoDB. No need to create more of them.
Please advise us for the solution.
Thanks, Narasimha
please address these general MySQL questions to [EMAIL PROTECTED]
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
