MySQL database needs to be optimized/fixed (excessive CPU use)
$30-250 USD
Completed
Posted over 11 years ago
$30-250 USD
Paid on delivery
My website is a school applicant database that public users have access to (here is what it looks like: [login to view URL]://[login to view URL] ) . Users can search or upload their profiles onto the database. My database is using excessive CPU on my webhost which is causing my webhost to suspend my account. As you can see below, the number of table row reads is excessive, and I need a solution.
I would need you to analyze and troubleshoot the problem on the database.
CPU_TIME:112 table_rows_read:329955639 SELECTS:1453 ROWS_UPDATED:12138 ROWS_FETCHED:0 BUSY_TIME:117 ONNECTED_TIME:129 BYTES_SENT:65010226 BYTES_RECEIVED:612373 WAIT_TIME:5
Top table row reads:
DB_USER: x -- TOTAL_CONNECTIONS: 79 -- CONNECTED_TIME: 117 -- CPU_TIME: 112 -- TABLE_ROW_READS: 329909628 -- SELECT_COMMANDS: 818 -- UPDATE_COMMANDS: -- BUSY_TIME: 113 -- BYTES_SENT: 30684004 -- BYTES_RECEIVED: 193198 -- WAIT_TIME (IO): 1