truncate table ...

2002-12-03 Thread Sekhar.Thota
Dear All, I am getting a severe problem with truncate comand( InnoDB Tables - Mysql 3.23.52-MAX on Linux 7.3) . The scenario is: I have a table with more than 100 Million records. I gave a truncate table command to delete all the data from this table. Once I gave th

RE: data migration

2002-09-05 Thread Sekhar.Thota
Hi, I am using sqlporter utility for the data migration. You can download the trail version and can use. Regards, Sekhar -Original Message- From: Khanh Pham-Phu [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:32 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re:

urgent ...

2002-09-04 Thread Sekhar.Thota
Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar -

row level locking .. urgent

2002-09-03 Thread Sekhar.Thota
Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar -

Row level Locking

2002-09-03 Thread Sekhar.Thota
Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar

Rowlevel Locking

2002-09-03 Thread Sekhar.Thota
Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar -