Re: Error optimize table : The table '#sql-1be4_8' is full
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
Subject
Views
Written By
Posted
3874
April 10, 2008 05:46AM
2013
April 10, 2008 12:58PM
Re: Error optimize table : The table '#sql-1be4_8' is full
2095
April 11, 2008 02:01AM
1922
April 10, 2008 04:25PM
1875
July 03, 2008 11:23AM
1790
July 24, 2008 12:27AM
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.