Optimize query and configure ProxySQL or MaxScale in MariaDB server

$25-50 USD / hour

Mbyllur

Postuar

almost 2 years ago

$25-50 USD / hour

I have a query that is taking 4-5 seconds to finish in mytop. This query is running multiple times at the same time and because of this is generating a slow load behavior in our backend. I need you to find if it's possible to optimize the query so it runs faster by either adding extra index or tweaking the MariaDB config. If none of that works I will need to setup either ProxySQL or MaxScale to cache this query and prevent to generate CPU usage and generating the slow load behavior explained above. No server access will be given, you will need to work through me.

Database Administration

ID e Projektit: 33951292

Rreth projektit

9 propozime

Projekt në distancë

Aktive 2 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

9 profesionistët e pavarur ofrojnë mesatarisht $50 USD/orë oferta për këtë punë

@AwaisChaudhry

Hello, Upon reading the job details I would say that all the required skills MariaDB, Linux, System Admin, MySQL and Database Administration fall under my skills. I work on freelancer full time and I believe I can do this job if I get all the detailed requirements. Please check my portfolio as well: https://www.freelancer.com/u/AwaisChaudhry?w=f Looking forward to your response. Awais

$50 USD në 23 ditë

5,0

(16 përshtypje)

6,1

@abhisaini0188

Hello I have understood the requirements of your project and I can help you to complete your website and convert it to SEO. I have expertise in SEO with 5+ years of experience in Optimization. ON-PAGE OPTIMIZATION: -Website analysis report -Keyword Research and Analysis -Title Tags -Meta Description Tags -URL Optimization -Robots Optimization -Optimization of Alt and Title tags. Also, set up Google Analytics optimization for the website. Off-Page Optimization: -Social Bookmarking -High-Quality Links -Local citation -Image submission -Classified Posting -Directory submission -PDF submission. Please start a message board, so we can discuss more in detail. Thank you.

$48 USD në 40 ditë