Mysql cpu usage 99%

[pucus78]

Hi,
I have linux debian. when i run tfs its all ok until...

>> Loading config
>> Loading RSA key
>> Testing SQL connection... MySQL.
>> Loading bans
>> Loading vocations
>> Loading commands
>> Loading items
>> Loading script systems
>> Loading monsters
>> Loading outfits
>> Loading admin protocol config
>> Loading experience stages
>> Using MD5 passwords
>> Checking world type... PVP
>> Loading map
> Map size: 38000x38000.
> Map loading time: 66.159 seconds.

...and here tfs stop..
When I run top I see that mysql have 99% after map load.
I have compiled tfs 0.2.2-0.2.5 and have all time this same problem.

What it can be?

 

[DedicatedOT]

Hmm. Wipe?

To wipe, goto your PMA and say:

DROP database.

 

[pucus78]

Hmm. Wipe?
To wipe, goto your PMA and say:
DROP database.

Nahh -.-
It's work now but its took 840.854 seconds

>> Loading config
>> Loading RSA key
>> Testing SQL connection... MySQL.
>> Loading bans
>> Loading vocations
>> Loading commands
>> Loading items
>> Loading script systems
>> Loading monsters
>> Loading outfits
>> Loading admin protocol config
>> Loading experience stages
>> Using MD5 passwords
>> Checking world type... PVP
>> Loading map
> Map size: 38000x38000.
> Map loading time: 66.159 seconds.
Notice: Map load (relational) took : 840.854 s
>> Setting gamestate to: GAME_STATE_INIT
>> All modules has been loaded, server starting up...
> WARNING: The Forgotten Server has been executed as root user, it is recommended to execute is as a normal user.
>> Walkiria Server Online!

It always took only 30 seconds -.- when it takes too long i kill process... why always it taked me 28-31 seconds and now 840 seconds :/

PS. sorry for my pure english

 

[DedicatedOT]

change your map type to binary.

 

[Fragdonut]

Pucus, You could consider getting a new computer, since I doubt that you'll be able to host with many players online, however, try hosting with a smaller map then post if it still loads very slowly.

 

[pucus78]

@UP
I got 2GB RAM and 1.6 Ghz processor. Map always loaded in ~70seconds on this computer.

change your map type to binary.

Sorry for a such simple question but how to made this? config.lua?

 

[nsanee]

Yes

useHouseDataStorage = "yes"

 

[pucus78]

change your map type to binary.

That is it thanks man

The Forgotten Server - Version 0.2.5 (Mystic Spirit).
A server developed by Talaturen, Kiper, Kornholijo, Jonern, Lithium & Elf.
Visit our forum for updates, support and resources: http://otland.net/.
>> Loading config
>> Loading RSA key
>> Testing SQL connection... MySQL.
>> Loading bans
>> Loading vocations
>> Loading commands
>> Loading items
>> Loading script systems
>> Loading monsters
>> Loading outfits
>> Loading admin protocol config
>> Loading experience stages
>> Using MD5 passwords
>> Checking world type... PVP
>> Loading map
> Map size: 38000x38000.
> Map loading time: 41.949 seconds.
Notice: Map load (binary) took : 0.002 s
>> Setting gamestate to: GAME_STATE_INIT
>> All modules has been loaded, server starting up...
>> Walkiria Server Online!

 

[exique]

Still.. time to get a new computer XD

 

[pucus78]

Still.. time to get a new computer XD

Yeah sureeee u have better lol i use real map and I dont think that 42 seconds its too much to load map

 

[john290]

I have too 100% cpu apache2 :/ i set useHouseDataStorage = "yes"

 

[Znote]

If your using Linux and its not a VPS then its nothing wrong with your computer nor OS.

 

[john290]

I have got this - Serwer dedykowany Superplan Mini - OVH server

10 minutes is 20% cpu, 1 minutes is 100% cpu...