MySQL - Table is full

1

When I try to upload a file to a table from my mysql database the system returns the error Table is Full. However, I have other tables that are larger and heavier than this table that do not have this error. The error table has approximately 300MB. I already set the variable innodb_file_per_table = 1

But I was not able to set innodb_data_file_path in my.cnf because every time I hit the variable mysql service did not start, although I only add the lines:

[mysqld]
innodb_data_file_path = 'ibdata1:10G:autoextend'

I've tried this other method presented here with ALTER TABLE but it did not work either. I checked the disk space with the df -h command, and all partitions have plenty of free space. I do not know what it could be anymore.

Adding the code mentioned in Raylan's comment resulted in a mysql startup error, so I fixed my my.cnf to:

[innodb]
innodb_data_file_path = ibdata1:10G:autoextend:max:10G

And yet the Table is full error persists.

Typing the code mysql on the server appears unknown variable 'innodb_data_file_path=ibdata1:10G:autoextend:max:10G'

In another attempt I made a DROP TABLE and even now with the empty table the error continues. I do not know where else to go.

The command to create the table was:

    CREATE TABLE auxiliar_MA.HT_MA4_SBX_SEG
    (
      TS_SAMPLETM  DATETIME
    , VL_M4000109 DOUBLE
    , VL_M4000110 DOUBLE
    , VL_M4000111 DOUBLE
   ...
    , VL_M4000669 DOUBLE
    , VL_M4000674 DOUBLE
    , VL_M4000675 DOUBLE
    , VL_M4000676 DOUBLE
    )
    ;

Thank you in advance.

    
asked by anonymous 03.02.2016 / 18:01

0 answers