Does the order, arrangement or grouping of columns with large (such as long text descriptions) and small (such as bit and tinyint) field types have any noticeable impact on MySQL (InnoDB engine) querying performance when table sizes get large and JOINs need to be done on them? E.g. should I put all of the bit/tinyint fields first?
What about most common queries? Could querying be faster if one were to front load the table with what might be the most commonly used columns?
Based on this (and/or other considerations), should I plan my table structure based on the field type, or is something like an alphabetical order just as good?