Now this was *really* weird.
I fixed the DBD::mysql problem by adding '/usr/lib64/perl5/vendor_perl’ to my
‘use’ statement in startup.pl, EVEN THOUGH it’s already in @INC, and DBD::mysql
lives in /usr/local/lib64/perl5/DBD
DBI lives in that directory, but other scripts using DBI an
27;);
use DBI ();
use Apache2;
1;
This is similar to the one I’ve used on another production server for some time
without issues, but that one doesn’t use MySQL, only Oracle.
As I said other mod_perl applications on this same server are working as
expected; this issue seems to be strictly with the DB
use DBI;
# Perhaps some other modules you are using in your CGI scripts...
1;
On Wed, Jun 3, 2020 at 1:53 PM Bruce Johnson
wrote:
> I’m migrating a bunch of old cgi web apps to a new server (CentOS8) and
> running them under mod_perl.
>
> one of them uses the DBD::mysql driver
I’m migrating a bunch of old cgi web apps to a new server (CentOS8) and running
them under mod_perl.
one of them uses the DBD::mysql driver and when running under mod_perl only I
get the strange error:
[Tue Jun 02 10:29:32.289698 2020] [:error] [pid 3729:tid 140210163652352]
DBD::mysql
xinhuan
>
> From: Perrin Harkins
> Date: Thursday, June 27, 2013 3:05 PM
> To: xiaolan
> Cc: "modperl@perl.apache.org"
> Subject: Re: mysql connection pooling
>
> Hi,
>
> There is nothing exactly like the database pool in JDBC. However, there
> are so
;
mailto:modperl@perl.apache.org>>
Subject: Re: mysql connection pooling
Hi,
There is nothing exactly like the database pool in JDBC. However, there are
solutions for this problem.
The first thing you should do is run a reverse proxy in front of your mod_perl
server. That typically reduce
re:
> http://www.slideshare.net/Tim.Bunce/dbdgofer-200809
>
> - Perrin
>
>
> On Thu, Jun 27, 2013 at 2:26 AM, xiaolan wrote:
>
>> Hi,
>>
>> Currently I have been using Apache::DBI for long connections to Mysql.
>> But having the problem that, if the apache
nario are here:
http://www.slideshare.net/Tim.Bunce/dbdgofer-200809
- Perrin
On Thu, Jun 27, 2013 at 2:26 AM, xiaolan wrote:
> Hi,
>
> Currently I have been using Apache::DBI for long connections to Mysql.
> But having the problem that, if the apache processes are 1, they open
&g
Hi,
Currently I have been using Apache::DBI for long connections to Mysql.
But having the problem that, if the apache processes are 1, they open
1 connections to mysql, this make the DB crashed.
Is there any software for modperl working like Java's JDBC for connection
pooling?
Thanks.
On Sat, Jun 4, 2011 at 5:09 PM, David Christensen
wrote:
> mod_perl users:
>
> I have an idea for a WWW CMS framework and am looking for a current book on
> production-grade Perl WWW development
>
> Any comments or suggestions?
This book is about as tip of the spear as you can get:
http://ww
lbraith, P., 2009, "Developing Web Applications with Apache, MySQL,
memcached, and Perl",
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470414642.html .
Has anyone read this book?
Any comments or suggestions?
TIA,
David
On Thu, 24 Feb 2011 03:28:19 +1100, Daniel Manley
wrote:
I've been digging around in my mod_perl-based apps and trying to figure
out why setting up the DB connections for pinging is still randomly
producing first-thing-in-the-morning "mysql server has gone away"
errors.
On Wed, Feb 23, 2011 at 4:07 PM, Daniel Manley wrote:
> well, I think I figured this one out on my own. Though I've used Perl for a
> number of years, I've never gotten to the XS file coding. and so after
> running this under perl debug, I finally get the hint that maybe th
well, I think I figured this one out on my own. Though I've used Perl
for a number of years, I've never gotten to the XS file coding. and so
after running this under perl debug, I finally get the hint that maybe
the mysql ping() is done in C. And so it is.
Dan
On 11-02-2
Hi,
I've been digging around in my mod_perl-based apps and trying to figure
out why setting up the DB connections for pinging is still randomly
producing first-thing-in-the-morning "mysql server has gone away"
errors. I read up about the morning bug and such (adding ping() to
On Tue, Feb 08, 2011 at 10:32:02AM -0500, Perrin Harkins wrote:
> > I'm pointing at Class::XSAccessor since it's my only hint.
> > Seems to me that DBIx::Class uses Class::XSAccessor through
> > Class::Accessor::Grouped. That's the only use of Class::XSAccessor
> > I could find in my perl director
Hi,
> I'm pointing at Class::XSAccessor since it's my only hint.
> Seems to me that DBIx::Class uses Class::XSAccessor through
> Class::Accessor::Grouped. That's the only use of Class::XSAccessor
> I could find in my perl directories.
The first thing I'd suggest is making sure you have the latest
Am 08.02.2011 00:58, schrieb Cosimo Streppone:
Hi all,
Apache is segfaulting immediately on startup, before even writing
to the log files. Now, in my code I don't use Class::XSAccessor.
I'm pointing at Class::XSAccessor since it's my only hint.
Seems to me that DBIx::Class uses Class::XSAccesso
Hi all,
I'm still trying to track down this weird segfault
problem on Apache startup. I had originally targetet dbi-users@
because it initially seemed to be DBI-related. Was trying to get
some feedback, "has anyone ever seen this?" type of question.
Now I have a stack backtrace, that might narrow
're now using two separate connections.
> Am on Apache::Session::MySQL (1.01), with differing (old and new)
> Apache::Session versions.
Chances are you can get your code working just by making sure the same
connection is used in both cases, but my suggestions for the future
would be t
can see the get_lock waiting in the
database and I can only image that release_lock hasn't been called for
some reason.
Am on Apache::Session::MySQL (1.01), with differing (old and new)
Apache::Session versions.
I am curious whether anyone has memories of seeing this before or other
thoughts?
Thanks in advance,
Raf
On Wed, Dec 10, 2008 at 2:27 PM, Justin Wyllie <[EMAIL PROTECTED]> wrote:
> However if Apache uses
> child processes sequentially - i.e there is no danger of that child process
> being used simultaneously by two requests I think I should be ok. I think
> this is what Perrin was confirming?
Yes, th
Hi Guys
Thanks for all the help.
I have some code which inserts something into a database and immediately
(the next line) executes another sql statement with SELECT
LAST_INSERT_ID() - so it is not a previous one from somewhere else in the
code.
My concern was that because the actual connect
On Wed, Dec 10, 2008 at 1:22 PM, Enno <[EMAIL PROTECTED]> wrote:
> yes, but, do you really want to gamble that the second request is handled by
> the same child process? and what if another request comes in between?
I think you're misunderstanding his question. As I read it, he was
worried that m
Perrin Harkins wrote:
On Fri, Dec 5, 2008 at 5:39 PM, Justin Wyllie <[EMAIL PROTECTED]> wrote:
The mySQL documentation for LAST_INSERT_ID says that it returns the last
auto-incremented field value for 'that client'.
I am not sure what the client is in a mod_perl situation
On Fri, Dec 5, 2008 at 5:39 PM, Justin Wyllie <[EMAIL PROTECTED]> wrote:
> The mySQL documentation for LAST_INSERT_ID says that it returns the last
> auto-incremented field value for 'that client'.
>
> I am not sure what the client is in a mod_perl situation wi
Hi
The mySQL documentation for LAST_INSERT_ID says that it returns the last
auto-incremented field value for 'that client'.
I am not sure what the client is in a mod_perl situation with Apache::DBI?
I have an Apache child process which uses one open database connection for its
life
On Tue, Dec 2, 2008 at 1:56 PM, April Papajohn
<[EMAIL PROTECTED]> wrote:
> I tried setting alarm() around the DBI lines, using the Sys::SigAction
> module, in order to get the script to timeout if MySql isn't
> responsive. This works great if I run it as a plain perl script.
Hello,
I am working on a site that has a modperl (mod_perl 1.3, perl 5.8.0, on linux)
handler doing some authentication work via DBD::MySql. It connects to
a MySQL server over the network.
Recently during some maintenance on the MySql server, the entire site
was hung up, because the MySQL server
> I don't know the details, but there is something about the way
> PerlModule works in mod_perl 1 that causes it to load the module again
> when apache restarts at startup (it runs yours conf file twice when
> you start, as documented). Using an explicit use() puts an entry in
> %INC and fixes the
On Wed, Jul 2, 2008 at 5:12 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote:
> No more errors there either! :)
Great!
> I don't know anything about the internals but to me the mod_perl source looks
> like PerlModule is using "require" instead of "use" to load modules. I guess
> that is making the dif
Quoting Tobias Kremer <[EMAIL PROTECTED]>:
> Quoting Perrin Harkins <[EMAIL PROTECTED]>:
> > How are you loading this? With a PerlModule call? Can you try
> > loading it from a Perl section like this?
> >
> > use MyModule;
> >
> Wow, it seems that this fixes the problem!
> Do you have any ide
Quoting Perrin Harkins <[EMAIL PROTECTED]>:
> How are you loading this? With a PerlModule call? Can you try
> loading it from a Perl section like this?
>
> use MyModule;
>
Wow, it seems that this fixes the problem! At least with my minimal application.
Here's the debug output which looks qu
On Tue, Jul 1, 2008 at 10:08 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote:
> On server start:
>
> 20097 Apache::DBI skipping connection during server startup, read the docu !!
> 20097 Apache::DBI push PerlCleanupHandler
> 20097 Apache::DBI need ping: yes
> 20097 Apache::DBI new
Quoting Perrin Harkins <[EMAIL PROTECTED]>:
> Yes, but what does it tell you on the first connection AFTER startup?
> It should say whether it's making a new connection or not.
Here's the complete debug output which suggests that the connection during
startup is reused for the first request.
On s
On Tue, Jul 1, 2008 at 9:56 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote:
> Yes, I'm using the latest 1.07 release. I already had the debug flag on and
> it's
> correctly telling me that it's "skipping connection during server startup".
Yes, but what does it tell you on the first connection AFTER
Quoting Perrin Harkins <[EMAIL PROTECTED]>:
> Ok. First, check that you're on the latest version. Then, turn on
> the debug flag and see if it thinks it is reusing the startup
> connection or not.
Yes, I'm using the latest 1.07 release. I already had the debug flag on and it's
correctly telling
On Tue, Jul 1, 2008 at 3:42 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote:
> Removing Apache::DBI makes the errors go away.
Ok. First, check that you're on the latest version. Then, turn on
the debug flag and see if it thinks it is reusing the startup
connection or not.
- Perrin
Quoting Perrin Harkins <[EMAIL PROTECTED]>:
> On a closer look, you're not. You are keeping around your $foo
> closure variable in handler(), as well as putting it in a global.
> It's not obvious why that causes this problem. If you want to
> determine whether Apache::DBI is malfunctioning for yo
On Mon, Jun 30, 2008 at 1:40 PM, Tobias Kremer <[EMAIL PROTECTED]> wrote:
> Could you please show me the exact line in my example in which I put the
> database handle in a
> global during startup?
On a closer look, you're not. You are keeping around your $foo
closure variable in handler(), as wel
On 30.06.2008, at 17:10, Perrin Harkins wrote:
It's not Apache::DBI that's caching it -- you're caching it. Don't
put a database handle in a global before you fork. It will stay, and
there's nothing Apache::DBI can do about it.
Could you please show me the exact line in my example in which I
Tobias Kremer wrote:
> Quoting Michael Peters <[EMAIL PROTECTED]>:
>> Why are you storing the DB handle in a global variable?
>> If you do that then Apache::DBI can't help you if the connection goes away.
>
> To make this variable available to all Mason components.
Then use a method to do this,
On Mon, Jun 30, 2008 at 11:02 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote:
> According to the docs Apache::DBI
> should automatically avoid caching this connection.
It's not Apache::DBI that's caching it -- you're caching it. Don't
put a database handle in a global before you fork. It will stay,
Quoting Michael Peters <[EMAIL PROTECTED]>:
> Tobias Kremer wrote:
> > use vars qw( $dbh $thefoo );
> Why are you storing the DB handle in a global variable?
> If you do that then Apache::DBI can't help you if the connection goes away.
To make this variable available to all Mason components. Theor
Tobias Kremer wrote:
> use vars qw( $dbh $thefoo );
Why are you storing the DB handle in a global variable?
If you do that then Apache::DBI can't help you if the connection goes away.
--
Michael Peters
Plus Three, LP
Quoting Perrin Harkins <[EMAIL PROTECTED]>:
> I don't see anything in this code, but you're not really showing us
> much here. I think you'll need to try commenting out parts of it
> until you find which part breaks it. I'd start with that
> selectall_arrayref that you store.
I can reproduce the
On Mon, Jun 30, 2008 at 9:28 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote:
> Ok, I narrowed it down to the database connection initiated during server
> startup. As soon as I remove it the errors vanish completely.
Good, that's major progress.
> Here are some snippets to illustrate what I'm doing:
Quoting Perrin Harkins <[EMAIL PROTECTED]>:
> On Mon, Jun 30, 2008 at 4:54 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote:
> > We never fork and I thought that Apache::DBI takes care of checking if a
> > connection went stale by utilizing DBI's/DBD::mysql's ping() method?
> It does, but it can't stop
On Tue, Mar 4, 2008 at 8:09 PM, Will Fould <[EMAIL PROTECTED]> wrote:
> We're buying a handful of new machines and I'm trying to make the best
> weighted decision for our budget.
Buy the cheapest CPUs available. You will barely touch them. Spend
the money on more RAM.
- Perrin
Hello
A lot of hype has surrounded quad core vs dual core processors.
We're buying a handful of new machines and I'm trying to make the best
weighted decision for our budget.
My very brief research indicates that ironically, a slightly faster dual
core (for example, a recent Opteron 22xx process
On Dec 28, 2007 4:09 PM, Hendrik Van Belleghem
<[EMAIL PROTECTED]> wrote:
> I'm having some trouble with DBD::mysql under mod_perl2 on Leopard.
> The build process when just fine, make test didn't show any errors and
> running it in console and as CGI didn't show an
Hi all,
I'm having some trouble with DBD::mysql under mod_perl2 on Leopard.
The build process when just fine, make test didn't show any errors and
running it in console and as CGI didn't show any errors. I already tried
adding "PerlSetEnv LD_LIBRARY_PATH '/usr/local/
_perl, 1 for
PHP and 1 for
the proxy) then you can use a smaller lightweight proxy like squid.
off the top of my head, there were a lot of library conflicts
between mp and php regarding mysql at some point. the fix was to
compile everything from source. it has to deal with the wa
On 7/20/07, Clinton Gormley <[EMAIL PROTECTED]> wrote:
I've managed to get php5.2.2, mod_perl 2.0.3, apache 2.2.4 and mysql
5.0.27 working on openSuSE 10.2 x86_64.
Your install options don't look much different than mine. I think my
problem might be glibc, since I'm get
I've managed to get php5.2.2, mod_perl 2.0.3, apache 2.2.4 and mysql
5.0.27 working on openSuSE 10.2 x86_64.
In summary:
- I install these MySQL packages:
MySQL-server-standard-5.0.27-0.rhel4.x86_64.rpm
MySQL-client-standard-5.0.27-0.rhel4.x86_64.rpm
MySQL-devel-sta
Dustin D. wrote:
> With that in mind, is it possible to reuse the same apache install
> directory, and just launch the different processes with different
> httpd.conf files that load the appropriate DSO's and settings?
Absolutely. This is what I normally do. There's no reason to have the same
bin
I don't necessarily have a problem running 3 different apaches. One issue I
have is that I also need a development environment,
Stop, and setup a sep. box or vserver. I cant imagine doing development on
the same server env. that is in production will meet with approval from
your client(s) o
On 7/20/07, Michael Peters <[EMAIL PROTECTED]> wrote:
Dustin D. wrote:
> I can't seem to get php 5.2.3, mod_perl 2.0.3, mysql 5.0.45, and apache
> 2.2.4 to work together.
Why do you need to do that? Normally what I've seen others do in this
situation
(and have don
Dustin D. wrote:
> I can't seem to get php 5.2.3, mod_perl 2.0.3, mysql 5.0.45, and apache
> 2.2.4 to work together.
Why do you need to do that? Normally what I've seen others do in this situation
(and have done myself) is to have 2 separate apaches and a proxy in front of
them t
I can't seem to get php 5.2.3, mod_perl 2.0.3, mysql 5.0.45, and apache
2.2.4 to work together. I've read countless websites and documentation,
followed all the different hints and tips, and I either end up with a
situation where mysql or php complain about mysql problems, or, if I i
On 5/3/07, Chris Allen <[EMAIL PROTECTED]> wrote:
[Fri May 04 01:44:04 2007] [error] [client 10.3.10.2] DBD driver has not
implemented the AutoCommit attribute at
/usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm line 277.\n
DBD::mysql::db selectrow_array failed: Lost connection to MySQL
Dear All,
I am running:
apache 2.2.3 / mod_perl / DBI v1.54, DBD::mysql v4.004 / Apache::DBI
I am connecting to 2 MySQL databases:
1 on the local machine through a domain socket
1 over the LAN.
100% of the queries to the LAN connected db work fine
80% of the queries to the local db work
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Jan 31, 2007 at 08:29:55AM -0500, Perrin Harkins wrote:
> On 1/31/07, Todd Finney <[EMAIL PROTECTED]> wrote:
> >Wouldn't throwing a
> >
> > return DECLINED unless $r->is_initial_req;
> >
> >at the top of the handler fix the problem, in
On 1/31/07, Todd Finney <[EMAIL PROTECTED]> wrote:
I can set it up so that it does the copy->save to pnotes dance for every
one of the variables, except perhaps for the actual session handle, which
is stuck into pnotes('SESSION_HANDLE').
If you really need to keep a ref to $session like that, t
On 1/31/07, Todd Finney <[EMAIL PROTECTED]> wrote:
It's responsible for making sure that the client has a session, and it
takes any of the values in the session and stores them in pnotes.
Are you sure that you had removed all of these when you did the test
of copying the session_id, and it stil
On 1/31/07, Todd Finney <[EMAIL PROTECTED]> wrote:
Wouldn't throwing a
return DECLINED unless $r->is_initial_req;
at the top of the handler fix the problem, in that case?
Probably, if you don't actually need this handler to run for the final
URI. What's the purpose of the handler?
her use Apache::Session::Flex or make your own
Apache::Session::MySQL. Open up Apache::Session::MySQL and look at
the code. It's nothing more than a config file. If you copy it,
change the name (and package), and change the name of the locking
class, that will work.
As for what's goin
ent request holds onto its session and lock, causing a hang.
Before I spend too much time analyzing your symptoms, are you sure
that your application requires excusive locks on sessions? If not,
you can use Apache::Session::Lock::Null for your locking class. You
will not get any data corruption be
he issue was.
I'm going through the old listserv articles right now
this *might* give you some ideas
http://www.issociate.de/board/post/309410/
Apache::Session::MySQL_lock_troubles.html
a bunch of the '(X-No-Archive: yes)' deleted posts in that are from
you :)
i remember d
%session;
eval {
tie %session, 'Apache::Session::MySQL', $cookie, {
DataSource => 'dbi:mysql:boygenius', #these arguments are
UserName => 'nobody', #required when using
Password
fully in
both straight Perl command line use and via fcgid.
-Original Message-
From: Frank Maas [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 5:16 AM
To: [EMAIL PROTECTED]; modperl@perl.apache.org
Subject: RE: Can't use mysql stored procedures under mod_perl (although they
wor
> -8<-- Start Bug Report 8<--
> 1. Problem Description:
>
> I'm trying to use stored procedures in a mysql database from within a perl
> script.
> A simple test script runs fine from a command-line perl interpreter, and
>
-8<-- Start Bug Report 8<--
1. Problem Description:
I'm trying to use stored procedures in a mysql database from within a perl
script.
A simple test script runs fine from a command-line perl interpreter, and
runs fine
when invoked via CGI
crazy. i used to use postgres extensively @work - my CTO was real
big on it.
we moved over to mysql when he left, because it was easier for me to
staff projects based on it, and we didn't need triggers or stored
procedures. I had no idea about the invalid data - i just checked
Jonathan Vanasco wrote:
> with mysql5 , they decided to make mysql easier for everyone by setting
> a default to ignore errors and coerce the data into a valid format
Not true, MySQL has always treated data that way, that's one of the reasons
many DBAs didn't take it seriously.
Jonathan Vanasco wrote:
with mysql5 , they decided to make mysql easier for everyone by setting
a default to ignore errors and coerce the data into a valid format
MySQL has always done that. Being able to turn that off was one of the
big new features in MySQL 5.
it turns out that you
I was using InnoDB w/transactions in mysql, because i needed
transactions and I've used mysql a lot before.
i was using mysql4 fine, but came into some odd bug caused by
changing the collation of a table to ut8. the only way to get rid of
it was to uninstall all of mysql & the
On Fri, 2006-03-10 at 15:26 -0500, Jonathan Vanasco wrote:
> I've found large need to migrate from mysql to postgres
>
> Are there any mod_perl specific things I should know about?
Were you using transactions with MySQL? If not, you'll need to learn
about that, and probably
On Fri, 10 Mar 2006 15:26:41 -0500
Jonathan Vanasco <[EMAIL PROTECTED]> wrote:
> I've found large need to migrate from mysql to postgres
>
> Are there any mod_perl specific things I should know about?
>
> I'm not referring to SQL traits or DBI differences, bu
On Fri, 2006-03-10 at 13:13 -0800, David Wheeler wrote:
> The only one I can think of (and my information might be severely out-
> of-date) is that you can open a MySQL connection before Apache forks
> and have it still work in the children
I'm not sure where you got this idea, b
u can open a MySQL connection before Apache forks
and have it still work in the children, but the same is not true for
PostgreSQL (or most other databases, for that matter). If you use
Apache::DBI, there should be no problem. Otherwise, just be sure that
you have no database connections open
I've found large need to migrate from mysql to postgres
Are there any mod_perl specific things I should know about?
I'm not referring to SQL traits or DBI differences, but any little
tricks or odd things that might happen when using the pg dbi under
apache
thanks,
Jonathan
you could also try this:
store to /whatever/
read from memcached
failover to /whatever/
assuming you have the memory for it, it should handle spikes very well
On Thu, 2006-03-02 at 14:10 -0500, Dan Axtell wrote:
> I've been using Apache::Session::MySQL for a while, but I've been trying to
> lower the amount of database I/O in some applications that experience spikes
> in server traffic. So I came up with the idea of using Ap
I've been using Apache::Session::MySQL for a while, but I've been trying to
lower the amount of database I/O in some applications that experience spikes
in server traffic. So I came up with the idea of using Apache::Session::File
with the files on /dev/shm, with a cron job to clear
rrupt your database.
On Mar 1, 2006, at 4:38 PM, Perrin Harkins wrote:
If you aren't already using InnoDB tables in MySQL, try that
first. It
may save you the trouble of porting to PostgreSQL. (Nothing
against Pg,
but why port if you don't have to?) The transaction and replication
On Mon, 2006-02-20 at 21:23 +0100, Daniel McBrearty wrote:
> I'm currently using mysql, but I'm considering changing over to
> firebird or postgre.
>
> Anyone have any reasoned loves/hates/useful experiences to pass on?
If you aren't already using InnoDB tables in MyS
/ thread in a select system call answering
new connections
- all other threads will be blocked in a futex() syscall
For MySQL you have 2 options to resolve this:
- use a MySQL binary ( or recompile ) without pthread support
- disable pthreads by setting LD_ASSUME_KERNEL=2.4.9 or renaming
/lib
"Andreas Nolte" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> .. just curious:
>
> are you running on a Linux box with 2.6.x kernel ? If yes, then you
> might have the trouble we had with apache AND mysql and pthreads.
>
> Solution: just move /l
.. just curious:
are you running on a Linux box with 2.6.x kernel ? If yes, then you
might have the trouble we had with apache AND mysql and pthreads.
Solution: just move /lib/tls to s.th. like /lib/tls.save and restart
mysql and apache -> solved.
If anyone likes, I can give more in
"Jonathan" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> how many connections do you get from a show processlist in mysql?
It looks right, show processlist counts connections * processes, even during
a stress test.
> is it possible that some scop
how many connections do you get from a show processlist in mysql?
is it possible that some scoping issue had the connect occuring
during prefork, instead of postfork, and mysql is dying from apache
trying to do everything via 1 persistent connection?
From: "Jonathan" <[EMAIL PROTECTED]>
Subject: Re: Apache::Session::MySQL lock troubles
> looks like DBI stops talking to mysql
>
> when this happens, is apache hanging?
>
> or does it just crash on one page, and then continually crash on
> subsequent pages?
Y
fyi , you can also see that in a regular mysql client
show processlist
this could also be a pure mysql problem. mysql is a fast db, but its
got some weird bugs.
i kept having issues with a collation matching problem on a table,
because I needed to change the column defaults from
looks like DBI stops talking to mysql
when this happens, is apache hanging?
or does it just crash on one page, and then continually crash on
subsequent pages?
a few ideas:
a
are you using the same dh / $dbh for session as the rest of
your site?
if so
pache::Session::MySQL', $session_key,
{ Handle => $dbh, LockHandle => $dbh } ;
} ;
The only way I can "duplicate" it is by pounding the sever with ab.
Once it hangs, it says hung ( can't make any other requests ). A restart
always gets it going agian.
Thanks in advance for any advice!
Todd W.
mysql's innodb and mysql 5's 'improvements' should address a lot of
issues with previous versions
that said, mysql and postgres are great. (i've never used firebird)
there's beginning to be less of a difference between mysql and
postgres as time progres
On Mon, 20 Feb 2006 21:23:11 +0100
"Daniel McBrearty" <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> I'm currently using mysql, but I'm considering changing over to
> firebird or postgre.
>
> Anyone have any reasoned loves/hates/useful experiences to pass
Daniel McBrearty <[EMAIL PROTECTED]> wrote:
> I'm currently using mysql, but I'm considering changing over to firebird or
> postgre.
>
> Anyone have any reasoned loves/hates/useful experiences to pass on?
I love postgresql!
OK, to make it reasoned:
Hi guys,
I'm currently using mysql, but I'm considering changing over to firebird or postgre.
Anyone have any reasoned loves/hates/useful experiences to pass on?
Thanks
Daniel
-- Daniel McBreartyemail : danielmcbrearty at gmail.comwww.engoi.com : the multi - language vocab
1 - 100 of 221 matches
Mail list logo
