Closed

Rewrite simple PHP script, to use Redis instead of MySQL

I have one PHP script to receive information from HOST computer and insert in DB at remote [url removed, login to view] mysql receive a lot of connects which must process. For each connection it open new instance Bue due this many request its overloading my Computer processor, reaching 700% of cpu usage when i do top and uptime command.

So i need someone to modify my script and optimize it to reduce processor usage.

One idea i have to may be fix it is insert logs received in SERVER memory ram then after X time insert it in DB, reducing from multiple request to one single request.

PHP SCRIPT:

[url removed, login to view]

My server

ATOM C2750, 2.4 GHz with 16 GB ram

Number of queries per second

30-50

Each query takaes 2-3 seconds

Kemahiran: Linux, Nginx, PHP, Redis, SQL

Lihat lagi: 30 second script, simple php mysql data editing script, simple php wallpaper script without mysql, php, linux, redis, simple php mysql login script, simple php mysql script, simple php script mysql signup admin delete entry, simple php mysql entry script, simple php mysql edit script, simple php search script mysql, simple php mysql script users, simple php mysql video upload script

Tentang Majikan:
( 13 ulasan ) miami, Brazil

ID Projek: #10104219

19 pekerja bebas membida secara purata $192 untuk pekerjaan ini

KESHAVINFOTECH

Hi Thanks for your valuable time. :-) Just reply with 'Yes' and We will come up with a. Detail project plan with our comments/queries. b. Best-feasible-real COST & TIMELINE Latest Projects : [login to view URL] Lagi

$250 USD dalam 15 hari
(628 Ulasan)
8.5
toinnisfree

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor Lagi

$150 USD dalam 3 hari
(761 Ulasan)
8.3
BitLabs

Hello, I have gone through your outsourced requirements "Rewrite simple PHP script, to use Redis instead of MySQL" and have analyzed that I have right credentials and Skills required Linux, Nginx, PHP, Redis, SQL Lagi

$222 USD dalam sehari
(113 Ulasan)
6.7
mahamadali

Hello sir , Waiting for your positive response about this php + MySQL optimzation script ... I can do this stuff ... Thank you ...

$144 USD dalam sehari
(128 Ulasan)
6.3
techwelfare

Yes Sir let's explore the requirement to clarify in details also if you want us to share our skill and previous work let us know.. hope to hear you soon.. Thanks & regards Promiti

$208 USD dalam 5 hari
(136 Ulasan)
6.9
usin

PHP Skilled Program Developer Years of Experienced (+) 100% Happiness Guaranteed On Works (Invite Me To Chat For Further Details)

$400 USD dalam 18 hari
(84 Ulasan)
6.3
santossystems

Hi, I hope that's not your actual decryption key on that pastebin. Where is the processor load? On the db instance or on the application instance? There are a lot we can do with this script alone. Looking forward he Lagi

$500 USD dalam 3 hari
(49 Ulasan)
5.6
rana100

Dear Sir, I am very much interested to work in your project. I know the following languages that will meet the techincal needs of your project PHP, MYSQL,Wordpress,Javascript, CSS, Boostrap, responsive design. I c Lagi

$155 USD dalam 3 hari
(25 Ulasan)
5.1
phankhanh

Hi, Could you tell me how many rows in hosts table now? It should be not very slow. Redis is better solution and i can convert it to redis, but if you still need to stick with mysq, we can improve it. Let me kno Lagi

$100 USD dalam 3 hari
(28 Ulasan)
4.7
$100 USD dalam 2 hari
(31 Ulasan)
4.2
$188 USD dalam 3 hari
(5 Ulasan)
4.3
grundahl

Hi, i'm an expert php developper and database adminstrator, I can help you optimize your script. After a first look, i think each call to the script shouldn't take long enugh for call to stockpiling. If you hir Lagi

$277 USD dalam 5 hari
(3 Ulasan)
2.8
romdane

Database expert PhD Professional, Self-motivated and goal oriented. Have ability to follow through with projects from inception to completion using analytically and problem solving skills. I possess high programming Lagi

$250 USD dalam 5 hari
(1 Ulasan)
2.6
vishal618

I have experience of little similer work

$166 USD dalam 7 hari
(2 Ulasan)
1.5
karaboykov

Hello there. Going trough your script it looks like your problem is that you want location stats for the visitors to your service based on their source IP address. Your approach to complete that task at the same Lagi

$50 USD dalam 3 hari
(0 Ulasan)
0.0
akbarattari

Hello, I have great experience in php/mysql, wordpress and it's customization. I can start right away and I can make it quick. Waiting to chat with you, Thanks :)

$155 USD dalam 3 hari
(0 Ulasan)
0.0
ashwinnair7

I am best suited best for this project as i have nearly 1.5 years of experience of writing production level code in mysql, redis and php. Regarding the problem statement in hand we can figure out a way to reduce the Lagi

$88 USD dalam sehari
(0 Ulasan)
0.0
archayne

I will firstly profile the application then make changes accordingly. it should not take the amount of time that you are seeing. May also be some issue in MySQL config. If MySQL is the bottleneck we can shift to redis

$150 USD dalam 2 hari
(0 Ulasan)
0.0
$88 USD dalam 3 hari
(0 Ulasan)
0.0