Discuz!x3.2 用久了(特别是一个版本一个版本升级上来的) 短信内容容易堆积导致 数据库缓慢 可以使用以下句子 清理下 无效短信:
- DELETE FROM `pre_ucenter_pm_messages_1` WHERE `delstatus`='1' or `delstatus`='2';
- DELETE FROM `pre_ucenter_pm_messages_2` WHERE `delstatus`='1' or `delstatus`='2';
- DELETE FROM `pre_ucenter_pm_messages_3` WHERE `delstatus`='1' or `delstatus`='2';
- DELETE FROM `pre_ucenter_pm_messages_4` WHERE `delstatus`='1' or `delstatus`='2';
- DELETE FROM `pre_ucenter_pm_messages_5` WHERE `delstatus`='1' or `delstatus`='2';
- DELETE FROM `pre_ucenter_pm_messages_6` WHERE `delstatus`='1' or `delstatus`='2';
- DELETE FROM `pre_ucenter_pm_messages_7` WHERE `delstatus`='1' or `delstatus`='2';
- DELETE FROM `pre_ucenter_pm_messages_8` WHERE `delstatus`='1' or `delstatus`='2';
- DELETE FROM `pre_ucenter_pm_messages_9` WHERE `delstatus`='1' or `delstatus`='2';
- DELETE FROM `pre_ucenter_pm_messages_0` WHERE `delstatus`='1' or `delstatus`='2';
复制代码 |
|