API - ReginaGimazova/log_analyzer_api GitHub Wiki

GET /start - preparing the database for the analysis cycle:

creating tables if they are not in the database

clearing tables from the results of the previous cycle

GET /progress - get current progress of "general log" analyze stage

GET /configuration - get all statuses configuration ('EXPLAIN' and 'PROFILE' types statuses configuration)

POST /configuration/update - update statuses configuration

additional params

statuses - configuration objects ({id: 0, value: 'using temporary table', type: 'EXPLAIN' (or 'PROFILE'), mode: 1 (or 0)})

POST /configuration/add - add new status configuration

additional params

value - status value (for example 'using temporary table')

type - configuration type: 'EXPLAIN' or 'PROFILE',

mode - 1

POST /configuration/remove - remove status configuration

additional params

value - status value (for example 'using temporary table')

type: configuration type: 'EXPLAIN' or 'PROFILE',

GET /tables - get all tables

GET /queries - get parametrized queries

additional params

searchTables - set of tables (if user didn't choose any table, searchTables = empty set) page - number of page

GET /explain - get all status configurations with 'EXPLAIN' type

additional params

searchTables - set of tables (if user didn't choose any table, searchTables = empty set) page - number of page

POST /explain/update - re-executing the EXPLAIN command for all queries

GET /profile - get all status configurations with 'PROFILE' type

additional params

searchTables - set of tables (if user didn't choose any table, searchTables = empty set) page - number of page

POST /profile/update - re-executing the profiling for all queries

GET /filteredQueries - get filtered queries

additional params

statusId - configuration status id

type - explain or profile

('EXPLAIN' status - filtered queries relation stored in 'explain_replay_info' table, 'PROFILE' status - filtered queries relation stored in 'profile_replay_info' table)