I am looking for somebody proficient in php, mysql, and general server management to make the necessary modifications to the site attached to this project (included is database structure & php elements), and/or provide the appropriate advice that will result in faster load times.
Essentially, the site this code is run on receives up to 300,000 uniques per day, each of which result in an entry to the DB, and when the DB has >60,000 entries, the site begins running slowly (4 core 3.5GHz taking >8 seconds to load, or timing out, because ~100% of the CPU is being used by mysql).
I do not know if this is something to do with the coding of the database/site, or whether the sql connection limit is causing a backlog of requests, however once the CPU is fully loaded and the site is running slowly, if I truncate the tables, speed returns to normal (<1s average).
I have a suspicion that there is some fix which will result in me not requiring such a powerful server to host a 500kb web page, despite the high volume of requests.
Hopefully someone to provide insight on how to go about minimising load time, because all I keep reading is that the amount of entries in the database should have a negligible effect on serve/write speed.
I’d imagine this isn't a particularly time consuming task, so bids should probably stay under $50, but if you know what needs doing, and it requires more time, then just say so and we can sort something out!
I’ll not be back on Freelancer until about 8 hours after posting this project, so I’ll answer any questions anyone has then!
Thanks,
Harry
PS, please include the word ‘monkey’ in your bid so I can separate the bottled bids from real people :)
monkey. Hi, I estimate it to be around 1 hour of work, but it may be more or less, depending on your actual problem. give me your script and db layout so I'll take a look and will tell you how much it will cost to fix
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
Hi
I have experience on website speed optimization. I can optimize your website to load within minimum seconds and get expected rank on Google PageSpeed insight, Pingdom, GTMetrix, etc. There are more than 10 issues including CSS, JS, Images to be solved without changing any feature.
I will provide free CDN server (dns) to speed up website. (if required)
I have completed many website successfully with customer full satisfaction.
Would like to discuss more details.
thanks.
mizan
I checked the db structure and the pages.
Have them running on my server. I'm very expert on administration of Linux/MySQL/PHP systems, so it won't be difficult to fix this issue.
I may be asking you to check something in your server anche tell me the results, or, if i could be allowed, I may check myself if you could allow me to enter (maybe via Teamviewer).
I'm available in chat anytime.
HI,
There can be many reasons for slowing down a site.
With your description given we think that its a database issue as when you truncate table site speed returns to normal.
There can be many reasons for mysql slow queries.
We can have a log of slow queries provided my mysql and see where we need to optimize queries or change schema.
If we need to change schema then it may take time as we may need to change code as per schema.
Lets discuss more on chat.
Thanks and Regards
Vibearning
Hello, friend can analyze the php code as well as the configuration of your database, whether it is optimized, need to know if your database is on the same server as your application php or separate bank? I need to know if your server works with Apache or Nginx, although in often the bottleneck ends up occurring due to the use of Apache, not by poor quality of php code if the issue from the server after you analysis, I can report as well mount server with Nginx, and need to know which version of the Linux operating system is used.
Without further.