Closed

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

This project was awarded to frkSuna for $99 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
N/A
Total Bids
10
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online