On 091110, Boehm, Matthew wrote:
> Interestingly, if I run the "update_index" bench (ie: UPDATE table SET
> indexedColum=indexedColumn+1 WHERE PKcolumn=<rand>), that one runs just
> fine all the way up to 256 threads.
>
> But if I try the update_nonindex, (ie: UPDATE table SET
> nonIdxColum='<random 100 char string>' WHERE PKcolumn=<rand>), that is
> the one that fails right away on the 64/128/256 thread bench.
Updating indexed column takes lots of time (relatively speaking).
So maybe that's what keeps the traffic low enough to not hit
send buffer limit.
If binlogging is off and you're not selecting masses of data
to API, that leaves the update traffic. Maybe somebody else
knows if it's possible to hit send buffer limit here.
--
Pekka Nousiainen, Software Engineer, Sun Microsystems / MySQL
