Project

Profile

Help

Task #7533

write data from json file to db

Added by Mark Zaslavskiy over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
High
Category:
performance
Sprint/Milestone:
Start date:
14.09.2016
Due date:
% Done:

0%

Estimated time:
Target branch:
Test scenario:

https://github.com/OSLL/mdbci/pull/307

Run

./scripts/benchmark_parser/write_benchmark_results.rb -i scripts/benchmark_parser/test_data/7533.json -e env

Expected result (first value in VALUE section may differ for particular runs)

parse_json_file scripts/benchmark_parser/test_data/7533.json
validate_hash
build_params
benchmark_results
write_results_to_db {"build_params"=>{"jenkins_id"=>"jenkins_id", "start_time"=>"start_time", "box"=>"box", "product"=>"product", "mariadb_version"=>"mariadb_version", "test_code_commit_id"=>"test_code_commit_id", "product_under_test"=>"maxscale", "job_name"=>"job_name", "machine_count"=>5, "sysbench_params"=>"sysbench_params", "mdbci_template"=>"./scripts/benchmark_parser/test_data/7533_mdbci_template", "test_tool"=>"sysbench", "target"=>"target", "maxscale_commit_id"=>"maxscale_commit_id", "maxscale_cnf"=>"./scripts/benchmark_parser/test_data/7533_maxscale_cnf"}, "benchmark_results"=>{"OLTP_test_statistics_queries_performed_read"=>1, "OLTP_test_statistics_queries_performed_write"=>2, "OLTP_test_statistics_queries_performed_other"=>3, "OLTP_test_statistics_queries_performed_total"=>4, "OLTP_test_statistics_transactions"=>5, "OLTP_test_statistics_read_write_requests"=>6, "OLTP_test_statistics_other_operations"=>7, "OLTP_test_statistics_ignored_errors"=>8, "OLTP_test_statistics_reconnects"=>9, "General_statistics_total_time"=>10, "General_statistics_total_number_of_events"=>11, "General_statistics_total_time_taken_by_event_execution"=>12, "General_statistics_response_time_min"=>13, "General_statistics_response_time_avg"=>14, "General_statistics_response_time_max"=>15, "General_statistics_response_time_approx___95_percentile"=>16, "Threads_fairness_events_avg"=>17, "Threads_fairness_events_stddev"=>18, "Threads_fairness_execution_time_avg"=>19, "Threads_fairness_execution_time_stddev"=>20}}
write_to_performance_test_run
INSERT INTO performance_test_run (jenkins_id, start_time, box, product, mariadb_version, test_code_commit_id, job_name, machine_count, sysbench_params, test_tool, product_under_test, mdbci_template) VALUES ('jenkins_id', 'start_time', 'box', 'product', 'mariadb_version', 'test_code_commit_id', 'job_name', 5, 'sysbench_params', 'sysbench', 'maxscale', 'content of ./scripts/benchmark_parser/test_data/7533_mdbci_template
')
write_to_product_parameters
write_to_maxscale_parameters
INSERT INTO maxscale_parameters (id, target, maxscale_commit_id, maxscale_cnf) VALUES (10, 'target', 'maxscale_commit_id', 'content of the ./scripts/benchmark_parser/test_data/7533_maxscale_cnf
')
write_to_benchmark_results sysbench
write_to_sysbench_results
INSERT INTO sysbench_results (id, OLTP_test_statistics_queries_performed_read, OLTP_test_statistics_queries_performed_write, OLTP_test_statistics_queries_performed_other, OLTP_test_statistics_queries_performed_total, OLTP_test_statistics_transactions, OLTP_test_statistics_read_write_requests, OLTP_test_statistics_other_operations, OLTP_test_statistics_ignored_errors, OLTP_test_statistics_reconnects, General_statistics_total_time, General_statistics_total_number_of_events, General_statistics_total_time_taken_by_event_execution, General_statistics_response_time_min, General_statistics_response_time_avg, General_statistics_response_time_max, General_statistics_response_time_approx___95_percentile, Threads_fairness_events_avg, Threads_fairness_events_stddev, Threads_fairness_execution_time_avg, Threads_fairness_execution_time_stddev) VALUES (10, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 )
write_db_result_to_env_file , env
Writing results to db completed!


Related issues

Related to [mdbci] Maria DB Continuous integration tool - Task #7426: implement script for storing sysbench results in dbClosed18.08.2016

<a title="Actions" class="icon-only icon-actions js-contextmenu" href="#">Actions</a>

History

#1 Updated by Mark Zaslavskiy over 4 years ago

  • Related to Task #7426: implement script for storing sysbench results in db added

#2 Updated by Mark Zaslavskiy over 4 years ago

  • Test scenario updated (diff)

#3 Updated by Mark Zaslavskiy over 4 years ago

  • Status changed from New to Active / In progress

#4 Updated by Mark Zaslavskiy over 4 years ago

  • Status changed from Active / In progress to Review

#5 Updated by Mark Zaslavskiy over 4 years ago

  • Status changed from Review to Closed

Also available in: Atom PDF