473,739 Members | 2,378 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

mysql_pconnect( ) vs mysql_connect()

Coming from a java background, I've been taught that connection pooling is
the best thing due to the obvious benefits.

I found out that the above pconnect() function will pool connections.

So how do you use it properly? There's another post in this list stating
that the user got connection refused error messages.

Also, is there a real performance increase due to connection pooling with
MySQL in PHP?

Thanks,
- Z -
Jul 20 '05 #1
4 6589
"OneSolutio n" <on*********@sb cglobal.net> wrote in message news:ctnlc.6227
I found out that the above pconnect() function will pool connections.
Where is this function. I cannot find the string "pconnect" in all of my
c:\mysql\includ e, and I have version 4.1.
So how do you use it properly? There's another post in this list stating
that the user got connection refused error messages.

Also, is there a real performance increase due to connection pooling with
MySQL in PHP?


Don't know about your exact question, but have a response for a similar
setup on C++. I do the connection pooling on the C++ side (which is
probably slightly faster than doing the pooling on the MySql Server side) --
there is a class Database which has an array of used and unused connections,
and when a Select object needs a connection it requests one from Database,
which looks in its array of unused connections for one, and if it doesn't
find one creates a new ActualConnectio n with mysql_real_conn ect, and the
destructor of ActualConnectio n calls myql_close to close the connection, and
the destructor of Select gives its connection back to the databasee.

My test program was to select last_name and first_name from contact N=3000
times, and to iterate through all the rows and count the number of columns
in each row. First run is with the connection pooling as described above,
and second run is with no connection pooling which is accomplished by
calling the function database.close_ unused_connecti ons().

The connection pooling method took 3562 milliseconds, and the non connection
pooling method took 21781 milliseconds.

In my test we connect to localhost. The times would be longer if we
connected to a remotehost.

My setup is Borland C++ Builder version 6, Windows ME with 128 MB RAM, MySql
version 4.1, and an AMD 1 GHz processor.
Jul 20 '05 #2
"OneSolutio n" <on*********@sb cglobal.net> wrote in message news:ctnlc.6227
I found out that the above pconnect() function will pool connections.
Where is this function. I cannot find the string "pconnect" in all of my
c:\mysql\includ e, and I have version 4.1.
So how do you use it properly? There's another post in this list stating
that the user got connection refused error messages.

Also, is there a real performance increase due to connection pooling with
MySQL in PHP?


Don't know about your exact question, but have a response for a similar
setup on C++. I do the connection pooling on the C++ side (which is
probably slightly faster than doing the pooling on the MySql Server side) --
there is a class Database which has an array of used and unused connections,
and when a Select object needs a connection it requests one from Database,
which looks in its array of unused connections for one, and if it doesn't
find one creates a new ActualConnectio n with mysql_real_conn ect, and the
destructor of ActualConnectio n calls myql_close to close the connection, and
the destructor of Select gives its connection back to the databasee.

My test program was to select last_name and first_name from contact N=3000
times, and to iterate through all the rows and count the number of columns
in each row. First run is with the connection pooling as described above,
and second run is with no connection pooling which is accomplished by
calling the function database.close_ unused_connecti ons().

The connection pooling method took 3562 milliseconds, and the non connection
pooling method took 21781 milliseconds.

In my test we connect to localhost. The times would be longer if we
connected to a remotehost.

My setup is Borland C++ Builder version 6, Windows ME with 128 MB RAM, MySql
version 4.1, and an AMD 1 GHz processor.
Jul 20 '05 #3
OneSolution wrote:

: Coming from a java background, I've been taught that connection
: pooling is the best thing due to the obvious benefits.
:
: I found out that the above pconnect() function will pool connections.
:
: So how do you use it properly? There's another post in this list
: stating that the user got connection refused error messages.
:
: Also, is there a real performance increase due to connection pooling
: with MySQL in PHP?
:
: Thanks,
: - Z -
Hi
maybe these pages may be of use to you.
http://uk.php.net/function.mysql-pconnect
http://uk.php.net/manual/en/features...onnections.php
Jul 20 '05 #4
OneSolution wrote:

: Coming from a java background, I've been taught that connection
: pooling is the best thing due to the obvious benefits.
:
: I found out that the above pconnect() function will pool connections.
:
: So how do you use it properly? There's another post in this list
: stating that the user got connection refused error messages.
:
: Also, is there a real performance increase due to connection pooling
: with MySQL in PHP?
:
: Thanks,
: - Z -
Hi
maybe these pages may be of use to you.
http://uk.php.net/function.mysql-pconnect
http://uk.php.net/manual/en/features...onnections.php
Jul 20 '05 #5

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

Similar topics

4
2548
by: Yun Guan | last post by:
Hello folks, In my php scripts, those mysql functions, like mysql_pconnect() and mysql_connect() are said to be undefined. What do I miss here? Thanks. -- Allen Guan 281-489-2314
0
1489
by: anders thoresson | last post by:
Hi, I have this function I call everytime I need to make a query from within my php-scripts: function db_connect ($user, $pwd, $db, $debug = 0) { $link = @mysql_pconnect("localhost", "$user", "$pwd"); if($link && mysql_select_db("$db")) if($debug == 1) {
4
4177
by: Angelos | last post by:
I get this error mysql_pconnect Too many connections ... every now and then. Does anyone knows where it comes from ? There are a lot of sites running on the server and all of them use the Database frequently. Is there any configuration that I will have to do to my server in order to handle the load ? Thank you... I would appreciate answers from someone that already experienced that
2
2837
by: Sugapablo | last post by:
I have a small test script connecting to a MySQL database. It seems to work, unless I try to use the resource link identifier returned by mysql_connect(); This works and returns all the rows in the table: <?php include("../config.php"); $dbi = mysql_connect($dbhost,$dbuname,$dbpass);
19
8110
by: Michael | last post by:
Hi, I'm trying to do something which should be very simple - connect to the MySQL database. Here is the call, followed by the error msg. $conn = mysql_connect("localhost", "root", ""); Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/buildhw.php on line 13
1
1859
by: tom_b | last post by:
I get this error when I try to connect to my database Fatal error: Call to undefined function mysql_pconnect() in c:\program files\apache group\Apache\htdocs\flash.php on line 11 Here's the code: <?php mysql_pconnect ("localHost", "root", "wooty"); mysql_select_db ("blog_db");
1
1533
by: WhatsPHP | last post by:
Can I use mysql_pconnect on an environment like this? There is just 1 server on which both PHP and MYSQL runs. It is an intranet server. At any point atleast 2 people will be actively using the server for their work. If the script uses mysql_pconnect and then the normal user name and password, will this speed up execution of scripts on the server by any chance? Fut
11
1677
by: =?ISO-8859-1?Q?J=F8rn?= Dahl-Stamnes | last post by:
Hello, I have been using mysql_connect in a script that display a lot of thumbnails for an album. Each thumbnail is displayed using the code: <IMG SRC="thm.php?id=some_id" ALT="some title"> thm.php use a mysql_connect to the database to access the info about the picture based on the id.
2
1954
by: EsahakNoorul | last post by:
hi, I want to know the difference between mysql_connect and mysql_pconnect Regards, Noorullah
9
1887
by: John Murtari | last post by:
Folks, We have a fairly busy web site present using PHP 5 to talk to a MySQL 5.0.45 DB on an Apache 1.3 series server. It's spread out over several physical hosts (one DB server), we use DB tracking of sessions and there is some transaction usage also. Right now we keep it simple using mysql_connect. I'd looked at mysql_pconnect a few years but got scared away by the warnings about problems. Somebody here wanted to revisit that
0
9341
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9211
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8216
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6756
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6056
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4572
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4826
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2748
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2195
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.