Fix Database errors (MySQL pro needed!!)

Færdiggjort Opslået 2 år siden Betalt ved levering
Færdiggjort Betalt ved levering

Hey I'm getting errors in my database that need to be fixed asap.

Here are some error logs:

Oct 20 10:02:07 node5512 kernel: Out of memory: Killed process 314 (mysqld) total-vm:3730532kB, anon-rss:221188kB, file-rss:0kB, shmem-rss:0kB, UID:27 pgtables:852kB oom_score_adj:0

Oct 20 10:02:14 node5512 kernel: Out of memory: Killed process 528 (mysqld) total-vm:3729908kB, anon-rss:207960kB, file-rss:0kB, shmem-rss:0kB, UID:27 pgtables:884kB oom_score_adj:0

Oct 20 10:02:17 node5512 kernel: Out of memory: Killed process 750 (mysqld) total-vm:2526244kB, anon-rss:180980kB, file-rss:0kB, shmem-rss:0kB, UID:27 pgtables:588kB oom_score_adj:0

Oct 20 10:02:19 node5512 kernel: Out of memory: Killed process 882 (mysqld) total-vm:2526244kB, anon-rss:175880kB, file-rss:0kB, shmem-rss:0kB, UID:27 pgtables:584kB oom_score_adj:0

MySQL processes were killed, and since they were running that has caused the databases to crash. The high memory usage spike is caused by slow queries made to the database. MySQL queries should be executed for under a second which is the regular operation of the MySQL service. If they take more than one second, that means that there is an issue with the MySQL database or its operation. When queries stack up, they create a bottleneck in the MySQL service and the server continues to invest resources in order to complete the MySQL queries in the queue.

For the last 5 days, there have been 38 such queries generated by the database.

I have an error log you can look at.

MySQL PHP Linux Database Administration System Administrator

Projekt ID: #31879065

Om projektet

14 bud Remote projekt Aktiv 2 år siden

Tildelt til:

udayarpandey2022

Greetings! I think I would be able t fix the problem. Lets do it. Thank you!

€30 EUR in 7 dage
(339 bedømmelser)
6.7

14 freelancere byder i gennemsnit €27 timen for dette job

vw580939vw

Dear Sir, At first glance, this is very much doable with us. Kindly provide website access along with fixing requirements details, we can review and estimate closely. We offer EUR8/hour of working and bid for 1 hour f Flere

€10 EUR in 3 dage
(181 bedømmelser)
7.5
aftabyounas

Hey I am a Full stack developer and ahve great command with database as well so willing to checkout your issue and fix it for you so feel free to contact

€30 EUR på 1 dag
(413 bedømmelser)
7.6
sabdsouza

Hello, I can fix the mysql error , kindly let me know if I can assist you with this project. Regards,

€25 EUR på 1 dag
(264 bedømmelser)
7.1
kuldeepvk

Hi, I will fix database error now.I have 13 years of experience in Linux servers as well as windows server and services such as cPanel/WHM, Plesk, Virtualmin LAMP Stack, Tomcat, Mysql/Mairadb, Zimbra, Postfix mail se Flere

€25 EUR på 1 dag
(590 bedømmelser)
7.4
machexport

Hi, I can help you fix bug on your website. Here's the link to my portfolio https://www.freelancer.com/u/machexport Let's discuss and move ahead with this project. Thank you

€50 EUR in 3 dage
(10 bedømmelser)
6.3
kamransiyal9

HI! I am an expert web programmer. I am familiar with Laravel and I have a lot of work experience in Laravel, Codeigniter, PHP, Wordpress, JavaScript, HTML, Vuejs, Reactjs, React Native, and MySQL. I can start right aw Flere

€30 EUR på 1 dag
(55 bedømmelser)
5.8
valeriypanovich1

Hi ⭐⭐⭐⭐⭐ PHP/Mysql Expert ⭐⭐⭐⭐⭐ I've seriously read your post and I have understood what you need. I have strong experience with mysql query so, I think we should check all queries which will take heavy times in the c Flere

€25 EUR på 1 dag
(21 bedømmelser)
5.1
nidhibill91

hi, i can solve these database errors as per your requirement, in a very perfect manner as you want, can we connect on chat for further more details, i can start right away

€20 EUR in 2 dage
(23 bedømmelser)
4.6
ahmedkamran9

Hi, I can help you with that if you want. I’m a professional DB developer. I hope to work with you Regards, Kamran

€30 EUR på 1 dag
(3 bedømmelser)
3.6
KellyAlwanga

I am Kelly , and I would be honoured if considered for this position. I am a great multi-tasker with a keen eye for detail. I am also highly motivated and guaranteed to inspire confidence in any employer. My FREELA Flere

€20 EUR på 1 dag
(7 bedømmelser)
2.8
nadezhda319

Hi there! Kindly allow me so that we can discuss over it NOW. I would be a pleasure to assist you on your project. Thanks & Regards

€30 EUR på 1 dag
(5 bedømmelser)
2.4