In Progress

mysql server admin expert to tweak, optimize, fix DB

I have a very busy database that is locking up and crashing because of the high load. The script that runs is very intensive but I need it to continue. I want to have as much tweaking and optimization done as possible to help avoid problems.

I know I want this done:

1. enable slow query logs if it does not exist and monitor the slow log, you

can propose indexes that need to be put in place to speed things up.

2. view runtime status in phpmyadmin and evaluate what configuration changes must be done to optimize the database.

3. based on #2 you should create/optimize the [url removed, login to view] file

4. Must monitor the DB for a few days to adjust settings as necessary

Skills: Linux, MySQL, System Admin

See more: optimization expert, mysql tweaking, what is admin, speed fix, server load, Server admin, Query optimization, optimize mysql, need help to fix my script, fix slow, fix mysql query, db, db query, admin expert, server load log, optimize server speed, runtime, server log, linux mysql create, fix query, phpmyadmin view, optimize view, mysql create server, mysql script help, system admin expert

About the Employer:
( 86 reviews ) Moreland, United States

Project ID: #1154526

Awarded to:

virusvi2

Please check PMB

$250 USD in 0 days
(53 Reviews)
5.4

5 freelancers are bidding on average $250 for this job

FandaR

Hello, I have over 8 years experience as a Linux admin. I can optimize your database and mysql settings. Thank You

$250 USD in 10 days
(424 Reviews)
7.3
CoVaLiDiTy

can help you. tnx.

$250 USD in 5 days
(172 Reviews)
6.5
lucarossi

I can help you. Regards

$250 USD in 3 days
(32 Reviews)
5.2
AccuPro

Can try this.

$250 USD in 1 day
(5 Reviews)
3.5
ajminsheikh

I am ready for this job ...

$250 USD in 1 day
(2 Reviews)
2.8