Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

Local tables bloating in size 3.3.5??

spleee254

By spleee254,
in Help and Support

 Share

Recommended Posts

spleee254 Newbie

spleee254

Posted
Posted (edited)

Hey there everyone, so I looked all around the web to see if anybody else has had this issue I am experiencing but i have come up empty on the search. Basically what is happening is every few days (2-3) the local_broadcast_texts  and local_page_text and serveral other "local" tables are increasing in size at a rate that clearly is not normal. We always keep our DB update and have long been using trinity core with out issue, so such an issue is quite odd to us. Starting with a fresh DB is not an option because of all of our work, so i was hoping someone here could point me in the direction to find the cause of this so we can address and fix it. I appreciate any help in advance,

Edited by spleee254
Link to comment
Share on other sites
Rochet2 Newbie

Rochet2

Posted
Posted

How big is it now? - clean seems 3.9MiB
How many rows are there? - clean seems 1946
Are there any custom rows in there?

Are you saying you have applied updates over the time you have noticed increasing? Might be that updates just added stuff.
The above values are from https://github.com/TrinityCore/TrinityCore/commit/fbaed38b5ea605e3dbd65a99835db1778ac24391

Link to comment
Share on other sites
spleee254 Newbie

spleee254

Posted
  • Author
Posted

I appreciate the quick replies, I make sure the updates are applied correctly so that there's no duplicate data or anything like that. A better way to describe the situation, I delete the local tables, replace them with fresh stock local tables, over the course of a few days they  shoot up by about 30-75mb range. the server is not using more memory then usual, (mine sits at about 950mb always because of all our custom stuff) and its not spitting any errors that would link it to that. My next question i suppose would be are our custom creatures we have added that have smart scripts and eluna scripts etc somehow filling these tables with info, again that's just my speculation as to what it could be.

Link to comment
Share on other sites
Rochet2 Newbie

Rochet2

Posted
Posted

Can you say a specific table and the values of the size of it (size and amount of rows)?
Currently there is no clear single example with exact values.

The locales tables in general vary from 1KiB to 70MiB so its hard to compare with "non modified" values.
Also the memory usage is probably not directly related to the saved data. Im sure if we have exact same databases they will probably vary in size.

Its not likely any script unless you can find the table name of the increasing table in them.

Link to comment
Share on other sites
 Share
Go to topic listing

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • PavelFreeman
      Error with compilling Trinity Core
      By PavelFreeman
      Hello, I want to compile Trinity, but I get this errors...

      Did everything according to the documentation (https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130077/Installation+Guide) for Windows 10.

      Visual Studio 2019.
    • PhaseV
      [3.3.5] No Leatherworking bags
      By PhaseV
      I unfortunately had to find out that there are no bags for the profession of leather processing in the current database for 3.3.5.  Is that also the case with you?  Can someone who has this available as SQL?
      Greetz PhaseV
    • Valufa
      Spell information in a file.
      By Valufa
      Hello, would anyone know if there is an XML OR JSON file with all the class spells from section 3.3.5a?
      If not, would you know how to inform the procedure on how to extract this information from the game client, or some way faster than Web Scraping?
       
    • Dipdill
      3.3.5 (12340) Client Wont Connect
      By Dipdill
      So I got a new Trinity Core server up and running.  For the life of me I can not get my client to connect.  I have edited the Data\enUS\realmlist.wtf to point to my server.  I have confirmed that the firewalls are open to both 8085 and 3724.  When I open the wow.exe client I use my credentials and it immediately goes to Downloading Update screen and sits at 0%.  I have also added set patchlist to my server thinking that might help and still no go.  I downloaded the client from warmane as mentioned in this thread:  
      Did I miss a step on patching the wow.exe file?  I know on the new master branch there is a patching process... but I didn't see one for the 3.3.5 branch.  
      Thanks
    • Hesione
      enforce peace fix in abc?
      By Hesione
      I'm having a problem with a number of factions not getting the flag "at war" in the reputation tab, and this is unable to be selected by the player. Currently, this is with The Oracles, as my character has their reputation with Frenzyheart. The problem occurs when one of two opposing factions is chosen as the positive reputation one. That said, Bloodsail Buccaneers seems to work fine.
      I did a search on how to fix this, and found this on the TrinityCore issues tracker: https://github.com/TrinityCore/TrinityCore/issues/9469 (specifically https://github.com/TrinityCore/TrinityCore/issues/9469#issuecomment-78925130)
      Do I just go into the ReputationManager.cpp file and edit it directly? I don't understand how the dbc/cpp files are used. Are they called by the client each time the client is started up?
      I found the code for ReputationManager.cpp here: https://github.com/TrinityCore/TrinityCore/blob/master/src/server/game/Reputation/ReputationMgr.cpp
      I don't understand how the fix goes into this code. I can see a Git pull (push?) whereas I thought I could just edit ReputationManager.cpp directly. If so, which lines do I replace (if any)? Otherwise, where should I insert the fix?
       
×
×
  • Create New...