Hi All

I am really hoping someone can help me with this issue as it is currently bringing the site down multiple times a day!!

We are in the final stages of developing quite a large site on 5.7 but several times a day the site is just hanging infinitely when trying to load. We have established that it is a problem with a SQL Process that is getting stuck and holding up MySQL so that no other SQL queries on that database are being executed, all of the other queries are left in wait mode so the site never loads.

The SQL query that is causing is trying to Update the PageSearchIndex table, in the SQL Processes, unfortunately I cannot see the full query but it begins as the following:

UPDATE PageSearchIndex SET cID = '512', cName = 'Housing', cDescription = '', cPath = '/market-secto

I don't have any of the automated jobs turned on so it is not being called from that, im not sure where it is coming from. It is always that page that it mentions. I have tried editing and publishing the page but that did nothing.

Has anyone else experienced this problem? Or have any suggestions on where to look to work out what is going on?

I am actually not using the Concrete Search so if there is any way of turning off the indexing, that would do the job too!!

Thanks
David