mg>hopefully quick comments
> Date: Sun, 7 Jun 2009 04:41:20 -0600
> Subject: Thread safe queries with multiple connections
> From: buf...@biffco.net
> To: mysql@lists.mysql.com
>
> I think my question is whether the data in MYSQL_RES and MYSQL_ROW data
> structures are
I think my question is whether the data in MYSQL_RES and MYSQL_ROW data
structures are sufficiently independent from that of other instances of
those data structures in a multi-threaded situation when a pool of
connections are share. The application my have multiple connections
structures defined
On Fri, Jun 6, 2008 at 9:25 PM, TUT - LightSpeed <[EMAIL PROTECTED]> wrote:
>
> Actually they are 2 connection to 2 different databases on 2 different
> hosts.
> I wanted rquery results from db1 to be in a temporary table to be used in
> db2.
> I can go around it with some php code to create the t
de to create the table in db2 but thought
it could be easier just to use the temporary table created by the query on
db1.
Thanks
--
From: "Omni Adams" <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2008 7:32 PM
To:
Subject: Re: T
On Fri, Jun 6, 2008 at 2:28 PM, TUT - LightSpeed <[EMAIL PROTECTED]> wrote:
> I have this problem
>
> I connect to 2 database servers in the same script
>
> If I create a temp table on one, won't be able on the other
>
> $db1 = db_connect1();
> $db2 = db_connect2();
>
> I get error that temp_table
I have this problem
I connect to 2 database servers in the same script
If I create a temp table on one, won't be able on the other
$db1 = db_connect1();
$db2 = db_connect2();
$query = "CREATE TEMPORARY TABLE temp_table SELECT ..";
$result = mysql_query($query,$db1) or die(mysql_err
Hello,
I run a PHP/MySQL environment. This may be more of a PHP question, but I'll
take my chance here.
I have 3 different servers:
- 1 running apache2 + php4
- 1 running mysql 5.0
- 1 running mysql 4.1
On the web server, I run multiple php applications which all connect to the
MySQL databa
uent sorts.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Kevin Burton [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 21, 2005 6:01 PM
> To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Possible to DoS
Not sure if this is a known issue or not.. but I haven't seen it
documented anywhere.
Anyway. My past thinking was that you should always use as many
connections as you have tables (at least with myisam). This way in the
worst case scenario you could have locks open on all tables instead of
on't really open a new connection when requested
but instead return the previous open handle. This is how mysql_pconnect in PHP and
connect_cached in DBI works.
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 09, 2004 12:13 PM
> To: [E
So this means that my DB driver is somehow using the same connection when I
ask it to create 2 different ones?
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 12:13 PM
To: [EMAIL PROTECTED]
Subject: Re: Multiple Connections
"Paul M
"Paul McNeil" <[EMAIL PROTECTED]> wrote:
> This tells me that the DB is treating my connections as the same connection.
> I need to know if the problem is that MySQL is caching and reusing any
> connection from my client OR if the problem is with my driver.
For each connection a new thread is cre
Good morning to all.
I am using the mySQL connector to connect to the mySQL database. My
question concerns the session between the DB and the client.
How is the session maintained? In other words, how does the DB know that it
is communicating with my specific connection? Here is why I ask.
In
Sergio Ilarri <[EMAIL PROTECTED]> wrote:
> P.S. I also get sometimes an error: General error, message from server:
> "Can't lock file (errno: 116)".
...which is:
[EMAIL PROTECTED] egor]$ perror 116
Error code 116: Stale NFS file handle
See the end of .err files in datadir of your servers, the
Hi everybody,
I have the following scenario. Several computers with shared disk in a
LAN. Each of these computer has a MySQL server that serves several
databases. I have several clients that communicate with a Java process
that I have in each computer to answer queries for a given database
(it co
Hi,
Currently, my program creates a new MYSQL object each time a connection
is needed to save or load information from my MySQL database.
Sometimes, this connection is created 10,000 or more times during one
use of the program. I'm wondering if I reuse the connection (have a
static MYSQL attr
Hi all,
How can we set multiple connections for multiple users in mySQL. I'm
accessing MYSQL using MYSQL++ library. This code is in the middle tier,
which can be accessed by any number of users. Its working fine for 3
clients, when connecting for the next it is giviing problems. Please he
I seem to be having a problem on linux with the mysql c api hanging sometimes when I
try to make 2 connections in a threaded program, with p threads. It's redhat 7 box,
and it is an intermittient problem. Sometimes it works great, and sometimes it hangs
on the second connection. Anyone know
alex writes:
>
>
>
> By the way it seems to me that in 3.23.XX series mysql_init() returns address not
> of the starting point of the allocated memory pool but a point somewhere further
> (like to provide hidden data not included in "official" MYSQL structure). Hence
> when trying to use
Sinisa Milivojevic wrote:
>
> Hi!
>
> I made an error in my previous message. All three instances should be
> like this:
>
> connX = mysql_init(NULL);
> if (!mysql_real_connect(connX, ip2, user2, pass2, db2, 0, NULL, 0))
> error .
>
By the way it seems to me that in 3.23.XX series mys
Valerio Ferrucci writes:
> John Dean wrote:
>
> > Hi
> > I think you should check the API documentation
>
> Can you point me to some docs about this?
>
> > because you code example is
> > wrong. Each connection should have its own initialized connection handle.
> > You have only initi
Valerio Ferrucci writes:
> Hi,
> I'm building a MySQL C API client. I need to connect to different dbs
> at the same time. My code is (approximately):
>
> //
> MYSQL mysql, *conn1, *conn2;
>
> mysql_init(&mysql)
>
> conn1 = mysql_real_connect(&mysq, ip1, u
erio Ferrucci [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 12, 2001 8:32 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL C API multiple connections
>
> Hi,
> I'm building a MySQL C API client. I need to connect to different dbs
> at the same time. My code is (app
John Dean wrote:
> Hi
> I think you should check the API documentation
Can you point me to some docs about this?
> because you code example is
> wrong. Each connection should have its own initialized connection handle.
> You have only initialized one data structure i.e. mysql, which is passed
>
Hi,
I'm building a MySQL C API client. I need to connect to different dbs
at the same time. My code is (approximately):
//
MYSQL mysql, *conn1, *conn2;
mysql_init(&mysql)
conn1 = mysql_real_connect(&mysq, ip1, user1, pass1, db1, 0, NULL, 0)
printf("conn1 = %d", con
Hi,
I'm building a C API MySQL client.
I need to connect to different dbs at the same time. My code is
(approximately):
//
MYSQL mysql, *conn1, *conn2;
mysql_init(&mysql)
conn1 = mysql_real_connect(&mysq, ip1, user1, pass1, db1, 0, NULL, 0)
printf("conn1 = %d", con
26 matches
Mail list logo
