Đang Thực Hiện

119022 Mysql slow query fix

I am looking for someone who can help me fix a mysql query that is taking a high load on the server. It's from a image hosting website. I have attached the query that is taking the huge load. As you can see the query time is 31 SECONDS and its examing ALL rows on the database (163286 rows).

Please see the attachment for details.

Thank you


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

Xem nhiều hơn: n query, help website fix, help me fix it, mysql query, fix slow, fix mysql query, fix query, image query, php mysql database query, query query, mysql query slow, mysql query php, mysql slow, mysql attachment, slow server, hosting fix, php server load mysql, php mysql load time, huge load, load php mysql, fix load server, fix server load, attachment mysql, php slow fix, query database

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

ID dự án: #1865191