Hello.
What is SHOW PROCESSLIST reporting when the server is reaching the max_connections limit? Kishore Jalleda <[EMAIL PROTECTED]> wrote: >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 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
