Sounds like this is what you want: http://dev.mysql.com/doc/mysql/en/handler.html
Atle - Flying Crocodile Inc, Unix Systems Administrator On Wed, 13 Apr 2005, Homam S.A. wrote: > Is there a way to use dirty reads (that acquire no > read locks on the table) with MyISAM tables? > > I want to avoid having the read requests queuing up > while the table is updated, and I can tolerate a small > margin of inconsistency for the sake of throughput. > > So far I found only information about scheduling cues > (e.g. LOW_PRIORITY, DELAYED, etc) and using table > handlers, but even with these cue, you still have the > potential of queuing up reads or starving updates. > > For example, in MS SQL Server, you can either give a > per-query lock hint or use a read-uncommitted > transaction isolation level. > > MyISAM doesn't have a SET TRANSACTION READ UNCOMMITTED > equivalent to InnoDB, and the SELECT statement doesn't > have lock hints like (NOLOCK). > > So is there a way to allow reads to go through when > the table is updated, or allow updates to proceed > without waiting for prending reads to finish up? > > Thanks, > > Homam > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
