Forum Moderators: coopster

Message Too Old, No Replies

MySQL MEMORY/HEAP table limit of 16 MB on Windows 2008?

I know, I know, windows...

         

rollinj

5:40 am on Jan 10, 2010 (gmt 0)

10+ Year Member



Please, don't ask me why I'm trying to run a web server from Windows, I just am!

So I've hit a limit of 16.0 MB on my MEMORY table... Thank goodness for "or die(mysql_error)" or I never would have noticed or thought that my "table is full" ...?

I've added the following to my my.ini file (the windows version of my.cnf):
"[mysqld]
#set max MEMORY table size to about 294 megs..
max_heap_table_size = 294967295"

And even after re-starting the IIS server, dropping the MEMORY table, and creating it again, I'm still hit with this mysterious 16Megabyte limit...

Anyone have any experience with this? Thanks.

rollinj

7:48 am on Jan 11, 2010 (gmt 0)

10+ Year Member



Woooooop, false alarm...

Re-setting IIS doesn't reset MySQL :P