Not the answer you need?
Register and ask your own question!

help in interpreting explain command

siefusiefu EntrantCurrent User Role Beginner
hi,

suddenly our percona mysql db giving high cpu usage. although the query down here wasn't in slow query log before.


'1', 'SIMPLE', 'cw', 'index', 'PRIMARY', 'mdl_coursect_cousec_uix', '16', NULL, '1', 'Using index'
'1', 'SIMPLE', 'md', 'ref', 'PRIMARY,mdl_modu_nam_ix', 'mdl_modu_nam_ix', '62', 'const', '1', 'Using where; Using index'
'1', 'SIMPLE', 'm', 'ALL', 'PRIMARY', NULL, NULL, NULL, '23', 'Using join buffer (Block Nested Loop)'
'1', 'SIMPLE', 'cm', 'ref', 'mdl_courmodu_cou_ix,mdl_courmodu_mod_ix,mdl_courmodu_ins_ix', 'mdl_courmodu_ins_ix', '8', 'moodle_15161.m.id', '1', 'Using where'

as i'm not an expert in db. someone can interpret for me?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.