Sedang Disiapkan

large mysql database trouble shooting- repost

Hi,

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.

Kemahiran: Pentadbiran Pangkalan Data, Joomla, MySQL, Oracle, PHP

Lihat lebih lanjut: mysql php expert freelancer, mysql job freelancer, joomla freelancer jobs, joomla expert freelancer, jobs webmaster, connect php mysql database, freelancer vps, freelancer need database, freelancer job joomla, freelancer check result, check freelancer level, vps jobs, freelancer resources, webmaster tool google, shooting, mysql freelancer, mysql database , joomla expert seeking, jobs php freelancer, get freelancer job, freelancer webmaster, database freelancer, joomla slow large database, mysql memory load, connect mysql joomla

Tentang Majikan:
( 6 ulasan ) Beijing, China

ID Projek: #4048704

Dianugerahkan kepada:

triamazikamno

Professional server/application optimizer.

$500 USD dalam 5 hari
(49 Ulasan)
6.2

13 pekerja bebas membida secara purata $549 untuk pekerjaan ini

buzzz

Hello, I am ready to fix Your trouble. can optimize db and optimize mysql settings for this type of db.

$600 USD dalam 2 hari
(373 Ulasan)
7.6
coolguyinus2004

9+ years of exp in PHP/MYSQL programming.Database and mysql load expert here.

$1000 USD dalam 4 hari
(271 Ulasan)
7.3
itcslive

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 Lagi

$500 USD dalam 5 hari
(156 Ulasan)
7.3
neoconcepts

php/mysql team

$500 USD dalam 5 hari
(101 Ulasan)
7.2
joomextensions

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

$350 USD dalam 3 hari
(48 Ulasan)
6.7
dracco

professional here ready to help you in this project. Check my reviews and let me know if you want to work with me.

$500 USD dalam 5 hari
(137 Ulasan)
5.9
techwelf

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$789 USD dalam 9 hari
(38 Ulasan)
5.8
pauljacionis

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 Lagi

$400 USD dalam 4 hari
(3 Ulasan)
5.3
dotsaravanan

Hello, Thanks for your post. Kindly check our PMB.

$400 USD dalam 10 hari
(10 Ulasan)
5.2
norberto108vw

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

$570 USD dalam 30 hari
(23 Ulasan)
5.2
codetrance

I can help you. Thank you.

$250 USD dalam 3 hari
(43 Ulasan)
5.1
f1x3r

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 dalam 3 hari
(7 Ulasan)
3.9
defuz3d

Check details in PM

$540 USD dalam 3 hari
(5 Ulasan)
3.9
smartofts

Kindly check your PMB for details. Thank you!

$800 USD dalam 15 hari
(1 Ulasan)
2.0
jerrymoa

Check your PMB for details. Thanks

$700 USD dalam 10 hari
(0 Ulasan)
0.0