locking problems......

[Macspeed]

Hi everyone,
One of my table will be receiving inserts 24/7/365, every few seconds.
This table needs will be used to generate reports. But when inserts are running and I run a long query, I start to get timeout errors on the client and others locking problems.

In SQL Server, READPAST allows to perform a query skipping anything that's locked. What equivalent solution can offer MySQL? Any idea?
Thank you. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Renne]

If using MyISAM tables and never delete anything from them, INSERTS will automatically run in parallel to queries.

If you need to delete something from time to time, try to do it in big bunches and run OPTIMIZE afterwards.

MyISAM always locks the whole table. If you want to have row locks, ALTER the table to an InnoDB table. Also, tune your application by using the optimal isolation level then. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --