Speed up SQL query MYSQL 8.0.32 -- 2
Budget: $10 – $30 USD
I upgraded from MYSQL 5.7 to MYSQL8.0.32 and restored database ( after I removed any reference to NO_AUTO_CREATE_USER)
I have a query than now runs very slow 22 seconds. I need help speeding up. All indexes seem to be the same as before upgrade. I am thinking maybe new Keywords and Reserved Words may help?
Note I will not be giving you my database but will give you access to log in.
I still have a different server that is running 5.7 that could be referenced back to
Has:
Windows server
Mysqlworkbench
Mysql shell
Has Not:
No phpadmin
** Note: To show that you have read this please reply back starting with "I am the best for this job because....."
I have a query than now runs very slow 22 seconds. I need help speeding up. All indexes seem to be the same as before upgrade. I am thinking maybe new Keywords and Reserved Words may help?
Note I will not be giving you my database but will give you access to log in.
I still have a different server that is running 5.7 that could be referenced back to
Has:
Windows server
Mysqlworkbench
Mysql shell
Has Not:
No phpadmin
** Note: To show that you have read this please reply back starting with "I am the best for this job because....."