Re: MySQL - HEAP table type

From:	John Nichel	Date:	Sun, 14 May 2006 02:49:28 +0000
Subject:	Re: MySQL - HEAP table type
References:	1	Groups:	php.general
Request:	Send a blank email to php-general+get-236137@lists.php.net to get a copy of this message

Martin Zvarík wrote:

Hi, I am sorry for this not being really a PHP question

So you know it's off topic, yet you're going to ask anyway.

MySQL database, I have a table, which is HEAP (memory) type and I found out I can store only about 22000 entries in it, then when I want to insert new entry it gives me an error that the table is full. The question is: How can I increase this limit?

Well, you could read the *MySQL* manual. You could search Google. You could search the archives for the *MySQL* mailing lists. If none of that bears fruit, you could post this question on the *MySQL* mailing list. <being good boy> In an ongoing effort to provide better answers, I didn't use RTFM, STFW or STFA. </being good boy> -- John C. Nichel IV Programmer/System Admin (ÜberGeek) Dot Com Holdings of Buffalo 716.856.9675 jnichel@dotcomholdingsofbuffalo.com