Barnet Wagman wrote:
> I've been working with two simple tests, an INSERT and a SELECT
> <snip>
> Any comments/suggestions re tweaking performance would be appreciated.
Is the insert test running in autocommit mode ?
Running the inserts in autocommit mode is slow as each commit involves a
flush of the log to the disk for each row.
Instead you can try to run with autocommit as false and execute a
number of inserts in one transaction and then explicitly issue a commit.
just curious - were you using the transactional (innodb) storage engine
for mysql and was it set to force logs to disk for every commit ?
Sunitha.
ps: Also, it may be best to run a few repeats of the test to gather
stable numbers.
|