The name is a blessing and a curse, certainly helps people to remember me.
My parent get a big chuckle out of it still; they really got me good with that one.
;)
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Feb 10, 2006, at 2:20 PM, Mark Galbreath wrote:
That's alright...
That's alright...it's Friday and no one was sending any jokes, anyway. And I was getting a chuckle out of your name.
mark>>> Boysenberry Payne <[EMAIL PROTECTED]> 10-Feb-06 13:30:46 PM >>>
Sorry about the extra posts I was having email difficulties that day...Everything is working fine now tho
Sorry about the extra posts I was having email difficulties that day...
Everything is working fine now though. The AutoCommit = 0 fixed it
all...
Thanks again for all of the help,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Feb 8, 2006, at 11:55 AM, Boysenberry Payne
I took out the flags and the disconnect. I also set:
$Apache::DBI::DEBUG = 2;
to get debugging output.
I'm not getting any connection errors. (going to set mysql's max
connections to 150 per server)
What I'm seeing is 37 mysql threads being created for 7 apache
children. It would seem as
th
I took out the flags and the disconnect. I also set:
$Apache::DBI::DEBUG = 2;
to get debugging output.
I'm not getting any connection errors. (going to set mysql's max
connections to 150 per server)
What I'm seeing is 37 mysql threads being created for 7 apache
children. It would seem as
th
what DB are you using?
if you're using mysql, try opening a mysql client and doing a :
show processlist
it'll give you all the info on current connections
you can also turn on the querylog in the my.cnf file and have a
terminal tail -f it -- it'll show you all the process ids and wha
On Thursday 09 February 2006 19:14, Boysenberry Payne wrote:
> What are the ramifications of making AutoCommit => 0?
> It going to bite me in the but later?
I prefer to connect every connection with AutoCommit=>1. Then if I need a
transaction it is started with $dbh->begin_work and finished with
You're right it was a typo. Now that it's fixed it works using the do(
"USE database_name") syntax
with AutoCommit => 0
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Feb 9, 2006, at 12:02 PM, Clinton Gormley wrote:
DBD::mysql::st execute failed: Table 'boy
Hi Boysenberry -
DBD::mysql::st execute failed: Table 'boysie_habtiat.sessions' doesn't exist
at /Users/boysie/mod_perl_inc/Habitat/DB/Select.pm line 95.
Shouldn't that be "boysie_habitat.sessions" ?
Larry
What are the ramifications of making AutoCommit => 0?
It going to bite me in the but later?
What are the pros and cons of using Apache::DBI::Cache over
Apache::DBI?
Thank for all of the help so far...
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Feb 9, 2006, at 12:11 PM,
After reading up on Apache::DBI::Cache it seems like it might solve the
issues, thanks.
I'll reply again if it doesn't...
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Feb 9, 2006, at 10:03 AM, Torsten Foertsch wrote:
On Thursday 09 February 2006 16:14, you wrote:
I wil
Ok I switched to using fully qualified database requests as:
database_name.table_name and received the following errors:
8854 Apache::DBI need ping: yes
8854 Apache::DBI new connect to 'database=adm_accounts;host=localhostNamePassAutoCommit=1PrintError=1RaiseError=1Usernam
What if you'd write all your SQL-Statements in a fully qualified manner?
---8<---
SELECT * FROM $DB1.$TABLE1;
SELECT * FROM $DB2.$TABLE1;
---8<---
Tom
Boysenberry Payne wrote:
> The only difference in each connection is the database. I tried conne
quite possibly
in older versions as well.
-Original Message-
From: Boysenberry Payne [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 09, 2006 10:14 AM
To: mod_perl
Subject: Re: I'm getting max connection errors for Apache::DBI
The only difference in each connection is the databas
I got rid of the disconnect, duh. I still have the errors, but no longer get the
12844 Apache::DBI disconnect (overloaded)
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Feb 9, 2006, at 9:14 AM, Boysenberry Payne wrote:
The only difference in each conne
The only difference in each connection is the database. I tried connecting
to the same database then using $h-do( "USE new_database" ); But it doesn't
switch to the new database (works fine using DBI.)
I decided as a temporary hack I'd try the following:
sub clean_processes {
my $self = shift;
On Wed, 2006-02-08 at 11:51 -0600, Boysenberry Payne wrote:
> What I'm seeing is 37 mysql threads being created for 7 apache
> children. It would seem as
> though I would need to create a 5/1 ratio of mysql connections to
> apache children. Is that normal?
No. If you use the same connection i
Boysenberry Payne wrote:
What do I need to do
to fix it?
You probably just need to raise the maximum number of connections on
your MySQL servers.
If you use two different database servers then you should be seeing a
total number of connections on each one that matches the number of child
p
18 matches
Mail list logo
