Never Mind: I set in /etc/my.cnf max_heap_table_size = 256M
and, all is good. Van -- ================================================================= http://www.dedserius.com/ - Linux rocks!!! ================================================================= Van wrote: > > Hey, All: > > I'm getting: > ERROR 1114: The table '#sql-3612_4' is full when trying to convert a MyISAM > table to HEAP with: > ALTER TABLE ns_sum_cats TYPE=HEAP; > > mysql> describe ns_sum_cats; > +----------+---------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +----------+---------------+------+-----+---------+-------+ > | nid | int(10) | | PRI | 0 | | > | Filename | varchar(100) | | MUL | | | > | Cat | varchar(25) | | MUL | home | | > | moddate | timestamp(14) | YES | | NULL | | > +----------+---------------+------+-----+---------+-------+ > 4 rows in set (0.03 sec) > > mysql> select count(*) from ns_sum_cats; > +----------+ > | count(*) | > +----------+ > | 665739 | > +----------+ > 1 row in set (0.06 sec) > > mysql> show indexes from ns_sum_cats; > +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | > Cardinality | Sub_part | Packed | Null | Index_type | Comment | > +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > | ns_sum_cats | 0 | nid | 1 | nid | A > | 665739 | NULL | NULL | | BTREE | | > | ns_sum_cats | 1 | Filename | 1 | Filename | A > | 303 | NULL | NULL | | BTREE | | > | ns_sum_cats | 1 | Cat | 1 | Cat | A > | 1 | NULL | NULL | | BTREE | | > +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > 3 rows in set (0.00 sec) > > max_heap_table_size | 134216704 > tmp_table_size | 553648128 > > Machine is PIII Intel 700 with 512 MBytes RAM running Slackware 9.0. > [EMAIL PROTECTED]:~$ free > total used free shared buffers cached > Mem: 514192 406480 107712 0 22696 195216 > -/+ buffers/cache: 188568 325624 > Swap: 279176 2680 276496 > > [EMAIL PROTECTED]:~$ df /tmp > Filesystem 1k-blocks Used Available Use% Mounted on > /dev/hda1 1007960 195116 761640 21% / > > Anyone else know what I need to increase? > > Thanks, > Van > -- > ================================================================= > http://www.dedserius.com/ - Linux rocks!!! > ================================================================= > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
