[ale] mysql advice

[jknapka at kneuro.net (JK)]

Jeff Hubbs wrote:

> In MySQL, IIRC, tables map to individual files.


I think that depends upon which DB backend is in use (Inno, Berkeley, etc).


>  MySQL will have the job 
> of sorting out how your multiple write queries to the same table become 
> writes to the same file and because of that, write cache will matter.  
> Some filesystems (e.g., ext4, JFS) may work better than others.


So true.  Managing many concurrent writes to the same table is going to
be a major issue, no matter how those tables map to filesystem entities.
Benchmark, benchmark, benchmark. (Or "profile, profile, profile". Something
like that, anyway.)

-- JK