I got a little Problem here … Scenario:
Server 1: HTTP Server where our CMS is
Server 2: MySQL Server of the CMS
Sometimes (a few Times a Week) we got MASSIVE Traffic Spikes between those 2 Servers. (200-300 MBit for 1-2 Minutes) and I’m unable to find the Source of those massive Traffic Spikes … My guess is that there is a Bogus-Query which fetches a very Big Resultset … but I was not able to find such a Query. (Not to wonder with xxx.xxx Queries within the CMS …)
Already tried it with the Slow-Query-Log, with Peak Memory Monitoring within PHP, … but no luck yet.
Now I wanted to ask if there is some possibility to monitor/log if MySQL delivers such a big Resultset - and if - which Query triggered it …
Hope someone here can help me with this?!
Thank you, bye from sunny Austria