MySQL DB/queries optimization

In Progress

A website running a big database needs some MySQL/PHP optimization to reduce server load and get rid of slow queries.

The main problem comes with result pagination. Homepage loads fine but when going to page nr 16,000 of results, and ordering results by name, by date, by name and date, etc, site is slow and takes a lot of CPU.

This specially happens when Googlebot is crawling the site for indexing.

Database size is 2GB. Attached are some actual PHP files with the queries used, the database structure (.sql) with indexes etc, and a screenshot of phpMyAdmin where you can view number of rows, size of each table etc..

Thanks

Skills: Linux, MySQL, PHP

See more: mysql db, sql queries, queries, database queries, database optimization, table optimization, mysql structure, reduce sql, mysql number sql, mysql running, php mysql load table, queries database, mysql page number, sql view table, phpmyadmin view, mysql homepage, table queries, sql reduce, optimization database, reduce database size, queries sql, indexes date, slow queries, sql database size, php server optimization

Project ID: #2522629

Awarded to:

websterz

**MySQL/PHP expert here** Please see PMB.

€70 EUR in 1 day
(10 Reviews)
4.6

22 freelancers are bidding on average €185 for this job

zeke

Dear Customer! I am an expert web developer with over 6 years of experience and very interested in this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service More

€250 EUR in 3 days
(173 Reviews)
7.1
phpxpert89

Hello Dear Employer, I am a Custom PHP/MySQL developer. I have designed and developed, many websites on PHP amd MySQL. I have 4 years of total experience in IT industry, and had built popular applications with compa More

€250 EUR in 15 days
(37 Reviews)
6.2
phpdeveloper100

Please check PMB.

€250 EUR in 20 days
(34 Reviews)
6.0
profyguy

hello. please read pmb

€250 EUR in 3 days
(41 Reviews)
5.9
techwelf

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare -- Please check inbox for our previous work.

€250 EUR in 9 days
(44 Reviews)
5.9
pyostrike

Hello. I can help you. Anton.

€50 EUR in 2 days
(90 Reviews)
5.8
pablotorres

I can do it!

€30 EUR in 3 days
(106 Reviews)
5.8
phpXpertbd

I specialize in similar projects. Please check PM for more details.

€250 EUR in 7 days
(19 Reviews)
5.6
BackSlaSh85

Hello, please check your inbox. Thanks

€250 EUR in 1 day
(9 Reviews)
5.1
desireds

We are having a great expertise in providing web design, development services to all kinds of small, medium and large enterprises.

€200 EUR in 5 days
(14 Reviews)
5.0
YassineB

I will optimize the MySQL server and database structure for you. Please check PMB for more details, Thanks.

€230 EUR in 5 days
(20 Reviews)
4.4
lkh007

I worked with millions records of database before. I noticed that there are quite some rooms of improvements for SQL. I am sure I can help you!

€48 EUR in 2 days
(8 Reviews)
4.4
srajbr

I need more details

€100 EUR in 5 days
(13 Reviews)
3.8
eblive

Hi, I can help you out with this.

€100 EUR in 5 days
(9 Reviews)
3.8
developermedia

Hi, we have check all details with all points and now we are interested with this job so please provide one chance to us related this job please check your PMB for more details Thanks

€250 EUR in 5 days
(12 Reviews)
3.4
itconsultindia

php/mysql team

€350 EUR in 3 days
(9 Reviews)
2.9
laabuelita

I think we need more details to start with the project (indexes, the output format [straight html, json, xml...]), so please read PM and we may get it easilly

€100 EUR in 4 days
(0 Reviews)
0.0
borischernov

Hello, I have experience in both systems administration (Linux, MySQL, Apache, Nginx, etc ... ) and programming (PHP, RoR, ...). I have also worked with quite heavily loaded websites (like caribsports.com) which makes More

€150 EUR in 3 days
(0 Reviews)
0.0
KAuTt8C69

Custom software development (<b><i>Removed by Admin</i></b>)

€250 EUR in 1 day
(0 Reviews)
0.0
krezen

Hello, Good wishes. Went through your requirement and please check PMB for our findings and queries. Thank you, Krezen Team

€250 EUR in 5 days
(0 Reviews)
0.0