Linux [MYSQL] Connection time out!

[5mok3]

I get this error every once in a while..

mysql_commit() - MYSQL ERROR: Lost connection to MySQL server during query (2013)

[14:45:25.225] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: MySQL server has gone away (2006)

Don't pay much attention to the query itself but the problem..

After this players can't login because they get an Invalid Account Name error

If anyone knows what to do.. please let me know!
I'm willing to pay for worthy solutions to my problem..

I know it's not my engine but the mysql server! because i already tried using different distributions

 

[kosan100]

Got an Admin Account? You have the right tibia client and protocol in Ip Changer?

You got an Database thats connected to mysql file in your Server?


(Rep If I Helped:thumbup

 

[Cykotitan]

http://mysqltuner.pl/mysqltuner.pl

 

[5mok3]

@Cyko

I did try that already!
It tells me my tables are fragmented.. i already tried optimizing.. editing and shit and i wasn't able to..

First off when i manually try to optimize it tells me Innodb can't be optimized