ncomper
asked on
Performance tuning LAMP server
I have learned to do the following to get MYSQL to use more ram, but can you force certain processes to take up more processing space (i.e Apche to use more CPU / RAM, or MYSQL to use you memory).
Is it all within the application confg files each time or is there a tool for ubuntu that can tune the server ?
Is it all within the application confg files each time or is there a tool for ubuntu that can tune the server ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Each component can be fine tuned, you would first need to determine what performance issues and what is contributing to them.
Phpmyadmin is a tool to analyze mysql performance.
Apache, can be adjusted by controlling for the number of child process that are started, usually it is 5.
Improving mysql usually the processing consumer since more often than not, the PHP/mysql interactions are where usually performance impacts are.
Phpmyadmin is a tool to analyze mysql performance.
Apache, can be adjusted by controlling for the number of child process that are started, usually it is 5.
Improving mysql usually the processing consumer since more often than not, the PHP/mysql interactions are where usually performance impacts are.
What problems are you experiencing?
Mysql: mysqltuner.pl tuning-primer.sh
Apache/php: switch to httpd-worker and php-chi via mod_fcgid
Not painless but reduces memory use 10x
Mysql: mysqltuner.pl tuning-primer.sh
Apache/php: switch to httpd-worker and php-chi via mod_fcgid
Not painless but reduces memory use 10x
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Additional Information provided was very useful thanks
http://hosting.com/support/linux/tuning-the-apache-prefork-mpm/