1

I am trying create a table using a cross join or Cartesian Product subquery that creates a table with a large number of rows, like at least 148 million rows. I get this

ERROR 1114 (HY000): The table is full.

I plan on filtering and querying the table later on, but how can I create this table?

Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
Dataman
  • 11
  • 1
  • 4

1 Answers1

-2

Check, if you did not run out of disk-space (this is the first step, check the tmp file)

From the comments, You seem to have a too low maximum size for your innodb_data_file_path, You cannot host more than 512MB of data in all innodb tables combined.

I think you should switch to an innodb-per-table scheme using innodb_file_per_table.

AnouarZ
  • 225
  • 2
  • 6