----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
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:kjt@stripped]
> > > Sent: Tuesday, March 23, 2004 12:46 PM
> > > To: mysql@stripped
> > > 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
> Dan Nelson
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
Register now for the 2004 MySQL Users Conference!