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.
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