Re: InnoDB interaction between secondary and primary keys.

2013-02-01 Thread Jeremy Chase
; > -Original Message- > > From: Rick James > > Sent: Wednesday, January 30, 2013 1:08 PM > > To: 'Jeremy Chase'; mysql@lists.mysql.com > > Subject: RE: InnoDB interaction between secondary and primary keys. > > > > secondarykey and r

RE: InnoDB interaction between secondary and primary keys.

2013-01-30 Thread Rick James
ql@lists.mysql.com > Subject: RE: InnoDB interaction between secondary and primary keys. > > secondarykey and redundantkey are redundant with each other -- in all > versions of InnoDB. > > One "expert" said that redundant key would have two copies of `1`,`2`. > I think h

RE: InnoDB interaction between secondary and primary keys.

2013-01-30 Thread Rick James
secondarykey and redundantkey are redundant with each other -- in all versions of InnoDB. One "expert" said that redundant key would have two copies of `1`,`2`. I think he is wrong. I believe the two are the same in size. There is a subtle change in 5.6 that _may_ make a _few_ queries work be