[madkn1ght]

Thanks you so much Ari35. Can I use rankme on Counterstrike 1.3. Can you please teach me how to install it. God Bless..

[madkn1ght]

Originally Posted by Ari35 Hi madkn1ght, have you download the Plugin rankme.zip in the first page ? After you can unzip this file to the folder csgo/addons/sourcmod on your server.

Thanks So much Ari35. Can I use rankme on Counterstrike 1.3. Please help me install it. Thanks and God Bless..

[t1empO]

Hello lag version 3.0.0 rankme in CS:Go
what to do

[h3bus]

Hi, for those having mySQL using far to much CPU, here are some tips I used on my servers.

First thing is to limit the database size. This can be done using rankme_autopurge X. I personally set X to 30 for 30 days. This is a tradeoff between keeping players score on a long inactive duration and performance.
Having a smaller table will give a good performance boost.

Second but very important is to create and index on steam id. Like this (assuming that your table in named "rankme":

CREATE INDEX steam_index ON rankme(steam)

This will give a HUGE performance boost, on my server this by itself divided by 100 the CPU usage of mysql.

There might be other things you can do like changing data types of steam and lastip to VARCHAR(40) and VARCHAR(20) but I'm not sure of the performance gain on these.

[t1empO]

Originally Posted by h3bus Hi, for those having mySQL using far to much CPU, here are some tips I used on my servers. First thing is to limit the database size. This can be done using rankme_autopurge X. I personally set X to 30 for 30 days. This is a tradeoff between keeping players score on a long inactive duration and performance. Having a smaller table will give a good performance boost. Second but very important is to create and index on steam id. Like this (assuming that your table in named "rankme": CREATE INDEX steam_index ON rankme(steam) This will give a HUGE performance boost, on my server this by itself divided by 100 the CPU usage of mysql. There might be other things you can do like changing data types of steam and lastip to VARCHAR(40) and VARCHAR(20) but I'm not sure of the performance gain on these.

Hello lag version 3.0.0 rankme in CS:Go
what to do

[Neuro Toxin]

Omg. It's like these guys are 12 and have no clue. Go study network engineering. Then you might understand.

[h3bus]

What is the point of your remark?

Is what I wrote completely stupid?
Why has CPU usage of mysqld dropped then?

[nguyenbaodanh]

Yea! H3bus can you optimize this plugin ? way too lag now

[h3bus]

I'm not the owner of the code.

But rankme is not causing lags on my side. Are you using sqlLite or mySQL?
If mySQL, did you try the optimizations I posted above?

[TUSK3N1337]

I dont really get it is GameMe like HLStatsX? And what is the difference between this plugin and the plugin that you have to pay for on their site http://www.gameme.com/ ??