Timeline for Performance issues after upgrading from MySQL 5.7 to MySQL 8.0
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 25 at 14:08 | comment | added | Tomas.Nemec | PawSQL is able to do the exact optimization automatically. I copied the ddl and query and setup a tuning task. Here is the optimization result link. https://www.pawsql.com/statement/1783496744313094146 @Ketan Panchal | |
| Dec 9, 2023 at 18:20 | comment | added | Rick James |
@KetanPanchal - "Same" is not always the "same". Start a new Question with SHOW CREATE TABLE and the query and EXPLAIN ANALYZE SELECT ....
|
|
| Dec 7, 2023 at 13:48 | comment | added | Ketan Panchal | have you got any solution for the performance issue? After upgrading MySQL version 5.7 to 8.0.mysql_aurora.3.04.0, I am facing the same issue. | |
| Apr 3, 2023 at 3:36 | comment | added | Tomas.Nemec | Added explanation of previous workable suggestion and the solution to the new query. | |
| Apr 3, 2023 at 3:33 | history | edited | Tomas.Nemec | CC BY-SA 4.0 |
add explanation of previous workable suggestion, and how to optimize the new query
|
| Mar 31, 2023 at 12:46 | comment | added | Programming Caveman | I edited my question AGAIN. I posted longer query which has more conditions and this one doesn't work fast in MySQL 8 even with your proposed index (and all previous indexes turned off). What would you suggest for this case? | |
| Mar 31, 2023 at 11:07 | comment | added | Programming Caveman | However when I add more imei and dtime conditions to the query then it still uses MRR and becomes much slower. | |
| Mar 31, 2023 at 11:03 | vote | accept | Programming Caveman | ||
| Mar 31, 2023 at 11:34 | |||||
| Mar 31, 2023 at 11:02 | comment | added | Programming Caveman | It accually worked but I need to understand WHY. | |
| Mar 31, 2023 at 10:39 | comment | added | Programming Caveman | Hi. Why not to include "filter" column as well? As why did you propose such order of columns for new index? | |
| Mar 31, 2023 at 2:55 | history | answered | Tomas.Nemec | CC BY-SA 4.0 |