SSP gone real slow with MySQL 5.7

SunBlade

Hi everyone,
maybe someone as hint or an idea about this.
I'm using DataTables with ServerSideProcessing for several months now and I never had any problems. (So my scripts are several months old as well.) However, my Provider switched from MariaDB to MySQL 5.7 a few days ago, and now it takes up to a minute to load data with my SSP Class instead of a few seconds. It still works, but you can't really work with it anymore.
Has anyone came across this problem?
Thanks in advance, Sunny.

allan

I'd suggest that you determine the exact SQL query that is being executed by whatever server-side processing script you are using, and then run it with the EXPLAIN keyword in front of it in an SQL console (phpMyAdmin for example).

That should tell you why the query is running slowly. It might be a missing index.

Allan

SunBlade

Thanks a lot, I'll try that.

Already found out yesterday that it has something to do with the way MySQL 5.7 is dealing with Subqueries/Subselects, maybe the EXPLAIN keyword will help me there.