Re: load index into cache not working

2004-11-08 Thread Andrew Clemente
I posted a detailed description of a similar problem one week ago to general and then later to internals with no response to either (title "load index into cache doesn't?"). Using load index into cache to preload a 1GB index into a 2GB cache comes back in 0.0 seconds as 'done'. But there is no di

Re: phpMyAdmin and MySQL 4.1

2004-10-28 Thread Andrew Clemente
> i struggled w/ this for a while, before learning > that even though i had > mysql 4.1 installed, php4 was being compiled w/ it's > own built-in mysql > libraries, which are pre-4.1, hence the error. > compiling php5 will > solve the problem, as it's included mysql libraries > are apparently

LOAD INDEX INTO CACHE doesn't!

2004-10-27 Thread Andrew Clemente
Hi :)  I'm having trouble using "LOAD INDEX INTO CACHE".  It isn't loading any index blocks! I am using 4.1.7-standard, for pc-linux on i686 on a redhat box. mysqladmin debug reports this, before a LOAD INDEX:   Key caches:   default   Buffer_size:    2147483648   Block_size:   1024   Di