large mysql database trouble shooting- repost


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.

Evner: Database Administration, Joomla, MySQL, Oracle, PHP

Se mere: webmaster freelancer com, webmaster for joomla, the problem with freelancer com, php and mysql jobs, mysql php expert freelancer, mysql job freelancer, joomla freelancer jobs, joomla expert freelancer, jobs webmaster, jobs me freelancer, jobs at freelancer, how to get job at freelancer com, how to connect php with mysql database, how much is freelancer com, how can i use freelancer, how can i get freelancer jobs, how can i check my freelancer, freelancer vps, freelancer need database, freelancer job joomla, freelancer how check result, freelancer com level, freelancer com is it real, freelancer com how get jobs, freelancer com has a problem

Om arbejdsgiveren:
( 6 bedømmelser ) Beijing, China

Projekt ID: #4048704

Tildelt til:


Professional server/application optimizer.

$500 USD in 5 dage
(50 bedømmelser)

12 freelancers are bidding on average $529 for this job


Hello, We are ready for this job, Please check Private Message. Regards.

$350 USD in 3 dage
(171 bedømmelser)

php/mysql team

$500 USD in 5 dage
(150 bedømmelser)

9+ years of exp in PHP/MYSQL [url removed, login to view] and mysql load expert here.

$1000 USD in 4 dage
(339 bedømmelser)

Dear sir, we are a web design, web development expert company. We are offering an efficient,professional ,friendly service. Can you check our skills in Private message box and discuss with us about your project? Thanks Flere

$500 USD in 5 dage
(218 bedømmelser)

Hi, we have created and managed several high traffic websites (some featured on news and high profile tech websites - I'll send you a list in a personal message) with millions of records each and gigabytes worth of da Flere

$400 USD in 4 dage
(42 bedømmelser)

I can help you. Thank you.

$250 USD in 3 dage
(100 bedømmelser)

Hi, I made a lot of database optimization just changing some query sintaxes. Let me help you on that problem. Regards, Norberto

$570 USD in 30 dage
(25 bedømmelser)

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.

$240 USD in 3 dage
(14 bedømmelser)

Check details in PM

$540 USD in 3 dage
(5 bedømmelser)

Kindly check your PMB for details. Thank you!

$800 USD in 15 dage
(1 bedømmelse)

Check your PMB for details. Thanks

$700 USD in 10 dage
(0 bedømmelser)