"MY TABLE" based on Innodb with composite primary key because I am storing many trees inside this table. The PK is for example
1- Does Innodb store rows with same (a,b,c) near together?
2- Does every
(a,b,c) add one 'page' (at least 4 kb) and so increase my table size?
3- Does this query almost checks all table?
Select * from mytable where a='1' and b='2' So it would be faster if I user 'MyIsam' and use secondary index (a,b) ?
PS: I edited and removed that question. (yeah,that was really funny :) )