it will lock the table,read and write are blocked during the process.
-原始邮件-
发件人: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
发送时间: 2007年11月19日 15:24
收件人: MySql
主题: Alter table
Hi Everybody,
I would like to know that, while changing storage engine from one type to
another loc
Hi Everybody,
I would like to know that, while changing storage engine from one type to
another locks that table or not.
alter table engine=myisam;
alter table engine=innodb;
During the process of changing storage engine from one type to another.
Whether it will work fine for an online system.
Joris Kinable wrote:
Good evening,
I've got to create a very large table: 180GB of data has to be stored.
In order to to this I'm using the following steps:
1. Create database structure including keys.
2. Disable keys: ALTER TABLE ut_netflow_4 DISABLE KEYS
3. Load data into the database.
4. Gen
Good evening,
I've got to create a very large table: 180GB of data has to be stored.
In order to to this I'm using the following steps:
1. Create database structure including keys.
2. Disable keys: ALTER TABLE ut_netflow_4 DISABLE KEYS
3. Load data into the database.
4. Generate all index keys: m
At 02:05 PM 11/16/2007, you wrote:
How do you import the data?
Load data from file is faster thought
so better to export myisam -> file and then you do load data from file
make sure you set autocommit=0 to make it faster
Ady,
Sure but won't the entire Load Data will still be wrapped in a
