slow response for dynamically generated reports

I have a domain controller generating a very large number of events on a daily basis, well over 1 million. Events are collected by the manage engine server without any issues.

However, when i click on the specific event types to view detailed information, it takes a long time to generate the graphical report page. For example, clicking the "unsuccessful user logos" tag has been churning for the past 12 minutes and it's still going.

The manage engine server is running on a Dual Xeon machine with 4gb of ram. I see mysqld-nt.exe using ~20% of the processor. If there some optimization change that needs to be made to allow mysqld-nt to use more resources and execute in a more timely fashion?