Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-22470

Performance problem in datbase activity module - missing index

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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

      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.

        Gliffy Diagrams

          Activity

          bostelm Henning Bostelmann created issue -
          Hide
          mentis 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
          mentis 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 ?????.%'))
          dougiamas Martin Dougiamas made changes -
          Field Original Value New Value
          Workflow jira [ 36347 ] MDL Workflow [ 46231 ]
          dougiamas Martin Dougiamas made changes -
          Workflow MDL Workflow [ 46231 ] MDL Full Workflow [ 74534 ]
          bostelm Henning Bostelmann made changes -
          Labels performance
          bostelm Henning Bostelmann made changes -
          Link This issue has been marked as being related by MDL-17327 [ MDL-17327 ]
          Hide
          fox Séverin Terrier added a comment -

          You should look at MDL-17327

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

          Does this still apply?

          Show
          poltawski Dan Poltawski added a comment - Does this still apply?
          Hide
          bostelm 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
          bostelm 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
          poltawski Dan Poltawski added a comment -

          Closing this one then, thanks Henning.

          Show
          poltawski Dan Poltawski added a comment - Closing this one then, thanks Henning.
          poltawski 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: