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 126.96.36.199 store.
I did run the following query, which did not complete:
SET FOREIGN_KEY_CHECKS=0; TRUNCATE `index_event`; SET FOREIGN_KEY_CHECKS=1;
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.