Bash script

- bash script endless loop

- got log file rotating if size reached *.log -> *.log-prev

- log adding about 100 lines per second

- need to save all data to mysql db continuously every X seconds

- log lines use delimiter "|"

need a soltion for that + make easy bash script

- option A - tail logfile | while read line do mysql INSERT

- disadvantage can be very cpu intensive because with every insert it login to db and logout

- option B - LOAD DATA LOCAL INFILE 'logfile'

- advantage - fast insert

- disadvantage - must remember last written row from logfile, after X seconds must write data AFTER last row

- if logfile rotates we dont have last row

- option C - ???

Need experienced coder which will do very easy bash script for this purpose.

thank you

Taidot: Bash Scripting, Scripting

Näytä lisää: bash script if, bash script for loop, bash scripting cheat sheet, bash script extension, how to run a bash script, bash -c option, bash scripting tutorial pdf, bash script arguments, bash script kill process cpu time, cpu usage bash script, bash script cpu, bash script insert data mssql, insert mysql bash script, insert bash script output mysql, bash script insert database, bash script insert mysql data, parse line bash script, mysql insert bash script, issue load data local infile bash, mysql bash script insert

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #15106714

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello I can write such script Message me, we can discuss more Regards

$50 USD 1 päivässä
(1 arvostelu)
$66 USD 10 päivässä
(0 arvostelua)

I'm working in hosting company as UNIX administrator 7 years, therefore I can help you with your problem. Важливі навички та досвід I writing on bash and have many my .sh scripts Запропоновані поетапні платежі Lisää

$45 USD 3 päivässä
(0 arvostelua)

I am confident that we can use optioin B - by inserting to the database collection of logs at once, this is the best option. Relevant Skills and Experience I am currently new to freelancer but I have been wroking on u Lisää

$50 USD 10 päivässä
(0 arvostelua)

can you send me a sample log file? some lines and the database structure? Relevant Skills and Experience bash script Proposed Milestones $70 USD - full project

$70 USD 1 päivässä
(0 arvostelua)

I have a lot of experience in system administration and I will help to solve this task. Stay tuned, I'm still working on this proposal.

$35 USD 1 päivässä
(0 arvostelua)

Hello, let discuss about this project. i'm very interrested and wish get this project for my first time here Relevant Skills and Experience I'm working as telco programmer, we create microservices running in centos. I Lisää

$66 USD 10 päivässä
(0 arvostelua)

i am a cheap script expert

$50 USD 2 päivässä
(0 arvostelua)