Comments - mariaDB Limit Issue
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
1 PRIMARY am ALL PRIMARY 14 Using temporary 1 PRIMARY <derived2> ref key0 key0 769 FIAT_140319.am.make_id_pk 2993034 Distinct 2 DERIVED amgf index PRIMARY 783 3352 Using index; Using temporary 2 DERIVED <derived4> ref key0 key0 8 FIAT_140319.amgf.financial_product_id 29 2 DERIVED amg index PRIMARY 2309 3079 Using where; Using index; Using join buffer (flat, BNL join) 4 DERIVED ud const PRIMARY PRIMARY 767 const 1 4 DERIVED usr ALL 48825 Using where 4 DERIVED fpb ref PRIMARY PRIMARY 8 FIAT_140319.usr.relative_user_id 678 Using where; Using index 4 DERIVED fp eq_ref PRIMARY PRIMARY 8 FIAT_140319.fpb.financial_product_id 1 Using where
and mariaDB version is 5.5.35
There have been a number of optimizer improvements in the later stable releases, MariaDB 10.0, MariaDB 10.1, MariaDB 10.2 and MariaDB 10.3 - if MySQL 5.6 runs your query faster than 5.5, it's very likely the same improvements were made in a version of MariaDB > 5.5, so you can try upgrading your MariaDB version and see if that helps.
If not, and the same query runs slower on MariaDB, you can report as a bug with more details to help recreate the problem.