I've got a set of transactions for storing stuff in a database which runs
slower and slower and slower as the tables get larger.
The traffic graph in MySQL Administrator goes up and up as the Number of SQL
Queries graph goes down and down.
There is nothing obviously wrong with any of the queries in the
transaction - they've all got sensible indexes, and none of them returns any
significant amount of data, which is why the bytes_sent figure (the Traffic)
graph is puzzling.
(I haven't yet checked running MySQL and the client on separate boxes and
getting a ...