After running a specific query in my DB, the entire DB is very very slow.
I can see a huge decrease in performance on my 220.127.116.11 store.
I did run the following query, which did not complete:
I got the error; Cannot truncate a table referenced in a foreign key constraint
After that, the DB is very slow. Load on pages on backend and frontend +2 sec.
What causes this issue and how can I solve this?
UPDATE: When enabling Product Flat Data index, I get the error that there was a error with indexing. This worked perfectly before.