100 Commits
Author SHA1 Message Date
dvanaken c116c7cdad Fixed data sharing 2020-07-31 17:30:31 -04:00
Dana Van Aken e56309dc28 Update requirements.txt
Increased required numpy version from 1.14.0 to 1.15.4.
2020-07-31 12:29:10 -04:00
dvanaken cd4e1ead62 Do not check celery status during unit tests 2020-05-15 20:51:19 -04:00
dvanaken 6d854b86ac Updated enumvals for oracle knob use_large_pages 2020-05-14 12:50:34 -04:00
dvanaken e92f55cc12 Fixed names of dba_workload_replay metrics 2020-04-30 03:19:20 -04:00
Dana Van Aken d47b09b0c0 Added env to docker web credentials.py to set the background task interval 2020-04-17 19:11:06 -04:00
Dana Van Aken c9370b76a3 Cleanup 2020-04-17 19:11:06 -04:00
Dana Van Aken ca63f91f55 Fixed bug in background task that happened when all workload data was invalid 2020-04-17 19:11:06 -04:00
dvanaken 9cc119e129 Added flag to alt_create_or_edit_session() that specifies whether to return the ddpg models 2020-04-17 00:59:37 -04:00
dvanaken b43a911bd7 Logging and cleanup 2020-04-14 11:49:02 -04:00
dvanaken 99c80e2e83 Improved/reordered preprocessing of metrics in workload characterization task to further reduce the number of columns and speed up the computation. Tweaked a few admin views to show more recent info first. 2020-04-14 11:49:02 -04:00
dvanaken efa02899b5 When ranking knobs in the background tasks use the target objective(s) by default. Added an option that when enabled also uses the pruned metrics. 2020-04-14 11:49:02 -04:00
dvanaken aeaae7d9f4 When aggregating knobs/metrics order the columns by name to ensure matrices have consistent columnnames in case they're combined in subsequent tasks. 2020-04-14 11:28:38 -04:00
dvanaken ff0efd7482 Fixed lint errors 2020-04-13 17:30:19 -04:00
dvanaken 4e1233ded2 Added a new textfield to the BackupData model to save additional (not required) files uploaded by the user. 2020-04-13 17:30:19 -04:00
dvanaken 593c4acb1d fixed lint errors 2020-04-03 03:56:59 -04:00
dvanaken 6d123d7509 Bug fix: pass single result object to save_execution_time() 2020-04-03 03:56:59 -04:00
dvanaken 94dcc0530d Fixed lint errors 2020-04-03 03:56:59 -04:00
dvanaken 78c2fa283a Return http error if views.give_result() is called and it's not a tuning session and updated .gitignore 2020-04-03 03:56:59 -04:00
dvanaken 72580f65a0 Startcelery mgmt cmd now pipes output to logfile only if 'console' handler is not present in the Django LOGGING settings. Also updated stopcelery warnings to make it clear they are just warnings not errors. 2020-04-03 03:56:59 -04:00
dvanaken 66ad361654 Fixed super verbose celery log messages and updated Django options to also log messages to the console. 2020-04-03 03:56:59 -04:00
dvanaken 423140169f Made the workload editable so it can be edited in the admin view and cleaned up the admin view and template 2020-04-03 01:50:38 -04:00
dvanaken 8eb79c3cc4 Fixed lint errors 2020-03-19 21:52:51 -04:00
dvanaken c423a4d435 Compute all available target objectives and include them in metrics 2020-03-19 21:52:51 -04:00
Dana Van Aken f61021c32f Fixed setting of session knobs to be case-insensitive and added git commit hash to server info 2020-03-05 17:28:33 -05:00
Dana Van Aken f737a0493e Added backdoor method to get webserver info 2020-03-05 17:28:33 -05:00
dvanaken ae5ab0b9e0 Cleanup backdoor methods 2020-03-03 19:57:14 -05:00
dvanaken 07425da6e8 Fixed style 2020-02-20 17:16:04 -05:00
dvanaken ff488cae35 Updated parser unit tests. 2020-02-20 17:16:04 -05:00
dvanaken 944a0ccc8d Speedup parser 2020-02-20 17:16:04 -05:00
dvanaken 8768686d17 Added rule for new migration file to pylintrc 2020-02-20 00:52:46 -05:00
dvanaken 3bd6d03efe Increased length of function field in executiontime model from 32 to 64 2020-02-20 00:52:46 -05:00
dvanaken 42fc5ebe3e Update celery commands 2020-02-08 17:31:29 -05:00
dvanaken 9a5dea806f Added new migration file to change type of Result.taskids field and cleaned up views.py 2020-02-08 17:31:29 -05:00
dvanaken 4d228f5765 Updated task_ids field from CharField to TextField type 2020-02-08 17:31:29 -05:00
dvanaken ec9066e5b2 Updated handling of celery task status in views 2020-02-08 17:31:29 -05:00
dvanaken d9e2806b9e Changes:
- website.celery: create celery app
- website.admin: do not unregister the djcelery models
- website.settings: added some new celery settings and updated others. Added 'celery.tasks' to our logging config which resolved the missing celery log messages issue
- website.async_tasks: removed redundant abstract task classes. Removed the settings that configured retries since do not handle retries in the tasks
2020-02-08 17:31:29 -05:00
dvanaken 7339d07a98 Updated celery package version requirements 2020-02-08 17:31:29 -05:00
dvanaken 06948089d2 Added new model to store execution times 2020-01-23 23:38:56 -05:00
Dana Van Aken 0cbc7ba334 travis-ci: trigger a build in the other repository instead of cloning and building it here 2020-01-23 16:15:49 -05:00
Dana Van Aken 6b78b8a131 Added 'set -e' to the top of docker/install.sh so bash exits if there are any errors during package installation. 2020-01-19 08:52:14 -05:00
Dana Van Aken 286046e2df Save the latest git commit ID inside the Docker containers to /app/.git_commit 2020-01-19 08:52:14 -05:00
Dana Van Aken 35160f2fb4 Upgraded Django from version 1.11.23 to 1.11.27 2020-01-19 06:33:25 -05:00
Dana Van Aken 1d8913f408 When converting a value in bytes to human-readable, if the conversion fails then log a warning and return the original value instead of raising an exception. 2020-01-19 02:43:55 -05:00
dvanaken 6bf50b892d Moved dumpdata code from resetwebsite into its own mgmt command, ignore errors from stopcelery kill command, added backdoor method to dump website backend database and logfiles 2020-01-14 07:43:31 -05:00
dvanaken 9f9f2845d6 Fixed formatting 2020-01-13 17:21:56 -05:00
dvanaken 7b962c4065 Updated parser classes to not cache knob/metric catalogs and replaced all queries that filter for numeric metrics with the new MetricType.numeric() method. 2020-01-13 17:21:56 -05:00
dvanaken e1a41928f6 Fixed admin forms for Metric/KnobCatalog models. 2020-01-13 17:21:56 -05:00
dvanaken ee101d818e Added class methods to get numeric/nonnumeric metric types. 2020-01-13 17:21:56 -05:00
dvanaken a4f8e0b37e Cleanup old celery processes in docker/start.sh 2020-01-13 17:21:56 -05:00
dvanaken bcad0fa017 Added CHOOSE to enumvals for Oracle parameter optimizer_mode 2020-01-13 10:09:31 -05:00
dvanaken 2f79bfdc17 Fixed parser to treat enum values as case-insensitive 2020-01-13 10:09:31 -05:00
dvanaken 2adab245c0 added create_knob_settings.py script to pylint exclude list 2020-01-09 03:23:06 -05:00
dvanaken 16348d1c7a Updated fixtures, human-readable values values in knob/metric comparison view 2020-01-09 03:23:06 -05:00
dvanaken c33defa29a Updated oracle knob fixtures 2020-01-09 03:23:06 -05:00
dvanaken 4c6ec3f0fd checkpoint 2020-01-09 03:23:06 -05:00
dvanaken 433bb68f2f Added next few Oracle params 2020-01-09 03:23:06 -05:00
dvanaken e1da577ad0 Fixed formatting 2020-01-08 15:29:31 -05:00
dvanaken 9393fb7aca Fixed bugs and improved logging in config recommendation tasks/views 2020-01-08 15:29:31 -05:00
dvanaken 3786714093 Updated handling of next config in the driver 2020-01-08 15:29:31 -05:00
dvanaken 8cec62160f Create/format/save the recommended config for the latest result before the on_success method. 2020-01-08 15:29:31 -05:00
dvanaken 8001b658c9 Added management function similar to 'startcelery' except that it auto-reloads modified website files. 2020-01-07 04:04:06 -05:00
dvanaken 9fced864fe Updated Django settings: removed unused paths, fixed incorrect paths to media/template dirs, increased size of rotating log files from 50KB to 2MB and the number of backup files. 2020-01-03 07:32:28 -05:00
dvanaken 16acc35f54 Fix style 2019-12-21 06:47:48 +01:00
dvanaken 2a7bc6145f Fixed db time target objective 2019-12-16 20:47:24 +01:00
dvanaken fc4cf0e18b added new oracle knobs 2019-12-15 19:20:29 +01:00
dvanaken 1994a09a6e update docker-compose create script 2019-12-11 19:18:35 +01:00
dvanaken 24a8bbb298 add dev packages to install.sh 2019-12-11 19:18:35 +01:00
dvanaken a144069e6b shuffle lhs samples 2019-12-11 19:18:35 +01:00
dvanaken d25d5b4cca Expose rabbitmq host in docker 2019-12-11 19:18:35 +01:00
dvanaken 4b37dec988 Fixed formatting 2019-12-11 00:40:06 +01:00
dvanaken ffc88bfaae Run ddpg++ by default 2019-12-11 00:40:06 +01:00
dvanaken c4e8eb53a1 Fixed docker tag for base image in travis 2019-12-11 00:40:06 +01:00
dvanaken 65f3a7b0d6 Finished adding support for Oracle enums 2019-12-11 00:40:06 +01:00
dvanaken a3cc34ba8e Updated oracle fixtures 2019-12-10 18:01:56 +01:00
dvanaken 42e1a4add3 Make constants editable 2019-12-10 18:01:56 +01:00
dvanaken a7724233d3 fixed formatting 2019-12-09 22:19:47 +01:00
dvanaken b0cddcc289 Added 3 Oracle hidden knobs 2019-12-09 22:19:47 +01:00
dvanaken 02c40f5cea Adjusted background task time 2019-12-05 20:46:02 -05:00
dvanaken 783b94cd4d Speedup travis-ci tests 2019-12-05 20:46:02 -05:00
dvanaken 9e9c9c7510 Fixed bug when collecting session knobs; for LHS sessions, remove all pre-generated configs if the session knobs are modified 2019-12-05 20:46:02 -05:00
dvanaken 7be5b89975 Changes: when we deploy our docker images we now also build/deploy the internal driver image; fixed .dockerignore; moved integration test data into the driver; fixed cast in oracle db_time target objective. 2019-12-04 17:27:05 -05:00
dvanaken c739eb066e Changes: removed docker centos image; updated expected value used in test in analysis/tests/ddpg_test.py to be less strict; run all tests on travis vm and docker containers; push docker images to docker-hub repo if on the master branch; 2019-12-03 18:33:04 -05:00
dvanaken e80639c859 Fixed formatting 2019-11-26 15:25:06 -05:00
dvanaken 9994a22f16 Updated management commands 2019-11-26 15:25:06 -05:00
dvanaken 4ab2fdfd52 Updated knob tunability getter 2019-11-26 15:25:06 -05:00
dvanaken c23308e9f1 Fixed log output 2019-11-26 05:15:44 -05:00
dvanaken b211ad455d Fixed bug caused by stale value of latest result in views.give_result() 2019-11-26 05:15:44 -05:00
dvanaken 5555ead3a3 Fixed small bug in parser. 2019-11-22 15:12:54 -05:00
dvanaken a0c60afc3c Addressed Dongsheng's review comments. 2019-11-18 13:04:14 -05:00
dvanaken 6a58c52762 formatting 2019-11-18 13:04:14 -05:00
dvanaken 9a4bbeead5 ...formatting 2019-11-18 13:04:14 -05:00
dvanaken a008428903 formatting 2019-11-18 13:04:14 -05:00
dvanaken 2a3b075516 fixed formatting 2019-11-18 13:04:14 -05:00
dvanaken 9055516737 Updating Oracle knobs/metrics 2019-11-18 13:04:14 -05:00
dvanaken a99cf72c6c Updated oracle tunable knobs 2019-11-18 13:04:14 -05:00
dvanaken a5cbb50521 fixed formatting 2019-11-18 13:04:14 -05:00
dvanaken cf19380107 Updated the knob/metric output samples for each of the Oracle versions we support since my fix changed all of them. 2019-11-18 13:04:14 -05:00
dvanaken e1b29eaafa Added support for Oracle v12.1c. 2019-11-18 13:04:14 -05:00
dvanaken d874ca6a8b The Oracle collector now prepends the view name to each metric to avoid overwriting metrics from different views with the same names 2019-11-18 13:04:14 -05:00