mysql expert -- 2
Budget: $10 – $30 USD
we are running a web game based on threads of mysql database
each task is a thread stored in db with time , if time equal now then the server will auto run the query
the normal average for queries per second is 500 query , the php side is perfect no issues
the cpu and ram are strong
the issue i believe is in limits of query per time
which when there are over 60 queires at same time then a delay happen for executing them
we need someone to configrue the apache and mysql to work in 95% of the recourses
we need the queries done one their time is up , no delay at all
each task is a thread stored in db with time , if time equal now then the server will auto run the query
the normal average for queries per second is 500 query , the php side is perfect no issues
the cpu and ram are strong
the issue i believe is in limits of query per time
which when there are over 60 queires at same time then a delay happen for executing them
we need someone to configrue the apache and mysql to work in 95% of the recourses
we need the queries done one their time is up , no delay at all