• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Mysql Reduce Save Time / Laatido Question

OTx

OTx

Member
Joined
Aug 3, 2012
Messages
126
Reaction score
10
I've heard that It's possible to reduce the time of save on TFS by MYSQL database editions. If yes, then how to do it?
The most RL servers are saving on 1-2 seconds with 100 players online.

Laatido Question:
Can I have larger than 99mb map with Laatido?
 
Sort by date Sort by votes
Aha, on startup you choose OptimizeTablesblablabla = true?
That's already on "true" but It's still slow save :(

So SSD have something to do with this aswell?

Laatido question?
 
Upvote 0 Downvote
You do not need to edit the database. There is something like increasing mysql server configuration.

But I know a simple solution that effectively reduces save time.
Go to config.lua and find this line:
LUA: 
useHouseDataStorage = "no"
change it to:
LUA: 
useHouseDataStorage = "yes"

Or it could be "true" but you change it to "false".
 
Upvote 0 Downvote
Optimize with mysqltuner.

How much larger exactly? I've seen some having around 110MB which ran fine.
 
Upvote 0 Downvote
Ninja said:
Optimize with mysqltuner.

How much larger exactly? I've seen some having around 110MB which ran fine.
Click to expand...


Where can I download mysqltuner?
Aha, because before laatido I had 101mb map and it told me to compile it with 64-bit and crashed. I just asking if It can handle higher than 100mb big map with Laatido support.
Thanks :)

FreshMapper said:
You do not need to edit the database. There is something like increasing mysql server configuration.

But I know a simple solution that effectively reduces save time.
Go to config.lua and find this line:
LUA: 
useHouseDataStorage = "no"
change it to:
LUA: 
useHouseDataStorage = "yes"

Or it could be "true" but you change it to "false".
Click to expand...

It's set to "false" now. What does it do, actually?
 
Upvote 0 Downvote
It's the house data storage, obviously, it reduces the save time, not much at all but a little bit .
 
Upvote 0 Downvote
OTx said:
Where can I download mysqltuner?
Aha, because before laatido I had 101mb map and it told me to compile it with 64-bit and crashed. I just asking if It can handle higher than 100mb big map with Laatido support.
Thanks :)



It's set to "false" now. What does it do, actually?
Click to expand...

It stops using House data storage which take some seconds to load. How fast does it load now?

Loney said:
It's the house data storage, obviously, it reduces the save time, not much at all but a little bit .
Click to expand...

It is very useful and can reduce save time up to 50x!
 
Upvote 0 Downvote
Back
Top