Hrmm, I am mad suspicious about those update+innerjoin queries in the wormholeCritical event.
Again, not an expert in innodb and hard to say without the query planner, but according to this gentleman, you might be locking way more of the table rows than you expect: https://stackoverflow.com/questions/6664667/mysql-innodb-locks-on-joined-rows/12251122#12251122
You could try using a with clause, it might help hint the query planner to reduce the amount of rows locked by divorcing the...
Read moreWith the arrival of the Abyssal Proving Grounds in New Eden and an exciting quadrant full of conflict ahead of us we’re inviting capsuleers to vie for fame and glory by announcing Champions of the Abyss!
Over the course of Quadrant 3 there are nine Proving Grounds events planned. Each event will have its own unique filament which will work only during the period that event is running. Your victories for each event will be tracked on leaderboard and these leaderboards will be reset before the start of the next event. For more details check out the recent dev blog about the new Proving Filaments feature.
... Read moreOutbound from the EVE Launcher and Client then we are connecting to ports 443 on the Login Server, 26000 on the Game Server, and 5222 on the Chat Server. All TCP, we don’t use UDP.
The issue started at 21:10 according to player graphs and started to recover at 21:35.
image916×462 19 KB
Oh I will absolutely blame my ISP and get them to credit me for exploded internet spaceships.
They never understand…
Please contact our customer support department who will be able to review the case for you.
Cloudflare had significant issues this evening, see e.g. https://techcrunch.com/2020/07/17/cloudflare-dns-goes-down-taking-a-large-piece-of-the-internet-with-it/ and ...
Read moreWe are seeing some of our services coming back online but things are still quite slow. Please be patient while this matter is being looked into by us and our partners.
Hello,
Please move the conversation to the incident thread I have just set up. It will be easier for us to post updates there for everyone to see. Thank you very much!
22:12
CloudFlare appears to have addressed the root cause of the issues and are monitoring the status on their end. Our services seem to be accessible again as well, and player numbers are climbing back up.
21:55
We are seeing some services returning back to normal but overall performance is still very slow.
Hello everyone.
There was a sudden disconnect that affected many players on Tranquility around 21:15 UTC. We are actively investigating the situation which might be connected with an outage reported by Cloudflare.
I am going to share updates in this thread as they become available.
It’s a very large event. It is known about.
Hey guys, we are investigating the situation as we speak.
My recommendation would be that you start by looking into the query planner explain command. I use the TSQL equivalent a lot when doing these kinds of optimizations to the eve DB. Unfortunately, I know very little about the details of innoDB, but as an example, consider the following query:
devtrackers.gg
UPDATE signatures SET modifiedByID = 0, modifiedByName = "Tripwire" WHERE lifeLeft < NOW() AND lifeLength <> '0' AND type <> 'wormhole';
When executing that query, you’re hinging on the index being created by this key in the signatures table to avoid a whole table scan:
KEY `lifeLeft, lifeLength` (`lifeLeft`,`lifeLength`),
However, it may be buying you less than you expect. You’re about to wander into the deep magic of implementation-specific db engine index construction techniques.
Here are some good links on the topic:
Hmmm not sure, maybe I made an error moving data over from the spreadsheet and got the rows misaligned. Unfortunately the way I’m doing this has several manual steps so mistakes can occur, I’ll try to be careful.
With this current update as of 19:00 you’re back to 22 though - did you have another win since this morning or did I get it right this time?