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 --