Đang Thực Hiện

152923 Optimize mysql Query (Large)

I got a mysql query

in php, that does a join on a large table (90GB)

query takes somewhere between 7 and 20 seconds

I need help to speed this up.

I can show the query on the private message board.

You need to be real experiences with mysql, experience with optimizing and tweaking performance.

I think indexes are on the right place, and "explain" shows that they are being used

please basic mysql skills will not be sufficient to solve this problem.

If you are a mysql guru, this should be an easy buck

Kỹ năng: Bất kì công việc gì, MySQL, PHP

Xem thêm: performance board, n query, guru skills, guru message, basic guru, query table, optimize mysql, mysql query, i got a 7, php mysql join table, mysql join table, mysql table join, php mysql optimize, mysql optimizing , mysql help table, query performance, query query, mysql query php, query optimize, performance optimize, mysql join, optimize php mysql, performance problem, query optimize mysql, php mysql table join

Về Bên Thuê:
( 11 nhận xét ) Netherlands

Mã Dự Án: #1899104

Đã trao cho:

jeffgan007

Hi, I could help you on this one. See PMB for details. Regards, Jeff

$20 USD trong 1 ngày
(17 Đánh Giá)
3.5