stats

Page 3 of 10 Previous  1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next

View previous topic View next topic Go down

Re: stats

Post  Christina_Cox on Wed Feb 01, 2012 10:19 am

Since the RO server has been changed to all weapon. I created a new stats page for AW details.
The original RO server stats have been kept and they will continue if we change back to rifle only.

In the meantime you can use the server selector in the top right corner of the page to view details for every server.

Also as Sixer pointed out. When you click on a medal (bash for example), you go to a page where all bash stats are shown, from all servers together...... so you have to go to the top-right corner and select the bash stats for every server individually.

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  Christina_Cox on Fri Feb 10, 2012 7:32 am

For security reasons I had to upgrade my server to PHP 5.3.9

This broke the stats server and also caused my hosting server to crash several times, along with my clients' websites.

I turned off the stats server till I find a way to optimize the database server resource usage so it does not block the entire server.

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  master_jeebus on Tue Feb 14, 2012 11:16 am

i get a 404 when i try to check the stats page?
avatar
master_jeebus

Posts : 842
Join date : 2011-09-03
Age : 37
Location : Finland

View user profile

Back to top Go down

Re: stats

Post  Christina_Cox on Tue Feb 14, 2012 12:52 pm

Unfortunately the stats must be taken down since they kept crashing my server.

The player database just got too big (over 4 million records) and it kept running my CPU usage off 100% for 1-2 hours while i was parsing the logs.

Now I understand why almost all UltraStats installations i saw never went above 10 000 kills per person and tracked only recent rounds. The database just gets to big for any server. I even moved it from a shared hosting account to my VDS and it kept crashing. Tried installing it locally, parsing the log and then uploading it to the server... crashed either when parsing, or when trying to upload.

Searched for other tools... but didn't find any that supported Cod:UO.

We either shut them down....or we restart tracking from 0 and reset it every 6 months.

The former stats are here... but not updated: http://is7s.com/dhstats1/


Last edited by Christina_Cox on Tue Feb 14, 2012 4:37 pm; edited 1 time in total

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  #green___ on Tue Feb 14, 2012 4:34 pm

Reset stats every 6 months and keep an archive is good enough imo

#green___
|DH|Clan Administrators~
|DH|Clan Administrators~

Posts : 848
Join date : 2010-12-27

View user profile

Back to top Go down

Re: stats

Post  Weeds on Wed Feb 15, 2012 10:55 pm

Stats are still not working...just start them from new! affraid
avatar
Weeds

Posts : 271
Join date : 2011-09-04
Age : 25
Location : Germany

View user profile

Back to top Go down

Re: stats

Post  T-T-TOSTIE >_< on Thu Feb 16, 2012 7:14 am

#green___ wrote:Reset stats every 6 months and keep an archive is good enough imo
avatar
T-T-TOSTIE >_<

Posts : 478
Join date : 2011-05-17
Age : 22
Location : Hoorn,Noord-Holland,Netherlands

View user profile

Back to top Go down

Re: stats

Post  Christina_Cox on Mon Feb 20, 2012 9:14 pm

good news.... kinda finishing all my other projects and i'll have time to re-up the stats websites at the end of the week

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  Christina_Cox on Fri Feb 24, 2012 2:36 pm

Bad news: I will not be keeping the stats anymore.

Technical stuff:
- the stats server was written without any table indexes...so every query to display data queries the entire table and not the proper index ---> long index ---> server CPU usage goes up + server memory load goes up ---> server goes down --> i call customer support --> they charge money to get their butts up and restart the server by hand (if i use a shared hosting account, they'll just simply deactivate my account untill I take it down)
- almost every query, due to the lack of indexes becomes a long/slow query
- written for the completely wrong MySQL engine, the count operation takes way to much, but InnoDB was not that known when UltraStats was written
- there are no limits set for general SELECT queries, so any stupid data display, like the last 10 rounds of a single player, interrogates all the database, instead of counting the first 10 results and just printing them.


If you have another stats keeping solutions let me know, and I'll try them out.
Meanwhile, I can't even export the database tables anymore.

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  3Bsalam ; ) on Fri Feb 24, 2012 11:20 pm

Christina_Cox wrote:Unfortunately the stats must be taken down since they kept crashing my server.

The player database just got too big (over 4 million records) and it kept running my CPU usage off 100% for 1-2 hours while i was parsing the logs.

Now I understand why almost all UltraStats installations i saw never went above 10 000 kills per person and tracked only recent rounds. The database just gets to big for any server. I even moved it from a shared hosting account to my VDS and it kept crashing. Tried installing it locally, parsing the log and then uploading it to the server... crashed either when parsing, or when trying to upload.

Searched for other tools... but didn't find any that supported Cod:UO.

We either shut them down....or we restart tracking from 0 and reset it every 6 months.

The former stats are here... but not updated: http://is7s.com/dhstats1/
scratch scratch scratch
silent silent silent
Question Question Question
pale pale pale
avatar
3Bsalam ; )
|DH|Clan Administrators~
|DH|Clan Administrators~

Posts : 759
Join date : 2010-11-29
Age : 24
Location : Egypt

View user profile

Back to top Go down

Re: stats

Post  johnny pistola on Sat Mar 10, 2012 5:13 pm

Christina_Cox wrote:Bad news: I will not be keeping the stats anymore.

Technical stuff:
- the stats server was written without any table indexes...so every query to display data queries the entire table and not the proper index ---> long index ---> server CPU usage goes up + server memory load goes up ---> server goes down --> i call customer support --> they charge money to get their butts up and restart the server by hand (if i use a shared hosting account, they'll just simply deactivate my account untill I take it down)
- almost every query, due to the lack of indexes becomes a long/slow query
- written for the completely wrong MySQL engine, the count operation takes way to much, but InnoDB was not that known when UltraStats was written
- there are no limits set for general SELECT queries, so any stupid data display, like the last 10 rounds of a single player, interrogates all the database, instead of counting the first 10 results and just printing them.


If you have another stats keeping solutions let me know, and I'll try them out.
Meanwhile, I can't even export the database tables anymore.

What pity, now that had improved my statistics!

Yes Master Don\'t know Crying or Very sad
Depressed
avatar
johnny pistola
Donors & Honorary Members
Donors & Honorary Members

Posts : 18
Join date : 2011-08-08
Age : 44
Location : barcelona

View user profile johnnypistola

Back to top Go down

Re: stats

Post  Christina_Cox on Tue Mar 13, 2012 9:15 pm

I'm testing some new stats trackers.

This is just a test: http://is7s.com/serverstats-test/

It will not be the official stats server, since it lacks features.
Maybe someone is interested in seeing what they did the last 2 months on the SD RO server.

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  T-T-TOSTIE >_< on Tue Mar 13, 2012 9:30 pm

Christina_Cox wrote:I'm testing some new stats trackers.

This is just a test: http://is7s.com/serverstats-test/

It will not be the official stats server, since it lacks features.
Maybe someone is interested in seeing what they did the last 2 months on the SD RO server.

doesnt look bad, not flashy too tho'

its enough. ^^

its this a perm thingy or just temp?
avatar
T-T-TOSTIE >_<

Posts : 478
Join date : 2011-05-17
Age : 22
Location : Hoorn,Noord-Holland,Netherlands

View user profile

Back to top Go down

Re: stats

Post  Christina_Cox on Tue Mar 13, 2012 9:36 pm

temp
I found another tracker that does the same thing as the old UltraStats.
But I have to test it for a week, to see if it can remember results or if it crashes my server.

It's something like this: http://hbcweb.nw.io/vsp/pub/themes/bismarck/index.php

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  Christina_Cox on Wed Mar 14, 2012 9:12 pm

http://dh.is7s.com/

the stats are back
BUT: i'm still dodging out some details (the awards don't work yet)

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  Christina_Cox on Wed Mar 14, 2012 9:31 pm

the awards work now
to see what award the player has, just hover the mouse over the shield

PS: SD RO server coming in 1-2 days as well

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  T-T-TOSTIE >_< on Thu Mar 15, 2012 9:42 am

Christina_Cox wrote:the awards work now
to see what award the player has, just hover the mouse over the shield

PS: SD RO server coming in 1-2 days as well

niiiiiice(:

kudo's to you! ;D
avatar
T-T-TOSTIE >_<

Posts : 478
Join date : 2011-05-17
Age : 22
Location : Hoorn,Noord-Holland,Netherlands

View user profile

Back to top Go down

Re: stats

Post  Christina_Cox on Thu Mar 15, 2012 9:54 am

the dates are a lot off (think 41 years difference) \:-{|>
i'll fix them after i have time to read some ADOdb documentation ...

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  Christina_Cox on Fri Mar 16, 2012 7:28 am

Christina_Cox wrote:the dates are a lot off (think 41 years difference) \:-{|>
i'll fix them after i have time to read some ADOdb documentation ...

The stats for the main server are back to being updated on a regular basis. The dates are still off.
Since we track stats by user cd key ---- the 129 egyptians that play with the same CD key are currently leading the stats Cry laughing


The RO SD server coming tonight. ●~*

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  #green___ on Fri Mar 16, 2012 9:30 am

The stats system is way faster than the older one =)

#green___
|DH|Clan Administrators~
|DH|Clan Administrators~

Posts : 848
Join date : 2010-12-27

View user profile

Back to top Go down

Re: stats

Post  |DH|R4ndom. on Fri Mar 16, 2012 9:49 am

yeah, i noticed that to. it's way faster to see someone's details.

good job christina! ^^
avatar
|DH|R4ndom.

Posts : 702
Join date : 2011-10-16
Age : 22
Location : Maastricht,The Netherlands.

View user profile

Back to top Go down

Re: stats

Post  Christina_Cox on Fri Mar 16, 2012 6:37 pm

http://dhsd.is7s.com
SD RO Server stats

I put 2 different skins per stats server to distinguish one from another.
I recommend keeping it that way yourself.

If you ain't listed, means you haven't made the 100 frags threshold ... but you can find your name if you manually search for it.

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  T-T-TOSTIE >_< on Fri Mar 16, 2012 7:14 pm

Christina_Cox wrote:http://dhsd.is7s.com
SD RO Server stats

I put 2 different skins per stats server to distinguish one from another.
I recommend keeping it that way yourself.

If you ain't listed, means you haven't made the 100 frags threshold ... but you can find your name if you manually search for it.

lookiiiiiiiiiiiiiiiiiiiiiiiiiiiiiing goooooooooooooooooood!

/kneel
avatar
T-T-TOSTIE >_<

Posts : 478
Join date : 2011-05-17
Age : 22
Location : Hoorn,Noord-Holland,Netherlands

View user profile

Back to top Go down

Re: stats

Post  |DH|R4ndom. on Tue Mar 20, 2012 12:05 pm

christina, do the new stats work with ip tracking? because it's counting aliasses, and GUID's.
avatar
|DH|R4ndom.

Posts : 702
Join date : 2011-10-16
Age : 22
Location : Maastricht,The Netherlands.

View user profile

Back to top Go down

Re: stats

Post  Christina_Cox on Tue Mar 20, 2012 12:24 pm

Works by GUID / cd key.

__________________________________
Using hacks is not skill.
Killing hackers is true skill.

avatar
Christina_Cox
|DH|Co~clan Leaders~
|DH|Co~clan Leaders~

Posts : 2017
Join date : 2011-02-01
Age : 33
Location : Romania

View user profile christinacox

Back to top Go down

Re: stats

Post  Sponsored content


Sponsored content


Back to top Go down

Page 3 of 10 Previous  1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum