I'M seeking a mysql database expert.
My Joomla mysql database has about 3.4 million rows in content table. Very slow and often use out of resources. To speed up it, I segmented it into 6 sub-tables and added many indexes.
However, the problem still there and some times more serious. Current situation:
Memory used out, could not connect to database, table locked
500 and 404 errors reported by Google webmaster tool 16000 times per day,
Some pages load quickly but some pages load slow or not show(query long time, 10 minutes, or 30 minutes more)
My VPS is host gator level 7. Please check for specification.
Before I assign the job, please
1. Give an evaluation
2. Let me know what measure you will take
3. What result you will get. What you promise to me?
[url removed, login to view] long and how much.
I need an absolute solution, not temporarily or slightly improve. I need a promise, not just simply say " I can complete your job", blah blah. I do not like such garbage.
I need a real expert, with according expertise, 4.9 + scores and 20+ jobs at freelancer.com.
12 freelancers are bidding on average $529 for this job
Hi, I am experienced systems and database administrator. I have dealt with mysql performance problems in the past. I can analyze your current setup, propose changes and implement these.