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]
