Re: [users@httpd] Apache Performance Tuning document and minsparethreads maxsparethreads, etc.
On 04/10/2015 02:44 PM, Rose, John B wrote: We have gone through the Performance Tuning document and it seems the "Process Creation" section only addresses prefork MPM. http://httpd.apache.org/docs/2.4/misc/perf-tuning.html Is there a somewhat exhaustive Performance Tuning document addressing Process Creation settings for the Event MPM in 2.4? Also, for example, looking at the Apache MinSpareThreads documentation, I am not seeing anything specific to "Event" MPM. Any good resources for this information would be appreciated. Yes, indeed, the performance tuning document is woefully out of date, and could use a lot of love, particularly from people with real-world recommendations. I'd love to see it completely rewritten, but, to date, I have never run a website where this kind of performance tuning was even necessary, so I lack the experience to do much more than describe the performance-related configuration directives. --Rich -- Rich Bowen - rbo...@rcbowen.com - @rbowen http://apachecon.com/ - @apachecon - To unsubscribe, e-mail: users-unsubscr...@httpd.apache.org For additional commands, e-mail: users-h...@httpd.apache.org
[users@httpd] Happy 20th Birthday, httpd
For those that missed ApacheCon last week in Austin, I wanted to share a few things. This year marks the 20th birthday of the Apache httpd project (or late last year, depending on how you count) and so we had a little celebration. The feather that was made for the Apache conference in 1998 - https://www.flickr.com/photos/iamamoose/63963722/ - was at ApacheCon, and we tried to stage the same photo again, as much as was possible: https://plus.google.com/u/0/+RichBowen/posts/Gfs1Ek6MWqu We also took pictures with all of the httpd committers who were present (although I expect we missed a few people.) : https://www.flickr.com/photos/rbowen/sets/72157651553317030/ And, we had a birthday cake https://www.flickr.com/photos/linuxfoundation/17157208981/ https://www.flickr.com/photos/linuxfoundation/16537678153/ There's lots more ApacheCon photos here: https://www.flickr.com/photos/linuxfoundation/sets/72157651931911042 We're very proud of what we've accomplished over the last 20 years, and I'm pretty excited about the next 20. Thank you, every one of you, for being part of this journey, whether you've been here one day or the whole 20 years. -- Rich Bowen - rbo...@rcbowen.com - @rbowen http://apachecon.com/ - @apachecon - To unsubscribe, e-mail: users-unsubscr...@httpd.apache.org For additional commands, e-mail: users-h...@httpd.apache.org
Re: [users@httpd] Apache 2.4, Perl 5.010, MySQL 5.6 and Windows 8.1 pro - no database connection
On 04/20/2015 04:31 AM, Dan Östberg wrote:
Any changes of httpd.conf that I shall do? Or in any other
configuration file? Or...?
DBIcreatetabledoesn't run but printenv does:
Have you tried running DBIcreatetable from the command-line to see if
you get any Perl compile failure or other fatal errors?
DBIcreatetable:
"
#!C:\Dwimperl\perl\bin\perl.exe
use 5.010;
use strict;
use warnings;
use DBI;
print "Content-type: text/plain; charset=iso-8859-1\n\n";
say "Perl MySQL Create Table Demo";
# MySQL database configurations
my $dsn = "DBI:mysql:clients";
my $username = "root";
my $password = "pw";
# connect to MySQL database
my %attr = (PrintError=>0, RaiseError=>1);
my $dbh = DBI->connect($dsn,$username,$password, \%attr);
# create table statements
my @ddl = (
# create tags table
"CREATE TABLE tags (
tag_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
tag varchar(255) NOT NULL
) ENGINE=InnoDB;",
# create links table
"CREATE TABLE links (
link_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
title varchar(255) NOT NULL,
url varchar(255) NOT NULL,
target varchar(45) NOT NULL
) ENGINE=InnoDB;",
# create link_tags table
"CREATE TABLE link_tags (
link_id int(11) NOT NULL,
tag_id int(11) NOT NULL,
PRIMARY KEY (link_id,tag_id),
KEY fk_link_idx (link_id),
KEY fk_tag_idx (tag_id),
CONSTRAINT fk_tag FOREIGN KEY (tag_id)
REFERENCES tags (tag_id),
CONSTRAINT fk_link FOREIGN KEY (link_id)
REFERENCES links (link_id)
) ENGINE=InnoDB"
);
# execute all create table statements
for my $sql(@ddl){
$dbh->do($sql);
}
say "All tables created successfully!";
# disconnect from the MySQL database
$dbh->disconnect();
"
printenv:
"
#!C:\Dwimperl\perl\bin\perl.exe
#
# To permit this cgi, replace # on the first line above with the
# appropriate #!/path/to/perl shebang, and on Unix / Linux also
# set this script executable with chmod 755.
#
# * !!! WARNING !!! *
# This script echoes the server environment variables and therefore
# leaks information - so NEVER use it in a live server environment!
# It is provided only for testing purpose.
# Also note that it is subject to cross site scripting attacks on
# MS IE and any other browser which fails to honor RFC2616.
##
## printenv -- demo CGI program which just prints its environment
##
use strict;
use warnings;
print "Content-type: text/plain; charset=iso-8859-1\n\n";
foreach my $var (sort(keys(%ENV))) {
my $val = $ENV{$var};
$val =~ s|\n|\\n|g;
$val =~ s|"|\\"|g;
print "${var}=\"${val}\"\n";
}
"
//
[users@httpd] Apache 2.4, Perl 5.010, MySQL 5.6 and Windows 8.1 pro - no database connection
Any changes of httpd.conf that I shall do? Or in any other configuration
file? Or...?
DBIcreatetable doesn't run but printenv does:
DBIcreatetable:
"
#!C:\Dwimperl\perl\bin\perl.exe
use 5.010;
use strict;
use warnings;
use DBI;
print "Content-type: text/plain; charset=iso-8859-1\n\n";
say "Perl MySQL Create Table Demo";
# MySQL database configurations
my $dsn = "DBI:mysql:clients";
my $username = "root";
my $password = "pw";
# connect to MySQL database
my %attr = (PrintError=>0, RaiseError=>1);
my $dbh = DBI->connect($dsn,$username,$password, \%attr);
# create table statements
my @ddl = (
# create tags table
"CREATE TABLE tags (
tag_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
tag varchar(255) NOT NULL
) ENGINE=InnoDB;",
# create links table
"CREATE TABLE links (
link_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
title varchar(255) NOT NULL,
url varchar(255) NOT NULL,
target varchar(45) NOT NULL
) ENGINE=InnoDB;",
# create link_tags table
"CREATE TABLE link_tags (
link_id int(11) NOT NULL,
tag_id int(11) NOT NULL,
PRIMARY KEY (link_id,tag_id),
KEY fk_link_idx (link_id),
KEY fk_tag_idx (tag_id),
CONSTRAINT fk_tag FOREIGN KEY (tag_id)
REFERENCES tags (tag_id),
CONSTRAINT fk_link FOREIGN KEY (link_id)
REFERENCES links (link_id)
) ENGINE=InnoDB"
);
# execute all create table statements
for my $sql(@ddl){
$dbh->do($sql);
}
say "All tables created successfully!";
# disconnect from the MySQL database
$dbh->disconnect();
"
printenv:
"
#!C:\Dwimperl\perl\bin\perl.exe
#
# To permit this cgi, replace # on the first line above with the
# appropriate #!/path/to/perl shebang, and on Unix / Linux also
# set this script executable with chmod 755.
#
# * !!! WARNING !!! *
# This script echoes the server environment variables and therefore
# leaks information - so NEVER use it in a live server environment!
# It is provided only for testing purpose.
# Also note that it is subject to cross site scripting attacks on
# MS IE and any other browser which fails to honor RFC2616.
##
## printenv -- demo CGI program which just prints its environment
##
use strict;
use warnings;
print "Content-type: text/plain; charset=iso-8859-1\n\n";
foreach my $var (sort(keys(%ENV))) {
my $val = $ENV{$var};
$val =~ s|\n|\\n|g;
$val =~ s|"|\\"|g;
print "${var}=\"${val}\"\n";
}
"
