Measure of performance !!!
Hi all, Some days ago I sent a question about performance of Oracle and MS SQL Server databases, but I don't got any answer that help me. I have installed on my machine: Linux Red Hat 6.2 Apache 1.3.14 (installed on machine 1 ) mod_perl 1.24-1 DBD::Oracle DBD::Sybase ( to access the MS SQL Server database ) Oracle (installed on machine 2 ) MS SQL Server (installed on machine 3 ) I know using the Apache::DBI module the connection time is reduced, but I need to make some tests of performance without Apache::DBI. The Oracle and SQL Server servers are running on different machines that Web server. I undestand one Oracle connection consumes more resources that SQL Server, but there is a thing that I don't undestand, when I ran the tests for SQL Server the machine 1 works properly, but when I ran the tests for Oracle the machine 1 works much more slow. Same with the database servers installed on different machines that Web server, does one connection Oracle consume more resources on the machine 1 that a SQL Server connection? Why? Why does the machine 1 work much more slow for Oracle? Please, if someone must help me I will be very thankful. Happy hollidays for everyone. Edmar Edilton da Silva Bacharel em Cincia da Computaco - UFV Mestrando em Cincia da Computaco - UNICAMP
Performance measures of a perl script !!!
Hi all, I ran some performance measures on two perl scripts under mod_perl, the first script access a Oracle database using the DBD::Oracle module and the second script access a MS SQL Server database using the DBD::Sybase module. The measured response times was very different at the two cases, the time for the Oracle database was approximately three times the time for MS SQL Server databse. Why all this difference between the measured values ? I also understood that an Oracle connection needs much more resource of machine than an MS SQL Server connection (both database servers are not installed on the same machine that the Web server). Is it correctly? Please, is there some place where I can find docs about it? Any help will be very appreciated. Thanks... Edmar Edilton da Silva Bacharel em Cincia da Computaco - UFV Mestrando em Cincia da Computaco - UNICAMP
Driver to access the MS SQL Server database!!!
Hi all, Please, can anyone tell me what driver I can use to access the MS SQL Server database? I am using the freetds_dbd driver, but It doesn't work properly when under heavy workload, the child processes of the apache server are aborted. I think that the problem is the freetds_dbd driver, because I am wanting to use another driver. If someone must help me I will be very appreciated. Thanks... Edmar Edilton da Silva Bacharel em Cincia da Computaco - UFV Mestrando em Cincia da Computaco - UNICAMP
Problem with the freetds_dbd driver!!!
Hi everyone, I have a problem with the "freetds_dbd" module (driver to access the MS SQL Server), it doesn't work correctly. This module is installed under apache 1.3.14, mod_perl 1.24_01 and DBI 1.13-1. When a lot of requests run a perl script that uses the driver to open a database connection, the child processes of the apache are aborted and the followings error messages are print in the error_log file: httpd: tdslayer.c:2923: newStream: Assertion `total6' failed. [Wed Dec 13 01:57:57 2000] [notice] child pid 1767 exit signal Aborted (6) Please, does anyone know what is the problem with my driver? Does anyone know another driver to access MS SQL Server which I can use? All help will be very appreciated. Thanks. ____ Edmar Edilton da Silva Bacharel em Cincia da Computaco - UFV Mestrando em Cincia da Computaco - UNICAMP
Concurrenty access to a log file!!!
Hi all, I have installed on my machine the mod_perl module and exists a lots perl scripts running under mod_perl. I am doing some tests and I need that all call to these perl scripts write in a log file. How can there are a lots scripts running to the same time, I need to control the processes of write. Please, can anyone give me any hint about it? Is there any doc on the Internet that I can use? Thanks for all help... Edmar Edilton da Silva Bacharel em Ciência da Computacão - UFV Mestrando em Ciência da Computacão - UNICAMP
Response time under mod_perl
Hi all, I need to know the response time of a Perl script running under mod_perl. To do this I need a function that it's returns the current time of the system in milliseconds. Please, have anyone any idea what function I can use? Thanks for any help... Edmar, - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Response time of a perl script!!!
Hi folks, I ran a same perl script twice. First time only under mod_perl, and after under mod_perl and Apache::DBI. The response time of both experiments was very different. The last was fastest than the first approximately 20 times. Is it correctly? If the response time of a perl script with mod_perl is bad, I think that it without mod_perl will be much worse. I also would like to know if when the apache (with mod_perl) starts each child process already has one embedded interpreter or they will have only when the first request arrives. Please, if soneone help me will be very appreciated. Thanks... Edmar, - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Perl scripts with Apache::DBI !!!
Hi folks, I am not sure if my perl scripts are running under Apache::DBI. How can I check if they are using database connections which was already openned. Is there any command that I can add to the perl script for it tell me if was opens a new connection with the database or if it used a connection already opened? Thanks for any help!!! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Order of Installation!!!
Hi all, I have installed on my machine the following modules: apache 1.3.12-2 mod_perl 1.21-10 DBI 1.13-1 DBD::Oracle 1.03 Apache::DBI 0.86-1 The problem is that when I run a perl script under mod_perl, the response time is almost the same than the response time of the same script being ran without the mod_perl module. And I know that mod_perl was correctly installed. Another problem is that I can not open database connections when the WWW server starts because happen an error in the child processes of the apache. I think can there is some problem in the installation or configuration of the modules. Did the order for installing of the modules do any difference? If someone help me will be very appreciated. Thanks... -- Edmar Edilton da Silva Bacharel em Ciência da Computacão - UFV Mestrando em Ciência da Computacão - UNICAMP
Problem with Apache::DBI under mod_perl!!
Hi all,
I am sending again the previous message because I still didn't know how
to resolve the below problem. Can anyone any idea how help me?
I have installed on the my machine the following modules:
apache 1.3.12-2
perl-5.00503-10
mod_perl 1.21-10
DBI 1.14
DBD::Oracle
Apache::DBI 0.87
Oracle Client Software
For enable the mod_perl module, I added the below code in the
configuration file of apache ("httpd.conf"):
# If the perl module is installed, this will be enabled.
IfModule mod_perl.c
PerlFreshRestart On
Alias /perl-bin/ /home/httpd/perl-bin/
Location /perl-bin
SetHandler perl-script
PerlHandler Apache::Registry
PerlSendHeader On
Options +ExecCGI
/Location
/IfModule
For load the Apache::DBI module, I also added this line in the
"httpd.conf" file:
PerlRequire /etc/httpd/conf/startup.pl
Inside of "startup.pl" file, I added the following code:
#!/usr/bin/perl
use strict;
# Extend @INC if needed
use lib qw(/dir/foo /dir/bar);
# Make sure we are in a sane environment.
$ENV{MOD_PERL} or die "not running under mod_perl!";
# For things in the "/perl-bin" URL
use Apache::Registry;
# Load Perl modules of your choice here
# This code is interpreted *once* when the server starts
use Apache::DBI ();
$Apache::DBI::DEBUG = 2;
$Apache::AuthDBI::DEBUG = 2;
use DBI ();
# Tell me more about warnings
use Carp ();
$SIG{__WARN__} = \Carp::cluck;
# Load CGI.pm and call its compile() method to precompile
# (but not to import) its autoloaded methods.
use CGI ();
CGI-compile(':all');
#Initialize the database connections for each child
Apache::DBI-connect_on_init
("dbi:Oracle:ora8", "travel", "travel",
{
PrintError = 1, # Warn() on errors
RaiseError = 0, # Don't die on error
AutoCommit = 1, # Commit executes immediately
}
);
But, when I try loading a HTML page of WWW server, the server refuse my
request. I think that the problem is in the WWW server that don't load
their child process because to the Apache::DBI to be with some problem.
During the installation of all the modules didn't have any problem. The
apache start correctly, but when I try stoping them, I get a error
message that the process failed. If I don't load the DBI and Apache::DBI module
in the apache, it works correctly. Using only the DBI and
DBD::Oracle modules, I can access the Oracle database no problems. Really the
problem must be in the Apache::DBI ( when it is loaded ), but I don't know exactly
where. Can anybody help me? Locking the configuration files, can anyone tell me
what is happening? Any help will very appreciated.
____
Edmar Edilton da Silva
Bacharel em Ciência da Computacão - UFV
Mestrando em Ciência da Computacão - UNICAMP
Problem with Apache::DBI under mod_perl!!
Hi all,
I have installed on the my machine the following modules:
apache 1.3.12-2
perl-5.00503-10
mod_perl 1.21-10
DBI 1.14
Apache::DBI 0.87
For enable the mod_perl module, I added the below code in the
configuration file of apache ("httpd.conf"):
# If the perl module is installed, this will be enabled.
IfModule mod_perl.c
PerlFreshRestart On
Alias /perl-bin/ /home/httpd/perl-bin/
Location /perl-bin
SetHandler perl-script
PerlHandler Apache::Registry
PerlSendHeader On
Options +ExecCGI
/Location
/IfModule
For load the Apache::DBI module, I also added this line in the
"httpd.conf" file:
PerlRequire /etc/httpd/conf/startup.pl
Inside of "startup.pl" file, I added the following code:
#!/usr/bin/perl
use strict;
# Extend @INC if needed
use lib qw(/dir/foo /dir/bar);
# Make sure we are in a sane environment.
$ENV{MOD_PERL} or die "not running under mod_perl!";
# For things in the "/perl-bin" URL
use Apache::Registry;
# Load Perl modules of your choice here
# This code is interpreted *once* when the server starts
use Apache::DBI ();
$Apache::DBI::DEBUG = 2;
$Apache::AuthDBI::DEBUG = 2;
use DBI ();
# Tell me more about warnings
use Carp ();
$SIG{__WARN__} = \Carp::cluck;
# Load CGI.pm and call its compile() method to precompile
# (but not to import) its autoloaded methods.
use CGI ();
CGI-compile(':all');
#Initialize the database connections for each child
Apache::DBI-connect_on_init
("dbi:Oracle:ora8", "travel", "travel",
{
PrintError = 1, # Warn() on errors
RaiseError = 0, # Don't die on error
AutoCommit = 1, # Commit executes immediately
}
);
But, when I try loading a HTML page of WWW server, the server refuse my
request. I think that the problem is in the WWW server that don't load
their child process because to the Apache::DBI to be with some problem.
During the installation of all the modules didn't have any problem. The
apache start correctly, but when I try stoping them, I get a error
message that the process failed.
Locking the configuration files, can anyone tell me what is happening?
Any help will very appreciated.
____
Edmar Edilton da Silva
Bacharel em Ciência da Computacão - UFV
Mestrando em Ciência da Computacão - UNICAMP
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem with Apache::DBI under mod_perl!!
Sorry, but I forgot, I also have installed a DBD module for the
Oracle ( the "DBD::Oracle" ). Do you have any idea to resolve this
problem?
Thanks,
Sapphire Software wrote:
Hello
Don't you need a DBD module?
Or did I miss something?
Ruben
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Edmar Edilton da Silva
Bacharel em Ciência da Computacão - UFV
Mestrando em Ciência da Computacão - UNICAMP
Re: Problem with Apache::DBI under mod_perl!!
Hi,
I added the code folow in the config file, but the Apache ::DBI
module continue don't working. If I don't load the Apache::DBI module,
the apache works correctly. Using only the DBI and DBD::Oracle modules,
I can access the Oracle database no problems. Really the problem must be
in the Apache::DBI, but I don't know where. Can anybody help me?
Thanks,
Ian Kallen wrote:
#!/usr/bin/perl
use strict;
# Extend @INC if needed
use lib qw(/dir/foo /dir/bar);
# ok, setup the Oracle and (optionally) the debug DBI environment
BEGIN {
$ENV{'ORACLE_HOME'}='/highway/to/orac/hell';
$ENV{DBI_TRACE}="3=/var/tmp/dbitrace.log";
}
# Make sure we are in a sane environment.
$ENV{MOD_PERL} or die "not running under mod_perl!";
ciao
--
Salon Internet http://www.salon.com/
Manager, Software and Systems "Livin' La Vida Unix!"
Ian Kallen [EMAIL PROTECTED] / AIM: iankallen / Fax: (415) 354-3326
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
____________
Edmar Edilton da Silva
Bacharel em Ciência da Computacão - UFV
Mestrando em Ciência da Computacão - UNICAMP
DBD module for Microsoft SQLServer!!!
Hi all,
I am trying to install the DBD module for Microsoft SQLServer (DBD-FreeTDS-0.02),
and I get many error message when the command "make" is executed. I have installed
the perl 5.005, mod_perl 1.21, DBI 1.14, and Apache::DBI 0.87. The following commands
are used to install the DBD module:
perl Makefile.PL
make
make test
make install
Can anyone tell me what is wrong in the installation process? Is There another
DBD module to access the MS SQLServer Database?
Thanks, any help!!!
Edmar Edilton da Silva
Bacharel em Ciência da Computacão - UFV
Mestrando em Ciência da Computacão - UNICAMP
Re: DBD module for Microsoft SQLServer!!!
/intrpvar.h:43: warning: type defaults to `int'
in
declaration of `PL_sawvec'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:43: warning: data definition has no
type
or storage class
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:44: parse error before `PL_unsafe'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:44: warning: type defaults to `int'
in
declaration of `PL_unsafe'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:44: warning: data definition has no
type
or storage class
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:120: parse error before `PL_tainting'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:120: warning: type defaults to `int'
in
declaration of `PL_tainting'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:120: warning: data definition has no
type or storage class
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:152: parse error before
`PL_preambled'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:152: warning: type defaults to `int'
in
declaration of `PL_preambled'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:152: warning: data definition has no
type or storage class
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:192: parse error before
`PL_in_clean_objs'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:192: warning: type defaults to `int'
in
declaration of `PL_in_clean_objs'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:192: warning: data definition has no
type or storage class
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:193: parse error before
`PL_in_clean_all'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:193: warning: type defaults to `int'
in
declaration of `PL_in_clean_all'
/usr/lib/perl5/5.00503/i386-linux/CORE/intrpvar.h:193: warning: data definition has no
type or storage class
In file included from /usr/lib/perl5/5.00503/i386-linux/CORE/perl.h:2140,
from /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/DBIXS.h:19,
from FreeTDS.h:45,
from FreeTDS.xs:35:
/usr/lib/perl5/5.00503/i386-linux/CORE/thrdvar.h:67: parse error before `PL_tainted'
/usr/lib/perl5/5.00503/i386-linux/CORE/thrdvar.h:67: warning: type defaults to `int' in
declaration of `PL_tainted'
/usr/lib/perl5/5.00503/i386-linux/CORE/thrdvar.h:67: warning: data definition has no
type
or storage class
/usr/lib/perl5/5.00503/i386-linux/CORE/thrdvar.h:88: parse error before `PL_dirty'
/usr/lib/perl5/5.00503/i386-linux/CORE/thrdvar.h:88: warning: type defaults to `int' in
declaration of `PL_dirty'
/usr/lib/perl5/5.00503/i386-linux/CORE/thrdvar.h:88: warning: data definition has no
type
or storage class
/usr/lib/perl5/5.00503/i386-linux/CORE/patchlevel.h:41: warning: `local_patches'
defined
but not used
make: *** [FreeTDS.o] Error 1
I do not know how to resolve this problem. Can anybody help me?
Dave DeMaagd wrote:
Edmar Edilton da Silva [EMAIL PROTECTED] wrote:
Hi all,
I am trying to install the DBD module for Microsoft SQLServer (DBD-FreeTDS-0.02),
and I get many error message when the command "make" is executed. I have installed
the perl 5.005, mod_perl 1.21, DBI 1.14, and Apache::DBI 0.87. The following
commands
are used to install the DBD module:
perl Makefile.PL
make
make test
make install
Can anyone tell me what is wrong in the installation process? Is There another
DBD module to access the MS SQLServer Database?
Would probably be able to help a /lot/ more if you were to include the error
message.
--
Dave DeMaagd - [EMAIL PROTECTED] - http://www.spinynorm.net
Get plenty of calcuim. Don't eat it, just hoard it. -- TDTiaB
GPG key: http://www.spinynorm.net/gpg_key.txt
--
Edmar Edilton da Silva
Bacharel em Ciência da Computacão - UFV
Mestrando em Ciência da Computacão - UNICAMP
Installing the DBD module for Microsoft SQLServer!!!
Hi all, Now, I have another problem. When I runned the "perl Makefile.PL" and "make" commands they work very well. But, when I runned "make test" is returned the following message: "Writing "Makefile.aperl" for this perl Using DBI 1.14 installed in /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI Writing Makefile.aperl for DBD::FreeTDS make -f Makefile.aperl perl make[1]: Entering directory `/root/freetds_dbd/freetds_dbd' Writing perlmain.c cd . gcc -c -I/usr/lib/perl5/5.00503/i386-linux/CORE -Dbool=char -DHAS_BOOL -I/usr/local/include -Wall -Wmissing-prototypes -ggdb -static -DTRACE_ALLOCMEMORY_LEAKS -ggdb \ -DVERSION=\"0.03a\" \ -DXS_VERSION=\"0.03a\" -I/usr/lib/perl5/5.00503/i386-linux/CORE perlmain.c cat /usr/lib/perl5/5.00503/i386-linux/auto/DynaLoader/extralibs.ld blib/arch/auto/DBD/FreeTDS/extralibs.all cat blib/arch/auto/DBD/FreeTDS/extralibs.ld blib/arch/auto/DBD/FreeTDS/extralibs.all gcc -L/usr/local/lib -rdynamic -o perl -ggdb ./perlmain.o blib/arch/auto/DBD/FreeTDS/FreeTDS.a /usr/lib/perl5/5.00503/i386-linux/auto/DynaLoader/DynaLoader.a /usr/lib/perl5/5.00503/i386-linux/CORE/libperl.a `cat blib/arch/auto/DBD/FreeTDS/extralibs.all` -lnsl -ldl -lm -lc -lposix -lcrypt To install the new "perl" binary, call make -f Makefile.aperl inst_perl MAP_TARGET=perl To remove the intermediate files say make -f Makefile.aperl map_clean make[1]: Leaving directory `/root/freetds_dbd/freetds_dbd' PERL_DL_NONLAZY=1 ./perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/01loadok t/02connect.database is jdbctest server is testms port name is 1433 port num is 1433 uid is testuser password is password DBI-connect(database=jdbctest;host=testms;port=1433;) failed: Couldn't find host testms at t/./TestCommon.pm line 17 Can't call method "disconnect" on an undefined value at t/02connect.t line 26. tdslayer.c:2952: Didn't free block at 0x823f47c dbdimp.c:387: Didn't free block at 0x8230cec dbdimp.c:378: Didn't free block at 0x8235d5c dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Test/Harness.pm line 288. make: *** [test_static] Error 255" Same with it error in the "make test" command, when I runned "make install" the System don't return any error message ( it's OK ). Now, when I try to run one perl script, it doesn't work and the following message is showed: "install_driver(FreeTDS) failed: Can't locate loadable object for module DBD::FreeTDS in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 .) at (eval 1) line 3 Perhaps a module that DBD::FreeTDS requires hasn't been fully installed at Tempo_Resposta_MS_Perl.pl line 28" I don't know what to do to resolve this problem anymore. Can anyone tell me how I can resolve it? Thanks, Edmar Edilton da Silva Bacharel em Ciência da Computacão - UFV Mestrando em Ciência da Computacão - UNICAMP
configuration file ( startup.pl )!!!
Dear all,
I am with a small problem. I used the following command to open some
connections when the WWW server is initialized:
#Initialize the database connections for each child
Apache::DBI-connect_on_init
("dbi:Oracle:ora8", "travel", "travel",
{
PrintError = 1, # Warn() on errors
RaiseError = 0, # Don't die on error
AutoCommit = 1, # Commit executes immediately
}
);
The problem is which I do not know how to configure the WWW server
to open many connections for example "20 connections"!!!
Can anyone help me ? If possible, I would like someone send me your
configuration file (startup.pl).
Thanks,
____________
Edmar Edilton da Silva
Bacharel em Ciência da Computacão - UFV
Mestrando em Ciência da Computacão - UNICAMP
Installation problems!!!
I installed mod_perl 1.24 successfully ( the web server used is apache 1.3.9 and perl 5.004-4 ). No errors during configure, make , make test or make install. I added the loadmodule and addmodule lines to httpd.conf. But when I started the apache I get the following error message: "Starting httpd: httpd Syntax error on line 132 of /etc/httpd/conf/httpd.conf: Cannot load /etc/httpd/modules/libperl.so into server: /etc/httpd/modules/libperl.so: undefined symbol: ap_ctx_get" Can anyone help me? Thanks... -- Edmar Edilton da Silva Bacharel em Ciência da Computação - UFV Mestrando em Ciência da Computação - UNICAMP
