Tagged Questions

1
vote
0answers
53 views

What can lock the only MySQL db process?

A plain old "delete single record" statement froze on me. Suspecting a (dead)lock issue, I checked the process list to see what blocks the delete. The delete statement was the only running db process ...
6
votes
2answers
3k views

MySQL InnoDB database 'hangs' on selects

I'm trying to fix MySQL configuration on our server. Our app's specifics is that a lot of data is stored in single table (currently over 300 millions of rows). This table is used often for inserts ...
0
votes
2answers
634 views

Will dropping AUTO_INCREMENT rebuild table in MySQL?

I've got table with following schema: CREATE TABLE `tblsomething` ( `something_id` int(11) NOT NULL AUTO_INCREMENT, … PRIMARY KEY (`something_id`) ) ENGINE=InnoDB AUTO_INCREMENT=144620955 I ...