optimize the pligg queries to fixed performance problems

$30-50 USD

İptal edildi

İlan edilme:

12 yıldan fazla önce

$30-50 USD

Teslimde ödenir

Hi, I am looking for MySql Expert to fixed and repair optimize the pligg queries to fixed performance problems. My host suspend my account. Look at these deactivation notes mysqld(1) started: Sun Dec 4 12:24:26 2011. (03d 10h 35m 47s runtime) AdjRowsEx: UserCPU/ Select Update Other Voluntry Nonvol LastQry LastQry Actv LastQry LastQry Database User CPUTime BusyTime CPU/Busy RowsExamined RE*CPU/Busy TotalCPU Cmds Cmds Cmds CtxSw CtxSw StrtCPU EndCPU Qrys BusyTime CPUTime ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- gotagged_go 438,811.3447 607,129.9836 0.7228 63,826,282,902 46,131,302,663 0.6306 2,329,739 69,405 941,505 NULL NULL NULL NULL NULL NULL NULL root 7,929.5070 8,844.5637 0.8965 170,838,668 153,163,735 0.0114 571,656 4,735 3,040,391 NULL NULL NULL NULL NULL NULL NULL This is way too much mySQL cpu time (63% of all mySQL activity, 88 seconds/minute, 18 billion rows read per day). Most read tables (anything with atleast 100k rows read): | Table_schema | Table_name | Rows_read | Rows_changed | Rows_changed_x_#indexes | +--------------+----------------------+-------------+--------------+-------------------------+ | gotagged_go | pligg_links | 41239607089 | 25387 | 253870 | | gotagged_go | pligg_tags | 6504566080 | 4156 | 8312 | | gotagged_go | pligg_users | 2343341633 | 7702 | 23106 | | gotagged_go | pligg_messages | 169936481 | 936 | 936 | Customer has abundant, large mysql slow query logs he can reference for additional information. Repair and optimize of the database is insufficient. Customer must optimize his queries to resolve this issue. Your job is to fixed the MySql issue, so that my website can go live again. Your job will be review by the hosting Team and once they clear it and make the website like then only you'll get your payment and the job marked as DONE. Thanks

Linux

MySQL

PHP

Proje No: 1330968

Proje hakkında

5 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 12 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

5 freelancer bu proje için ortalama $101 USD teklif veriyor

@GuruDeveloper

I can tackle it. A lot of experience in MySQL & Percona.

$151 USD 3 gün içinde

4,6

(31 değerlendirme)

5,8

@MustafaSR

Hello, Please check PMB

$70 USD 2 gün içinde

5,0

(69 değerlendirme)

5,6

@Kotkowiczpl

I work at home. My costs are lower, prices more competitive and my workplace is idealy suited to my needs. I have been working remotely for years and I believe this is an ideal solution. I profess the mutual trust principle. The fact that we have never seen each other does not mean I will not do my job properly, and I also expect that I will receive the agreed payment from my employer at the agreed time. We all play fair, right? The form of our cooperation, settlements and monitoring of my work progress is agreed individually together with the customer and depends on their needs and expectations. The interest in modern solutions is one feature that is characteristic of my way of working. I am open to suggestions and willing to implement new technologies. Many of my projects were based on author's solutions, thus the later server administration or working on the code is much simpler. My work is also my passion, therefore the customer can be sure, that they will receive the highest possible quality in case of the solutions created by me, and the price will always remain attractive.

$150 USD 1 gün içinde