Tag Info

New answers tagged


Probably you have an ordinary "cold cache" case. When you INSERT 10,000 rows into a table, the rows need to be added to the appropriate place(s) in the "data". Also, 10,000 entries need to be added to each index's BTree. (How many indexes do you have? Please provide SHOW CREATE TABLE.) If you have AUTO_INCREMENT, then the rows will be "appended" to the ...

Top 50 recent answers are included