Fixing MYSQL errors & optimizing queries

Note: My websites are gay adult themed

I'm usually very clear about what I need from a programmer, but in this case I'm not quite sure. For the 24 hours my server has been overloaded with MYSQL queries among other issues.

There are two things that I need to be fixed asap:

1) Fix MYSQL errors on several pages on my site

2) Find the root of the problem of the MYSQL overload and fix

To assess the situation, I will need to forward email correspondence with my hosting support to you. There are some cron jobs sending mail that are also part of the problem, and I also need this assessed and fixed.

I'm on a dedicated Linux server, with the latest version of cpanel.

## Deliverables

I need someone very experienced working in LINUX, APACHE, MYSQL, PHP environments for larger scaled interactive (dating) websites. Please respond only if you have history on RAC and projects that reflect the above mentioned experience.

Your bid on this project is for the initial assessment and fixes needed. Once I have chosen you as the coder and you have fixed the initial problems, you can let me know what needs to be done and we can agree on a bonus or I can post another project for you to fix it. I have very good history on RAC and have had only happy coders. I'm more then fair when it comes to working with coders and giving bonuses for going above and beyond what I ask for.

The CPU usage has gone to 100% a couple of times in the past 24 hours and has completely halted page loads and access to the server.

My sites are membership sites, and the fixes are time sensitive because it's affecting my members ability to use the sites. However, this is NOT a quick fix and go project. The health of my server and sites are being compromised by whatever is crippling it and I need a programmer who will dig in find the problems, propose solutions, and ensure everything is running normally.

I need a programmer who will

1) assess the problems and propose a solution and time frame to implement solutions

2) ensure the my two sites: [login to view URL] and [login to view URL] are working properly asap

3) watch the websites performance over the next few days, identity additional problem queries, cron jobs, etc and propose a solution and fix accordingly

Aptitudini: Inginerie, MySQL, PHP, Administrare proiect, Arhitectură software, Testare software, Web Hosting, Administrare site-uri web, Testare site-uri web

Vezi mai multe: what support will i need from management, what are some good jobs, time management jobs, problems that need fixing, problem fixing, need gone asap, jobs in health, interactive health, health management jobs, health fair, good jobs with no experience needed, fixing websites, fixing problems, fixing problem, fixing com, find version of linux, find project management jobs, find part time jobs, find coders for projects, find a linux programmer

Despre angajator:
( 62 recenzii ) United States

ID Proiect: #3971495

Acordat lui:


See private message.

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 14 zile
(165 Recenzii)

5 freelanceri licitează în medie 118$ pentru acest proiect


See private message.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 14 zile
(121 recenzii)

See private message.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 14 zile
(19 recenzii)

See private message.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 14 zile
(6 recenzii)

See private message.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 14 zile
(2 recenzii)