10-14-2008
What is the your current max clients settings in both Apache and MySQL?
What are your keep alive and connection timeout settings in MySQL?
Many folks set these incorrectly and it causes problems.
Also, did you run FireBug (FireFox plugin) and look at the performance numbers?
Did you run mysqltuner.pl and tuning-primer.sh ? If so, please post the results.....
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi there, I've got a debian 3.1r4 half working (no x yet :P)
I need some pointers for installing a Apache - MySQL - PHP configuration on my box, and set them up to work together. I know to use vim a bit :)
I would like something that is similar to tanguay.at, or even simpler, since I'm a real... (1 Reply)
Discussion started by: izua
1 Replies
2. UNIX for Advanced & Expert Users
How does everyone else handle this?
My Setup:
Server A:
CentOS 5.x
10.0.0.1
Apache
MySQL Master
Server B:
CentOS 5.x
10.0.0.2
Apache
MySQL Slave
My Domains:
dom1.com A record: 10.0.0.1
A Record: 10.0.0.2
dom2.com A record: 10.0.0.1
A Record: 10.0.0.2 (3 Replies)
Discussion started by: Ikon
3 Replies
3. Web Development
Hello All,
I have a LAMP server (CentOS 5.5) which has a lot of php scripts and the php pages runs fine. My question is if I have to allow the OS udpates regularly on the server, will there be any problems in running the existing php scripts? Please advise if my apache/mysql/php functionality... (3 Replies)
Discussion started by: ilan
3 Replies
4. Solaris
Hello Everybody,
Does anybody know or recommend me a tutorial for LAMP server on Solaris 10 x86? (3 Replies)
Discussion started by: ahmedamer12
3 Replies
5. Web Development
Hello everyone,
I would like to setup a lamp server from a minimal distro and to compile PHP, MySQL and Apache myself.
I have chosen CentOS minimal for the OS and I am trying to build the stack by hand... But well, it appears I need some help!
First: I am looking for good and recent... (3 Replies)
Discussion started by: freddie50
3 Replies
6. Programming
Hello All,
I need a good lamp(linux, apache, mysql, php) tutorial for web development. I searched in net but not finding suitable one. suggest me something. (3 Replies)
Discussion started by: amisubha
3 Replies
7. HP-UX
Dear Folks,
How to Install LAMP on HP-UX system. Please Guide.
Regards,
KRISHNA (2 Replies)
Discussion started by: krishna.lu
2 Replies
8. Red Hat
I wish to setup LAMP environment. Amongst, I have successfully installed Linux 6.1. I am looking fwd to install - Apace Web Server, My Sql Database & PHP environment.
Say if I look for MySql, could see downloadable available in rpm format. But this must be copied over to Linux machine.
As... (2 Replies)
Discussion started by: videsh77
2 Replies
9. UNIX for Advanced & Expert Users
How do I install a LAMP server on a new installation of Debian 9 using the lalest versions of
AMP?
Here is what I have.
Corrections please.
MYSQL
apt-get install mysql-server mysql-client
You can verify the MySQL server status using command:
systemctl status mysql
-------
PHP7... (0 Replies)
Discussion started by: Meow613
0 Replies
LEARN ABOUT DEBIAN
apache::session::lock::mysql
Apache::Session::Lock::MySQL(3pm) User Contributed Perl Documentation Apache::Session::Lock::MySQL(3pm)
NAME
Apache::Session::Lock::MySQL - Provides mutual exclusion using MySQL
SYNOPSIS
use Apache::Session::Lock::MySQL;
my $locker = Apache::Session::Lock::MySQL->new();
$locker->acquire_read_lock($ref);
$locker->acquire_write_lock($ref);
$locker->release_read_lock($ref);
$locker->release_write_lock($ref);
$locker->release_all_locks($ref);
DESCRIPTION
Apache::Session::Lock::MySQL fulfills the locking interface of Apache::Session. Mutual exclusion is achieved through the use of MySQL's
GET_LOCK and RELEASE_LOCK functions. MySQL does not support the notion of read and write locks, so this module only supports exclusive
locks. When you request a shared read lock, it is instead promoted to an exclusive write lock.
CONFIGURATION
The module must know how to connect to your MySQL database to acquire locks. You must provide a datasource name, a user name, and a
password. These options are passed in the usual Apache::Session style, and are very similar to the options for
Apache::Session::Store::MySQL. Example:
tie %hash, 'Apache::Session::MySQL', $id, {
LockDataSource => 'dbi:mysql:database',
LockUserName => 'database_user',
LockPassword => 'K00l'
};
Instead, you may pass in an already opened DBI handle to your database.
tie %hash, 'Apache::Session::MySQL', $id, {
LockHandle => $dbh
};
AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>.
SEE ALSO
Apache::Session
perl v5.10.1 2010-10-18 Apache::Session::Lock::MySQL(3pm)