I am still working on launching RDR2 RP tracking (and other changes, see previous blog for some more info). I have currently gotten sidetracked with rewriting the clip processing part of the backend java app. Despite all my best efforts of optomisiation on my home pc I was only able to process 100k clips an hour without noticeable impact on my pc / the test website. I had completely rewritten everything I could to eke out better performance when I decided to check the root of the issue. Turns out my local MySQL settings were pretty awful, only allocating 8mb for the inno db buffer. (How much ram of a specific table type could use as a buffer at a time).

This obviously was very minuscule amount but I had been suffering from ram issues for awhile, I have an old i7 920 pc and it had 6 gigs of ram total. I bumped it up to 80mb, this helped a fair bit but obviously was still rather low. I decided to finally bite the bullet and buy some more ram, it is something I have been meaning to do since I originally built the pc. I originally built it around 10 years ago and cheaped out on the ram with the intent to replace it / add more later. I never thought it would be 10 years later however.

Regardless, I bought 12 gigs of ram and installed it today. I then unleashed MySQL and it is currently eating 6gb of my ram but is it blazingly fast, I went from being able to process 100k clips an hour to 200k clips a minute. Not only that I was able to use my pc without it randomly freezing and crawling to a snails pace. Definitely something I should have done along time ago but money and other factors delayed it. I have spent today playing with MySQL settings and the performance is night and day. Everything is beyond insanely fast, I had to actually whip up a quick request throttler as Twitch only allows around 800 requests a minute and the backend end was doing 800 requests every 20 seconds.

To the point, I am still working on things and preparing a deployment plan as there is...

I always post in the discord when I remove/add new servers but I rarely make blogs about them. So to summarise the latest changes: Magicality RP, Slick Top Gaming and Redacted RP are no longer actively tracked servers. We have recently added Our Benefactors, SVRP and Twitch Paradise RP as tracked servers.

Removals

Magicality RP is currently shut down from what I could find from googling. Slick Top Gaming and Redacted RP I couldn't find much about but they haven't been streamed. SoE and Revolution Life RP are currently also candidates for removal but it seems like they do have some activity if not a lot.

Additons

SubVersionRP is a heavily streamed server and we have had several requests to add them. It is currently Ming's home for now and apparently some of the Chang Gang members will be stopping by this week to check it out.
Twitch Paradise is another server we added because of a few request and they have a fairly active streamer base. I checked it out last night watching some of the court RP and it definitely seems interesting.
Our Benefactors which is often regarded as Dondi's server despite their mission statement? saying it is not :P The server is highly active with many names from FamilyRP NoPixel and many other servers. They have a strong focus on realism and punishments from what I have seen. Dondi if you didn't know was a semi controversial streamer from No Pixel but his true claim to fame is he is the developer of The Isle. Definitely a server with a lot of potential and worth checking out.

Some of the less recent additions we have added are:
TheCrewRp which has a strong streamer base and Ezilii is their main developer. One of our most recent Helper additions is SimplyAmanda and caretaker...

Once again Andre is raising money for Extra Life, if you haven't heard about Exta Life they raise money for the Children's Miracle Network Hospitals. Their entire purpose is to unite gamers to help support children going through some of the darkest times of their lives. Since 2008 they have raised $70 million dollars so far for sick and injured children which has been spread between 170 hospitals and provide 32 million treatments a year. !00% of all donations go towards the hospitals. For a bit more background click here.

Andre has been supporting Extra Life for 5 years raising funds for them in anyway way he can. This year he will be doing at least three streams to raise funds for them. He will be playing a variety of games and in various tournaments with other Extra Life Streamers. He is currently live but he will also be streaming on Wednesday and Thursday (coincidentally his birthday - so be sure to wish him a good one) and depending on support a Friday stream. He will be starting his streams at around 2pm est (roughly) and playing a variety of games including tournaments with other Extra Life streamers.

Not only has Andre been a massive supporter of Extra life he was the second person to reach out to Has Root to improve the site, and to this day he is 2nd in character additions only bested by myself. He was also someone who supported me when I would lose faith in the site and always pushed me to take the site further. I would encourage you all to support Extra life and Andre because they deserve it.

Also for only $10 you can make him do 10 pushups and watch him suffer, I REALLY encourage you to do this donation amount, y'know - for the kids!

Go watch now and you can also check out the ExtraLife4Kids Channel!

Thanks.

ScottishRambler.

Just wanted to showcase an amazing stream/vod I am watching, it was an insane ride with many unexpected twist and turns but more importantly it was a unique slice of NoPixel. DasMEHDI's recent permathon which I am still currently watching involves him making 'one life' characters and if they die or go to jail they are deleted. There are rules to allow extra lives to be given for 100+ subs etc but that's the essence.

tl;dr watch this vod! :P

I tuned in expecting some luls and we got that with the first character: (click character names to go to the VODs of them)
Karen, a coupon obsessed housewife who wanted a higher status in life, hell bent on getting black friday discounts.
Followed by Reema the "Whore Lord", Ramee's older sister who was instantly brought into the fold and got to experience an intense snapshot of how the CG operate: bank jobs, shoot outs, inner gang discussions and SBS galore.
Then Mervin (continues in this vod) a potential predator turned PI turned #1 assasination target in the city, whose story involves other people’s permas and major implications.
There may be another character as I haven't actually finished the VOD yet :P

While these stories by themselves are worth watching what was really unique was that it was a glimpse of the city we never really see from one streamers pov. With each character that was created we got to see another side of the server, showcasing different roleplayers and the groups that control different areas. Mehdi was traveling around the city and it felt alive in a way I hadn't really appreciated nor even seen in all my years watching GTA RP. From gang bangers, bank robbers, tarot card readers, civilians, petty criminals and totally not a gang at all HoA to the...

I was investigating a potential issue with notifications and realised that things really didn't update as often as they could. When I first wrote everything it was with the intention of causing as little load on the server as possible as we were hosted for free. As we now have our own server to go nuts with I unshackled a lot of the backend and let it go wild.

The stream list now updates every minutes and we now pull clips from Twitch nearly constantly. The clips views on the site are still cached for 10 minutes but I will probably reduce that in the coming days.

Also if you missed it we have a new user scripts page now which adds HasRoot history buttons to Twitch VODs and Clips so you can go straight from the moment you are watching to other streamers points of view!

Enjoy!

ScottishRambler.