MySQL database needs to be optimized/fixed (excessive CPU use)

IN PROGRESS
Bids
10
Avg Bid (USD)
$104
Project Budget (USD)
$30 - $250

Project Description:
My website is a school applicant database that public users have access to (here is what it looks like: http://web.archive.org/web/20110726081345/http://www.pharmapplicants.com/ ) . 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

Skills required:
MySQL, PHP, Software Architecture
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.