Hi,
1. On dragoon, lots of mysql messages like:
Aborted connection 1179872 to db: 'vox_bw' user: 'midgard' host:
'helioos'
(Got timeout reading communication packets)
Aborted connection 1179872 to db: 'vox_bw' user: 'midgard' host:
'helioos'
(Got an error reading communication packets)
I wuld focus on this issue only. Other ones are related and mainly started
here IMO.
I think there are two possible cases:
* Problem with mysql server <->client
- connection timeout
- max clients
/etc/my.cnf:
max_connections = 1000 (never reached)
wait_timeout = 300
connect_timeout = 30
net_read_timeout = 60
net_write_timeout = 120
table_lock_wait_timeout = 90
* Apache ( for some weird reason ) uses threads instead of forks.
midgard-apache module only initializes connection using mysql client
libraries.
Later, connection pointer is "stored" in fork model of core ( absolutely
not thread safe )
So..? Ahhh.. when it was all on one machine, lost connection happened as
well however it was quite rare .. 3-5 per hour while the box get hundred
thousands of hits a day
Anything interesting in mysql error logs?
Only those mentioned.
Solt
_______________________________________________
user mailing list
[email protected]
http://lists.midgard-project.org/mailman/listinfo/user
