Tuning of our Mysql 5.5 configuration

Completato Pubblicato 3 anni fa Pagato alla consegna
Completato Pagato alla consegna

We have a 94 GB RAM dedicated server hosting a popular website that uses apache, php and mysql. The configuration for mysql has been more or less stable for many years but since the last couple of weeks, mysql becomes unresponsive all of a sudden despite no immediate obvious increase in the number of queries. The site cannot connect to mysql for a number of minutes ranging from 2 to 60 and then everything goes back to normal. The mysql configuration has been based on copy paste jobs from the Internet based on various recommendations but is not based on careful evaluation of server capacity and mysql performance parameters. We cannot make immediate changes to too many queries in the website since a recoding project is anyway underway. What we need is for someone to take a look at the server and mysql configs and work with us over a couple of days to fine tune the mysql config.

MySQL

Rif. progetto: #25874728

Info sul progetto

5 proposte Progetto a distanza Attivo 3 anni fa

Assegnato a:

vinnie6669

I am a Linux admin have 10 years of experience in this field. I worked in webhosting industry and manage datacenter from remote. I will check this and give you recommendation for mysql config changes I also have experi Altro

₹9999 INR in 7 giorni
(29 valutazioni)
4.8

5 freelance hanno fatto un'offerta media di ₹9600 per questo lavoro

anirbandutta999

Hello..I am an experienced cloud server engineer ...I can fix the issue with mysql slow down ....I would suggest you to implement RADIS and migrate to mariadb if your application supports .......Let me know in chat

₹6000 INR in 1 giorno
(10 valutazioni)
3.2
sonishubham

Greetings, I have been working in IT industry from last 8 years and delivered many projects successfully. Your project fit my skills and experience, so I would like to discuss with you on its details. I am available Altro

₹12000 INR in 7 giorni
(5 valutazioni)
2.6
smruti19936

i have read your jib descritpion and i can do this job i have good experience in my sql and web design.

₹10000 INR in 3 giorni
(0 valutazioni)
0.0
alekslemann8888

Hi dear I have rich experience with mysql database. if you want ,we could discuss more about your project Good luck

₹10000 INR in 1 giorno
(0 valutazioni)
0.0