Re: query optimization

[Rick James]

    where  p.host_name in (
        SELECT  node_name
            from  oam_db.node
            where  cluster_name='AIRTEL_TANZANIA_MOBIQUITY' 
                           )

--> (to avoid the poor performance of "IN ( SELECT ...)")

    JOIN   oam_db.node AS n
        ON n.node_name = p.host_name
    where  n.cluster_name='AIRTEL_TANZANIA_MOBIQUITY'

Avoid leading '%' when possible

INDEX(timestamp)

INDEX(cluster_name, node_name)

There may be more suggestions. If these suggestions do not suffice, please provide SHOW CREATE TABLE.