|
Author |
Thread Statistics | Show CCP posts - 5 post(s) |
|
Valar
|
Posted - 2006.08.12 12:44:00 -
[1]
Bookmark loading is causing unusually big load on the database server, I'm taking some measures to fix this without a reboot. ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport |
|
|
Valar
|
Posted - 2006.08.12 12:51:00 -
[2]
Yeah, slowly getting better ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport |
|
|
Valar
|
Posted - 2006.08.12 12:53:00 -
[3]
Originally by: Valan
Originally by: Valar Bookmark loading is causing unusually big load on the database server, I'm taking some measures to fix this without a reboot.
You seem to have done the trick, running smooth now.
Any reason why it's been like this two Saturday's in a row? Is it a different maintenance routine on a Saturday? Or is it prep for Kali?
There was no maintenance other then the daily downtime jobs done last saturday, so I guess its just because more players log in right after downtime on saturdays. ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport |
|
|
Valar
|
Posted - 2006.08.12 14:02:00 -
[4]
Originally by: Scetrov Edited by: Scetrov on 12/08/2006 12:52:13
Originally by: Jenny Spitfire
Or 100 escrows returning to BM sellers during downtime?
I would hazard a guess that BMs in containers or on escrow take up residence in the items table rather than the bookmarks table. My rational being you cant right click warp to a bookmark in your hold only in People and Places, also Valar mentioned that a BM in a hanger took up an ItemID.
Bookmarks in people and places take up 1 row in the bookmarks table, but bookmarks as items take up 1 record in the bookmarks table, one in the vouchers table and one in the items table.
The bookmarks table is the biggest table in the db taking up more then 14% of the total space. ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport |
|
|
Valar
|
Posted - 2006.08.12 14:28:00 -
[5]
I've cleared all traffic advisories, a relog will make the autopilot allow you to select a route to previously locked systems. ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport |
|
|
|
|