[ misk0 @ 31.03.2009. 08:46 ] @
U poslednjih nekoliko dana desava mi se cudan problem. Dobijam poruku: Code: mysql> use myvivabill; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 15 Current database: *** NONE *** Pa sam promjenio max_allowed_packet sa 16M na 128M ali i dalje dobijam tu (slicnu) poruku. Code: mysql> use myvivabill; No connection. Trying to reconnect... Connection id: 3 Current database: *** NONE *** Database changed Nije vezano za vrstu komande kao niti za vrstu database gdje se izvrsava. Upit se uvijek izvrsi. Verzija Server version: 5.0.67-community. To se desava i iz lokala (konzole na serveru) i sa windows klijenta kad se konektujem na server. Najvazniji dio : desava se po isteku nekog broja sekundi (mozda 6-10, ne mogu izmjeriti tacno). Code: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking skip-innodb query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_user_connections=25 max_connections=500 interactive_timeout=10 wait_timeout=10 connect_timeout=20 thread_cache_size=128 key_buffer=16M join_buffer=1M max_allowed_packet=128M table_cache=1024 record_buffer=1M sort_buffer_size=2M read_buffer_size=2M max_connect_errors=10 thread_concurrency=8 myisam_sort_buffer_size=64M server-id=1 Skoro sam uradio upgrade sa 4.1 na 5.0 misleci da ce to rijesiti problem, ali nije. Ideje? 'fala |