Moodle
  1. Moodle
  2. MDL-22470

Performance problem in datbase activity module - missing index

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: 1.9.8
    • Fix Version/s: None
    • Labels:
    • Environment:
      Apache + MySQL (MyISAM) running on server with 2 x Quad-Core Xeon, 4 GB RAM, Ubuntu Server edition 8.04 LTS
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Rank:
      6025

      Description

      In a database activity with many entries (approx. 1200), performance was very low for e.g. the list view to be displayed. Pages needed up to 5 seconds to be generated, causing 100% load on one CPU core, on an otherwise idle server.

      The problem turned out to be caused by queries of the following type:

      SELECT COUNT(DISTINCT c.recordid) FROM mdl_data_content c,mdl_data_records r,mdl_data_content cs, mdl_user u WHERE c.recordid = r.id
      AND c.fieldid = 32
      AND r.dataid = 10
      AND r.userid = u.id
      AND cs.recordid = r.id

      More precisely, there is no usable index for the "cs.recordid = r.id" join, which leads to full table scans.

      Adding an index in the "mdl_data_content" table, on the "recordid" column, improved performance dramatically.

        Activity

        Henning Bostelmann created issue -
        Hide
        Alex Djachenko added a comment -

        We are have this problem too: a lot of SQL-queries ???? runing more th?n several houes.I t's very big perfomance problem - it can broke the site down.

        977547 Query 424858 statistics SELECT COUNT( DISTINCT c.recordid )
        FROM mdl_data_content c, mdl_data_records r, mdl_data_content cs, mdl_user u, mdl_data_content c1178, mdl_data_content c1179, mdl_data_content c1180, mdl_data_content c1181, mdl_data_content c1183, mdl_data_content c1184, mdl_data_content c1185, mdl_data_content c1186, mdl_data_content c1188, mdl_data_content c1189, mdl_data_content c1190, mdl_data_content c1191, mdl_data_content c1192, mdl_data_content c1193, mdl_data_content c1194, mdl_data_content c1195, mdl_data_content c1196, mdl_data_content c1197, mdl_data_content c1198, mdl_data_content c1199, mdl_data_content c1202, mdl_data_content c1205, mdl_data_content c1206, mdl_data_content c1207, mdl_data_content c1208

        WHERE c.recordid = r.id
        AND r.dataid =116

        AND r.userid = u.id
        AND cs.recordid = r.id
        AND u.id =1
        AND c1178.recordid = r.id
        AND c1179.recordid = r.id
        AND c1180.recordid = r.id
        AND c1181.recordid = r.id
        AND c1183.recordid = r.id
        AND c1184.recordid = r.id
        AND c1185.recordid = r.id
        AND c1186.recordid = r.id
        AND c1188.recordid = r.id
        AND c1189.recordid = r.id
        AND c1190.recordid = r.id
        AND c1191.recordid = r.id
        AND c1192.recordid = r.id
        AND c1193.recordid = r.id
        AND c1194.recordid = r.id
        AND c1195.recordid = r.id
        AND c1196.recordid = r.id
        AND c1197.recordid = r.id
        AND c1198.recordid = r.id
        AND c1199.recordid = r.id
        AND c1202.recordid = r.id
        AND c1205.recordid = r.id
        AND c1206.recordid = r.id
        AND c1207.recordid = r.id
        AND c1208.recordid = r.id
        AND u.firstname LIKE '%????%'
        AND u.lastname LIKE '%????????????%'
        AND ((c1178.fieldid =1178
        AND c1178.content = '???????????'))
        AND ((c1179.fieldid =1179
        AND c1179.content LIKE '%??? ? 504%'))
        AND ((c1180.fieldid =1180
        AND c1180.content LIKE '%??? ??????? ??? ???????????????? ???? ? 504%'))
        AND ((c1181.fieldid =1181
        AND c1181.content LIKE '%???????????? ???? ?????????%'))
        AND ((c1183.fieldid =1183
        AND c1183.content LIKE '%http://www.detsad504.ru%'))
        AND ((c1184.fieldid =1184
        AND c1184.content LIKE '%dsad504@rambler.ru%'))
        AND ((c1185.fieldid =1185
        AND c1185.content LIKE '%2011%'))
        AND ((c1186.fieldid =1186
        AND c1186.content LIKE '%1%'))
        AND ((c1188.fieldid =1188
        AND c1188.content = '???'))
        AND ((c1189.fieldid =1189
        AND c1189.content = '???'))
        AND ((c1190.fieldid =1190
        AND c1190.content LIKE '%???????????? ???? ???????????%'))
        AND ((c1191.fieldid =1191
        AND c1191.content LIKE '%?????-?????????%'))
        AND ((c1192.fieldid =1192
        AND c1192.content LIKE '%Pichun@mail.ru%'))
        AND ((c1193.fieldid =1193
        AND c1193.content LIKE '%28.07.1986%'))
        AND ((c1194.fieldid =1194
        AND c1194.content = '?????? ??????????????'))
        AND ((c1195.fieldid =1195
        AND c1195.content LIKE '%?????????? ?????????????? ??????????????? ???????????%'))
        AND ((c1196.fieldid =1196
        AND c1196.content LIKE '%2009%'))
        AND ((c1197.fieldid =1197
        AND c1197.content LIKE '%??????????????%'))
        AND ((c1198.fieldid =1198
        AND c1198.content LIKE '%??????? ???????? ????? ? ??????????%'))
        AND ((c1199.fieldid =1199
        AND c1199.content LIKE '%1 ???%'))
        AND ((c1202.fieldid =1202
        AND c1202.content = '??? ?????????'))
        AND ((c1205.fieldid =1205
        AND c1205.content LIKE '%(495)9412463%'))
        AND ((c1206.fieldid =1206
        AND c1206.content LIKE '%(495)1958343%'))
        AND ((c1207.fieldid =1207
        AND c1207.content LIKE '%(903)6144061%'))
        AND ((c1208.fieldid =1208
        AND c1208.content LIKE '%\"????????? ???????????\"2010,2 ?????%'))

        981388 Query 422135 statistics SELECT COUNT( DISTINCT c.recordid )
        FROM mdl_data_content c, mdl_data_records r, mdl_data_content cs, mdl_user u, mdl_data_content c1178, mdl_data_content c1179, mdl_data_content c1180, mdl_data_content c1181, mdl_data_content c1183, mdl_data_content c1184, mdl_data_content c1185, mdl_data_content c1186, mdl_data_content c1190, mdl_data_content c1191, mdl_data_content c1192, mdl_data_content c1193, mdl_data_content c1194, mdl_data_content c1195, mdl_data_content c1196, mdl_data_content c1197, mdl_data_content c1198, mdl_data_content c1199, mdl_data_content c1200, mdl_data_content c1202, mdl_data_content c1205, mdl_data_content c1206, mdl_data_content c1207, mdl_data_content c1208

        WHERE c.recordid = r.id
        AND r.dataid =116

        AND r.userid = u.id
        AND cs.recordid = r.id
        AND u.id =1
        AND c1178.recordid = r.id
        AND c1179.recordid = r.id
        AND c1180.recordid = r.id
        AND c1181.recordid = r.id
        AND c1183.recordid = r.id
        AND c1184.recordid = r.id
        AND c1185.recordid = r.id
        AND c1186.recordid = r.id
        AND c1190.recordid = r.id
        AND c1191.recordid = r.id
        AND c1192.recordid = r.id
        AND c1193.recordid = r.id
        AND c1194.recordid = r.id
        AND c1195.recordid = r.id
        AND c1196.recordid = r.id
        AND c1197.recordid = r.id
        AND c1198.recordid = r.id
        AND c1199.recordid = r.id
        AND c1200.recordid = r.id
        AND c1202.recordid = r.id
        AND c1205.recordid = r.id
        AND c1206.recordid = r.id
        AND c1207.recordid = r.id
        AND c1208.recordid = r.id
        AND u.firstname LIKE '%??????%'
        AND u.lastname LIKE '%????????%'
        AND ((c1178.fieldid =1178
        AND c1178.content = '???????????'))
        AND ((c1179.fieldid =1179
        AND c1179.content LIKE '%??? ? 504%'))
        AND ((c1180.fieldid =1180
        AND c1180.content LIKE '%??? ??????? ??? ???????????????? ???? ?504%'))
        AND ((c1181.fieldid =1181
        AND c1181.content LIKE '%???????????? ???? ?????????%'))
        AND ((c1183.fieldid =1183
        AND c1183.content LIKE '%http://www.detsad504.ru%'))
        AND ((c1184.fieldid =1184
        AND c1184.content LIKE '%dsad504@rambler.ru%'))
        AND ((c1185.fieldid =1185
        AND c1185.content LIKE '%2012%'))
        AND ((c1186.fieldid =1186
        AND c1186.content LIKE '%1%'))
        AND ((c1190.fieldid =1190
        AND c1190.content LIKE '%???????? ?????? ??????????%'))
        AND ((c1191.fieldid =1191
        AND c1191.content LIKE '%?????-?????????%'))
        AND ((c1192.fieldid =1192
        AND c1192.content LIKE '%galina.sochilina@mail.ru%'))
        AND ((c1193.fieldid =1193
        AND c1193.content LIKE '%05.01.1958%'))
        AND ((c1194.fieldid =1194
        AND c1194.content = '?????? ??????????????'))
        AND ((c1195.fieldid =1195
        AND c1195.content LIKE '%???? .?.?.????%'))
        AND ((c1196.fieldid =1196
        AND c1196.content LIKE '%1979%'))
        AND ((c1197.fieldid =1197
        AND c1197.content LIKE '%??????????????%'))
        AND ((c1198.fieldid =1198
        AND c1198.content LIKE '%??????? ????????? ???????%'))
        AND ((c1199.fieldid =1199
        AND c1199.content LIKE '%31 ???%'))
        AND ((c1200.fieldid =1200
        AND c1200.content LIKE '%7 ???%'))
        AND ((c1202.fieldid =1202
        AND c1202.content = '??? ?????????'))
        AND ((c1205.fieldid =1205
        AND c1205.content LIKE '%(495)9412463%'))
        AND ((c1206.fieldid =1206
        AND c1206.content LIKE '%(495)7518249%'))
        AND ((c1207.fieldid =1207
        AND c1207.content LIKE '%(903)5118137%'))
        AND ((c1208.fieldid =1208
        AND c1208.content LIKE '%\"????????? ???????????\"2010, 1 ?????%'))

        989884 Query 417198 statistics SELECT COUNT( DISTINCT c.recordid )
        FROM mdl_data_content c, mdl_data_records r, mdl_data_content cs, mdl_user u, mdl_data_content c1178, mdl_data_content c1179, mdl_data_content c1180, mdl_data_content c1181, mdl_data_content c1183, mdl_data_content c1184, mdl_data_content c1185, mdl_data_content c1186, mdl_data_content c1190, mdl_data_content c1191, mdl_data_content c1192, mdl_data_content c1193, mdl_data_content c1194, mdl_data_content c1195, mdl_data_content c1196, mdl_data_content c1197, mdl_data_content c1198, mdl_data_content c1199, mdl_data_content c1205, mdl_data_content c1206, mdl_data_content c1207, mdl_data_content c1208

        WHERE c.recordid = r.id
        AND r.dataid =116

        AND r.userid = u.id
        AND cs.recordid = r.id
        AND u.id =1
        AND c1178.recordid = r.id
        AND c1179.recordid = r.id
        AND c1180.recordid = r.id
        AND c1181.recordid = r.id
        AND c1183.recordid = r.id
        AND c1184.recordid = r.id
        AND c1185.recordid = r.id
        AND c1186.recordid = r.id
        AND c1190.recordid = r.id
        AND c1191.recordid = r.id
        AND c1192.recordid = r.id
        AND c1193.recordid = r.id
        AND c1194.recordid = r.id
        AND c1195.recordid = r.id
        AND c1196.recordid = r.id
        AND c1197.recordid = r.id
        AND c1198.recordid = r.id
        AND c1199.recordid = r.id
        AND c1205.recordid = r.id
        AND c1206.recordid = r.id
        AND c1207.recordid = r.id
        AND c1208.recordid = r.id
        AND u.firstname LIKE '%???? %'
        AND u.lastname LIKE '%????????????%'
        AND ((c1178.fieldid =1178
        AND c1178.content = '???????????'))
        AND ((c1179.fieldid =1179
        AND c1179.content LIKE '%??? ? 504%'))
        AND ((c1180.fieldid =1180
        AND c1180.content LIKE '%??? ??????? ??? ???????????????? ???? ? 504%'))
        AND ((c1181.fieldid =1181
        AND c1181.content LIKE '%???????????? ???? ?????????%'))
        AND ((c1183.fieldid =1183
        AND c1183.content LIKE '%http://www.detsad504.ru%'))
        AND ((c1184.fieldid =1184
        AND c1184.content LIKE '%dsad504@rambler.ru%'))
        AND ((c1185.fieldid =1185
        AND c1185.content LIKE '%2012%'))
        AND ((c1186.fieldid =1186
        AND c1186.content LIKE '%1%'))
        AND ((c1190.fieldid =1190
        AND c1190.content LIKE '%???????????? ???? ???????????%'))
        AND ((c1191.fieldid =1191
        AND c1191.content LIKE '%?????-?????????%'))
        AND ((c1192.fieldid =1192
        AND c1192.content LIKE '%Pichun@mail.ru%'))
        AND ((c1193.fieldid =1193
        AND c1193.content LIKE '%28.07.1986%'))
        AND ((c1194.fieldid =1194
        AND c1194.content = '?????? ??????????????'))
        AND ((c1195.fieldid =1195
        AND c1195.content LIKE '%?????????? ?????????????? ??????????????? ???????????%'))
        AND ((c1196.fieldid =1196
        AND c1196.content LIKE '%2009%'))
        AND ((c1197.fieldid =1197
        AND c1197.content LIKE '%??????????????%'))
        AND ((c1198.fieldid =1198
        AND c1198.content LIKE '%??????? ???????? ????? ? ??????????%'))
        AND ((c1199.fieldid =1199
        AND c1199.content LIKE '%1 ???%'))
        AND ((c1205.fieldid =1205
        AND c1205.content LIKE '%(495)9412463%'))
        AND ((c1206.fieldid =1206
        AND c1206.content LIKE '%(495)1958343%'))
        AND ((c1207.fieldid =1207
        AND c1207.content LIKE '%(903)6144061%'))
        AND ((c1208.fieldid =1208
        AND c1208.content LIKE '%\"????????? ???????????\"2010, 2 ?????.%'))

        Show
        Alex Djachenko added a comment - We are have this problem too: a lot of SQL-queries ???? runing more th?n several houes.I t's very big perfomance problem - it can broke the site down. 977547 Query 424858 statistics SELECT COUNT( DISTINCT c.recordid ) FROM mdl_data_content c, mdl_data_records r, mdl_data_content cs, mdl_user u, mdl_data_content c1178, mdl_data_content c1179, mdl_data_content c1180, mdl_data_content c1181, mdl_data_content c1183, mdl_data_content c1184, mdl_data_content c1185, mdl_data_content c1186, mdl_data_content c1188, mdl_data_content c1189, mdl_data_content c1190, mdl_data_content c1191, mdl_data_content c1192, mdl_data_content c1193, mdl_data_content c1194, mdl_data_content c1195, mdl_data_content c1196, mdl_data_content c1197, mdl_data_content c1198, mdl_data_content c1199, mdl_data_content c1202, mdl_data_content c1205, mdl_data_content c1206, mdl_data_content c1207, mdl_data_content c1208 WHERE c.recordid = r.id AND r.dataid =116 AND r.userid = u.id AND cs.recordid = r.id AND u.id =1 AND c1178.recordid = r.id AND c1179.recordid = r.id AND c1180.recordid = r.id AND c1181.recordid = r.id AND c1183.recordid = r.id AND c1184.recordid = r.id AND c1185.recordid = r.id AND c1186.recordid = r.id AND c1188.recordid = r.id AND c1189.recordid = r.id AND c1190.recordid = r.id AND c1191.recordid = r.id AND c1192.recordid = r.id AND c1193.recordid = r.id AND c1194.recordid = r.id AND c1195.recordid = r.id AND c1196.recordid = r.id AND c1197.recordid = r.id AND c1198.recordid = r.id AND c1199.recordid = r.id AND c1202.recordid = r.id AND c1205.recordid = r.id AND c1206.recordid = r.id AND c1207.recordid = r.id AND c1208.recordid = r.id AND u.firstname LIKE '%????%' AND u.lastname LIKE '%????????????%' AND ((c1178.fieldid =1178 AND c1178.content = '???????????')) AND ((c1179.fieldid =1179 AND c1179.content LIKE '%??? ? 504%')) AND ((c1180.fieldid =1180 AND c1180.content LIKE '%??? ??????? ??? ???????????????? ???? ? 504%')) AND ((c1181.fieldid =1181 AND c1181.content LIKE '%???????????? ???? ?????????%')) AND ((c1183.fieldid =1183 AND c1183.content LIKE '% http://www.detsad504.ru% ')) AND ((c1184.fieldid =1184 AND c1184.content LIKE '%dsad504@rambler.ru%')) AND ((c1185.fieldid =1185 AND c1185.content LIKE '%2011%')) AND ((c1186.fieldid =1186 AND c1186.content LIKE '%1%')) AND ((c1188.fieldid =1188 AND c1188.content = '???')) AND ((c1189.fieldid =1189 AND c1189.content = '???')) AND ((c1190.fieldid =1190 AND c1190.content LIKE '%???????????? ???? ???????????%')) AND ((c1191.fieldid =1191 AND c1191.content LIKE '%????? - ?????????%')) AND ((c1192.fieldid =1192 AND c1192.content LIKE '%Pichun@mail.ru%')) AND ((c1193.fieldid =1193 AND c1193.content LIKE '%28.07.1986%')) AND ((c1194.fieldid =1194 AND c1194.content = '?????? ??????????????')) AND ((c1195.fieldid =1195 AND c1195.content LIKE '%?????????? ?????????????? ??????????????? ???????????%')) AND ((c1196.fieldid =1196 AND c1196.content LIKE '%2009%')) AND ((c1197.fieldid =1197 AND c1197.content LIKE '%??????????????%')) AND ((c1198.fieldid =1198 AND c1198.content LIKE '%??????? ???????? ????? ? ??????????%')) AND ((c1199.fieldid =1199 AND c1199.content LIKE '%1 ???%')) AND ((c1202.fieldid =1202 AND c1202.content = '??? ?????????')) AND ((c1205.fieldid =1205 AND c1205.content LIKE '%(495)9412463%')) AND ((c1206.fieldid =1206 AND c1206.content LIKE '%(495)1958343%')) AND ((c1207.fieldid =1207 AND c1207.content LIKE '%(903)6144061%')) AND ((c1208.fieldid =1208 AND c1208.content LIKE '%\"????????? ??????????? \" 2010,2 ?????%')) 981388 Query 422135 statistics SELECT COUNT( DISTINCT c.recordid ) FROM mdl_data_content c, mdl_data_records r, mdl_data_content cs, mdl_user u, mdl_data_content c1178, mdl_data_content c1179, mdl_data_content c1180, mdl_data_content c1181, mdl_data_content c1183, mdl_data_content c1184, mdl_data_content c1185, mdl_data_content c1186, mdl_data_content c1190, mdl_data_content c1191, mdl_data_content c1192, mdl_data_content c1193, mdl_data_content c1194, mdl_data_content c1195, mdl_data_content c1196, mdl_data_content c1197, mdl_data_content c1198, mdl_data_content c1199, mdl_data_content c1200, mdl_data_content c1202, mdl_data_content c1205, mdl_data_content c1206, mdl_data_content c1207, mdl_data_content c1208 WHERE c.recordid = r.id AND r.dataid =116 AND r.userid = u.id AND cs.recordid = r.id AND u.id =1 AND c1178.recordid = r.id AND c1179.recordid = r.id AND c1180.recordid = r.id AND c1181.recordid = r.id AND c1183.recordid = r.id AND c1184.recordid = r.id AND c1185.recordid = r.id AND c1186.recordid = r.id AND c1190.recordid = r.id AND c1191.recordid = r.id AND c1192.recordid = r.id AND c1193.recordid = r.id AND c1194.recordid = r.id AND c1195.recordid = r.id AND c1196.recordid = r.id AND c1197.recordid = r.id AND c1198.recordid = r.id AND c1199.recordid = r.id AND c1200.recordid = r.id AND c1202.recordid = r.id AND c1205.recordid = r.id AND c1206.recordid = r.id AND c1207.recordid = r.id AND c1208.recordid = r.id AND u.firstname LIKE '%??????%' AND u.lastname LIKE '%????????%' AND ((c1178.fieldid =1178 AND c1178.content = '???????????')) AND ((c1179.fieldid =1179 AND c1179.content LIKE '%??? ? 504%')) AND ((c1180.fieldid =1180 AND c1180.content LIKE '%??? ??????? ??? ???????????????? ???? ?504%')) AND ((c1181.fieldid =1181 AND c1181.content LIKE '%???????????? ???? ?????????%')) AND ((c1183.fieldid =1183 AND c1183.content LIKE '% http://www.detsad504.ru% ')) AND ((c1184.fieldid =1184 AND c1184.content LIKE '%dsad504@rambler.ru%')) AND ((c1185.fieldid =1185 AND c1185.content LIKE '%2012%')) AND ((c1186.fieldid =1186 AND c1186.content LIKE '%1%')) AND ((c1190.fieldid =1190 AND c1190.content LIKE '%???????? ?????? ??????????%')) AND ((c1191.fieldid =1191 AND c1191.content LIKE '%????? - ?????????%')) AND ((c1192.fieldid =1192 AND c1192.content LIKE '%galina.sochilina@mail.ru%')) AND ((c1193.fieldid =1193 AND c1193.content LIKE '%05.01.1958%')) AND ((c1194.fieldid =1194 AND c1194.content = '?????? ??????????????')) AND ((c1195.fieldid =1195 AND c1195.content LIKE '%???? .?.?. ????%')) AND ((c1196.fieldid =1196 AND c1196.content LIKE '%1979%')) AND ((c1197.fieldid =1197 AND c1197.content LIKE '%??????????????%')) AND ((c1198.fieldid =1198 AND c1198.content LIKE '%??????? ????????? ???????%')) AND ((c1199.fieldid =1199 AND c1199.content LIKE '%31 ???%')) AND ((c1200.fieldid =1200 AND c1200.content LIKE '%7 ???%')) AND ((c1202.fieldid =1202 AND c1202.content = '??? ?????????')) AND ((c1205.fieldid =1205 AND c1205.content LIKE '%(495)9412463%')) AND ((c1206.fieldid =1206 AND c1206.content LIKE '%(495)7518249%')) AND ((c1207.fieldid =1207 AND c1207.content LIKE '%(903)5118137%')) AND ((c1208.fieldid =1208 AND c1208.content LIKE '%\"????????? ??????????? \" 2010, 1 ?????%')) 989884 Query 417198 statistics SELECT COUNT( DISTINCT c.recordid ) FROM mdl_data_content c, mdl_data_records r, mdl_data_content cs, mdl_user u, mdl_data_content c1178, mdl_data_content c1179, mdl_data_content c1180, mdl_data_content c1181, mdl_data_content c1183, mdl_data_content c1184, mdl_data_content c1185, mdl_data_content c1186, mdl_data_content c1190, mdl_data_content c1191, mdl_data_content c1192, mdl_data_content c1193, mdl_data_content c1194, mdl_data_content c1195, mdl_data_content c1196, mdl_data_content c1197, mdl_data_content c1198, mdl_data_content c1199, mdl_data_content c1205, mdl_data_content c1206, mdl_data_content c1207, mdl_data_content c1208 WHERE c.recordid = r.id AND r.dataid =116 AND r.userid = u.id AND cs.recordid = r.id AND u.id =1 AND c1178.recordid = r.id AND c1179.recordid = r.id AND c1180.recordid = r.id AND c1181.recordid = r.id AND c1183.recordid = r.id AND c1184.recordid = r.id AND c1185.recordid = r.id AND c1186.recordid = r.id AND c1190.recordid = r.id AND c1191.recordid = r.id AND c1192.recordid = r.id AND c1193.recordid = r.id AND c1194.recordid = r.id AND c1195.recordid = r.id AND c1196.recordid = r.id AND c1197.recordid = r.id AND c1198.recordid = r.id AND c1199.recordid = r.id AND c1205.recordid = r.id AND c1206.recordid = r.id AND c1207.recordid = r.id AND c1208.recordid = r.id AND u.firstname LIKE '%???? %' AND u.lastname LIKE '%????????????%' AND ((c1178.fieldid =1178 AND c1178.content = '???????????')) AND ((c1179.fieldid =1179 AND c1179.content LIKE '%??? ? 504%')) AND ((c1180.fieldid =1180 AND c1180.content LIKE '%??? ??????? ??? ???????????????? ???? ? 504%')) AND ((c1181.fieldid =1181 AND c1181.content LIKE '%???????????? ???? ?????????%')) AND ((c1183.fieldid =1183 AND c1183.content LIKE '% http://www.detsad504.ru% ')) AND ((c1184.fieldid =1184 AND c1184.content LIKE '%dsad504@rambler.ru%')) AND ((c1185.fieldid =1185 AND c1185.content LIKE '%2012%')) AND ((c1186.fieldid =1186 AND c1186.content LIKE '%1%')) AND ((c1190.fieldid =1190 AND c1190.content LIKE '%???????????? ???? ???????????%')) AND ((c1191.fieldid =1191 AND c1191.content LIKE '%????? - ?????????%')) AND ((c1192.fieldid =1192 AND c1192.content LIKE '%Pichun@mail.ru%')) AND ((c1193.fieldid =1193 AND c1193.content LIKE '%28.07.1986%')) AND ((c1194.fieldid =1194 AND c1194.content = '?????? ??????????????')) AND ((c1195.fieldid =1195 AND c1195.content LIKE '%?????????? ?????????????? ??????????????? ???????????%')) AND ((c1196.fieldid =1196 AND c1196.content LIKE '%2009%')) AND ((c1197.fieldid =1197 AND c1197.content LIKE '%??????????????%')) AND ((c1198.fieldid =1198 AND c1198.content LIKE '%??????? ???????? ????? ? ??????????%')) AND ((c1199.fieldid =1199 AND c1199.content LIKE '%1 ???%')) AND ((c1205.fieldid =1205 AND c1205.content LIKE '%(495)9412463%')) AND ((c1206.fieldid =1206 AND c1206.content LIKE '%(495)1958343%')) AND ((c1207.fieldid =1207 AND c1207.content LIKE '%(903)6144061%')) AND ((c1208.fieldid =1208 AND c1208.content LIKE '%\"????????? ??????????? \" 2010, 2 ?????.%'))
        Martin Dougiamas made changes -
        Field Original Value New Value
        Workflow jira [ 36347 ] MDL Workflow [ 46231 ]
        Martin Dougiamas made changes -
        Workflow MDL Workflow [ 46231 ] MDL Full Workflow [ 74534 ]
        Henning Bostelmann made changes -
        Labels performance
        Henning Bostelmann made changes -
        Link This issue has been marked as being related by MDL-17327 [ MDL-17327 ]
        Hide
        Séverin Terrier added a comment -

        You should look at MDL-17327

        Show
        Séverin Terrier added a comment - You should look at MDL-17327
        Hide
        Dan Poltawski added a comment -

        Does this still apply?

        Show
        Dan Poltawski added a comment - Does this still apply?
        Hide
        Henning Bostelmann added a comment -

        Hi Dan,
        regarding the missing index (which I originally commented on): It seems that the index was added meanwhile, it is definitely present in the 2.3 branch.
        Henning

        Show
        Henning Bostelmann added a comment - Hi Dan, regarding the missing index (which I originally commented on): It seems that the index was added meanwhile, it is definitely present in the 2.3 branch. Henning
        Hide
        Dan Poltawski added a comment -

        Closing this one then, thanks Henning.

        Show
        Dan Poltawski added a comment - Closing this one then, thanks Henning.
        Dan Poltawski made changes -
        Status Open [ 1 ] Closed [ 6 ]
        Resolution Duplicate [ 3 ]

          People

          • Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: