Advertisement
mahmoodn

mysql-create-index

Jul 11th, 2020
445
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.14 KB | None | 0 0
  1. 2020-07-11T15:13:09.556506Z 1970928 Query SHOW TABLES LIKE 'mdl\_%'
  2. 2020-07-11T15:13:09.560104Z 1970928 Query CREATE TEMPORARY TABLE mdl_backup_ids_temp (
  3. id BIGINT(10) NOT NULL auto_increment,
  4. backupid VARCHAR(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '29c59f21596c4a54840f7b555a234447',
  5. itemname VARCHAR(160) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  6. itemid BIGINT(10) NOT NULL,
  7. newitemid BIGINT(10) NOT NULL DEFAULT 0,
  8. parentitemid BIGINT(10),
  9. info LONGTEXT COLLATE utf8mb4_unicode_ci,
  10. CONSTRAINT PRIMARY KEY (id)
  11. ) DEFAULT COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC
  12. ;
  13. 2020-07-11T15:13:09.584332Z 1970928 Query CREATE INDEX mdl_backidstemp_bacitepar_ix ON mdl_backup_ids_temp (backupid, itemname, parentitemid)
  14. ;
  15. 2020-07-11T15:13:09.585628Z 1970928 Query CREATE INDEX mdl_backidstemp_bacitenew_ix ON mdl_backup_ids_temp (backupid, itemname, newitemid)
  16. ;
  17. 2020-07-11T15:13:09.586994Z 1970928 Query CREATE UNIQUE INDEX mdl_backidstemp_baciteite_uix ON mdl_backup_ids_temp (backupid, itemname, itemid)
  18. 2020-07-11T15:13:09.591832Z 1970928 Query SELECT cm.*, cp.value AS version, m.name AS modulename, s.id AS sectionid, s.section AS sectionnumber
  19. FROM mdl_course_modules cm
  20. JOIN mdl_modules m ON m.id = cm.module
  21. JOIN mdl_config_plugins cp ON cp.plugin = CONCAT('mod_', m.name) AND cp.name = 'version'
  22. JOIN mdl_course_sections s ON s.id = cm.section
  23. WHERE cm.id = '43630'
  24. 2020-07-11T15:13:09.592889Z 1970928 Query SELECT t.id, t.name, t.rawname
  25. FROM mdl_tag t
  26. JOIN mdl_tag_instance ti ON ti.tagid = t.id
  27. WHERE ti.itemtype = 'course_modules'
  28. AND ti.component = 'core'
  29. AND ti.itemid = '43630'
  30. 2020-07-11T15:13:09.593585Z 1970928 Query SELECT * FROM mdl_backup_ids_temp WHERE backupid = '29c59f21596c4a54840f7b555a234447' AND itemname = 'grouping'
  31. 2020-07-11T15:13:09.719925Z 1970986 Connect moodleuser@localhost on moodle using Socket
  32. 2020-07-11T15:13:09.720487Z 1970986 Query SET NAMES utf8mb4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement