RE: Key buffer partially unused - why

2007-02-28 Thread Martijn van den Burg
> > Hi, > > > > I have allocated 500MB to key_buffer_size, but only 324MB is in use > > (64%). > > > > Am I right to assume that this can mean one of the > following: (1) all > > indexes have already been cached and together they are just 324 MB, > Do "find /var/lib/mysql -name "*.MYI" -ls" (if

Re: Key buffer partially unused - why

2007-02-20 Thread Christian Hammers
On 2007-02-20 Martijn van den Burg wrote: > Hi, > > I have allocated 500MB to key_buffer_size, but only 324MB is in use > (64%). > > Am I right to assume that this can mean one of the following: (1) all > indexes have already been cached and together they are just 324 MB, Do "find /var/lib/mysq