It's not really necessary for you to adjust that variable.
-Original Message-
From: jitendra ranjan [mailto:jitendra_ran...@yahoo.com]
Sent: Tuesday, August 17, 2010 7:52 AM
To: mysql@lists.mysql.com
Subject: max_seeks_for_key
Hi,
We have myisam tables which has round 10 lak
Hi,
We have myisam tables which has round 10 lakhs of records in each tables.I want
to search the records based on index. What should be the value of
max_seeks_for_key as it is set at default 4294967295.
Thanks in advance.
Jeetendra Ranjan
MySQL DBA
count.
2) Is there some reason that my index trees would not be uniform? Is there
anything I can do about this?
3) For InnoDB tables, does it make sense to always keep max_seeks_for_key at
a low value (1, 100, ?)
Many thanks in advance,
-Bob
- Original Message -
From: <[EMAIL PR
y choosing the wrong index, or
> no index at all, for queries on tables with 20 million rows. Would it be a
> good idea for me to set max_seeks_for_key to 1 (or something less than 4
> billion), in order to force MySQL to use an index? We are using InnoDB.
>
> Since InnoDB has clustered
I am having problems with MySQL inconsistently choosing the wrong index, or no
index at all, for queries on tables with 20 million rows. Would it be a good
idea for me to set max_seeks_for_key to 1 (or something less than 4 billion),
in order to force MySQL to use an index? We are using
