MySQL Forums
Forum List  »  InnoDB

Re: Error optimize table : The table '#sql-1be4_8' is full
Posted by: Delphine PIN
Date: April 11, 2008 02:01AM

Hi,

Thanks for your messages.

1. show variables like 'innodb_data_file_path';
=>
+-----------------------+------------------------+
| Variable_name | Value |
+-----------------------+------------------------+
| innodb_data_file_path | ibdata1:10M:autoextend |
+-----------------------+------------------------+

=> autoextend is well configured !

My ibdata1 file is 74 Mo, and the logfiles are 24Mo.


2. The table to optimize is big (1.9 Go). You say to be sure to have enough space in the tablespace to hold 2 copies of the table.
But how can I know this ?

What is the tablespace ? Is it ibdata1 ? Autoextend is well configured, what should I do ?...
If it is the available space on the hard disk, it's ok, I have enough space...


Thanks for your help.

Delphine

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error optimize table : The table '#sql-1be4_8' is full
2095
April 11, 2008 02:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.