how to know the behavior of MariaDB engine

Question

I am new to MySQL/MariaDB.

I am comparing performance of a Stored Procedure in both MS SQL and MariaDB and found the performance of MariaDB to be slower than MS SQL. I found that the same query is taking more time in MariaDB than MSSQL. In fact i had to add an index on temporary table in the stored procedure which was not required in MS SQL. Why this type of result. How and where can i dig more into the behavior of MariadB engine like execution plan(detailed). Which performance monitoring tool(open source) will help me in handling slow queries as well as optimization other than slow query log.

How can i use EXPLAIN for below code CREATE TEMPORARY TABLE tmp_ABC AS SELECT * from tbl_ABC

Regards, Saumik Vora