Hi All,
Last night I upgraded our Master server to 4.1.14 standard log from 4.0.17,
I upgraded the slave a week ago and the replication was working perfectly,
once I upgraded and started mysql, it started fine without any errors but
the server was steadily creating mysql processes at the rate of like 20/sec
until it reached the Max_connections limit set at 800, while it was doing
this it was serving the web clients only randomly , also the load was very
very low neither was it taking up any memory, it was just creating processes
, I remember seeing this behaviour even earlier with 4.0.17 when the server
just started but after a certain point the no of processes return to normal.
So I had to switch back to 4.0.x, and it works perfectly fine, Also I did
not dump the databases just zipped the old datadir and unzipped it into the
new datadir, anybody else experience this behaviour at startup( I am aware
that once the server is back online it is flooded with requests), the OS is
Redhat 7.3, the server currently does 200-400 qps quiet comfortably .
Any help would be appreciated, let me know if you need more info
Kishore Jalleda