Php script - need to improve caching mechanism and optimizing mysql [login to view URL] internal server 500 error due to heavy load

Hello, i have an php video script(custom written) on my web site,including legal adult [url removed, login to view] has heavy loading issue. When online users excess number of 1k, apache server giving internal server 500 [url removed, login to view] is a caching system on script but i m not able to check or develop it to work correctly.I think the main problem is too much database queries occurs at the same [url removed, login to view] is hosting on Hostgator's web hosting service.

When i ask my website hosting provider(which is hostgator) they said that process limit has been exceed(which is limited to 25 processes).Database queries takes too long so need to implement table indexing and query caching or something else to decrease process usage.

I need a php developer and mysql expert to solve this issue.I can give detail informations who want to work on thid project

Skills: Database Administration, MySQL, PHP, Software Architecture, Website Management

See more: adult script, work online php developer, website to improve, web site error, video hosting service, software web php developer, php developer work online, php developer service, need a content developer, i want a software developer service online, i need a system developer, i need a server developer, exceed database, ask software developer, database caching, php developer server, solve php error, php software architecture mysql, need something written, mechanism

About the Employer:
( 0 reviews ) Varna, Turkey

Project ID: #4811617

7 freelancers are bidding on average $57 for this job


I can fix this caching issue problem and decrease process usage to avoid server crash. I will complete this work in 2 days.

$64 USD in 2 days
(597 Reviews)

Hello sir I have done this task a couple of times in my past projects. I'm very much interested in doing this task for you. Thank you for giving your precious time to review my bid and check PM for more details!

$23 USD in 3 days
(69 Reviews)

Hi, Please review my PM. Thanks

$100 USD in 0 days
(11 Reviews)

Let me help you.

$30 USD in 3 days
(2 Reviews)

I can do this work. Read the private message.

$30 USD in 3 days
(6 Reviews)

I inform you that I optimized a database with more than 8 GB in the main table, the response time increased from 23 seconds to 2 seconds, thank you to contact me for more details.

$30 USD in 2 days
(1 Review)

Pls, See PM

$35 USD in 5 days
(0 Reviews)

We can do it.

$55 USD in 3 days
(0 Reviews)

I can help you to optimize your queries.

$111 USD in 1 day
(0 Reviews)