[TYPO3-dev] BLOBs considered harmful

[Martin Kutschker]

Dmitry Dulepov schrieb:
> Hi!
> 
> Martin Kutschker wrote:
>> "Only" if you have deleted rows in the table. If you never delete rows 
>> or always optimize after a delete you have full write speed :-)
> 
> Nope. I watched myisam table on a server with constant read-write, 
> hundreds per second (~700tps). MySQL locks table all the time. If once 
> mysql process writes there, all others appear as "Locked" in "show 
> processlist". It is different with innodb: nothing is locked, 
> INSERT/UPDATE/SELECT run at the same time. I do not have any "LOCK TABLES".

Hm, I was just retelling what the docs say. They claim that if Myisam 
table has no "lost records" (I don't recall the correct term) then Mysql 
will add rows to the end of the table without locking it.

Masi