Expression Engine & MySQL Database Repair

In Progress

I need someone to optimize or repair out database queries. They are bogging down the database.

Here is what I have been reported.

1.

+Large rows and slow queries

Severity: High

Many tables such as exp_member_homepage (704,825 rows) exp_members (704,840 rows), and exp_member_data (704,838 rows) are very large in size. Besides these, I also counted about 10+ tables with 10,000-20,000 rows. The size of these tables used in conjunction with inefficient queries leads to slow queries, which I believe is the biggest culprit for the slow site speeds. Your MySQL slow queries log has grown to almost 358MB in just a few days. This log can be found at the following path:

/var/log/[url removed, login to view]

As a courtesy, I analyzed some of your slow queries, and see a large amount of queries that use 'SELECT *' in some of your largest tables. These types of queries appear to be the largest cause of your bottleneck, as they have to comb through 704,000+ records. Optimizing how your site utilizes MySQL will benefit you the greatest.

Skills: Expression Engine, MySQL, Website Management

See more: mysql database engine, mysql expression, optimize mysql, how to repair, database queries, mysql optimizing , mysql tables rows, mysql repair database, slow queries, mysql slow queries, mysql slow, mysql repair tables, database optimizing, mysql repair site, repair database, mysql optimize, large database slow site, mysql repair, optimize database mysql, select select mysql, select days mysql, php repair database mysql, optimize slow queries, optimize database, mysql optimize large database

Project ID: #4728638

Awarded to:

webaccelerator

Dear PCTOC, I have studied you project requirement about query optimization and interested to work on it Could you please check private message for more details Thanks Jolly

$631 USD in 20 days
(55 Reviews)
5.8

15 freelancers are bidding on average $577 for this job

donkyaw

I'm interested in your project.

$500 USD in 10 days
(35 Reviews)
5.1
farhaoui

Please check PM

$773 USD in 10 days
(37 Reviews)
4.8
sahsoft

Plz check you PMB

$555 USD in 7 days
(20 Reviews)
4.6
Fourtek1

Hello there, We would like to discuss this project with you, plz check PMB for the details

$526 USD in 3 days
(4 Reviews)
4.2
mxicoders

Hello sir We are having a team of best designers and developers that are working in the web development field since last 10 years. We would like to grab this opportunity to work in your valuable and most esteemed pro More

$736 USD in 21 days
(3 Reviews)
4.0
e3d

Expert here. Kindly check your PM

$495 USD in 5 days
(3 Reviews)
3.7
miniric3

Kia ora! Mulvays.com are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi More

$773 USD in 30 days
(2 Reviews)
4.4
elboukharimu

I can help you please check you inbox

$388 USD in 3 days
(4 Reviews)
3.1
tparis00ap

You need to use indexes with that sort of data. I can help you identify where you need indexes and also limit the amount of data that must be collected and sorted.

$500 USD in 30 days
(2 Reviews)
1.7
maheshreddyv

I am good in optimizing queries in SQL, and working on performance related issues from last 3 year, i can do this for you.

$555 USD in 3 days
(0 Reviews)
0.0
IcasmIT

Hi, I've worked on countless EE sites, both exisiting sites and new sites, I have also worked with MySQL for 7-8 years, I should be able to optimise your EE site in a day. Please see PM for further details about More

$444 USD in 3 days
(0 Reviews)
0.0
johnstan007

I have over 8 years of query optimisation, database design and data architecture experience with the largest technology consultancy in the world.

$555 USD in 3 days
(0 Reviews)
0.0
oobretenov

I have experience in DB design and optimization. I could help you with this task. Send me the db schema and some description of the data to see it.

$666 USD in 10 days
(0 Reviews)
0.0
on2it

Kia ora! on2itonline are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi More

$721 USD in 12 days
(0 Reviews)
0.0
abhinay18

More than 2 years of experience in query optimization. I can do this job for you.

$611 USD in 20 days
(0 Reviews)
0.0