My website is a school applicant database that public users have access to (here is what it looks like: [url removed, login to view]://[url removed, login to view] ) . 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