Delayed errors and Handler_read_rnd_next?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
anivad
Forum Commoner
Posts: 80
Joined: Thu Apr 09, 2009 11:16 pm

Delayed errors and Handler_read_rnd_next?

Post by anivad »

I'm getting a lot of delayed_errors in my MySQL status report, and it says: "The number of rows written with INSERT DELAYED for which some error occurred (probably duplicate key)."

What does it mean by 'duplicate key'?
I have no INSERT DELAYED commands at all. :/

Handler_read_rnd (The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.)
and Handler_read_rnd_next (The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.)

were also flagged, but all my explicit JOINs are indexed properly.

I'm guessing that some queries are counted as joins even when there's no explicit JOIN command, but what are these queries and how do I recognise them?

Thanks!
Post Reply