BLOG: Working on TheCLQ.com / AllGameServers.com

[BattleMode]

Intergrated everything into the website.

E.g. this page:
http://www.theclq.com/ags/player.php?player=%5BBBS%5DBattleMode&sub=4

Describes how you can add this to a forum (includes short hyperlink):

[BattleMode]

Some tests to check all Unicode stuff is working:

[BattleMode]

Made a smaller version:

[BattleMode]

Introduced different font sizes and color schemes:
Selectable here: http://www.theclq.com/ags/player.php?player=%5BBBS%5DBattleMode&sub=4

Examples:

[BattleMode]

Introduced 2 more color schemes and 1 new banner, the BIG banner:

[BattleMode]

One final test with full Unicode etc.

[BattleMode]

Added support for Left 4 Dead 2 now. Will probably be a little while before The CLQ finds a bunch of servers.

http://www.theclq.com/ags/servers.php?game=l4d2

[BattleMode]

The CLQ found 4800 servers for L4D 2: http://www.theclq.com/ags/servers.php?game=l4d2

[BattleMode]

The massive recalc I started "11 Nov 2009" finally completed. The stats of the last year are now as accurate as possible.

A week ago I made some changes to the CSS to make TheCLQ look better with very wide screens.

Today I worked on speeding up the slowest stat: ranking history. I fixed it by limiting the time spend on collecting historic data and at the same time starting a background process collecting all data. So The page will now be faster and if it is opened more that once it will be complete as well. I also changed caching settings so cache wipes will no longer clean all this data.

[Slaughter]

The massive recalc I started "11 Nov 2009" finally completed. The stats of the last year are now as accurate as possible.

Was that a non-stop recalc?

[BattleMode]

The massive recalc I started "11 Nov 2009" finally completed. The stats of the last year are now as accurate as possible.

Was that a non-stop recalc?

Yes. Took a "few" CPU cycles.

[BattleMode]

The realtime player statistics sometimes lagged a bit. This is understandable given that thousands of player records have to be updated every second. Especially player records that where not in RAM or SSD cause problems because those have to be fetched from (slow) harddisk.

I now implemented a quota based system in which the access to disk is time limited. So every block of data to be processed gets a fixed amount of time for harddisk access. This means the system will now automatically adapt to how busy the harddisk is. If the harddisk is busy less objects will be fetched.

In practical terms this means the amount of time someone has to be online before TheCLQ starts keeping realtime data for that player is now dependent on how busy the server is. It also means that once TheCLQ starts tracking a player in realtime, it will keep updating the stats very fast even while the server is busy.

[BattleMode]

Command to remember: cp -vdpu --reply=yes /var/lib/mysql/ags/* /ssd2/agstables/

[BattleMode]

Got a disk full problem causing some problems.

The solution: find /data/scans/2009 -name '*__*' | xargs rm