Re: Commit commands with SELECT

2012-04-13 Thread Stephen Tu
nse that the longer your transaction block is, the more time you spend holding (read) locks, and thus excluding writers. Hope that helps, -- Stephen Tu

Re: why does "select * from table oder by indexed_field" not use key?

2012-07-11 Thread Stephen Tu
On Wed, Jul 11, 2012 at 5:46 AM, Reindl Harald wrote: > > mysql> show profiles; > > > +--++--+ > > | Query_ID | Duration | Query > > | > > > +--