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]
