Re: increased disk ops after alter table

2005-02-14 Thread Gleb Paharenko
Hello. The problem could be related to the filesystem layer. You may use a raw disk partition or decrease the size of your tablespace (if it is autoextend). Pradeep Hodigere [EMAIL PROTECTED] wrote: Hi All, I had to do an alter table on a very large InnoDB table (100 million

increased disk ops after alter table

2005-02-11 Thread Pradeep Hodigere
Hi All, I had to do an alter table on a very large InnoDB table (100 million rows avg. row size 300 bytes inclusive of index length). This table is on a 200G disk and the server has 4G RAM. I also archived 50 million rows to another table. So the total table size is now 1/2 of its original.