MySQL tune up and consulting job

[url removed, login to view] All,

We are running a mysql heavy front end of a website on a dedicated server with following specs

2x120G SSD disks on RAID-1


Dual E5620 @[url removed, login to view]

We seems to get lot of CPU usage by MySQL process during peak hours and this seems to result in a really slow site loading time during the peak. I have attached an #atop screenshot when this issue is happening.

I am looking to hire someone to fix this issue.

1. Either by optimizing mysql/server configuration

2. Or by providing detailed instructions to script vendor on how to optimize their mysql queries.a

Skills: MySQL, Nginx, Perl

See more: hire consulting, consulting job, tune up, optimize mysql, tune optimize, mysql optimizing , site consulting, fix 301, fix cpu, tune server, slow queries, mysql tune, optimize website front end, process cpu usage, mysql slow queries, mysql slow, ram usage, dedicated server ram, slow queries fix, loading optimize, fix loading time site, mysql dedicated server, dedicated mysql, mysql optimize, php mysql part time job

About the Employer:
( 47 reviews ) NYC, Canada

Project ID: #5267967

25 freelancers are bidding on average $143 for this job


Hello Sir, I am good at MySQL etc. optimized many servers . to this issue you met, sometimes also related to backend query. (got bad sql query). so, could you please let me check and work on it? [url removed, login to view]

$133 USD in 3 days
(75 Reviews)

Hello, I have over 9 years experience as an Linux admin and can help you. Please feel free to ask if you have any questions. Thank You

$242 USD in 7 days
(167 Reviews)

Hello, I'm Matt and I'm MySQL database administrator specializing in performance issues. Before I begin my work I make complete database backup (unless You wish otherwise). I also backup all configuration files More

$515 USD in 14 days
(23 Reviews)

I'm interested in that project. I'm experienced (15+) system administrator and web developer. I've some idea based on data you have provided, has similar case some time before and the solution i think about helped More

$111 USD in 3 days
(17 Reviews)

Hi I can optimize both server and queries. It would be great to have a look at the following file: /var/log/[url removed, login to view] All the best Alexei

$150 USD in 3 days
(40 Reviews)

I can help you optimizing the server for your site. Do you have root access to your server?. I'm looking forwards to your response. Thank you.

$110 USD in 2 days
(29 Reviews)

Hello. I have vast experience in mysql tuning for highly loaded adult sites. as I can see from attached files you are running VERY outdated mysql server (5.1.67), and your server completely misconfigured - InnoDB usage More

$111 USD in 0 days
(23 Reviews)

Hi, For starters, can you send me the schema/structure for the database so I can get a better idea of the situation. Also, please provide this log file before you accept my bid. /var/log/[url removed, login to view] I'll More

$30 USD in 3 days
(27 Reviews)

Hello I'm MySQL Expert an I can optimize your queries for fix this problem. ready to start.

$222 USD in 1 day
(8 Reviews)

Aucune proposition n'a encore été fournie.

$246 USD in 5 days
(16 Reviews)

I made a very low bid, but would like to have access to root ssh, phpmyadmin, ftp, etc. before being awarded the job. I will take a look for free, but if there is no quick solution, I will adjust my bid accordingly. Pl More

$30 USD in 3 days
(10 Reviews)

Hi ! I am senior systems administrator with more than 10 years of experience, i can optimize your server in 1-2 days, please consider me for this project. I am able to start ASAP. Best Regards, Konstantin

$150 USD in 3 days
(3 Reviews)

A proposal has not yet been provided

$50 USD in 1 day
(11 Reviews)

Hi, I am working in the largest telecom company in my country as server administrator of web, database and application. We have billions of data required to processed daily and i always need to tune up , optimize DB, More

$155 USD in 3 days
(4 Reviews)

I'm willing to help for free, I'm really tired of money and all i want to do is work and help the IT Infrastructure in the world better. My first guess would be that your application was written poorly. I willing to he More

$30 USD in 0 days
(5 Reviews)

Hi there, I will analyse your MySQL server, We can use other opensource alternatives which are very effective and MySQL tweaked versions for high performance under load. Secondly, We can catch the bad / slow quer More

$150 USD in 3 days
(1 Review)

I am experienced php and database developer. if you take a look at MySQL tuner [url removed, login to view] you will see: [!!] Table locks acquired immediately: 85% and -------- Recommendations ------------------------------------- More

$55 USD in 7 days
(1 Review)

Hello sir, I have an experience of 3 year in Linux filed.I will work for you You can see my other profiles too [url removed, login to view] PROFILE : Am a Redhat certified Engineer ( Cert More

$100 USD in 3 days
(1 Review)

Hello Sir, for more details add me on s.k.y.p.e - PatelDesigner Thank You, PatelDesigner Team. Email Marketing | Website Design | Graphic Design | SEO Service | Server Management |

$83 USD in 1 day
(0 Reviews)

Hi, Are you guys caching results somehow ( Memcached, Redis ) . It's now always possible to just change some settings and magicaly it starts to work faster . The best solution would be 1) see what queries can we More

$155 USD in 5 days
(0 Reviews)