Find Queries with huge Result-Set


we are using MariaDB as DB for our CMS. Lately I noticed a massive growth in Traffic between our HTTP <--> DB Server. Normally we got about 10MBit/s but since a few Days it's over 100MBit/s ... My first guess would be a Query which delivers a really huge Result-Set back to the HTTP Server - but I'm unable to find out which Query this could be (hundreds of Queries / Second) Already searched hours for an Answer - but no luck so far ... so I hope someone here can help me finding the Bogus Query ... ;-)

Thank you, bye from sunny Austria Andreas Schnederle-Wagner


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.