Find Jobs
Hire Freelancers

Speed up mySQL database

£20-250 GBP

Concluído
Publicado há mais de 4 anos

£20-250 GBP

Pago na entrega
I manage a job-board advertising website which allows users to search through hundreds of jobs. The job-board is hosted on a dedicated VPS, utilises caching and a CDN, however, although all our static pages load fast, attempting to make any job-related search query is very slow. This includes searching for a job or applying filters (e.g. location or salary) to the search results page. All our pages have a low TTFB, but the TTFB when making a search query or applying a search filter is around 8 seconds, which leads me to believe we have an efficient database. I require someone to: 1. Diagnose what is causing the delay and confirm whether it is a result of an inefficient database, 2. Speed up the database. Please note that I am already optimising the database (routinely deleting junk files, transients and file revisions etc.), so I am after someone who can make the database more efficient (e.g. index it for all current and future job posts). Please let me know if you need any additional info or have any questions. Thanks
ID do Projeto: 23917329

Sobre o projeto

15 propostas
Projeto remoto
Ativo há 4 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Having worked on some thousands of performance troubleshootings over the past 20 years, very similar to what you describe, I am reasonably confident I can eyeball the root cause if it is in the MySQL layer in under 2 minutes of logging into the server and either fix it (indexing, query modification) or come up with a proposal for a guaranteed fix (materialized views with triggers) in another 5 minutes. Hence the low quote. And, of course, no-fix-no-fee - in case the problem isn't database related.
£20 GBP em 1 dia
5,0 (7 avaliações)
3,2
3,2
15 freelancers estão ofertando em média £173 GBP for esse trabalho
Avatar do Usuário
Hi There, I am ready to start work immediately. >>> I will completely optimized your website code so that it can be as short as possible with exact features and functionality as I am experienced developers. As Well As... * I will manage Cache properly. * I will Optimized Content * I will Optimized Libraries * I will Optimized HTML * I will Optimized CSS Files * I will Optimized JavaScript * I will Optimized JQuery * I will optimize Images. * I will optimize JavaScript * Optimization of CSS Files with Html others. I have 8+ years of Experience with : Graphic & Web-Design| Bootstrap| Responsive HTML5|CSS| jQuery| Laravel | PHP| Wordpress: wooCommerce| Magento| OpenCart| Prestashop| Joomla| SEO Services. I have completed 800+ Projects over here on Freelancer with all 5 Star rating...without letting down a single Client....As Many Clients are still in touch based on my Working strategies and their satisfaction on their all previous Projects. >>> I have enough expertise to complete your requirement. Let's Do It. LET'S talk in detail about project scope. Please check PMB for more details. I am posting my bid as an expression of interest and appreciate further discussion in private message board. Waiting for your message to communicate further in this regard. With Best Regards, Rohit
£150 GBP em 3 dias
5,0 (967 avaliações)
8,8
8,8
Avatar do Usuário
Hello Hope you are doing well. I have 7 years of experience in MySQL DB management and web hosting. I can handle this project. Regards VishnuLal*
£100 GBP em 1 dia
4,9 (694 avaliações)
7,7
7,7
Avatar do Usuário
hello, I'm a senior Linux administrator in a hosting company. High ttfb for not cached pages can be not only because of MySQL issues. there are some other factors such as iops lack. I can fully diagnose what's going on with vps and only after discussing with you we will apply changes. let's chat
£44 GBP em 1 dia
5,0 (237 avaliações)
6,6
6,6
Avatar do Usuário
Database Expert , i can take care and try to speed up first ........................................thanks
£190 GBP em 2 dias
4,9 (47 avaliações)
6,0
6,0
Avatar do Usuário
Hi, my name is Umair. I've read your post and description of issue you are getting. I can debug your database, check for any vulnerability in it, structure. I've good expertise in designing database structure and got 7 years of work experience. I can also debug your code to check if we can optimize it for any improvement. Looking for your message, thanks!
£200 GBP em 7 dias
4,9 (62 avaliações)
5,7
5,7
Avatar do Usuário
Dear Employer, I am an AWS Solutions Architect and can help you with your project. I have extensive experience with: - Public and Private Cloud infrastructure design, migration (from/to), implementation and support. (Amazon AWS, Google Gloud, Microsoft Azure, etc.) - Network infrastructure (LAN and WAN) design, implementation and support. - Server infrastructure design, implementation, and support. - Virtualization technologies consulting - VMWare, Xen, KVM, etc.. - WiFi Solutions. - Fix Telephony design, implementation, and support. - Security Applications - Antivirus, Anti-SPAM, IDS/IPS systems, DDos Protection. - Automated and Manual security audits. - Proactive and Reactive Monitoring via local or cloud instances. - Creating detailed design documents (HLD and LLD) for every project. Contact me, if you have any questions. Regards, Miroslav Georgiev
£250 GBP em 3 dias
5,0 (20 avaliações)
5,1
5,1
Avatar do Usuário
Hi! I've experience in optimization of sql queries and db structure. For our cooperation I need dump of your db, I mean scripts with db structure and may be some data for testing.
£135 GBP em 3 dias
4,8 (22 avaliações)
4,5
4,5
Avatar do Usuário
Hello, I have diagnosed such issues in a large US based bank before. We need to do a network capture of packets while the transaction in question is happening. Analyzing the capture, we will be able to find out where the delay is happening. It need not be the database. But it could very well be. I hold a PhD in networking and am very well qualified to solve this problem. Kindly assign me the project.
£300 GBP em 7 dias
5,0 (1 avaliação)
3,1
3,1
Avatar do Usuário
Dear Client, I can help you to improve the performance of your database. I have an experience of 10 years in database and I am good in performance tuning. Initiate the chat to know some information and then award me the contract to start working on the task.
£222 GBP em 2 dias
5,0 (2 avaliações)
2,4
2,4
Avatar do Usuário
Hi Need to find long running queries and tune MySQL by increasing innodb buffer size, enable query caching.
£222 GBP em 2 dias
5,0 (1 avaliação)
0,0
0,0
Avatar do Usuário
I read your project discription I have lot experience on database query tuning present I am working on data migration in insurance domina
£166 GBP em 2 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED KINGDOM
Bedford, United Kingdom
5,0
2
Método de pagamento verificado
Membro desde fev. 15, 2020

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.