473,513 Members | 2,554 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

mysql w/ mod_perl

I've noticed that when I reboot a hung server (S1) that was using mod_perl
to gain access to a remote mysql server (S2), the mysql threads on S2
persist even after S1 returns to active duty.

This can (did) lead to the dreaded "Too many connections" error.

I really don't want to hup S2/mysqld if I have a runaway S1. is there a way
to test/purge the status of threads either from S1 or from S2?

bob.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1118

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
2111
by: Alex Hunsley | last post by:
A while ago I found a mysql/php/webserver bundle of software for windows that installed all three at once and made it easy to start developing sql/php web apps. Now I can't remember what it was or where to get it, and wondered if anyone here can suggest anything along those lines? thanks alex
11
2212
by: Von Klinkerhofen | last post by:
Yes I have googled for newsitems about this, and I found a trillion documents. But pardon me if I think most doen't help to clear up the mist. Tried this once before and again I am caught up in copying libmysql.dll and php_mysql.dll all over the place and still I get that annoying error: Unable to load PHP_mysql.dll So maybe someone has...
1
2524
by: Bill Warner | last post by:
I am looking for a good mod_perl/mysql application to study. I have been teaching myself perl for a few years now and have been doing things the way I have interpreted documentation. There are several things that I think I am doing wrong, at least in a design standpoint, I would like a good mod_perl somewhat basic web based interface to...
0
2988
by: Pablo S | last post by:
Hi there mod_perl/Pg folks, I have 2 systems, one OLD, (linux 2.4 running postgresql-7.2.1-5 with a perl web db on Apache/1.3.23 mod_perl 1.26 and dbi 1.37 with peristent db connections via apache:dbi. ) The other system is NEW, which i am demoing (running the same web app on linux 2.6 postgresql-7.4.2-1 w/ Apache/2.0.49 &...
0
2691
by: Philip Stoev | last post by:
Hi all, Please tell me if any of this makes sense. Any pointers to relevant projects/articles will be much appreciated. Philip Stoev http://www.stoev.org/pivot/manifest.htm ===================================
4
1838
by: KJemison | last post by:
Well.... just wanted to know if the people at the MySQL.org site ever look at the posts in this group. If they do, they can possibly us a little constructive criticism from a slightly irritated customer. Seems to me that if someone installs Redhat 9 with MySQL from the original CD source which is version 3.23.54a and then follows the...
6
4421
by: nntp | last post by:
I tried mod_perl. It is too troublesome. Many old scripts stopped running. Even those running eat memory like crazy. I wonder why mod_php does not have the problems in mod_perl, such as memory hog, varible initialization etc. Is there a way to use Perl scripts at the same speed of PHP without worrying about those clearing varibles etc in...
0
2412
by: Ben Fitzgerald | last post by:
Hi, I've built apache under a temp dir so I can package and install it, which I have done. I also have built and installed perl this way. Now I'm trying to build mod_perl under a temp directory to package. Unfortunately when running: mod_perl $ DESTDIR=~/buildroot/ make install
29
3134
by: Mainlander | last post by:
An ISP I belong to uses Majordomo for their mailing list system. I'd like to encourage them to move to a system that uses a database, preferably psql which they already run on their server. Anything out there in Php?
0
7270
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7397
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7543
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5103
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3255
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3242
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1612
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
817
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
473
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.