Find Jobs
Hire Freelancers

MYSQL CONFIGURATION EXPERT NEEDED

$15-25 USD / hour

Σε Εξέλιξη
Αναρτήθηκε πάνω από 3 χρόνια πριν

$15-25 USD / hour

We have a high load server that is constantly going down. mysql tables are crashing multiple times a week (sometimes more) and are requiring to be repaired (we even setup a script to auto-repair tables because it happens so often). The server is a high performance server with plenty of RAM but is still constantly having issues. Also, apache is often crashing and often when trying to reload httpd we see: Warning: The unit file, source configuration file or drop-ins of [login to view URL] changed on disk. Run 'systemctl daemon-reload' to reload units. The database has 112 tables. Some of the tables have millions of rows. Most of the tables are MyISAM but the ones with a larger amount of rows are InnoDB. The tables have indexes setup. When having issues and checking top, normally mysql is 80-150% usage and memory is at 4-15% usage. Like at the time of writing it the server is "ok" but mysql has 10-40% CPU usage and only 2-4% memory usage. We need help with the following items: -- Optimizing mysql via the /etc/[login to view URL] file (and all sub files for mysql configuration) -- To know what we need to do to make the site scalable (do we need to put mysql on a separate server, setup load balancing, is it merely configuration, etc)? -- We need help identifying where the bottlenecks are. Example, maybe there is a query that is missing an index, but we are not seeing it. We have mysql_slow_query_log setup but it seems largely useless as the server gets a large load and then basically every query is slow, queries that are not an issue at all, and they end up on the report making the report hard to use to identify issues. We do not use CPanel/WHM/etc, everything is done in linux. We need to understand what is being done. We need you to explain briefly what/why you did changes. I am writing this for the owner of the site. I am the writer of the script. I am a php expert with enough linux knowledge to get what I need done. I am not a linux expert but have worked with it for over a dozen years, and understand configuration for mysql, apache, bind, postfix, etc. We need someone that is a specialist with these things, most specifically mysql, and that clearly has more knowledge than I have. The "linux experts" with our hosting company are far from experts and I have more knowledge than them for these specific issues. We have hired them a couple times in the past and they have proved their incompetence, and we are not looking for someone that is on the same level as they are, we need a specialist. For your bid, including a brief description of something you would do to let me know that you are competent would greatly increase your chances of being rewarded the project. I don't need you to say what fixes you would do, but to say enough to let me know you understand the issue, have worked on projects like this, and that you are competent enough to solve our problems or advice us what we need to do so our server operates smoothly.
Ταυτότητα εργασίας: 26525186

Σχετικά με την εργασία

11 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 4 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
11 freelancers δίνουν μια μέση προσφορά $18 USD/ώρα για αυτή τη δουλειά
Avatar Χρήστη
Hello,   Our team has a huge experience in PHP, Linux, Apache, MySQL, Database Administration, as a result, we can successfully complete this project. Having the required skills, we will be glad to help you.   We have 20 years of strong experience in outsourced web development, software development, managed services, and we provide 24/7 technical support. As well as we guarantee Canadian quality.   Please, review our profile to find detailed information about our company and our portfolio. Feel free to contact us and discuss all the details. Best regards, Sales department Tangram Canada Inc.
$25 USD σε 5 ημέρες
4,9 (143 αξιολογήσεις)
7,7
7,7
Avatar Χρήστη
Hi, Stay safe, Stay healthy. Due to your listed requirements closely match with my skills, I express my interest in your posting job. I am confident my specialized knowledge of MySQL / Web Hosting / Cpanel / WHM would enable me to contribute to your project. I would be thankful if you give me a chance to discuss more. Looking forward to hearing from you. Thanks.
$20 USD σε 40 ημέρες
5,0 (7 αξιολογήσεις)
5,5
5,5
Avatar Χρήστη
Hello I am windows and Linux administrator. I will complete your work within time and budget. I have experience in many projects like this. Thanks Have a good day
$15 USD σε 40 ημέρες
4,9 (17 αξιολογήσεις)
3,2
3,2
Avatar Χρήστη
Hello, I hope you're doing great !! I would like to express my interest & enthusiasm for the assignment posted by you. I am pretty much clear about the scope of work. I have excellent experience in Website Designing/Development. I believe my abilities would be perfect for your venture. I can finish this job within the necessary time frame. I am professional website designer/developer. I have years of experience in this fielded and can provide you my past sample work. I will be serving you with all my hard work and skills. My Key Specialties are:- • PHP/MySQL • Wordpress , CakePHP Framework,YII,Codeigniter,Magento,Shopify • UI/UX Design, PSD To HTML with HTML5 and CSS3, Good Design Skills. • Javascript, jQuery, AJAX, Cross Browser Domain. • Javascript Animation, Object Development. I am looking forward to hearing from you soon. Thank you for considering my cover letter. Thanks Mohd
$15 USD σε 40 ημέρες
4,9 (5 αξιολογήσεις)
2,6
2,6
Avatar Χρήστη
Hi, I am available now. I’m Vasudev Meena, I can do this work at very low price $3/hr. I have gone through your project description, and I am a proficient Web developer 8+ years of extensive experience. I am expert in the skills that You want for this project. I have developed a great ability in many fields such as:- All of our programming skills: *Front-end: - HTML, HTML5, JSON. - JavaScript (Ajax, Angular1, Angular2, ReactJS, jQuery). - CSS, CSS3, Twitter Bootstrap, - Mobile apps: React Native, Swift, Objective-C. - Page speed optimize -WordPress, Magento *Backend Skills: - PHP (Framework: Codeigniter, Yii, Laravel, Cakephp), Node.js. - MVC, OOP, CURL, MySQL, Rest APIs, Selenium. *Mobile App Development (Android, IOS, Native) *Graphic Design skills: - Logo, Banner, Poster, Flyer, Book Cover, - Motion Design, GIF, Caricature, - Image Editing, Image Retouching, You can freely contact me to know more about services or can ask for a free report or ask a detailed proposal with a quotation. I am eagerly awaiting a response from your end. Warm Regards Vasudev Meena
$15 USD σε 8 ημέρες
4,6 (1 αξιολόγηση)
1,2
1,2
Avatar Χρήστη
Hello, I read your requirements and Understand Very well And ready to start work from now . I have developed & delivered Web database applications Mobile App development for enterprises & companies, using open source language PHP, MySQL, HTML 5, CSS3, AJAX, JSON, XML, etc. Coding, project and team management is my passion. My expertise comprises of CMS and Frameworks like, content writing, seo, smm, Wordpress, Cake PHP, Laravel, Magento, OS Commerce, Zen Cart, Codeigniter, Joomla, YII Framework, , MVC frameworks, Google Maps, Payment gateway integration, Familiarity with Linux environment and Apache, Javascript, Jquery, Ajax, xHTML, CSS/CSS3, HTML5, XML, XSLT, Flash, Git & SVN. Throughout these years, apart from advanced coding skills; I have good hands on experience in adding value to customer via effective I look forward to hearing from you. Thanks & Regards,
$16 USD σε 40 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hi there, I am an expert in SQL . I have gone through the description on your project and will be able to finish before the deadline. Thanks Jayant
$15 USD σε 40 ημέρες
0,0 (1 αξιολόγηση)
0,0
0,0
Avatar Χρήστη
I can handle MySQL related work. Can effectively solve the problem. Kindly consider my bidding for the task.
$22 USD σε 4 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Lacona, United States
0,0
0
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Ιουλ 11, 2020

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.