Linux Long server save = kicks

[Helga]

Aight, so the database is growing like hell and there's 400+ players online... This leads to a 25~ seconds long server save. The save is taking up all the threads and this makes the players to get disconnected from the server.

Is it possible to fix this? Like change the timeout? Or leave a thread open for the connection?

Thanks in advance,
Helga

 

[Bam]

This happens on 0.4 tfs with this dedi.

Intel i7 975 Extreme 3.33Ghz
12GB DDR3

So no, the server comp aint the problem.

 

[Znote]

Wow, I'm impressed how you just ignored Stians suggestion.

Having RAM problems with a 8GB ram computer? Running several OT servers on the same machine?

 

[Bam]

People dont have 100 piles of CC stacks dude, that aint the problem.

Your doing it wrong, however thanks stian.

We just need a solution until elf can fix it back to the way it was.

The "your doing it wrong" was to another person.
And the "thanks stian" was actually an appreciated thanks.


To be honest, he's the only person in this thread who have came up with something that made sense.

Wow, I'm impressed how you just ignored Stians suggestion.

Having RAM problems with a 8GB computer? Running several OT servers on the same machine?

We use 12gb, and the RAM aint the problem.

Give up, geez.

 

[Helga]

Wow, I'm impressed how you just ignored Stians suggestion.

Having RAM problems with a 8GB computer? Running several OT servers on the same machine?

I'm not ignoring Stian's suggestion, but I'm ignoring yours.

 

[Znote]

Yeah lol fuck my suggestion. Stian got me. I just noticed in this thread all the discussion is around it, but he didn't get a single reply.

 

[Slain]

One little hint to speed things up (at the huge cost of memory) is to keep EVERYTHING from the database in memory.

how?

 

[C@2]

If it helps, the people thats not getting disconnected is the people that have a bot connected (atleast elfbot) keeps the connection.
So "everyone" is getting kicked, its just the people with a bot connected that keeps the connection.

I've got the same problem that I'm trying to figure out.

Hope it helped.

 

[Bam]

If it helps, the people thats not getting disconnected is the people that have a bot connected (atleast elfbot) keeps the connection.
So "everyone" is getting kicked, its just the people with a bot connected that keeps the connection.

I've got the same problem that I'm trying to figure out.

Hope it helped.

Interesting ..

I think I have an idea of what is causing it now thanks to your info there about the bots.

I'll investigate it and will post here if I solve it.

 

[C@2]

Great, thanks =)

 

[C@2]

Found out ? ;d

 

[stian]

The "noobish" way is to you change every table into MEMORY HEAP and never ever restart Mysql. The other way is to change my.ini, and use google for it.

 

[Helga]

The "noobish" way is to you change every table into MEMORY HEAP and never ever restart Mysql. The other way is to change my.ini, and use google for it.

You mean my.cnf? aight?

Anyways, here is mine:

key_buffer		= 1024M
max_allowed_packet	= 32M
thread_stack		= 192K
thread_cache_size       = 1000
table_cache             = 1024
sort_buffer_size	= 512M
read_buffer_size	= 8M
read_rnd_buffer_size	= 8M
query_cache_limit	= 2M
query_cache_size        = 256M

And it didn't help... What am I doing wrong? There's something I've missed...

 

[koob]

Try mine:

key_buffer                                      = 64M
max_allowed_packet                              = 32M
thread_stack                                    = 256K
thread_cache_size                               = 32
table_cache                                     = 1024
sort_buffer_size                                = 4M
read_buffer_size                                = 2M
read_rnd_buffer_size                            = 8M
query_cache_limit                               = 32M
query_cache_size                                = 64M
query_cache_type                                = 1
tmp_table_size                                  = 64M

Try also optimize all tables, and try to increase:

innodb_buffer_pool_size

 

[SpekkarN]

I got the same problem @ hocke.mine.nu when we didnt have so much players it was no problem..

 

[Fare]

anyone have solved this issue? it's cuz of mysql config? or?

 

[Helga]

check the posts above

 

[Helga]

bump, still a big problem. not just for me but for a lot of other ppl that got populated servers

 

[Diazapam]

Check:

I can optimize your database so save takes 20-30x faster for 25e _/
Oh, and, it should also eliminate your problem with MySQL connection losses.

 

[RealSoft]

And when the server crash...?

Mate.. work against the crashes >.<

I got server save like each 48 hours and that's more then enough for me.

try to make the server stable instead of make hells of backups everyday..

 

[stian]

Make saving in a seperate thread and you'll get rid of kicks. And even the lag under saving (remember to make an extra Mysql connection for it).