SQL Performance (MOSC)

MOSC Banner

Peformance behaviour MySQL 5.7 vs. MySQL 8

Hi,

I recently upgraded from MySQL 5.7 to MySQL 8, and observed that the same query is performing much slower after the upgrade.

Please see example below..

I have table psa and table rmv. The query is like,

SELECT * FROM psa left join rmv on psa.pein = rmv.pein

Both psa and rmv tables have index KEY `pein` USING BTREE (`pein`).

The same query, it only takes less than 1 second in my old 5.7 database, while it takes around 15 minutes in new database.

And when I tried to do EXPLAIN on the query, it is telling different JOIN type..

-- EXPLAIN query in 5.7

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center