We have a Innodb table with 60 Million Records ( 35 GB total space occupied). We imported all this data with out any indexes. Once We completed the total data porting We intiated the index creation process. We have another 40 GB free space in this Innodb. But still the index creation process is asking us more space when this table is copying to tmp table. Already it took more than 8 hrs and has given space full error.
are we have to set any specific paramters when we are creating the indexes on such big tables ( Innodb).
Please help us guiding the correct way to create the indexes on big tables. ( We started the mysqld server with --big-tables option)