I gang

MYSQL CONFIGURATION EXPERT NEEDED

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.

Evner: MySQL, Linux, PHP, Apache, Database Administration

Se mere: php expert needed, joomla expert needed, web security expert needed, join freelancer, php freelance jobs, wordpress freelance jobs, php developer freelancer, freelancer login, freelancer jobs, freelancer free account, php development projects, photoshop expert needed san jose, volusion expert needed, digg expert needed, linux expert needed, php5 mysql configuration windows, mysql configuration cpu, mod rewrite expert needed, zen cart expert needed, php web scraping expert needed

Om arbejdsgiveren:
( 0 bedømmelser ) Central Square, United States

Projekt ID: #26525186

Tildelt til:

(10 bedømmelser)
4.3

16 freelancere byder i gennemsnit $20/time for dette job

seekdeveloper

Hi, I have read your post and understood your requirement. Looking for the freelancer to work on your next project? Or just need some issues/bugs/fixes ASAP? I have 11+ years of software experience in fortune 500 comp Flere

$25 USD / time
(106 bedømmelser)
8.7
tangramua

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 Flere

$25 USD / time
(108 bedømmelser)
7.5
(340 bedømmelser)
6.9
Wipitech

How are you! I have read your requirement and would develop the project for you exactly in the way you need it. I will provide an elegant and clean and pixel perfect design that will keep your target audience attracted Flere

$20 USD / time
(5 bedømmelser)
6.0
milosjovanovic88

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 Flere

$20 USD / time
(6 bedømmelser)
5.4
maverickindia

Hi There ! I can work in 8$ per hour I have read your requirement carefully and got total understanding of the project .kindly discuss your project in detail with [login to view URL] fake commitment,100% quality work. I have more Flere

$15 USD / time
(51 bedømmelser)
5.2
boomyjee

Hi, I am a full-stack developer with 10 years of PHP (Laravel, Symfony) experience. I use PHP, MySQL, HTML5, CSS3, JavaScript, AJAX, GIT on a daily basis. I have strong knowledge of Apache. I have implemented and suppo Flere

$30 USD / time
(1 bedømmelse)
5.1
rafiabdal

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 Flere

$15 USD / time
(5 bedømmelser)
2.6
vw8067039vw

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 / time
(6 bedømmelser)
1.9
vasudevmeena77

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 Flere

$15 USD / time
(1 bedømmelse)
1.2
manu83tudo

- previous experience in such topics; - eager to discuss a lot in this chat stream; - degree stats/maths;

$15 USD / time
(3 bedømmelser)
0.7
bizzmanweb

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 sour Flere

$16 USD / time
(0 bedømmelser)
0.0
ZakariaOmeiri

Greeting, My name is Zakarya, full stack developer. I have read your job description and it is very interested to me due to my previous work similar to yours. [login to view URL] [login to view URL] Flere

$20 USD / time
(0 bedømmelser)
0.0
Jayant222

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 / time
(1 bedømmelse)
0.0
girishnbr

I can handle MySQL related work. Can effectively solve the problem. Kindly consider my bidding for the task.

$22 USD / time
(0 bedømmelser)
0.0