Folks,
I'm wondering is someone could help us in trying to resolve the above error,
we have read through what threads we could find and tried all the
suggestions, but have had no luck.
There are no memory problems, in fact when this happens if there is still a
localhost client connection
CURRENT_USER() however is different in that it returns
the username and hostname that the current session was
authenticated as.
I too am unaware of how to prevent the truncation of
string. If anyone knows, I myself would be very
interested.
Thanks,
-Mark
--- Chris Faust [EMAIL PROTECTED
General: NEFACOMP [EMAIL PROTECTED]
To: Chris Faust [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 20, 2003 4:38 AM
Subject: Re: Getting remote connected machine as value in a select.
I don't know I well understand your problem.
There is a function SESSION_USER() in MySQL that returns
and everything worked exactly as I
hoped!
Thanks
-Chris
- Original Message -
From: Director General: NEFACOMP [EMAIL PROTECTED]
To: Chris Faust [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 20, 2003 9:48 AM
Subject: Re: Getting remote connected machine as value in a select.
You
Hello,
I'm curious as to if something is possible - I don't know if its possible to explain
it right.
I have a table which contains a bunch machine specific information, file paths, names
etc.
What I would like to try and accomplish is when I query this table for the information
I need, I
You could just ftp them wherever you want for storage.
I made a simple script where I took the provided mysqlhotcopy script,
added it and used it every day as a cron to make a copy of all my databases,
then run through a check of each one then tar them all up and ftp them to a
remote server.
Its
Hey All,
I want to install the mySql 4.0.9 to try out some features but I want to
make sure my 3.23.54 release stays 100% as is.
I'd like to have both servers running, using different data dirs etc. etc.
In short I don't want anything at all shared between the two.
I've read a bunch of docs on
If you want to limit the amount of text coming in or going out, wouldn't it
be easier to it either in your php script or constrain the html textarea?
Just a thought.
-Chris
-Original Message-
From: Craig melia [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 12:28 PM
To:
I can be no help to you at all, but I can tell you that I getting an error
message that relates to the GLibc problem that is document everyplace
although there doesn't seem to be any fix for me.. Maybe what I've gone
through to date can help you make some choices (I think my next one can only
be
Hello Group,
Due to ever increasing traffic I'm converting my site into mod_perl and
quite honestly I'm confused about persistent DB connection and DB connection
pooling.. I know there is tons of info out there on the goggle groups and on
perl.apache.com, I also picked up Mod_Perl Developers
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 05, 2003 11:40 AM
To: Chris Faust
Cc: MySql Mailing List
Subject: Re: mod_perl and mySql
Are you sure it would help? MySQL is damn fast at taking connections.
When we converted to mod_perl I made a mental note to switch
to persistent connections
Glad to hear that about MPW; thanks.
Its the truth, those 2 books have really saved my butt more then once - so
it should be me thanking you!!.
Regarding use of persistent connections, I wonder if you really need
them. To give an example from another language, PHP offers
mysql_connect()
.
Its been a wild week!!
Thanks
-Chris
-Original Message-
From: John P [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 1:45 PM
To: Chris Faust; [EMAIL PROTECTED]
Subject: Re: Desperate - failed: Lost connection to MySQL server during
query
If you are running close
Hello Mark,
Thanks for the reply..
I would need to wait until load gets up there to see the state of apache but
even now with almost no load on the machine I'm seeing at least a dozen
connections in the TIME_WAIT state. On the flip site of things I have not
been seeing any other connection
Message-
From: Doug Thompson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 7:33 AM
To: Chris Faust; Mark; [EMAIL PROTECTED]
Subject: RE: Desperate - failed: Lost connection to MySQL server during
query
Chris:
I bet a dollar to a donut that you have a hardware problem
If you are running close to the same setup with no problems then I feel a
little better about it not being a issue of pure traffic.
As for the scripts, its a heavy reliance on the database for information -
pretty much the whole site is like a classifieds ads system. Other then the
advance
Yes, I do connect to the DB server over IP - in short this is what I do
within MAIN of all my scripts (and $db is what is used anyplace a DB
connection is needed)
##
# Database Setup
# -
#
my $dbpassfile =
Hello All,
This mail list is about my last hope as I tried everything I could possibly
find online related to this problem and I've had no luck (it doesn't appear
to be the GLib problem that everyone keeps talking about).
Machine Specifics:
Web Server (dedicated):
P4 2gHz with 2gig memory
18 matches
Mail list logo