RE: [OT] Reload Problem -> "Mass-Reload" crashes DB

2006-01-14 Thread Tom Horstmann
Original Message- > From: ESV Media GmbH [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 14, 2006 4:27 PM > To: mysql@lists.mysql.com > Subject: Reload Problem -> "Mass-Reload" crashes DB > > Thanks for your quick reply. > > Thanks a lot for your help

Reload Problem -> "Mass-Reload" crashes DB

2006-01-14 Thread ESV Media GmbH
Thanks for your quick reply. We use PHP. I´ll try it with mysql_pconnect(); I´ve already thought about it. What happens, when we´ve several 1000 Users online. Doesn´t it open too many connections ? mysql_connect closes every connection after using. Does mysql_pconnect() the same ? Thanks a lot

RE: Reload Problem -> "Mass-Reload" crashes DB

2006-01-14 Thread Tom Horstmann
phone: +49 941 / 78 88 7-121 AG Regensburg HRA 6608 USt.183/68311 cellphone: +49 171 / 40 54 777 -- > -Original Message- > From: ESV Media GmbH [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 14, 2006 12:06 PM > To: mysql@lists.mysql.com > Subject: Reload Pro

Reload Problem -> "Mass-Reload" crashes DB

2006-01-14 Thread ESV Media GmbH
Hey, we´ve on 2 website the problem, that if you hit a several times F5 or hold it down to reload the site, MySQL opens many connections and breaks down after a while. How can we prevent this ? I close every MySQL Session and i do an if-statement ( if there´s any open connect ) before i open a