Joe Ellis wrote:
>
> Just For My Info: does it take long for one insert. if so, what does
> the insert statement look like. the reason i ask is becuase i use
> InnoDB and inserted a few records and it was pretty quick. but maybe
> thats becuase my statement was:
> insert into table (user,email
Just For My Info: does it take long for one insert. if so, what does
the insert statement look like. the reason i ask is becuase i use
InnoDB and inserted a few records and it was pretty quick. but maybe
thats becuase my statement was:
insert into table (user,email,firstname,lastname) values
Norman Khine wrote:
>
> Welcome to the MySQL list;^) good to see you here...
*grinz* It's weird being a newbie again :-P
> "In inserts InnoDB uses the insert buffer to merge secondary index records
> to indexes in batches. That saves a lot of disk i/o. In rollback no such
> mechanism is used, a
Hi Chris,
Welcome to the MySQL list;^) good to see you here...
Any way I found a link which might explain why your InnoDB inserts take
longer, perhaps this may be the reason...
http://www.mysql.com/doc/S/E/SEC418.html
"In inserts InnoDB uses the insert buffer to merge secondary index records
to