In Progress

Mysql query and database optimisation

After migrating to a new server, our website is crashing with high IO congestion. We think this is because of long query times and potentially an incorrectly configured mysql database.

We are looking for a DBA to

1. Optimise the database, indexes and advise on how to improve slow queries

2. Setup monitoring of the system for us to monitor and advise us on how to prevent the server from falling over in the future

Skills: Database Administration, MySQL

See more: mysql query, mysql dba, 2013 query, slow queries, database optimisation, mysql query slow, server crashing, mysql queries optimisation, mysql slow queries, monitoring setup, mysql slow, mysql optimise, mysql administration, optimise large mysql database, mysql database query jquery autocomplete textbox, system administration monitoring, query database, joomla mysql database query, query dba, database queries mysql, mysql crashing, dropdown ajax database query mysql country city state, mysql slow query, mysql remote database query, server mysql slow

About the Employer:
( 21 reviews ) London, United Kingdom

Project ID: #4790257

Awarded to:

datadiggers

Hello. I'm MySQL database administrator specializing in performance optimization. Please check PMB where I propose few things that potentially can be done to improve speed of Your MySQL server.

$150 USD in 10 days
(7 Reviews)
5.3

25 freelancers are bidding on average $153 for this job

meet2amitvw

Hello Thanks for the sharing requirement. I went through your description and ready to work with you. You will work directly with one person and that's me. No mediators. No managers. No subcontractors. I will More

$228 USD in 5 days
(38 Reviews)
6.2
noxtras

Hello, First of all you will need mysql slow queries setup, if you don't have it already, then according it's findings, optimize the queries, tables. Also, optimize mysql config for your particular setup. Please note More

$136 USD in 2 days
(21 Reviews)
5.7
breathhacker

Hey, Please check PMB.

$210 USD in 7 days
(4 Reviews)
5.5
pyostrike

Hello. I can help you. Anton.

$133 USD in 3 days
(32 Reviews)
4.9
pivn

Let expert do this

$155 USD in 3 days
(40 Reviews)
4.9
Webhawkstech

Dear Sir We are interested to do this project. Please check PMB.

$210 USD in 3 days
(3 Reviews)
4.7
nibiranijum

Hi, I am expert in database tuning. 6 years experienced in this. Please check my profile.

$155 USD in 3 days
(8 Reviews)
4.7
elboukharimu

I can help you please check your Inbox.

$126 USD in 2 days
(16 Reviews)
4.5
sat12

i will check the code and optimize the database also. needs to do indexing.

$147 USD in 3 days
(32 Reviews)
4.5
tcrnicki

If it worked on the old hosting and there are problems now on the new server then the first step is to check the new server setup. Please check PM.

$200 USD in 2 days
(10 Reviews)
4.3
tlchung

hosting and mysql expert here. can tune the DB and sql for you.

$90 USD in 3 days
(21 Reviews)
4.2
vickkey7

I am ready to start this project..

$88 USD in 2 days
(8 Reviews)
4.0
Reza2012

Hi I am interested to do the project

$155 USD in 3 days
(5 Reviews)
3.8
mdakteruzzaman

Expert in database administration. pls check pmb

$166 USD in 4 days
(2 Reviews)
1.3
brandnewunpunk

I can help you with this. 2+ years with optimizing mysql. Message me and we can discuss details.

$111 USD in 1 day
(2 Reviews)
1.0
ajaym259

12 years exp as DBA, please share the details and check the PM

$222 USD in 7 days
(0 Reviews)
0.0
sstsvw

I know exactly what needs to be done to trap the slow queries. After We have those I will provide a recommendation for a fix

$155 USD in 3 days
(0 Reviews)
0.0
thegadflyproject

We would like to provide this service for you and develop a long-term relationship for future needs.

$111 USD in 3 days
(0 Reviews)
0.0
divya12983

I have done Masters in Computer applications. I was a topper there. I have done similar work in HCL Technologies for 1year for very complex databases. I was an outstanding performer in my company.

$155 USD in 10 days
(0 Reviews)
0.0
prh47

Please see PM. Thanks.

$175 USD in 5 days
(0 Reviews)
0.0