Because if you want to pre-load indexes into cache, you need to have same block size for all indexes of a table.
--- Rhino <[EMAIL PROTECTED]> wrote: > I don't know the answer to your question but I'm > curious to know why you > would want to do this. > > Normally, that sort of detail is handled by the > database and should not be a > consideration for any user of the database. In other > words, your queries > should work regardless of whether the block sizes > for indexes are the same > or differ. > > I would be quite surprised if MySQL - or any decent > relational database - > gave you a way to control those block sizes. > > Or is this really a locking question? I'm not sure > how MySQL handles the > management of index pages and the corresponding data > pages that they > represent but DB2 (mainframe) gives you some control > over whether indexes > use full pages or subpages to let you minimize the > number of rows locked by > a given user. The more subpages you use, the fewer > data pages get locked. > However, you also tend to need more index space than > if you didn't use > subpages. > > Rhino > > > ----- Original Message ----- > From: "Haitao Jiang" <[EMAIL PROTECTED]> > To: "mysql" <[EMAIL PROTECTED]> > Sent: Thursday, April 15, 2004 8:34 PM > Subject: Can not get an answer here - how to force > the index block size to > be the same? > > > > > > 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. > > > > I really appreciate any help on this. > > > > Thanks > > > > HT > > > > > > > > > > __________________________________ > > 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] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ 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]
