MySQL Crashes Daily - repost

Closed

Description

MySQL crashes daily at exactly 17:00 (server time). The website freezes and nothing seems to work. Now I to reinstall the database from a backup to restart the website.

I am using MySQL with InnoDB and it seems that something locks the database at the same time always. The website makes a lot of writes and reads and probably there is an issue between InnoDB and MyISAM in handling of data.

Is there anybody who can identify what causes the lock and remove it?

This is a dedicated server that runs Apache and Nginx.

Skills: Database Administration, Linux, MySQL

See more: mysql backup, apache to nginx, linux mysql backup, mysql nginx, mysql lock, nginx linux, mysql dedicated server, dedicated mysql, nginx apache linux, nginx apache, backup mysql, linux server nginx, linux nginx, website makes daily, reinstall website, apache nginx mysql linux, backup dedicated server, nginx dedicated, apache always, identify mysql database, restart mysql server, reinstall mysql linux, 2013 mysql, mysql remove, mysql 2013

Project ID: #4214248

18 freelancers are bidding on average £37 for this job

linuxfreak1985

Hi there, i am very interested to complete this project. please see my past reviews lets complete this project

£30 GBP in 2 days
(131 Reviews)
6.5
shakoush2001

Hi I am a CISSP,RHCE,CCNA,MCSA,Linux+ and a CEH. I do have 7+ years experience in System Administration . I have experience in a high availability environment with 100+ servers and more than 500 000+ subscribers, I kno More

£50 GBP in 2 days
(57 Reviews)
6.2
watsysgroupvw

Hi There! I am a certified Linus administrator and have over 10 years experience with MySQL databases. If the time your server crashes is that reliable, the it's likely that you have a cron job or some other schedul More

£30 GBP in 3 days
(40 Reviews)
5.7
ezbik

I have great experience in tuning Mysql. I will review its log & will view running mysql processes and suggest a solution.

£35 GBP in 1 day
(52 Reviews)
5.0
morff

Hi, i'm skilled developer and administrator, and i will gladly help you resolve your issue. I will need some administrator level access to your server to examine what's the issue. If you have any question or more infor More

£30 GBP in 1 day
(37 Reviews)
4.9
vilce

Hello. I can help you with mysql issue.

£30 GBP in 1 day
(60 Reviews)
4.1
mohsenshilivw

Hi, i can help you,ready to start now. thanks.

£30 GBP in 0 days
(18 Reviews)
4.1
technofreakz

I am a Linux Consultant, I can fix mysql locking issue..

£30 GBP in 1 day
(17 Reviews)
4.0
kirilpanchev

Dear sir, I have over 10 years of experience in Linux Administration and Web Development including PHP, Smarty, MySQL, jQuery, etc. Also I am Zend Certified PHP Developer (ZCE). I can help you out with your troubles. L More

£30 GBP in 2 days
(12 Reviews)
3.7
tecsysindia

We're interested in your project and we're available 24x7.

£30 GBP in 1 day
(11 Reviews)
3.7
goodperlcoder

Hi! I ready to start explore it - like cron' works, mysql backups, etc.

£33 GBP in 1 day
(6 Reviews)
3.7
webdesignegor

Hi! I can handle this in a few hours. I can investigate slow queries in your MySQL db and also fix your tables in database. I think this is should help. If you have any questions, feel free to contact me an More

£30 GBP in 1 day
(4 Reviews)
2.8
dbahut

I believe nobody has a straightway solution so i need to watch your server till 17:00 (server time) for the analysis purpose then only i would be able to provide you a solution. I have placed my bid for a 2 day More

£30 GBP in 2 days
(0 Reviews)
0.0
Lalitjain786

Sir, we are the group of it professionals having sharp experience . we have Php developers, Flex developers ,Dotnet developers, Magento developers, Java developers,SEO experts, server admin and all type of work in It i More

£45 GBP in 7 days
(0 Reviews)
0.0
lilHermit

UK linux consultant available immediately.

£75 GBP in 1 day
(0 Reviews)
0.0
mouVo1P

Greetings , I can do it for you .

£70 GBP in 1 day
(0 Reviews)
0.0
mnspl

Hello, Greetings From Magnum! After initial reading of your posting, we feel that there might be some sql query running on the server, which is either eating up resources drastically, leaving no memory other proces More

£35 GBP in 2 days
(0 Reviews)
0.0
marianobuglione

Dear, I have a lot of experience conducting Root Cause Analisys in production environments running Web Apps with MySQL DB's with huge websites like OpenEnglish or SocialSphere.com. Pleaswe, let me know if I can help yo More

£30 GBP in 2 days
(0 Reviews)
0.0