Paul
I wanted to pre load keys into cache which is larger
than the total index size:
-----------------------------------------------
Reading table information for completion of table and
column names
You can turn off this feature to get a quicker startup
with -A
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 99 to server version:
4.1.1-alpha-Max
Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.
mysql> load index into cache MuzeTable;
+-----------------+--------------+----------+-----------------------------------
+
| Table | Op | Msg_type | Msg_text
|
+-----------------+--------------+----------+-----------------------------------
+
| mysql.MuzeTable | preload_keys | error | Indexes
use different block sizes
|
| mysql.MuzeTable | preload_keys | status |
Operation failed
|
+-----------------+--------------+----------+-----------------------------------
+
2 rows in set (0.00 sec)
------------------------------------------------------
I check the blocksize of the indexes, some of them are
1024, some are 2048.
Any idea how to solve this?
Thanks a lot!
Haitao
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 20:25 -0700 4/15/04, Haitao Jiang wrote:
> >Paul
> >
> >Because I want to use the "load index into
> cache..."
> >to pre-load the indexes into cache. But I can not
> use
> >this feature since the block size of indexes are
> >different (1024 vs. 2048), and the "load index into
> >cache.." complains about it.
> >
> >Any idea?
> >
> >Thanks a lot!
>
> I'm afraid that's pretty vague. What does your
> table structure
> look like? What does your LOAD INDEX statement look
> like? What
> is the result of the statement?
>
>
> >
> >Haitao
> >--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> >> At 17:34 -0700 4/15/04, Haitao Jiang wrote:
> >> >It seems to be either a hard question or stupid
> >> >question:). Is there anyway in Version 4.1.1 I
> can
> >> >force all the indexes to have same block size?
> Say
> >> >2048? If it is plain impossible without
> changing
> >> the
> >> >source code, please let me know.
> >>
> > > Why do you care about this?
>
>
> --
> Paul DuBois, MySQL Documentation Team
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
__________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
http://taxes.yahoo.com/filing.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
