zl

通过系统进程排查1.使用top命令确定进程pid可以看到有较多会话进程消耗CPU达到100%，然后找到这些存在问题的进程查看具体信息[oracle@ajdbosread 12.1.2]$ ps -ef | grep 432705oracle 432705 1 87 09:28 ? 02:13:13 oraclequerydb (LOCAL=NO)确认进程为远程连接后，使用如下SQL得到执行SQL的具体信息2.获取执行SQLSELECT /*+ ORDERED

使用or会导致sql无法使用索引。可以使用union进行改写SELECT `member_id` FROM `feel_member` WHERE ( `account` = 'leader' OR `mobile` = 'leader' OR `email` = 'leader' OR `name` = 'leader' ) AND `type` = 1 AND `closed` = 0 LIMIT 1;以selec

单列索引和复合索引的选择问题SQL：mysql>explain SELECT product_subject_rule_id, property_type, property_value, product_subject_id, submited_num, created_at, updated_at, enabled FROM product_subject_rule WHERE ( product_subject_id.