We're starting to use mysql (4.0.25) on an amd64 machine (running NetBSD-3). One of the reasons for doing this is to use much more RAM - we tend to thrash the key_buffer on i386 because one of our indexes is 10GB in size (the table is 15GB).
It appears that mysqld won't start if the setting for key_buffer is more than 2GB. 053419 11:34:15 Starting mysqld daemon with databases from /var/mysql 053419 11:34:15 mysqld started mysqld: Couldn't allocate stack for idle thread!: Cannot allocate memory 053419 11:34:15 STOPPING server from pid file /var/mysql/vern.landsonar.com.pid 053419 11:34:15 mysqld ended I'd like it to be 10GB (we have 16GB of RAM). I'm guessing that the variable(s) that deal with the key_buffer are 32-bit ints ... is there a straightforward way to find all the relevant places and make them 64-bit ints? Or is the problem that every thread is ending up with its own key_buffer, so there isn't enough memory to do this? Or something else? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
