Lukket

MySQL Query Performing Slowly! Fix MySQL Query Issue.

My website has a big database of advertisements where there are approximately 500,000 ads. My website's SQL query is not being able to handle this huge database and few SQL queries are being executed very slowly.

The website is hosted in a very good dedicated VPS, so hosting server is fine for the huge database but the website's SQL query need to be modified so that it can load and perform faster.

My VPS >> "MySQL Slow Query" log showing few specific queries are taking too long and those queries are affecting other queries to be executed slowly!!

I need you to fix this SQL query issue. my guess is, current SQL queries are not using proper "INDEX" & "SELECT" queries without limit!

There are 3-6 queries i think (can be bit more, not sure!) which are loading slowly and making other queries load slowly and you will be fixing those in this project.

After completing this project, i will need you to work on another few projects for me, so your bid should be with a reasonable price because of ongoing job!

If you can't work on this project right away, please do not bid ! ! !

Evner: Apache, MySQL, PHP, phpMyAdmin, SQL

Se mere: mysql in performance, mysql performance issues, fix slow mysql queries, mysql query optimization tips and tricks, mysql slow, slow mysql queries, how to check slow query in mysql, mysql join performance tips, edit csv mysql query, asp mysql query, 2013 lost connection mysql query, mysql query parent child, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, write mysql query, fix broken mysql database, optimize mysql query software, mysql query php table css

Om arbejdsgiveren:
( 7 bedømmelser ) Khilkhet, Bangladesh

Projekt ID: #17614791

47 freelancere byder i gennemsnit $149 på dette job

mekiho

Dear employer. I have read your project description carefully. Before, I have worked with 3 million records to speed up and I have reduce loading time as 2 sec. I'm very confident working with mysql programming so t Flere

$200 USD in 3 dage
(52 bedømmelser)
6.6
opuswebdevlopers

Hello, I can start work right away and can decrease loading time of sql query by changing it. Before commit to you anything i want to see log? could you conferrable to send me server details. Once i check issue then Flere

$150 USD på 1 dag
(160 bedømmelser)
6.6
widadsaghir1993

Hello sir. Nice to meet you. As a sql expert, i can help you well. I have good experiences in big database query. I am ready for your project always. Please contact me for your job. Thank you. Regard

$155 USD in 3 dage
(55 bedømmelser)
6.6
vishal817

I understand the Issue, I will Index the database or will make the Query which will load faster. Lets discuss. Thank you Vishal

$200 USD på 1 dag
(28 bedømmelser)
6.7
royalwebraisers

Dear Hiring Manager, We can help you in the project to make fast slow queries.. I am good in: php, codeigniter, laravel, jquery, google map api, MySQL. Let me know when we can discuss in more details and start Flere

$77 USD in 3 dage
(86 bedømmelser)
6.1
bjrupani

Hello hiring member i hope you are doing well i am bhavika i have 2.5+years experience in php ,laravel ,ajax,jquery ,javascript also i can do any mysql stuff and i can start your project right now and i have really goo Flere

$166 USD in 3 dage
(79 bedømmelser)
5.9
ssmlrehan0

Hello, Greetings from Rehan Arshad :) I will definitely optimize MYSQL as per your requirements. I am expert in Developing and Designing for a website with great experience of more than 8 years in a row. I am Flere

$150 USD in 2 dage
(55 bedømmelser)
5.8
usama13

Hey, Inbox me to start working on this project right now. I will check all queries and will update the queries so that it will work fast. I wont ask for payment until your 100% satisfaction. Thank you waiting for your Flere

$100 USD in 0 dage
(35 bedømmelser)
5.6
vinaysinghh

I am MySQL DBA having more than 8 yrs of experience and I have completed many projects for MySQL query optimisation

$111 USD på 1 dag
(57 bedømmelser)
5.3
ITPyramid85

hello,how are you. i read your bid carefully. i am php, mysql expert and have full experience for 10 years. php, mysql language is my top skill. i can provide most quality and high speed. if you want to success, pl Flere

$155 USD in 3 dage
(3 bedømmelser)
5.1
softechlab

hello. i am interest in your project. i have enough skills and full experience for your project. if you give me chance, i will do my best for you. thank you.

$100 USD in 3 dage
(13 bedømmelser)
4.6
delostyle

Hi , I have gone through the job details carefully and I am excited to start working on this project. I am confident that I can exceed your expectations by my quality of delivery. I have an extensive knowledge Flere

$100 USD in 2 dage
(15 bedømmelser)
4.4
JohnMary

Greetings, I have gone through the job description and i am very much comfortable to work on this project. I am available to discuss the project and ready to get started. Please share further details so I can start Flere

$250 USD in 4 dage
(12 bedømmelser)
4.2
arjun366333

Ready to start the work to Fix MySQL Query Issue, We can discuss more over chat, Thanks Regard Arjun S.

$110 USD in 3 dage
(18 bedømmelser)
4.5
deytps86

Hello I extensively worked in MySQL/Oracle and DB2 query optimization and performance tuning. Can we discuss more in details? Thank you!

$220 USD in 3 dage
(10 bedømmelser)
3.9
nojnish

Hi, I have 15+ years in sql development and query optimization in variety of databases such as MSSQL, MySQL and 5+ years specifically in MySQL database. hope to hear from you regards Babu

$200 USD in 3 dage
(2 bedømmelser)
3.6
$88 USD på 1 dag
(4 bedømmelser)
3.6
Tikdragon

Hello, sir. I have created many complex queries with mysql for php website. So i can be sure I can fix it. And what I want to know is how many tables you joined each other. If you're possible please send me a query Flere

$155 USD på 1 dag
(6 bedømmelser)
3.7
$166 USD in 3 dage
(10 bedømmelser)
3.9
$100 USD in 5 dage
(2 bedømmelser)
3.3