MySQL tune up and consulting job

Closed

Description

[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

16GB RAM

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

Project ID: #5267967

25 freelancers are bidding on average $143 for this job

Mindon

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? thanks.Steven

$133 USD in 3 days
(75 Reviews)
6.4
FandaR

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)
6.2
datadiggers

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)
5.9
lepoitr

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)
5.5
danale72

Hi I can optimize both server and queries. It would be great to have a look at the following file: /var/log/mysqld-slow.log All the best Alexei

$150 USD in 3 days
(40 Reviews)
5.0
codetrance

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)
5.0
softcom

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)
4.8
pratham2003

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/mysqld-slow.log I'll More

$30 USD in 3 days
(27 Reviews)
4.6
Mohsen6558

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)
4.4
elboukharimu

Aucune proposition n'a encore été fournie.

$246 USD in 5 days
(16 Reviews)
4.3
AlGordo

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)
4.3
kokl

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)
4.0
amiteshojha

A proposal has not yet been provided

$50 USD in 1 day
(11 Reviews)
3.4
olmisbd

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)
3.6
gressp

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)
2.7
lecyberian

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)
1.2
modestasmockus

I am experienced php and database developer. if you take a look at MySQL tuner output.txt you will see: [!!] Table locks acquired immediately: 85% and -------- Recommendations ------------------------------------- More

$55 USD in 7 days
(1 Review)
1.1
bindmission

Hello sir, I have an experience of 3 year in Linux filed.I will work for you You can see my other profiles too https://www.elance.com/s/edit/bindmission/ PROFILE : Am a Redhat certified Engineer ( Cert More

$100 USD in 3 days
(1 Review)
1.0
remotemysqldba

I have checked your processlist Output and my.cnf file. 1) Processlist. The queries are not taking more than 3 sec, but fired repeatedly. The queries might take a very huge data out of hardisk. With SSD the Dis More

$138 USD in 2 days
(0 Reviews)
0.0
pygmalion328

Hello I'm a field engineer for MySQL in Korea. Many MySQL server tuning and query tuning experience and experience with HA. One will leave me 100% sure if you can handle to you.

$133 USD in 1 day
(0 Reviews)
0.0