I am using Mysql(INNODB) and does Mysql locks table when I do some insert operation?
I have a huge table and it has lots of indexes. I do some research and Mysql doc says INNODB only locks rows not the entire table but I have indexes and does it still only locks rows? My insert queries nearly takes 36 seconds.
Query_time: 35.829970