MYSQL Expert (log error open-files-limit=10000 issue)

$15-25 USD / hour

Avslutat

Publicerad

över fyra år sedan

$15-25 USD / hour

DESCRIPTION: MYSQL process is consuming whole server CPU, showing - log error open-files-limit=10000 issue recursively running in the loop STORY: Back-end: MySQL database Front-end: PHP Server specs: Godaddy dedicated server 4 CPU Cores @ 3.1 GHz 16 GB memory 2 TB storage CentOS 6 + cPanel We are a team of developers and we are using MYSQL DB for our web and mobile application. we have one table which has 1.1 GB data and since the table has reached above 1 GB we are facing this issue: - One of the MYSQL processes is consuming the whole CPU and keeps trying to write in MySQL log error file which shows limit= 10000 and this process is hitting recursively in every millisecond. We tried killing it but it restarts again automatically. [please see the first record of screenshot/image] We are seeking a MYSQL DB expert who shows us: 1. How to stop above mentioned process. 2. What we are doing wrong and how to correct it. 3. How to manage big DB tables above than 1 GB in the future for seamless operations.

Project ID: 23551304

Om projektet

13 anbud

Distansprojekt

Senaste aktivitet fyra år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

13 frilansar lägger i genomsnitt anbud på $19 USD/timme för detta uppdrag

@vili1977

Hello. I would like to help you with fixing mysql error with openung limutation files 10000. I have experience. Please read my feedbacks. Thank you.

$15 USD Om 1 dag

4,9

(1124 omdömen)

7,7

@tangramua

Dear Sir, Our team has a huge experience in PHP, System Admin, 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 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 details. Best regards, Sales department Tangram Canada Inc.

$22 USD Om 5 dagar

4,6

(217 omdömen)

8,3

@arkac

Hi , I have been working with WHMa and CPANE for over 10 years . I have overall 12 years experience with Linux and LAMP systems. Please let me know if I can assist you. Regards, Arka

$20 USD Om 2 dagar

5,0

(62 omdömen)

5,4

@pgsbin

I can help with this problem. Your server has a limit of opened files. This can be changed in the configuration files. I can also help you configure MySQL to get better performance on this server and then show you how to optimize your database and queries.

$15 USD Om 20 dagar

5,0

(2 omdömen)

1,0

@nirmalsingh1818

Hi My name is Nirmal Singh, I have more than 9 Years of Experience in Linux Server client platform as a Sr Linux System Administrator . I can solve your issue. I am very excited to work for you i can say one thing you will get 100% satisfaction with me Lets discus and move forward

$16 USD Om 40 dagar

5,0

(1 omdöme)

0,4

@maheshbase2sky

You can allow me to access your service , I would check and see what can be the issue.

$22 USD Om 10 dagar

0,0

(0 omdömen)

0,0

@rsiluvainathan

first we need to investigate the logs and tune it based on the server resourses. 1G table is not a problem at all. something is misconfigured I guess.

$20 USD Om 40 dagar