Server End problem

[Supacek]

While server is running like 12h and i come back from work ill try to log in and i get DC today i get DBerror.log

any idea why is server shuting down ???

[NEW-BOY1]

I think you need it

show global variables like '%wait_timeout';

When you don't have connection after a certain period of time. Mysql will lose it

[Supacek]

I think you need it

show global variables like '%wait_timeout';

When you don't have connection after a certain period of time. Mysql will lose it

so today same problem .i get home try to login server boom this happened

last log in loginserver is

Stmt [INSERT INTO LoginPlayerData (PlayerID,IP,Date,Time) VALUES ('admin','xxxxmyipadressxxxxx','2022-10-14','22:40:09')] Lost connection to MySQL server during query

[Supacek]

the server is running empty no one is online so thats the probmel maybe so i need change that time probly right ?

[Supacek]

[NEW-BOY1]

It has told you, lost the connection mysql

wait_timeout=2880000 interactive_timeout = 2880000 You could be longer this time

[Supacek]

It has told you, lost the connection mysql

wait_timeout=2880000 interactive_timeout = 2880000 You could be longer this time

ill try

[tiancaiamao]

@NEW-BOY1 is right. The MySQL settings may cause inactive connection been kicked out, you need to change some configuration or global variables. @Supacek

[Supacek]

Fixed put times inzo mysql conf file..

[Supacek]

[mysqld] wait_timeout=2880000 interactive_timeout = 2880000

put it in mysql.cnf

[Supacek]

closed fixed