Apache and MySql Performance Tuning

I am moving a website and supporting MySql database to a new server provider. The move is complete, and although the new server hardware is superior to the old, my performance tests against the new Apache2 web server shows that it is performing less than half as well as the old installation. Since the hardware on the new server is better, it must be the configurations of the web and/or the database software.

I need to performance tune the Apache web server and (possibly) the MySql database configurations to make it perform at least as well as the old environment.

There will be a very simple test to determine this. I have a php web page that does a single database connection and a single update to that database server. Using http_load against this url, I run:

./http_load -parallel 1 -seconds 30 [url removed, login to view]

This gives the following results on the old server:

16348 fetches, 1 max parallel, 65392 bytes, in 30 seconds

4 mean bytes/connection

544.933 fetches/sec, 2179.73 bytes/sec

msecs/connect: 0.0453878 mean, 0.089 max, 0.036 min

msecs/first-response: 1.78962 mean, 14.089 max, 1.52 min

HTTP response codes:

code 200 -- 16348

If I can run this command on the new server after you do your performance tuning and get at least as good of results as this then I will be satisfied that the project is completed and the performance is good.

You will have full root access to the web and database server to test and do as you please.

The acceptance criteria are:

- http_load results using the above mentioned criteria on the new server is at least as good as the results of the old server

- you must provide a document clearly stating exactly what you did during your performance tuning, and exactly what you changed, including all new/modified parameters in the config files.

For clarification, the operating system is SUSE linux, MySql is version 5.5.8, php is 5.2.16 and Apache is 2.2.17

Evner: Apache, MySQL

Se mere: what does min mean, php tuning, php and mysql no codes, php and mysql connection, apache web server document root, http response code 200 16348, mysql mean, web server apache, apache web server software, web performance, update mysql, TUNING, superior, performance tuning, Performance test, mysql test, my completed tests, database tuning, database performance , apache web server, using codes access, moving apache, apache php config, mysql php single page, php connect mysql

Om arbejdsgiveren:
( 1 bedømmelse ) Denver, United States

Projekt ID: #1004827

Tildelt til:


Please see PM

$229 USD in 15 dage
(28 bedømmelser)

10 freelancere byder i gennemsnit $186 på dette job

$250 USD in 3 dage
(24 bedømmelser)

I can do it, please read my PM.

$35 USD in 0 dage
(3 bedømmelser)

I can tune your web server

$150 USD in 15 dage
(0 bedømmelser)

I have prior experience about Linux, PHP, Apache2 & MySQL performance tunes. More details, check your PM please. Thanks

$200 USD in 7 dage
(0 bedømmelser)

Please see the PM

$100 USD in 3 dage
(0 bedømmelser)

I can optimize apache and mysql for you, please check pm

$100 USD på 1 dag
(0 bedømmelser)

I am done many apache my sql related project,i am basically a release and webadmin engineer

$250 USD in 3 dage
(0 bedømmelser)

Please see your PM

$200 USD in 3 dage
(0 bedømmelser)

Please check PM

$350 USD in 10 dage
(0 bedømmelser)