This is what we get with our own binary 8.0.37: mysql> with monitorTwoHours AS (SELECT * FROM monitor_test_1 UNION SELECT * FROM monitor_test_2), monitorMaxTime AS(SELECT resource_id, MAX(timestamp) AS timestamp from monitorTwoHours where monitor_type = 'ph' and region = 'regionTest' GROUP BY resource_id) select * from monitorMaxTime JOIN monitorTwoHours ON (monitorTwoHours.resource_id = monitorMaxTime.resource_id and monitorTwoHours.timestamp = monitorMaxTime.timestamp); +--------------------------------------+---------------------+----------------------------------+------------+--------------------------------------+--------------+--------+------------+------------+-----------+----------+-------------------+--------------------+---------------------+----------------------+--------------+----------+---------------+--------------+---------------+--------------+------------------+----------------+------------------+-------------------+------------------+------------------+-------------------+-----------------------------+------------------------------+--------------------------------+---------------------------------+--------------------------+-------------------------+----------------------+-----------------------+----------------------------+-----------------------------+-------------------------+--------------------------+---------------------+----------------------+------------------+-------------------+------------------+--------------------------+---------------------------+------------+------------+-------------+---------------------+---------------------+ | resource_id | timestamp | id | region | resource_id | monitor_type | status | ip | mainframe | cpu_count | cpu_util | net_in_bytes_rate | net_out_bytes_rate | net_in_packets_rate | net_out_packets_rate | mem_total | mem_util | mem_available | mem_used | disk_total | disk_used | disk_util | node_boot_time | disk_util_single | disk_device_usage | disk_device_used | disk_used_single | disk_total_single | disk_read_bytes_rate_single | disk_write_bytes_rate_single | disk_read_requests_rate_single | disk_write_requests_rate_single | disk_write_requests_rate | disk_read_requests_rate | disk_read_bytes_rate | disk_write_bytes_rate | net_in_packets_rate_single | net_out_packets_rate_single | net_in_drop_rate_single | net_out_drop_rate_single | net_in_drop_percent | net_out_drop_percent | net_drop_percent | net_out_drop_rate | net_in_drop_rate | net_in_bytes_rate_single | net_out_bytes_rate_single | node_load1 | node_load5 | node_load15 | timestamp | insert_time | +--------------------------------------+---------------------+----------------------------------+------------+--------------------------------------+--------------+--------+------------+------------+-----------+----------+-------------------+--------------------+---------------------+----------------------+--------------+----------+---------------+--------------+---------------+--------------+------------------+----------------+------------------+-------------------+------------------+------------------+-------------------+-----------------------------+------------------------------+--------------------------------+---------------------------------+--------------------------+-------------------------+----------------------+-----------------------+----------------------------+-----------------------------+-------------------------+--------------------------+---------------------+----------------------+------------------+-------------------+------------------+--------------------------+---------------------------+------------+------------+-------------+---------------------+---------------------+ | d1bdcfb9-c188-4506-8b72-069412d426fa | 2024-05-08 16:59:33 | 64d10c4369c74b8ba5ad32434cb3db04 | regionTest | d1bdcfb9-c188-4506-8b72-069412d426fa | ph | 1 | 10.5.76.13 | 10.5.76.13 | 80 | 10.9 | 6231505.75893001 | 4919016.23437592 | 6184.57614342053 | 4801.75407499194 | 540505235456 | 53.1090 | 253448097792 | 287057137664 | 959683256320 | 58817019904 | 6.12879504947702 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:33 | 2024-05-08 16:59:00 | | 96e256cb-30ae-4ce3-9fdc-e291c7882818 | 2024-05-08 16:59:33 | 79cbe5ebf7ba456a8b3933c083f63f6a | regionTest | 96e256cb-30ae-4ce3-9fdc-e291c7882818 | ph | 1 | 10.5.76.15 | 10.5.76.15 | 128 | 0.3 | 4766491.63460511 | 3609591.84190607 | 4626.20865642771 | 3521.49262929547 | 540768120832 | 8.9093 | 492589203456 | 48178917376 | 479313604608 | 16674177024 | 3.47876147551387 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:33 | 2024-05-08 16:59:00 | | 7b1fbdec-b4e0-4493-b004-40d4c0a71733 | 2024-05-08 16:59:33 | d957943eb4404cc1bf8e517bce9c9e3b | regionTest | 7b1fbdec-b4e0-4493-b004-40d4c0a71733 | ph | 1 | 10.5.76.12 | 10.5.76.12 | 80 | 23.9 | 6531087.4240595 | 6317436.87350538 | 6926.10458788819 | 5564.53961336426 | 540505296896 | 73.2645 | 144506945536 | 395998351360 | 959683256320 | 71742947328 | 7.47569021919851 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:33 | 2024-05-08 16:59:01 | | 272647fe-2986-4902-b298-8ff787f1a132 | 2024-05-08 16:59:32 | f5a271cf401d4aecbf7f93fd0aa17a48 | regionTest | 272647fe-2986-4902-b298-8ff787f1a132 | ph | 1 | 127.0.0.1 | 127.0.0.1 | 80 | 4.2 | 7495559.78365875 | 3356019.35092553 | 7168.21290357919 | 4395.054209903 | 540505141248 | 59.8492 | 217016979456 | 323488161792 | 8959108079616 | 939321245696 | 10.4845397259262 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:32 | 2024-05-08 16:59:00 | | 91188358-6438-4440-996a-3c4328ed5985 | 2024-05-08 16:59:32 | b3e40c36feb447abbb0d73124ee52823 | regionTest | 91188358-6438-4440-996a-3c4328ed5985 | ph | 1 | 10.5.76.14 | 10.5.76.14 | 128 | 0.4 | 5383852.02904399 | 3418087.57740511 | 5253.1283124981 | 3664.63259296681 | 540768137216 | 8.8357 | 492987396096 | 47780741120 | 479313604608 | 24957288448 | 5.20688088300998 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:32 | 2024-05-08 16:59:00 | +--------------------------------------+---------------------+----------------------------------+------------+--------------------------------------+--------------+--------+------------+------------+-----------+----------+-------------------+--------------------+---------------------+----------------------+--------------+----------+---------------+--------------+---------------+--------------+------------------+----------------+------------------+-------------------+------------------+------------------+-------------------+-----------------------------+------------------------------+--------------------------------+---------------------------------+--------------------------+-------------------------+----------------------+-----------------------+----------------------------+-----------------------------+-------------------------+--------------------------+---------------------+----------------------+------------------+-------------------+------------------+--------------------------+---------------------------+------------+------------+-------------+---------------------+---------------------+ 5 rows in set (0.01 sec) mysql> with monitorTwoHours AS (SELECT * FROM monitor_test_1 UNION SELECT * FROM monitor_test_2), monitorMaxTime AS(SELECT resource_id, MAX(timestamp) AS timestamp from monitorTwoHours where monitor_type = 'ph' and region = 'regionTest' GROUP BY resource_id) select * from monitorTwoHours JOIN monitorMaxTime ON (monitorTwoHours.resource_id = monitorMaxTime.resource_id and monitorTwoHours.timestamp = monitorMaxTime.timestamp); +----------------------------------+------------+--------------------------------------+--------------+--------+------------+------------+-----------+----------+-------------------+--------------------+---------------------+----------------------+--------------+----------+---------------+--------------+---------------+--------------+------------------+----------------+------------------+-------------------+------------------+------------------+-------------------+-----------------------------+------------------------------+--------------------------------+---------------------------------+--------------------------+-------------------------+----------------------+-----------------------+----------------------------+-----------------------------+-------------------------+--------------------------+---------------------+----------------------+------------------+-------------------+------------------+--------------------------+---------------------------+------------+------------+-------------+---------------------+---------------------+--------------------------------------+---------------------+ | id | region | resource_id | monitor_type | status | ip | mainframe | cpu_count | cpu_util | net_in_bytes_rate | net_out_bytes_rate | net_in_packets_rate | net_out_packets_rate | mem_total | mem_util | mem_available | mem_used | disk_total | disk_used | disk_util | node_boot_time | disk_util_single | disk_device_usage | disk_device_used | disk_used_single | disk_total_single | disk_read_bytes_rate_single | disk_write_bytes_rate_single | disk_read_requests_rate_single | disk_write_requests_rate_single | disk_write_requests_rate | disk_read_requests_rate | disk_read_bytes_rate | disk_write_bytes_rate | net_in_packets_rate_single | net_out_packets_rate_single | net_in_drop_rate_single | net_out_drop_rate_single | net_in_drop_percent | net_out_drop_percent | net_drop_percent | net_out_drop_rate | net_in_drop_rate | net_in_bytes_rate_single | net_out_bytes_rate_single | node_load1 | node_load5 | node_load15 | timestamp | insert_time | resource_id | timestamp | +----------------------------------+------------+--------------------------------------+--------------+--------+------------+------------+-----------+----------+-------------------+--------------------+---------------------+----------------------+--------------+----------+---------------+--------------+---------------+--------------+------------------+----------------+------------------+-------------------+------------------+------------------+-------------------+-----------------------------+------------------------------+--------------------------------+---------------------------------+--------------------------+-------------------------+----------------------+-----------------------+----------------------------+-----------------------------+-------------------------+--------------------------+---------------------+----------------------+------------------+-------------------+------------------+--------------------------+---------------------------+------------+------------+-------------+---------------------+---------------------+--------------------------------------+---------------------+ | 79cbe5ebf7ba456a8b3933c083f63f6a | regionTest | 96e256cb-30ae-4ce3-9fdc-e291c7882818 | ph | 1 | 10.5.76.15 | 10.5.76.15 | 128 | 0.3 | 4766491.63460511 | 3609591.84190607 | 4626.20865642771 | 3521.49262929547 | 540768120832 | 8.9093 | 492589203456 | 48178917376 | 479313604608 | 16674177024 | 3.47876147551387 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:33 | 2024-05-08 16:59:00 | 96e256cb-30ae-4ce3-9fdc-e291c7882818 | 2024-05-08 16:59:33 | | 64d10c4369c74b8ba5ad32434cb3db04 | regionTest | d1bdcfb9-c188-4506-8b72-069412d426fa | ph | 1 | 10.5.76.13 | 10.5.76.13 | 80 | 10.9 | 6231505.75893001 | 4919016.23437592 | 6184.57614342053 | 4801.75407499194 | 540505235456 | 53.1090 | 253448097792 | 287057137664 | 959683256320 | 58817019904 | 6.12879504947702 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:33 | 2024-05-08 16:59:00 | d1bdcfb9-c188-4506-8b72-069412d426fa | 2024-05-08 16:59:33 | | b3e40c36feb447abbb0d73124ee52823 | regionTest | 91188358-6438-4440-996a-3c4328ed5985 | ph | 1 | 10.5.76.14 | 10.5.76.14 | 128 | 0.4 | 5383852.02904399 | 3418087.57740511 | 5253.1283124981 | 3664.63259296681 | 540768137216 | 8.8357 | 492987396096 | 47780741120 | 479313604608 | 24957288448 | 5.20688088300998 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:32 | 2024-05-08 16:59:00 | 91188358-6438-4440-996a-3c4328ed5985 | 2024-05-08 16:59:32 | | d957943eb4404cc1bf8e517bce9c9e3b | regionTest | 7b1fbdec-b4e0-4493-b004-40d4c0a71733 | ph | 1 | 10.5.76.12 | 10.5.76.12 | 80 | 23.9 | 6531087.4240595 | 6317436.87350538 | 6926.10458788819 | 5564.53961336426 | 540505296896 | 73.2645 | 144506945536 | 395998351360 | 959683256320 | 71742947328 | 7.47569021919851 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:33 | 2024-05-08 16:59:01 | 7b1fbdec-b4e0-4493-b004-40d4c0a71733 | 2024-05-08 16:59:33 | | f5a271cf401d4aecbf7f93fd0aa17a48 | regionTest | 272647fe-2986-4902-b298-8ff787f1a132 | ph | 1 | 127.0.0.1 | 127.0.0.1 | 80 | 4.2 | 7495559.78365875 | 3356019.35092553 | 7168.21290357919 | 4395.054209903 | 540505141248 | 59.8492 | 217016979456 | 323488161792 | 8959108079616 | 939321245696 | 10.4845397259262 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | 2024-05-08 16:59:32 | 2024-05-08 16:59:00 | 272647fe-2986-4902-b298-8ff787f1a132 | 2024-05-08 16:59:32 | +----------------------------------+------------+--------------------------------------+--------------+--------+------------+------------+-----------+----------+-------------------+--------------------+---------------------+----------------------+--------------+----------+---------------+--------------+---------------+--------------+------------------+----------------+------------------+-------------------+------------------+------------------+-------------------+-----------------------------+------------------------------+--------------------------------+---------------------------------+--------------------------+-------------------------+----------------------+-----------------------+----------------------------+-----------------------------+-------------------------+--------------------------+---------------------+----------------------+------------------+-------------------+------------------+--------------------------+---------------------------+------------+------------+-------------+---------------------+---------------------+--------------------------------------+---------------------+ 5 rows in set (0.00 sec)