In Progress

MYSQL / LIGHTTPD PERFORMANCE TUNING EXPERT

*********** ONLY FOR A MYSQL LINUX SERVER PERFORMANCE TUNING EXPERT **************

Please do not apply unless you are a performance tuning expert.

I need someone who can definitively tune a production MYSQL Database to maximise the possible maximum throughput.

I have a LLMP Test Server (Linux, LightTPD, MariaDB PHP5) - 24GB RAM, 8 Core processors running on Ubuntu Server [url removed, login to view]

The server runs entirely on an SSD DRIVE for speed. The tables are INNODB, and there are only four of them in total. It doesn't get much simpler.

I have 30 CLIENTS PC's that attack the server and insert a row into one table. The table has a single PK and no indices of any sort.

Each Client PC runs 20 instances of CHROME and 20 instances of FIREFOX.

Each instance requests a page from the server, and when it receives the page, requests it again.

Therefore I have approximately (20 * 20 * 30) = 12,000 page requests hitting the server every 5 seconds or so.

The Server responds by serving a MAXIMUM of 7500 pages per minute. It's good, but the processor only ever reaches 20% CPU.

There is a bottleneck somewhere, so I need someone to tell me how I can max out the CPU by adjusting the settings in [url removed, login to view], [url removed, login to view] and [url removed, login to view]

because the number of threads it uses does not get above 6 (which makes no sense to me).

BASIC INFORMATION

=================

There are no errors in the LIGHTTPD error log

There are no errors in the MYSQL (MariaDB) error log

APC caching is installed

There a NO slow queries, locks tables or contentions at all.

One table takes the main hit of everything - it is very small in size, but has around 1 million rows in it.

I am not looking for someone to analyse the underlying SQL code (at least not yet) - just the Server setup for threads/ram etc etc

I have enclosed a sample of tyhe configuration files and graph output. You will be expected to perform analysis on this information.

The Table Schemas can also be provided if required.

What I need is someone who can make suggestions for alterations to the configuration files, available RAM, number of processors (I can change anything).

I will perform a re-run (takes around half an hour) when these suggestions have been implemented, and feed you back all of the output from the run.

You will not have direct access to the Server. The data you must analyse will look like the attached.

CHARGES

=======

I would expect you to charge by the hour, for the time that I need. There are no deadlines or schedules - simply when you can is OK, but the information you provide MUST be on a Expert basis.

I have spent weeks on Google studying this subject. I DO NOT want you to 'guess' about changing things and then I do a test run to see if you are right.

All your suggestions MUST be based on the data in front of you - not because you read something on a blog somewhere.

Skills: MariaDB, MySQL

See more: sample graph data, php tuning, max graph, how do you graph data, how do i get google chrome back, how can i get google chrome, graph sample data, do you want to get google chrome, direct performance, access database expert, 6 tuning, google test speed, database caching, how to get google chrome, how do you get google chrome, tuning, sql data analysis, Performance tuning, performance test, performance based, how i can apply, database tuning, database performance , apc

About the Employer:
( 37 reviews ) Niort, France

Project ID: #5064642

Awarded to:

datadiggers

Hello, I'm Matt and I specialize in performance optimization projects. You can easily confirm that by looking at my past projects, most of them are related to MySQL/PHP/Linux optimization. Now, about issues Your're se More

$51 USD / hour
(9 Reviews)
5.4

3 freelancers are bidding on average $54/hour for this job

rmmarconi

I'm a experienced System and Network administrator with more than 10 years of experience with Debian, Slackware, FreeBSD, OpenBSD, Solaris and others Linux and Unix flavors. Now I'm a System Administrator for the Brazi More

$55 USD / hour
(5 Reviews)
4.2
brylu

Hello, I'll be happy to check thins out for you, I've been running linux servers for 15 years now and have extensive experience troubleshooting performance bottlenecks. I believe I can help. I am curious about th More

$55 USD / hour
(4 Reviews)
3.7