我想优化我下面的SQL查询,目标是在3-4秒内获得结果。 ((select data from t_sayac_degerler where id = (select max(id) from t_sayac_degerler where adres = '1.8.0' and tarih between '2016.02.15 11:00' and '2016.02.16 17:13')) (select data from t_sayac_degerler where id = (select
我的服务器上的mysql有一个严重的性能问题。我有一个很大的表,不是按行数(~900,000行)计算的,而是按列数(~90列)和大量索引(~30个索引)计算的(这是Innodb表)。CATALOG where PUBLISH = 1 and (Exclusions = 2 or Exclusions is null) |mysql);| COUNT(*) || 900872 |1 row