Parse log to sort entries by number of occurrences

The purpose for this is to use as a very simple near-real-time analytics system by generating a list of 20 most accessed urls from different users within the last hour.

I have a live log file, generated by the webserver, containing multiple rows of three key-value pairs: {"date":"[x]", "user":"[y]","slug":"[z]"} - currently ndjson (example attached) but I can output it in any convenient format, for parsing as easily as possible. The log is expected to have around 10.000 entries per hour and the machine is 2CPU 2GB, so kindly advise on estimated CPU load for the job.

I want a php script (can use wordpress hooks) that will:

1. Run in the background as a cron job every 15 minutes;

2. Start by deleting all log entries older than one hour;

3. Find the 20 slugs with the most entries from non-repeating users;

4. Write the 20 slugs to a database field as a string (such as "slug-1,slug-2,slug-3,slug-4").

Fähigkeiten: PHP, MySQL, WordPress

Mehr darüber parse log file enter information database, java program parse log files create report, perl script parse log mysql, sort entries table excel, java code parse log files error, dotproject sort project number, java program parse log file, parse log file java, java parse log, bash script parse log file, bash parse log file, display parse log file, bash parse log, bash parse log starting, parse log files build database, best parse log files, counting number characters string assembly language, php parse log file, parse log database

Über den Arbeitgeber:
( 3 Bewertungen ) Bucuresti, Romania

Projekt-ID: #21864243

Vergeben an:


Hello Sir I can do this php script perfectly please reply I can start working now waiting for you I can provide 100% perfect output

€30 EUR in 1 Tag
(55 Bewertungen)

8 Freelancer bieten im Durchschnitt €32 für diesen Job


Hello there. I can write this PHP script to parse and sort enteries as mentioned above...............

€30 EUR in 1 Tag
(325 Bewertungen)

Hi, I'm a WordPress expert and FULL Time Developer. I've been working on WordPress since last 8+ years & also developed 500+ WP projects successfully. I can start work immediately now for you and can provide you perf Mehr

€25 EUR in 1 Tag
(42 Bewertungen)

Hello Yes, I can develop your wordpress website as I am perfect for this project according to your requirement. I am a full-stack Wordpress developer with extensive 5+ years of experience in websites, theme & extension Mehr

€50 EUR in 1 Tag
(7 Bewertungen)

Hi there, I have completed similar tasks before. If you can share some more details. I believe we can help you to complete this project as per your requirements. Please get back to me if interested to discuss. Regard Mehr

€30 EUR in 3 Tagen
(14 Bewertungen)

Greetings, My name is Page and I have been working from last 8 years in IT field. I am very much interested in your project and would like to invite you for further discussion over chat board. Waiting for your positi Mehr

€30 EUR in 7 Tagen
(5 Bewertungen)

Hello Sir/Mam, APComp is one of the best providers of software development and other professional IT services. We have over 5 years in the software development field and a long list of satisfied customers. We know tha Mehr

€30 EUR in 7 Tagen
(21 Bewertungen)

Hi, Thanks for the opportunity to bid on your project. I am a PHP/Perl developer with over 15 years experience. I have written numerous systems for clients over the years. I am also familiar with WordPress and writin Mehr

€30 EUR in 3 Tagen
(3 Bewertungen)