Review the work logic of "Clear history and trends" button from Hosts->Items form: a long-running delete query locking tables may occur thus bringing the whole Zabbix instance down. Make it asynchronous by creating a task to Zabbix housekeeper with required time range to clean (so only entries before the button click are removed). This will put the whole operation to the background.