In Progress

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

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

Skills: MySQL, PHP, Software Architecture

See more: problem archive, mysql org, mysql database software, is it fixed, archive top, archive problem, school database, io, top webhost, excessive, mysql search table, php search mysql row, mysql search database table, php search database table, troubleshoot php mysql, website school database, access 2012 web database, search optimized, school website database, public school, database school, school access database, mysql school database, mysql rows_updated rows_fetched, php mysql school

About the Employer:
( 0 reviews ) Northridge, United States

Project ID: #2693148

Awarded to:

frkSuna

Please check PMB.

$99 USD in 1 day
(117 Reviews)
6.1

8 freelancers are bidding on average $115 for this job

thangtqvn

Hello, i have experience in optimize database. I will make it run better

$70 USD in 2 days
(175 Reviews)
6.6
MHDJAZ

IT engineer . Database expert.

$100 USD in 2 days
(33 Reviews)
5.3
dungvit85

Mysql expert here. I can help you debug and optimize your MySQL [url removed, login to view] check my reviews for similar jobs. Regards.

$100 USD in 0 days
(42 Reviews)
4.9
MakeYouBelieve

Hello, I can do it. Regards.

$250 USD in 7 days
(32 Reviews)
4.5
ExtraMemory

Hello Respected Client, I have Read your requirements and we are very experience in this concept. please check Message Board for more details. Thanks

$90 USD in 1 day
(3 Reviews)
3.3
thedevelopguy

Hi, I can start right away if you'd like

$69 USD in 0 days
(2 Reviews)
2.8
locwebde

I have experience optimizing MySQL queries for speed and efficiency and would be happy to troubleshoot your site.

$140 USD in 4 days
(1 Review)
2.1