Disk IOs. DB deadlocks - Page 2 - SmartCJ Support Forum

Disk IOs. DB deadlocks

13 posts

admin: Site Admin; Posts: 37994; Joined: Wed Sep 10, 2008 11:43 am

Re: Disk IOs. DB deadlocks

Quote

Post by admin » Mon Jun 03, 2019 3:36 pm

delete from `rot_gallery_data1` WHERE gallery_id not in (select gallery_id from rot_gallery_info)

Don't forget to run script update

R.A.F.K.: Posts: 29; Joined: Mon Aug 01, 2016 10:53 am

Re: Disk IOs. DB deadlocks

Quote

Post by R.A.F.K. » Tue Jun 04, 2019 11:09 am

почистил, отпишу чуть позже о результатах
-------
upd: все ок, проблемные таблицы больше не разрастаются

Last edited by R.A.F.K. on Thu Jun 06, 2019 10:21 am, edited 1 time in total.

admin: Site Admin; Posts: 37994; Joined: Wed Sep 10, 2008 11:43 am

Re: Disk IOs. DB deadlocks

Quote

Post by admin » Tue Jun 04, 2019 3:20 pm

ok

Don't forget to run script update

Post Reply

13 posts

Return to “Поддержка SmartCJ”