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.
[url removed, login to view]
ATOM C2750, 2.4 GHz with 16 GB ram
Number of queries per second
Each query takaes 2-3 seconds
19 pekerja bebas membida secara purata $192 untuk pekerjaan ini
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
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 :)
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