• jumbojim22 (7/14/2014)


    Hello,

    Consider a set of static data of which I want people to run their own queries against.

    What methods might be available to prevent someone from either purposely (or accidentally) DOS'ing the server via some sort of bad command? ie - a ton of joins on virtual tables. Monitoring the resources of Python alone would not suffice, particularly if they have caused the mysql process to run away.

    The data would actually be read-only and would not change.

    Thank you.

    First things that come to mind are memory resident database and resource governance.

    😎