Mysql query optimization
Budget: $30 – $250 USD
I have an auction site and I need to optimize some queries that slow down the server. The CPU consumption by mysql is close to 1800% and is making it impossible to carry out auctions. From what we perceive some tables freeze and do not close and this increases with the number of auctions.