Find Jobs
Hire Freelancers

Help me optimize query / index / fix database

$10-50 USD

완료함
게시됨 7년 이상 전

$10-50 USD

제출할때 지불됩니다
I have a dedicated server with MariaDB installed... My Database is only 3 columns, but is over 350k Row's. It is a database of ip address. Every visitor on my site, have a query.. SELECT * FROM known_ip where ip='$ip'" ... I have around 500K daily request... someitme my CPU usage peak to 1400% CPU(i have 16 cores, can go up to 1600% )... I beleive i need to build a Index, or something else, maybe simply need to arrange the php query or something i do not know... I do not find it normal i have 1000%+ CPU usage for one single table that has only 3 columns with only 300k rows... I am looking for a PHP/SQL expert who know how optimize and will do it quickly.
프로젝트 ID: 12304509

프로젝트 정보

20 제안서
원격근무 프로젝트
활동 중 7년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Greetings, I can write optimized query, index you tables, configure server and can use cache for you. I am sure after this query time will be too shorter as you want.
$25 USD 1일에
5.0 (2 건의 리뷰)
1.9
1.9
20 이 프로젝트에 프리랜서들의 평균 입찰은 $53 USD입니다.
사용자 아바타
Hello! With 98% to 99% completion rate, 900+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :) I am available to get started on your project right away. I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$105 USD 2일에
5.0 (924 건의 리뷰)
8.6
8.6
사용자 아바타
I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactorily completed. Contact me at your soonest convenience so we may get your solution delivered quickly. Thanks, coderXO
$65 USD 1일에
4.9 (757 건의 리뷰)
8.3
8.3
사용자 아바타
A proposal has not yet been provided
$88 USD 0일에
5.0 (493 건의 리뷰)
7.2
7.2
사용자 아바타
Hi. I can optimize your db queries, we dont need all the columns. ill put some indexes to make it faster as well. Lets discuss this in private chat i am available You can also review my profile for my past projects https://www.freelancer.pk/u/shebkhan2007.html Regards Shahbaz
$77 USD 1일에
4.9 (693 건의 리뷰)
7.1
7.1
사용자 아바타
sir pm me im good in php and sql my #1 skill is php i can optimize query pm me thanks ....................
$50 USD 0일에
5.0 (158 건의 리뷰)
6.2
6.2
사용자 아바타
Hi I need phpmyadmin access to Your database Dont worry - Im expert and I think I will do it carefully and resolve only 2 wishes 1- I need milestone be done today. I will provide You some additional help if needed in few days but milestone must be done today 2- You must say me how to test if my help was useful. Ssh access to run top or something else. Or You can do some screens of performance before and after my work Thanks.
$35 USD 1일에
5.0 (27 건의 리뷰)
5.7
5.7
사용자 아바타
Hello, Hope you are doing great ! I will help to reduce CPU uses in your server. I have over 4 years experience on managing server. Have a nice day. Regards Abu Bakar Siddique
$85 USD 2일에
5.0 (54 건의 리뷰)
5.6
5.6
사용자 아바타
Hi there, provide more information about your problem. .
$88 USD 1일에
5.0 (62 건의 리뷰)
5.7
5.7
사용자 아바타
Before began, will be important to know how u use these ip and how is being assigned and work for... To find the best way to solve your issue we need to find the proposal for these request and how u expect to be working
$55 USD 2일에
4.9 (20 건의 리뷰)
4.5
4.5
사용자 아바타
Hi! Have you done any optimizations for mariadb? The IPs are IPv4 only? How are storing the IP address values? There's a big difference between storing them as varchar and int. I'd really like to help you, just let me know.
$45 USD 1일에
5.0 (9 건의 리뷰)
4.3
4.3
사용자 아바타
Hi! Can help you optimize your site, will need full SSH access to your server to check what is happening. Will optimize the database, indexes and full Linux system if needed to maximize the performance. Any doubts please chat. Thanks for reading! - Vinicius
$35 USD 1일에
4.6 (14 건의 리뷰)
4.7
4.7
사용자 아바타
Dear Sir/Ma'am, As far as your requirement concern , i have good knowledge about it with more then 10 years of technically experienced. so kindly initiate the discussion.
$25 USD 1일에
3.1 (19 건의 리뷰)
3.7
3.7
사용자 아바타
Hey, You have posted a project for building a website. Our skills have the perfect match for your project and its requirement We have read your post thoroughly. Our team has experts especially doing these kinds of jobs. We don't let our clients away from us by disappointments; we gave a quality of work to our clients. We strive not for success but for building trust After discussing your project in details, we will be able to quote you the best price. ============================================================== Please make a positive response to our bid and drop us a message to discuss your project to start work soon. We will be waiting for your response. We will also available 24/7 you can contact us anytime. Thanks, Regards: Hassan and team ====================================
$35 USD 1일에
5.0 (2 건의 리뷰)
2.4
2.4
사용자 아바타
hi, you have several problems from your client, you need apply a script filter, with limit and offset parameter , or implement a update server script, and only response with the new data.
$35 USD 5일에
4.0 (1 건의 리뷰)
0.4
0.4
사용자 아바타
A proposal has not yet been provided
$30 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hello Dear AJIS is a software firm working successfully since years and working successful due to expert team of developers and programmers having expertise in various up to date technologies. Developers and Programmers of my firm will provide you the required work with efficient and reliable way. And we are committed until you get fully satisfied from the needs of this project. AJIS is a company worked thousands of clients with 31 Multinational companies as software development section and we have 13 companies on board for our services section. By continuing our best services, I would like to offer you the services of my firm, and choose the best of my skilled worker for your project to provide you all what you need. I believe to create the best working relation with every client I work, with and to create relation for long term work. Contact me soon to get your work done within time limit. Quality of work is guarantee and rates are negotiable, Pay for the quality only when you get satisfied from our work. Regards, AJIS Solutions
$45 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (CANADA)
Quebec, Canada
5.0
25
결제 수단 확인
2월 5, 2012부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.