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.
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).
[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