MySQL用户创建的临时表已满 [英] MySQL user created temporary table is full

问题描述

我使用内存引擎创建了一个临时表，如下所示:

I have a created a temporary table using the memory engine as followed:

CREATE TEMPORARY TABLE IF NOT EXISTS some_text (
    id INT DEFAULT 0,
    string varchar(400) DEFAULT ''
) engine = memory;

当我向其中插入行时，由于表已满，我遇到了#1114错误.它在mysql文档中解释说，更改tmp_table_size和max_heap_table_size并不会增加用户创建的临时表的大小，这是我认为的.我要如何扩大这张桌子?

When I insert rows into it I run into a #1114 error because the table is full. It explains in the mysql docs that changing the tmp_table_size and the max_heap_table_size don't do anything for increasing the size of user created temp tables, which is what I think I have here. How do I go about making this table larger?

我希望能够通过调用SET动态地执行此操作，但是我尝试设置tmp_table_size和max_heap_table_size，它们都远远超出了我在此表中期望的数据量.那么，有谁知道如何解决此表上的此错误?谢谢任何帮助的人.

I would love to be able to do this dynamically with a call to SET, but I've tried setting tmp_table_size and the max_heap_table_size and they are both well beyond the amount of data I am expecting in this table. So does anyone know how to resolve this error on this table? Thank you to anyone who helps.

推荐答案

max_heap_table_size是对使用MEMORY存储引擎的任何表(临时表或其他表)的大小的限制.您必须增加此配置选项，才能在表中存储更多数据.

max_heap_table_size is a limit on the size of any table (temporary or otherwise) that uses the MEMORY storage engine. You'll have to increase this config option to store more data in the table.

这篇关于MySQL用户创建的临时表已满的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！