I have table having 5 million data on production server. my database is mysql. when I fire delete query, I faced below error
Error code 1205 Lock wait timeout exceeded, try restarting transaction
I want to delete the data.
Asked
Active
Viewed 1,288 times
0
James Z
- 12,209
- 10
- 24
- 44
samar kadam
- 33
- 1
- 1
- 6
-
You want to delete all ? if yes a better way is `truncate table_name` – Abhik Chakraborty Oct 09 '15 at 07:54
-
Look at this one: http://stackoverflow.com/questions/2766785/fixing-lock-wait-timeout-exceeded-try-restarting-transaction-for-a-stuck-my. Maybe it'll help. – Alex Oct 09 '15 at 07:55
-
Run query "CHECK TABLE table_name EXTENDED;", In my opinion this table damaged. – 4EACH Oct 10 '15 at 05:35