Hi! ----- Original Message ----- From: "Dan Nelson" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, April 03, 2004 1:02 AM Subject: Re: innodb_buffer_pool_size limit
> In the last episode (Apr 02), Dathan Vance Pattishall said: > > > -----Original Message----- > > > From: Keith Thompson [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, March 23, 2004 12:46 PM > > > To: [EMAIL PROTECTED] > > > Subject: innodb_buffer_pool_size limit > > > > > > Is there a limit on what innodb_buffer_pool_size can be set in 4.0.17 > > > (64-bit Solaris 9)? > > > > > > I tried setting it to 4G in my.cnf and SHOW VARIABLES says it's 0. > > > > Try setting it to 4096M > > Also be sure your mysqld is a 64-bit binary; unless told to, I think > both gcc and cc default to generating 32-bit programs. I agree with Dan. You can use SHOW INNODB STATUS to check how many 16 kB pages there really are in the InnoDB buffer pool. Maybe the output of SHOW VARIABLES wraps around? > -- > Dan Nelson Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
