I tried to run linksql under mod_perl on a dedicated server with 256MB RAM.
This was not possible. I need to add more than 1GB RAM to (maybe) run it under mod_perl.

Now I switched back to static-pages, but I also think about to add more RAM.

I have a lot of images on my links-pages. Does more RAM brings more speed to my static-sites?

Adding 256MB would be ok for me, but adding 1GB is very expensive (IP-Prices, not the RAM prices in
a PC-Discount)

Michael

--
Michael Skaide

http://www.cycle24.de

How so? 256MB should be more than enough.


Adrian

The server was every 5 minutes out of memory, because of linksql-script.

When I called my sites, sometimes they seem to be running normal, suddenly I
got error messages, sometimes a click on a link produce a donwload of the script.

I remember a thread where pug_dog points to the high RAM-Usage of a mod_perl
installation.

I read this before, but thought I could try this with my small memory.

It would be interesting for me about the experiences of other users.

I have a database with:
800 records
85 columns for each record in the db
1 image (4kb) for every record will be displayed on the category-pages
30 records are in each category

30 categories

1000 visitors each day

Michael


--
Michael Skaide

http://www.cycle24.de

I don't have that much mod_perl experience, but I'm sure there's gotta be something wrong with the configuration somewhere. That doesn't sound right.


Adrian

Are the images stored in the database or just a URL to the place where the image is? A database this size is relatively small and should work very well under that server configuration.
Cheers,
Michael Bray

I don't remember a post saying mod_perl cannot be run on a small memory machine. I was running it, + apache + mysql on 128 meg sun sparc without problems. I had problems with SpeedyCGI, but this had to do with my configuration rather than anything else, I think.

My comments on size related to "thin" apache was 1meg or less in size, while apache mod_perl was almost 4 meg. This bloated the ram requirements for running mostly static sites. I've played with various configurations over the past 2 years, and never had any that wouldn't run. Some seened to use more resources than others, but I was only running on a 128 meg Sun Sparc.

I also used the proxy to send cgi requests back to the mod_perl apache and only running 5 such processes, with 30 of thin apache.

If you are running out of memory, or having problems, it has to be a configuration issue. Are you running under Unix or Windows?

If you are on windows, switch to Unix.

If you are on Unix, then you may need to recompile everything again, and make sure it has been properly installed and configured.

Based on my experience, 256 meg of RAM should be sufficient to run the site you mention, as I was running at least 40 sites, all using Links SQL on a single 128 meg machine. 5-10 sites were active to fairly active (meaning they were getting requests at any given point of the day), the others were intermittantly active.






PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

Hi,

256 megs is more then enough. Most likely your mod_perl install was misconfigured.

You might be better of using SpeedyCGI, it is very easy to setup (no changes to Apache), and provides similiar benefits.

http://daemoninc.com/speedycgi/

Cheers,

Alex
--
Gossamer Threads Inc.

They used this settings in httpd.conf

<Files *.pl>
SetHandler perl-script
PerlSendHeader On
Options +ExecCGI
PerlHandler Apache::PerlRun
</Files>
<Files *.cgi>
SetHandler perl-script
PerlSendHeader On
Options +ExecCGI
PerlHandler Apache::PerlRun
</Files>


With this settings linksql shows me that it runs under mod_perl

Persistant Env: mod_perl (1) SpeedyCGI (0)


This all without using the settings which are mentioned at README.mod_perl

When I try to insert them in httpd.conf I can´t restart httpd wihtout error message

<Location /url/to/links/cgi>
SetHandler perl-script
PerlHandler Apache::Registry
PerlSendHeader On
Options +ExecCGI
PerlSendHeader On
</Location>

and

PerlRequire /path/to/startup.pl

Do the settings need to be within a special place of httpd.conf ?
Maybe I use the wrong paths? It´s not really clear to me.

My installation is at http://www.mydomain.com/sql2/
That´s the URL where page.cgi and search.cgi is located

I created startup.pl at /home/mydomain/startup.pl

- - - -

During testing mod_perl I realized something curious.

I have wwwthreads on 3 domains on this server located at:

domain1/board
domain2/cgi-local/forum3
domain3/cgi-local/forum3

When I used the functions of wwwthreads at domain1 I was suddenly
moved to wwwhtreads of the other domains.

I think there must be something wrong with the mod_perl settings, or I need to combine
the IP´s server settings in the right way with the settings of README.mod_perl

Any idea?

Michael

--
Michael Skaide

http://www.cycle24.de

Hi,

If you get a lot of traffic you should really run mod_perl under a dual server mode. See:

http://perl.apache.org/...ache_and_One_mod_per

Try SpeedyCGI, you'll see similiar performance improvements, and it's much easier to config. All you do is change the first line of the script from /usr/bin/perl, to /usr/bin/speedy.

Cheers,

Alex
--
Gossamer Threads Inc.

Hi Alex,

thanks for your reply. I would like to know the answers of my questions about installation of mod_perl which mentioned in my last posting, because I will give mod_perl another try.

Please let me know what you think about the settings for httpd.conf and my questions about the right paths for this settings.

Michael

--
Michael Skaide

http://www.cycle24.de

Hi,

Inside the <VirtualHost> section for the domain you want, add:

PerlRequire /home/mydomain/startup.pl
<Location /sql2>
SetHandler perl-script
PerlHandler Apache::Registry
PerlSendHeader On
Options +ExecCGI
</Location>

and in your startup.pl add:

use lib '/path/to/admin';
use Links::mod_perl;
1;

Then restart. However, this is not the best for heavy loads, as you want to have a dual apache configuration as described in the URL I posted.

Cheers,

Alex
--
Gossamer Threads Inc.

Also, In the 1.1x forum there should be more specifics of getting Links to run with mod_perl in dual. mode from my experiences with it :) I would guess that was probably a good year back, maybe more.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.