On Mon, Nov 24, 2008 at 3:16 PM, Michael Peters [EMAIL PROTECTED] wrote:
Well except for getting 15K disks you probably won't be able to get much
more improvement from just the hardware.
You don't think so? RAID and SSD can both improve your write
throughput pretty significantly.
- Perrin
On Mon, Nov 24, 2008 at 3:46 PM, Michael Peters [EMAIL PROTECTED] wrote:
He's already using RAID0, which should be the best performance of RAID since
it doesn't have to use any parity blocks/disks right?
Yes, I missed that. He could still improve the throughput by adding more disks.
And from
On Mon, Nov 24, 2008 at 2:52 PM, André Warnier [EMAIL PROTECTED] wrote:
Can you do a return from a require-d file, and what does it do exactly ?
Doing an exit from a file during a require() is not normally a
problem. Try it. It's kind of a bad programming practice, but Perl
will tolerate it.
On Mon, Nov 24, 2008 at 4:15 PM, Neil Gunton [EMAIL PROTECTED] wrote:
Perrin Harkins wrote:
A ton of RAM in the server might help too.
I've already got 4GB in there.
Some desktop machines ship with that much these days. You could bump
it up to 16 or 32 (assuming it's 64-bit) pretty
On Tue, Nov 18, 2008 at 12:12 PM, db [EMAIL PROTECTED] wrote:
I plan to move Apache 1.3 to 2.0, and modperl 1 to modperl 2. One of
the perl module currently used is Apache::archive. Is there a new
name for the module in modperl2? Or it can still being used in
modperl2?
That module is about
On Tue, Nov 11, 2008 at 7:33 PM, Joel Bernstein [EMAIL PROTECTED] wrote:
2008/11/11 Perrin Harkins [EMAIL PROTECTED]:
On Tue, Nov 11, 2008 at 2:09 PM, Octavian Rasnita [EMAIL PROTECTED] wrote:
However, I've seen that many Catalyst developers prefer to use fastcgi and
not mod_perl, because when
On Tue, Nov 11, 2008 at 12:49 PM, David E. Wheeler [EMAIL PROTECTED] wrote:
To a certain degree, Apache/mod_perl is a victim of the success of HTTP.
It's fairly easy to implement a new HTTP server, so there are a lot of them,
and many are easy to use and extremely fast. If all you're interested
On Tue, Nov 11, 2008 at 2:09 PM, Octavian Rasnita [EMAIL PROTECTED] wrote:
However, I've seen that many Catalyst developers prefer to use fastcgi and
not mod_perl, because when using fastcgi, the applications can be restarted
without restarting the whole web server.
It's the same with
On Tue, Nov 11, 2008 at 3:42 PM, Adam Prime [EMAIL PROTECTED] wrote:
I'd really love to see a best practices kind of document, or at least a more
detailed document that described getting the light front / heavy backend
stuff working. The mp1 guide has a pretty extensive section on the various
On Tue, Nov 11, 2008 at 7:46 PM, Andrew Rodland [EMAIL PROTECTED] wrote:
But you _do_ want to keep static file serving apart from the app code (or else
incur the memory overhead of an app process for every file download), so you
do
need to go that frontend/backend route -- and it seems to me
On Mon, Nov 10, 2008 at 6:46 AM, André Warnier [EMAIL PROTECTED] wrote:
- A surprising number of people are running mod_perl under the worker
MPM.
What is so surprising about this ? (genuine curious question)
Because of the way perl threads use memory, you end up using less a
lot less memory
On Mon, Nov 10, 2008 at 11:45 AM, Issac Goldstand [EMAIL PROTECTED] wrote:
However, it's not necessarily better if your memory consumption goes
mostly to run-time data which can't be pre-generated (in which case
worker is better for the reasons listed below, since there's no COW benefit)
On Fri, Nov 7, 2008 at 1:25 PM, Dave Rolsky [EMAIL PROTECTED] wrote:
On Fri, 7 Nov 2008, Perrin Harkins wrote:
Does anyone have a recipe they can share for NYTProf with Mason under
mod_perl? I'm getting there, but if someone has already sorted it out
that would be great. I'm currently
On Sat, Oct 25, 2008 at 7:32 AM, André Warnier [EMAIL PROTECTED] wrote:
And they do remember some things between consecutive runs of scripts
or modules. That is usually undesirable, because it can give nasty
errors : a variable that you declare with my $var and that you expect
to be undef,
On Sat, Oct 25, 2008 at 7:34 AM, Clinton Gormley [EMAIL PROTECTED] wrote:
Michael Peters' comment about memory reuse was saying that:
- if at runtime, you load a large memory structure
- then let those variables go out of scope
- then that memory will be come available for reuse by Perl
I
On Thu, Oct 23, 2008 at 10:31 PM, Fayland Lam [EMAIL PROTECTED] wrote:
B one SQLs with some operation
SELECT col FROM table WHERE $where
while $count is scalar @cols and real cols is splice(@cols, $start, $rows)
If you're talking about Perl/DBI, doing that normally loads the entire
result set
On Fri, Oct 24, 2008 at 4:20 PM, Benjamin Hitz [EMAIL PROTECTED] wrote:
In case anyone was wondering about this head scratcher - you have to set
DBI_TRACE before you load DBI.pm.
You can just call DBI-trace() instead.
- Perrin
# CGI::Application community mailing list
On Fri, Oct 24, 2008 at 8:57 AM, Carl Johnstone
[EMAIL PROTECTED] wrote:
If you're really concerned and would rather the child process quits and
frees additional memory to the OS, then call $r-child_terminate in any of
your handlers, and the child process will automatically quit at the end of
On Thu, Oct 23, 2008 at 2:55 PM, Adam Prime [EMAIL PROTECTED] wrote:
PerlSections-dump kind of does what we want,
except that it doesn't expand the macro's that are used.
This may be obvious in hindsight, but using mod_macro was probably a
bad idea. I'd suggest using perl to handle what you
On Thu, Oct 23, 2008 at 3:22 PM, Perrin Harkins [EMAIL PROTECTED] wrote:
On Thu, Oct 23, 2008 at 2:55 PM, Adam Prime [EMAIL PROTECTED] wrote:
PerlSections-dump kind of does what we want,
except that it doesn't expand the macro's that are used.
This may be obvious in hindsight, but using
On Wed, Oct 22, 2008 at 1:33 PM, Benjamin Hitz [EMAIL PROTECTED] wrote:
It basically calls DBI-connect_cached(dbi:Oracle:sdev2, $user, $pass, {
RaiseError=1, AutoCommit=0, private_cachekey = $0 });
That ought to work. The connect_cached call should ping the
connection and reconnect if it's
On Wed, Oct 22, 2008 at 6:28 AM, André Warnier [EMAIL PROTECTED] wrote:
I would not ask, if there were not sometimes really many of these being
executed over and over again. I figure it may be worth knowing if one of
the forms above (or another one I haven't tried) is really better than
On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha [EMAIL PROTECTED] wrote:
Gosh I wonder
why mysql does not support SEubqueries.. It just hangs in the copying to tmp
table status. Atleast I know whats wrong... Thanks very much
It supports them, but won't optimize them well until 5.2. There's
some
On Mon, Oct 20, 2008 at 3:27 AM, Mihai Bazon [EMAIL PROTECTED] wrote:
I rewritten it with AUTOLOAD, though not sure which one is better:
If performance is a consideration, Sean's will be better than using AUTOLOAD.
- Perrin
___
templates mailing list
On Sat, Oct 18, 2008 at 3:39 PM, Mihai Bazon [EMAIL PROTECTED] wrote:
Thanks. It's not very orthodox if you ask me, but it's a good solution, in
lack of anything else. :-)
There's a simple option for turning off the things considered
dangerous, like EVAL. Including other template isn't
On Thu, Oct 16, 2008 at 3:40 PM, Reyna.Sabina [EMAIL PROTECTED] wrote:
A test using mysql -e LOAD table ... was ran to see
if LOAD' will give an error when loading a record with
the same primary-key of an existing record in the table.
Do you mean LOAD DATA INFILE? It will give an error
On Wed, Oct 15, 2008 at 12:31 PM, Mark Stosberg [EMAIL PROTECTED] wrote:
We had a double submit bug that allowed a form to be submitted twice when we
weren't fully prepared for that. We are still researching the best practices
to
address this a general case. One approach we are considering is
On Wed, Oct 15, 2008 at 2:44 AM, Shibi NS [EMAIL PROTECTED] wrote:
CGI.pm version 3.15
Update.
- Perrin
On Tue, Oct 14, 2008 at 10:03 AM, André Warnier [EMAIL PROTECTED] wrote:
, but in a a specific Location, I would like to reset this to
PerlSetVar myvar
I've never done this, but did you try undef? Or maybe 0, if you just
want to test for true.
- Perrin
On Tue, Oct 14, 2008 at 4:28 AM, Shibi NS [EMAIL PROTECTED] wrote:
my $req_params = $req-args;
my $cgi= CGI-new($req_params);
There's no need to do that. Just call CGI-new(). And make sure you
have the latest version of CGI.pm from CPAN.
- Perrin
On Thu, Oct 9, 2008 at 3:07 AM, Scott Tomilson [EMAIL PROTECTED] wrote:
Free to wrong pool da2750 not 184a6a8.
Which leads me to believe there is something funny going on with multiple
threads, etc.
In the past these have typically been threading problems. I don't run
Windows or threads, so
On Wed, Oct 8, 2008 at 11:56 AM, Jim Lyons [EMAIL PROTECTED] wrote:
Indexes speed up joins. Foreign keys should be indexes themselves, so they
can also speed up joins. If the FK is not an index, it won't help. So,
index your FKs
If you add a FOREIGN KEY constraint in MySQL 5+ it adds an
On Tue, Oct 7, 2008 at 5:03 PM, Matt Hucke [EMAIL PROTECTED] wrote:
Is there any way to prevent TT from calling functions that don't exist and
falling into AUTOLOAD?
I think you want to implement can() in your module.
- Perrin
___
templates mailing
On Tue, Oct 7, 2008 at 5:54 PM, Matt Hucke [EMAIL PROTECTED] wrote:
I use can() within Autoload.
I don't think that will help. I seem to recall that TT calls can() on
your module to see if it should call the thing as a method or not.
Implement can() in your module and see if it helps. Should
On Fri, Oct 3, 2008 at 4:25 PM, Phil Carmody [EMAIL PROTECTED] wrote:
I presume that all hosting services which offer LAMP do so via virtual
machines then, or via Apache 2.
No, they typically just offer CGI. This is not an issue with CGI
because you're spawning a whole new Perl interpreter
On Tue, Sep 30, 2008 at 8:11 AM, Jeff Pang [EMAIL PROTECTED] wrote:
AFAIK, Perlbal is reverse proxy before the webserver, not a real web server.
I don't use it, but it can do auth and serve images. If you read the
presentations about LiveJournal's backend, they explain this.
- Perrin
On Tue, Sep 30, 2008 at 1:11 PM, David Nicol [EMAIL PROTECTED] wrote:
On Tue, Sep 30, 2008 at 11:40 AM, Perrin Harkins [EMAIL PROTECTED] wrote:
I don't use it, but it can do auth and serve images.
as can Apache itself, with appropriate access control. The two steps
(this should not be news
On Mon, Sep 29, 2008 at 3:00 PM, Mark Stosberg [EMAIL PROTECTED] wrote:
We have a large, busy, database application that relates to millions of
photos, which we also need to store and display.
Have you read Cal Henderson's book about how Flickr works? It's a bit
extreme, but interesting. A
On Sat, Sep 27, 2008 at 9:04 AM, Porta [EMAIL PROTECTED] wrote:
Thanks to all for the feedback.
It seems that, basically, it's between Rose::DB::Object and DBIx::Class.
So far, RDO looks more like what I need, but a bit complex.
Would you like to see a new ORM in cpan, more simpler?
No. We
Very helpful! Thanks to both of you.
- Perrin
Hi,
I ran into a problem with a program I was working on today and
couldn't figure out what the correct way to solve it with DateTime
was. I ended up brute-forcing it, but I'd like to know the right way
for future work.
The gist of what I wanted to do is this:
- Take a DT object which has been
On Wed, Sep 24, 2008 at 2:56 PM, Chris Travers [EMAIL PROTECTED] wrote:
Just letting everyone know, I believe I have resolve the performance
problems in the template. The following two changes appear to have
cut the time on the dev box from around 8 minutes to about 90 sec
Certainly makes the
On Wed, Sep 24, 2008 at 12:39 PM, Fred Moyer [EMAIL PROTECTED] wrote:
I went ahead and use 1.06 in my production setup. If you want to use 1.07,
you will need to include the GlobalRequest option in your config setup.
It should be fine to use GlobalRequest. The warnings against it are
On Wed, Sep 24, 2008 at 3:08 AM, badman [EMAIL PROTECTED] wrote:
For Michael, yes i know what it mean to have global variables (semaphores,
...) i was investigating this option because when i do call ...-new(); it
reads a file to initiate its attribute.
I would like to improve the performance
On Tue, Sep 23, 2008 at 9:29 PM, kalin m [EMAIL PROTECTED] wrote:
count(if(a.Type = Signature Based Return, a.amount,'')) group by
order by
I think you're looking for sum().
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Tue, Sep 23, 2008 at 10:09 PM, kalin m [EMAIL PROTECTED] wrote:
i.e. i'd like to (assuming in the above example that _type_ and _amount_
are column names) sum all the amounts but count only the ones with a certain
type, all other amounts that are different type should not be part of the
On Tue, Sep 23, 2008 at 4:02 PM, Chris Travers [EMAIL PROTECTED] wrote:
Any idea where I can find performance information for Template Toolkit?
You can use Devel::NYTProf to profile your code.
I have a template which is taking forever to render and I am trying to
find ways to speed it up.
On Tue, Sep 23, 2008 at 12:32 PM, John Drago [EMAIL PROTECTED] wrote:
Ha no not really. Somehow everything else must suffer (usability, debugging,
intuitiveness, etc) so that we can have a *fast* web programming environment.
(Yay!)
While I agree that the splitting of the APIs you're
On Tue, Sep 23, 2008 at 2:51 PM, André Warnier [EMAIL PROTECTED] wrote:
I'm sure someone can think of a way to strip the possible leading and
trailing spaces off the keys at the same time though.
Please don't. Some of the reasons for using a well-tested parser like
CGI or libapreq2 are listed
On Thu, Sep 18, 2008 at 12:17 PM, Adam Woodworth [EMAIL PROTECTED] wrote:
I'm using mod_perl 2.0.3 with Apache 2.2.9 and mod_proxy for reverse
proxying. Is there a way, from my mod_perl application, that I can
tell when the connection to the backend server in mod_proxy timed out?
I.e.,
On Tue, Sep 16, 2008 at 11:00 PM, Himanshu [EMAIL PROTECTED] wrote:
For the following to work I must load Apache2RequestRec as well as
Apache2::RequestIO.
The idea is that you don't load what you don't need, which reduces
memory consumption, which is the bottleneck on most mod_perl
On Fri, Sep 12, 2008 at 3:46 PM, kropotkin [EMAIL PROTECTED] wrote:
Then I want to stop the script executing any further and ideally to write to
the server error logs. So the last line of my error handling routine is:
die $error_message.
Make that:
print STDERR $error_message;
return OK();
-
On Fri, Sep 12, 2008 at 6:38 PM, kropotkin [EMAIL PROTECTED] wrote:
Just one problem though - print STDERR is printing the message to the main
server error log not the virtual host error log. die printed it to the
virtual host error log.
Yeah, that was bad advice. You should probably use
On Thu, Sep 11, 2008 at 9:07 PM, Patrick Galbraith [EMAIL PROTECTED] wrote:
1. There are issues with using threads - what all are they?
2. What they should use- prefork or worker?
3. What is the consensus?
4. Is there a document available giving the pros and cons?
5. What is the official
On Thu, Sep 4, 2008 at 12:15 AM, Ryan Schwartz [EMAIL PROTECTED] wrote:
We're seeing a huge surge in our qps and I'd like to make sure we're tuned
as well as we can be. I'm wondering if I've got some variables maybe set too
large (is that even possible?) ? We do have a fair bit of innodb, so
On Thu, Sep 4, 2008 at 3:23 PM, Ryan Schwartz [EMAIL PROTECTED] wrote:
I'll have to crack open my copy - haven't read through it in a while
If you have the first edition, I recommend getting the newer one. It
has a lot more tuning info.
- Perrin
--
MySQL General Mailing List
For list
On Thu, Sep 4, 2008 at 4:26 PM, Josh Miller [EMAIL PROTECTED] wrote:
We're seeing a significantly higher percentage of IO wait on the system,
averaging 20% now with the majority of that being user IO. The system is
not swapping at all.
O_DIRECT may not be the best setting for your hardware.
On Thu, Sep 4, 2008 at 6:43 PM, Josh Miller [EMAIL PROTECTED] wrote:
We'd like to prove InnoDB and move onto that storage engine for the
transaction support, MVCC, etc.. but we're finding that performance is poor.
Well, thousands of large InnoDB database users prove that the engine
itself has
On Fri, Aug 29, 2008 at 4:57 AM, walter harms [EMAIL PROTECTED] wrote:
Since diskspace is plenty i thinking about to use the name directly. does
anyone has any idea
what is the performance penalty ?
On Fri, Aug 29, 2008 at 10:53 AM, Berg, Eric [EMAIL PROTECTED] wrote:
Just yesterday I ran into a problem in which using do( $file ) or eval(
$file ) both had problems in that they did not successfully execute the
code in $file.
What were the error messages from do and eval?
Folks, is there
On Fri, Aug 29, 2008 at 11:19 AM, Clinton Gormley [EMAIL PROTECTED] wrote:
Is this not a current-working-directory issue?
This isn't terribly well documented on the mod_perl site, but from
http://perl.apache.org/docs/2.0/api/ModPerl/Registry.html
Better documented here:
On Fri, Aug 29, 2008 at 1:23 PM, Berg, Eric [EMAIL PROTECTED] wrote:
The really weird thing is that when run in a CGI context, the -x test
works as expected, but when called when running as a mod_perl2 registry
script, it returns false, even though the file (that does exist) is
executable by
On Fri, Aug 29, 2008 at 2:04 PM, Berg, Eric [EMAIL PROTECTED] wrote:
The mod_perl server and the CGI server are the same.
Even so, CGI is often configured to execute the script as the owner of
the file, rather than as the user running the web server, so make sure
you really are the same user.
On Fri, Aug 29, 2008 at 3:43 PM, Berg, Eric [EMAIL PROTECTED] wrote:
For me, it's the same on both.
Nevertheless, there have been problems in the past with GID. Are you
running the latest mod_perl, and perl 5.8.8 or later? See this for
background:
On Fri, Aug 29, 2008 at 4:26 PM, Will Fould [EMAIL PROTECTED] wrote:
Assuming my code can look in an existing database/memcache with the
requested URI segment, can someone suggest the lightest/fastest ways to
accomplish this or provide a decent link to a better discussion?
Some options:
-
On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila [EMAIL PROTECTED] wrote:
Hi, I've been trying to find information on how myisam handles locks. I
though myisam had locking only on writes and not on reads.
No, readers block writers. This true of any system that only has read
and write locks
On Thu, Aug 28, 2008 at 10:59 AM, Jose Estuardo Avila
[EMAIL PROTECTED] wrote:
I understand that reads are locked by writes but nowhere does of mention
that reads also block reads.
How could they not? You can't simultaneously read and write the same
data -- the read would get half-written
On Thu, Aug 28, 2008 at 1:14 PM, Jose Estuardo Avila [EMAIL PROTECTED] wrote:
My point is that on my process lists there are no writes being done at that
time only reads and actually only one read all other reads are locked as
well as writes.
Sure, that's because the reads are in line behind
On Wed, Aug 27, 2008 at 5:15 AM, Timothy Partee [EMAIL PROTECTED] wrote:
Am I completely on the wrong track?
In my opinion, yes. You'd have to write your own DBI, or a DBD driver
that talks to mod_dbd. It would not be easy.
Is there
another more simple way to implement MySQL DBI connection
On Tue, Aug 26, 2008 at 2:04 PM, Berg, Eric [EMAIL PROTECTED] wrote:
We're using DBI here as well
That's going to make forking a lot more complicated. You'll need to
close your DBI handles before you fork, or set InactiveDestroy on
them. You need to open new ones in the forked process to do
On Tue, Aug 26, 2008 at 2:28 PM, Berg, Eric [EMAIL PROTECTED] wrote:
I'm using Apache::DBI.
I stripped out calls to code that use DBI and it still segfaults.
I've gone into the code and made sure that any method that does a DBI
call also uses $dbh-disconnect;
With Apache::DBI, you actually
On Fri, Aug 22, 2008 at 6:25 PM, Jens Gassmann [EMAIL PROTECTED] wrote:
we need RIPEMD160-Hashes for our mod_perl-app. The testscript attached
worked on commandline, but not with mod_perl. There it returns a wrong Hash
= 0123456789abcdeffedcba9876543210f0e1d2c3
Whats wrong? Where could i get
On Sun, Aug 24, 2008 at 4:54 PM, Joe Smoker [EMAIL PROTECTED] wrote:
Seems like mod perl does not like the CRLF chars in the notepad file... but
I also tried removing the CR chars with the same result...
It does sound like a problem with your line-ending characters. Since
I don't use Win32, I
On Mon, Aug 25, 2008 at 4:35 PM, Jens Gassmann [EMAIL PROTECTED] wrote:
The entire code is written in c :-( only some helper subs are written in
perl. I could only write perl
You may be able to tell what it's trying to do by using tools like
strace. If not, I'd suggest you either contact
On Wed, Aug 20, 2008 at 11:26 AM, Niels Larsen [EMAIL PROTECTED] wrote:
I can put
the command line to run in backticks and do print [EMAIL PROTECTED], and
that too works, but would like to use system, Proc::SafeExec, etc.
To fork and capture output without backticks, you have to do something
On Wed, Aug 20, 2008 at 3:03 AM, Brett Randall [EMAIL PROTECTED] wrote:
I'm trying to get PerlAuthenHandler to work but when I go to a URL that
I've set it up on, it asks for a username and password and then lets me
in no matter what I type.
Have you debugged this code to figure out which line
On Wed, Aug 20, 2008 at 5:42 PM, Brett Randall [EMAIL PROTECTED] wrote:
I was wondering about debugging... I'll probably do the good old open a
file, write to it after each line, and see where it stops writing
No need to open a file. Anything you print to STDERR goes to apache's
error_log, so
On Wed, Aug 13, 2008 at 7:30 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
Can u please guide me to any good books or URL for mysql sql tunning..
http://www.highperfmysql.com/
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Sun, Aug 10, 2008 at 10:54 AM, Kevin Waterson [EMAIL PROTECTED] wrote:
I have 3 tables (schema below) with categories, questions and answers.
Each category can of course have many questions in it. Also, the
answers are multiple choice, so each question can have several
related answers. I am
On Sat, Aug 9, 2008 at 8:20 PM, Dondi M. Stroma [EMAIL PROTECTED] wrote:
Thanks, but I do not see how Apache2::ServerUtil::restarting() does the same
thing. The $Apache::Server::Starting and $Apache::Server::ReStarting are,
respectively, 1 and 0 during start, 0 and 1 during restart, and 0 and 0
On Sat, Aug 9, 2008 at 8:10 AM, John Smith [EMAIL PROTECTED] wrote:
Now here's the question: I need to lock certain rows, so that no other
client can read or write that rows (I want those clients to wait until the
transaction is commited or rolled back). I don't want to lock the entire
table,
On Sat, Aug 9, 2008 at 5:19 PM, Dondi M. Stroma [EMAIL PROTECTED] wrote:
What are the mod_perl 2 equivalents of $Apache::Server::Starting and
$Apache::Server::ReStarting?
http://perl.apache.org/docs/2.0/user/porting/compat.html#C__Apache__Server__Starting__and_C__Apache__Server__ReStarting_
-
On Thu, Aug 7, 2008 at 11:22 AM, Berg, Eric [EMAIL PROTECTED] wrote:
I need to
build a configuration that will configure each instance based on a
single parameter. Right now I'm using a file called ENVIRONMENT that
gets written during the deploy, so I have a value for DEV, STAGE and
PROD.
On Tue, Aug 5, 2008 at 2:19 AM, Car54 [EMAIL PROTECTED] wrote:
After upgrading to Perl 5.8.8 from 5.8.0 the following happens...
Any time you change to a different perl, you must recompile mod_perl.
2) When trying to install mod_perl it can't find apache src directory and
neither can I.)
On Mon, Aug 4, 2008 at 6:47 PM, Dodger [EMAIL PROTECTED] wrote:
Erm... so what's NOT supported? Are there things that exist in Apache
2.0 that also exist in Apache 2.2 but aren't supported? Or are the
only things not supported *new* things for 2.2?
Others can probably give you a more precise
On Fri, Aug 1, 2008 at 7:32 AM, Rudolf Lippan [EMAIL PROTECTED] wrote:
How would you get duplicated data? In one case you have an integer
and in the other you have the value, but you still have to store one token
of information with the row.
I meant in the case of storing the value
On Thu, Jul 31, 2008 at 9:46 AM, Jerry Schwartz
[EMAIL PROTECTED] wrote:
Other than the fact that an ENUM can have many more values than a SET, is
there any particular reason to choose one over the other?
The only use for ENUM is to make your data smaller. It offers no
protection against
On Thu, Jul 31, 2008 at 11:38 AM, Mr. Shawn H. Corey
[EMAIL PROTECTED] wrote:
I don't see how that can be; with ENUM the DB has to set aside enough
bytes for the longest identifier.
ENUMs are stored as integers.
The only advantage of ENUM is that
the data is in the same table; you don't have
On Thu, Jul 31, 2008 at 8:00 AM, Fish Kungfu [EMAIL PROTECTED] wrote:
Ideally, I was hoping COUNT() could work like this, BUT it doesn't of
course:
mysql SELECT COUNT(SELECT aviName,MAX(dateTime) ,count(*) FROM
aviTrackerMain WHERE DATE(dateTime) LIKE CONCAT(DATE(NOW()),'%') GROUP
BY
On Thu, Jul 31, 2008 at 12:59 PM, Chris W [EMAIL PROTECTED] wrote:
So my question is, is doing that way better than making the query more
complex with all the joins?
If by better you mean faster then yes, it probably is marginally
faster. It would be simpler to just use the actual values you
On Mon, Jul 21, 2008 at 11:44 AM, mos [EMAIL PROTECTED] wrote:
I can't specify all of the columns in a Set statement in the
OnDuplicate clause because I don't know what the column names are and there
could be 100 columns.
Write code to do it. There is no way around specifying the
On Mon, Jul 21, 2008 at 2:43 PM, mos [EMAIL PROTECTED] wrote:
I thought if MySQL found a duplicate key on the insert, it would
automatically update the existing row that it found with the results from
table1 if I left out the column expressions in the update clause. But
apparently it doesn't
On Mon, Jul 21, 2008 at 6:29 PM, Cosimo Streppone [EMAIL PROTECTED] wrote:
I'm trying to fully understand this problem, but I'm considering
implementing throttling at the backend (maybe front?) level,
so I was wondering what is the current state-of-the-art
or best practice about this.
If you
On Sun, Jul 20, 2008 at 12:12 AM, mos [EMAIL PROTECTED] wrote:
Is there a way to get Insert ... select ... On Duplicate Update to update
the row with the duplicate key?
That's what it does.
Why can't it do this?
What makes you think it can't?
- Perrin
--
MySQL General Mailing List
For
On Sun, Jul 13, 2008 at 1:21 AM, John M. Dlugosz
[EMAIL PROTECTED] wrote:
OK, when I defined $r as you did, it worked. For documentation, I was
looking at here:
http://search.cpan.org/~joesuf/libapreq2-2.08/glue/perl/lib/Apache2/Request.pm
Hi John,
That SYNOPSIS is more like a set of
On Wed, Jul 16, 2008 at 12:06 PM, Jim Brandt [EMAIL PROTECTED] wrote:
Are there any other solutions for Apache 1 before I start hacking on this
module?
The Apache::Filter stuff does work, but I don't see any advantage to
using that in this case. You'd still have to do the proxy fetch
yourself.
On Wed, Jul 16, 2008 at 11:04 PM, Chris Zhuang [EMAIL PROTECTED] wrote:
But how to setup Komodo 3.1 to debug mod_perl?
You should probably ask the Komodo support list about that.
Apache::DB seems to be working.
- Perrin
On Thu, Jul 17, 2008 at 11:52 AM, [EMAIL PROTECTED] wrote:
Other than Catalyst, do you have any other framework suggested for MP
applications?
http://perl.apache.org/products/app-server.html
- Perrin
On Sun, Jul 13, 2008 at 5:40 PM, Fred Moyer [EMAIL PROTECTED] wrote:
I see a couple issues with the patch that caused this, but I'm not sure what
problem the patch was trying to solve.
Looks like it was trying to solve the rollback cleanup not working at
all for MP2. Pretty serious bug.
I
On Thu, Jul 10, 2008 at 7:38 AM, Jonathan Swartz [EMAIL PROTECTED] wrote:
Symlinks would work too.
Won't that load the components into memory twice though?
- Perrin
-
Sponsored by: SourceForge.net Community Choice Awards:
501 - 600 of 4038 matches
Mail list logo