[AeroAcrobat]

I'd like to disable the awards system because I have no use for it.
How should I go to do this and not break everything ?

Also has someone tried the InnoDB storage engine instead of MyISAM for hlstats ?

[Mavrick4283]

Do not run the hl_awards.pl

And yes I have moved the new version over the InnoDB because of the performance jump.

[AeroAcrobat]

Originally Posted by Mavrick4283 Do not run the hl_awards.pl

but the hl_awards.pl script is also responsible for maintaining & optimizing the database.

I've seen in the script:

 Actions (specify none or more, default -iarp):

I'm simply going to edit the parameter in my cron job.

Originally Posted by Mavrick4283 And yes I have moved the new version over the InnoDB because of the performance jump.

We've converted everything to InnoDB. Performance was good but the ingame response time, if you say "rank", was really slow. From 3 seconds up to 1 minute until the rank was shown ingame. I don't know why ...

A manual sql query was super fast.

Additionally I'd like to ask if you are looking for beta testers at this moment ?
Thanks!

[Rytis]

Originally Posted by AeroAcrobat but the hl_awards.pl script is also responsible for maintaining & optimizing the database.

Run with -p and -o, that should work and not calculate times etc..

[Mavrick4283]

Originally Posted by AeroAcrobat We've converted everything to InnoDB. Performance was good but the ingame response time, if you say "rank", was really slow. From 3 seconds up to 1 minute until the rank was shown ingame. I don't know why ... A manual sql query was super fast. Additionally I'd like to ask if you are looking for beta testers at this moment ? Thanks!

Converting the DB to InnoDB is not something you do for all the tables, MySAM has much higher read times but InnoDB can write faster (to over simplify it). So that is why you were seeing the difference, that you have to create new key's and index (most of the time) to get the most out of the different engine.

TBH I am not a database admin, I have my degree in network security. So all the SQL I leave up to my friend who is much better at DB design. So if it sounds like I am talking out my it is because I am repeating what I have been told.