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!
Delayed errors and Handler_read_rnd_next?
Moderator: General Moderators