Tuning of our Mysql 5.5 configuration

₹1500-12500 INR

完了済み

投稿日:

4年近く前

₹1500-12500 INR

完了時にお支払い

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

プロジェクト ID: 25874728

プロジェクトについて

4個の提案

リモートプロジェクト

アクティブ 4年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@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 experience working on AWS cloud. I worked in the following areas. * cPanel/WHM * Plesk * Webmin * Website Panel * Website migrations * Installation and configurations of applications like Wordpress, Joomla, magento, etc * Email server configuration and maintenance * FTP and DNS service configurations * Amazon web services like, EC2, S3, Route 53, VPC, RDS. * Migration Specialist *Postfix Mailserver with spf, dkim and IP rotation. *Nagios Monitoring setup *PCI Compliance *FFMPEG server setup *Imagemagick install. *MySQL , MariaDB database administration *DNS server and nameserver configuration *SSL installation/Lets Encrypt Please give me a chance to work with you. I am sure that you will be 100% satisfied

₹9,999 INR 7日以内

5.0

(65 レビュー)

5.8

この仕事に4人のフリーランサーが、平均₹9,500 INRで入札しています

@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

₹6,000 INR 1日以内

5.0

(19 レビュー)

4.5

@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 now and would like to discuss further on it. Thanks

₹12,000 INR 7日以内