Peter, There is no 1 gig limit that I am aware of. I have been using MySQL 4.1 since the day it was released. And when 4.1.1 came out I switched about half of our machines to using it, and when 4.1.2 comes out in the next week or so, I will switch our stuff that is using 4.1.x to that as well. We are using Fedora core 1 and we don't have a memory limit at all.
Linux does have a 2gig memory limit per process or thread. But MySQL can definitely use more than 1gig of memory.
If it couldn't then I wouldn't be using it.
I think what 1 GB refers to is that on 32-bit Linux, it is a good idea to keep your mysqld buffer memory utilization under 1 GB to keep the thread stacks from running into the heap.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]