--0-779675863-1282056716=:45656
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi,
=A0
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.
=A0
Thanks in advance.
=A0
Jeetendra Ranjan
MySQL DBA
--0-779675863-1282056716=:45656--
It's not really necessary for you to adjust that variable.
-----Original Message-----
From: jitendra ranjan [mailto:jitendra_ranjan@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 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
This message contains confidential information and is intended only for the=
individual named. If you are not the named addressee, you are notified th=
at reviewing, disseminating, disclosing, copying or distributing this e-mai=
l is strictly prohibited. Please notify the sender immediately by e-mail i=
f you have received this e-mail by mistake and delete this e-mail from your=
system. E-mail transmission cannot be guaranteed to be secure or error-fre=
e as information could be intercepted, corrupted, lost, destroyed, arrive l=
ate or incomplete, or contain viruses. The sender therefore does not accept=
liability for any loss or damage caused by viruses or errors or omissions =
in the contents of this message, which arise as a result of e-mail transmis=
sion. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089,=
USA, FriendFinder.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg