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. For 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

Se mere: mysql job queue, mysql jobs for freshers, php freelance jobs, php developer freelancer, wordpress freelance jobs, mysql job scheduler, entry level mysql jobs, mysql jobs salary, php expert needed, joomla expert needed, web security expert needed, 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:
( 1 bedømmelse ) United States

Projekt ID: #26524907

34 freelancere byder i gennemsnit $24/time for dette job


Hello. I would like to help you with mysql optimization. I have many projects with optimuzation before. Please read my feedbacks. Thank you.

$15 USD / time
(873 bedømmelser)

Hello,   Our team has a huge experience in PHP, Linux, Apache, MySQL, 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 experi Flere

$25 USD / time
(107 bedømmelser)
(583 bedømmelser)

Hi John J V.! I read all descriptions and I am very interested in your project. My budget is negotiable. Please let's discuss in detail. Thank you so much! Best Regards Flere

$17 USD / time
(50 bedømmelser)

Hi, I have expertise in hosting.I will check server and do the best configuration as required.I will -- Optimizing mysql via the /etc/[login to view URL] file (and all sub files for mysql configuration). I will also assist in "- T Flere

$15 USD / time
(431 bedømmelser)

Dear Sir/Madam, Thank you for this wonderful opportunity. I am keenly considering your job post including these skills.I am working as team leader in A4Logic it is software and web solution company we are operating f Flere

$20 USD / time
(154 bedømmelser)

Hello, I understand your requirement and can help you in this task as i have strong hand in Database/ mysql. We are Professional 8+ years experienced developers and designers with similar expertise. You can check our Flere

$25 USD / time
(103 bedømmelser)
(355 bedømmelser)
(269 bedømmelser)

Hey look, I know there are bunch of people here saying that they can fix the issue but I really manage big mysql databases with one database over 80+GB in size spread over 5 dedicated servers. [login to view URL] Flere

$35 USD / time
(21 bedømmelser)

HI, I can help you to fix your Mysql and Apache crashing issue , I can also Optimize and harden your server for a concrete resolution. I m already doing this for my number of clients. Please initiate a chat for furth Flere

$23 USD / time
(50 bedømmelser)
(290 bedømmelser)

Hello, I can help you with MYSQL CONFIGURATION. I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this Flere

$25 USD / time
(76 bedømmelser)
(36 bedømmelser)

Teoh here, a senior web developer and I am here to build a perfect project together. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] I Flere

$20 USD / time
(5 bedømmelser)

Hello sir , i can do this job perfectly right now , i am full time freelancer and available for more then 40hour/week . i can achieve what you looking for . please contact me , i will start right now Note : Bid amo Flere

$20 USD / time
(40 bedømmelser)
(15 bedømmelser)

Hello Client, How are you? *** 24hours Communication, If you need, I can work as full time *** I am good at WEB server configuration. I’ve carefully gone through your job post. I feel very confident about your project Flere

$20 USD / time
(4 bedømmelser)

Hi, I will audit complete configuration of the server and will check the issue with server crashing and apache configuration. I do have more than 8 years of expertise in web hosting, server setup, server configuration Flere

$30 USD / time
(29 bedømmelser)

Dear Sir, I am interested of your task. I read your project post fully. Seems Interesting your case. currently I am maintaining Mobile Operator VAS service MySQL Database server. I maintain huge data in Database. I can Flere

$20 USD / time
(9 bedømmelser)