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

          Attachments

            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: