Re: Table locking questions

2002-08-15 Thread Pekka Saarinen
At 8/15/2002, you wrote: >Hi everyone! > >I'm fairly familiar with the table locking methods in MySQL but I have a >problem I can't solve. > >I have two main tables which are read simultaneously by many clients. The >clients only do reads, but they do it very extensively and for 30 secs each. > >T

Table locking questions

2002-08-15 Thread Claus Reestrup
Hi everyone! I'm fairly familiar with the table locking methods in MySQL but I have a problem I can't solve. I have two main tables which are read simultaneously by many clients. The clients only do reads, but they do it very extensively and for 30 secs each. The two main tables needs updates e