Analysis of reasons for slow-running SQL queries

$30-100 USD

In Bearbeitung

Veröffentlicht

vor etwa 14 Jahren

$30-100 USD

Bezahlt bei Lieferung

Semi-dedicated web server (512Mb RAM, Xeon(R)CPU E5420 @ 2.50GHz) running Apache with: Linux 2.6.18-028stab066.8 MySQL [login to view URL] PHP 5.1.6-23.2.el5_3 Database is 56.7Mb over 39 tables, with 1 table of 28.3Mb. Load average is frequently in the 2.00-6.00+ range and when running the "top" command, it shows results such as: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 21782 mysql 17 0 376m 49m 5972 S 99.2 9.6 26990:01 mysqld 29712 psaadm 15 0 171m 23m 15m S 0.3 4.6 0:07.12 httpsd 1 root 18 0 10344 732 608 S 0.0 0.1 0:05.97 init 5724 apache 15 0 307m 32m 4932 S 0.0 6.4 0:00.80 httpd 5905 root 15 0 96576 3728 2860 R 0.0 0.7 0:00.09 sshd This work request is to investigate the cause of this high mysql process and make recommendations as to what can be done to reduce the load average and increase the site's speed. Notes: 1. I am not looking for generic recommendations - I am looking for someone to point out specific problems and how they could best be fixed. 2. No direct fixing is required as part of this work. 3. Recommendations may lead to future work, including carrying out those suggested fixes. Thanks.

Apache

MySQL

PHP

Projekt-ID: 613446

Über das Projekt

17 Vorschläge

Remote Projekt

Aktiv vor 14 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@TakeReal

Please, see private message.

$100 USD in 2 Tagen

5,0

(1264 Bewertungen)

7,5

17 Freelancer bieten im Durchschnitt $71 USD für diesen Auftrag

@Georgia

I am interested.

$90 USD in 3 Tagen

5,0

(84 Bewertungen)

7,2

@clearware

Hello, we are a company focused on creating custom-made solutions. We have a great experience in optimizing MySQL queries. Also in our team there are sys-admins who could tweak the MySQL and Apache configuration to achieve the best possible results. At the end of each project we create, we spend 2-3 weeks in optimizations and squeeze all possible speed of the projects. If you are interested or have questions/comment, just contact us. Regards ClearWare Sales Team

$80 USD in 5 Tagen

5,0

(2 Bewertungen)

5,8

@exsys

Hi, Please check PM.

$40 USD in 0 Tag

5,0

(20 Bewertungen)

4,8

@itamarjp

please check pm

$100 USD in 0 Tag

4,9

(42 Bewertungen)

4,8

@peteruk

I can optimise this for you to best suit the host machine.

$100 USD in 2 Tagen

4,8

(13 Bewertungen)

4,6

@braincyber

Hi.. Can fix now itself.. Please check your PM.. Thank You

$50 USD in 0 Tag

5,0

(9 Bewertungen)

3,9

@gr8Ideas

Hi, Pl. check PM. I am working on 70 Mysql server for many websites of my organization. regards gr8ideas

$100 USD in 1 Tag

5,0

(7 Bewertungen)

3,8

@sat12345

Plz check PMB...

$100 USD in 2 Tagen

4,0

(51 Bewertungen)

3,9

@garhwalsatyapal

i can fix it

$50 USD in 5 Tagen

5,0

(8 Bewertungen)

3,5

@igoryp

Hello, I have longtime experience resolve problem like this, This my cup of tee. Thank you.

$30 USD in 1 Tag

5,0

(2 Bewertungen)

2,6

@secpro

I'm a security expert and programmer senior.. i can fix this with no problem ... probably you don't use partitioning methods its new from version 5.1 i can do it in 10 minutes and probably redesign it and increase at 90% the performance and reduce at the same time your server load. i can give you some tricks or explication to understand the process if you need to best regards J-C

$30 USD in 0 Tag

5,0

(1 Bewertung)

1,7

@mathemonkey

I'm posting my suggestions to PMB.

$40 USD in 0 Tag

0,0

(0 Bewertungen)

0,0

@wattwood

I'm a senior systems engineer, I.T. Manager and overall I.T. guru when it comes to Linux-based systems. I can track down the cause of your slow queries and provide recommendations on how to improve performance both on the OS level and the database schema itself. I suggest this will take me 1-2 hours to complete.

$50 USD in 1 Tag