Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo


Log tables

  • Zlatan Momic
    Zlatan Momic

    What about data in log tables like gameEvents, halloffame_archive, itemlog, kills, loginEvent, loginseed? With time that tables will have large number of records. Does this affect performance? Do you have any method of archiving them or deleting old log data?

  • Katie Russell
    Katie Russell

    Hi, as far as I know we don't delete old data.

    On gameEvents we've used rolling partitioning by date as old data is less interesting than new data. I mean simply, rename the existing table to a date-stamped name and create a new table called gameEvents which is empty. Not "MySQL partitioning".

    Other tables (e.g. itemlog) we prefer to keep a full history intact. But they're rarely read and our asynchronous database access means bigger queries, when needed, are not a problem.

    We recently improved the indices on loginEvent as we noticed a delay on login if the database was under load.

    For the website (i.e. Hall of Fame, Recent Events, Kills) we use caching to minimise the number of required reads.



Cancel   Add attachments