将MySQL5.5升级到Percona5.7后，应用程序运行非常缓慢。我无法优化查询，因为这些查询是用应用程序编译的。我唯一能做的就是优化mysql服务器（或服务器配置）
我需要提到的是，我看到一些查询返回大量数据（70m的结果）data dir在ssd上。我有32g ram，但我为mysql分配了20个（60%是因为我们还有其他小型服务）
如果我激活缓存，我会注意到一个小的改进（这将被弃用）
下面是我的配置
在此处显示全局状态结果
有人知道如何改进mysql配置或服务器以提高性能吗？我用一个带explain的sql作为例子。它返回672行数据，但需要30秒（29行停留在“发送数据”中）。

explain select l.idCodeLocation as idLocation, l.txLocation as name, l.radius as radius, l.amLat as lat, l.amLong as lng, g.isin as isin, g.isout as isout, g.onval as onval, m.isGeofenceIn as isGeofenceIn, m.geofenceInTime as geofenceInTime, m.isGeofenceOn as isGeofenceOn, v.idVeh as idveh, v.idPlateVeh as plate, v.idClient as client from sat_geofence g left join sat_clientLocation as l on (g.idLocation=l.idCodeLocation) join sat_geofence_vehicle_mtm as m on (g.idLocation=m.idLocation) join sat_vehicle as v on (m.idVeh=v.idVeh);
+----+-------------+-------+------------+--------+---------------+---------+---------+-------------------+--------+----------+----------------------------------------------------+
| id | select_type | table | partitions | type   | possible_keys | key     | key_len | ref               | rows   | filtered | Extra                                              |
+----+-------------+-------+------------+--------+---------------+---------+---------+-------------------+--------+----------+----------------------------------------------------+
|  1 | SIMPLE      | g     | NULL       | ALL    | idx           | NULL    | NULL    | NULL              |     38 |   100.00 | NULL                                               |
|  1 | SIMPLE      | m     | NULL       | ref    | idx           | idx     | 768     | Stdb.g.idLocation |      5 |   100.00 | Using index condition                              |
|  1 | SIMPLE      | v     | NULL       | eq_ref | PRIMARY       | PRIMARY | 3       | Stdb.m.idVeh      |      1 |   100.00 | Using where                                        |
|  1 | SIMPLE      | l     | NULL       | ALL    | NULL          | NULL    | NULL    | NULL              | 116952 |   100.00 | Using where; Using join buffer (Block Nested Loop) |
+----+-------------+-------+------------+--------+---------------+---------+---------+-------------------+--------+----------+----------------------------------------------------+

我放在这里的表格结构：https://gist.github.com/costyoancea/deee560f9c94aa2463162d7ce0556392
谢谢，科斯蒂