1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Many POST requests

Discussion in 'Site & Server Administration' started by Hecky, Jul 30, 2011.

  1. #1
    Hi,

    I run a game server and it uses a mysql database to save the stats (or at least, it kind of does). What happens is, whenever data is sent or retrieved from the database, the game sends HTTP POST data to a php file, which then reads the POST data (name, id, score), and inserts it or withdraws it from the mysql. The result data (or error) is then returned to the game.

    This works fine, except it suffers from random errors sometimes (500, 503 errors typically), especially when many people connect or disconnect from the server at once (for example, when the server restarts for an update). The files, game server, and mysql database are all hosted on the same server.

    When this happens, people lose their data and get grumpy.

    Is there anything I can do about this?

    Thanks
     
    Hecky, Jul 30, 2011 IP