Hello to everybody , After searching on the all mighty google for a few hours for a solution i gave up because i don't know what exactly i'm looking for. This is my problem ... I've got a linux box with mysql server installed (fedora, x86 , 4gb ddr2 ). I've got 3 or more remote game servers hosted by some 3rd party. On my linux box also have a web-application , that application is using a mysql database table. The remote game servers need to read the information in this table all the time and also make updates/changes to it when an event orcurs. I don't know why but sometimes ... randomly, the connection between mysql database and game server IP is lost. I've tried searching for a solution but since i don't know what exactly i'm searching for maybe somebody here had a similar problem and can help me out this is the mysql configuration file Code: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). #old_passwords=1 skip-innodb thread_cache_size=4 key_buffer_size=32M query_cache_size=8M query_cache_limit=48M join_buffer_size=2024K table_cache=96 skip-locking connect_timeout=120 interactive_timeout=58000 wait_timeout=58000 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout Thank you!
Is there something in between your servers that blocks the connection from time to time (firewall, unstable connection, etc.)?
as far as i know it shouldn't be , i'll send you my firewall script in PM maybe you'll spot something i didn't
