MLFlow.DB.확인방법

1) docker mlflow> ps auxwwwe | grep postgres

호스트와 계정 / 비번, 디비 확인

 

2) docker mlflow> psql -d mlflow mlops

 

3) table목록

mlflow postgre console>=#\dt

 

4) select

mlflow postgre console> select * from alembic_version;

 

9) exit

mlflow postgre console>=#\q

 

 

USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND

root         1  0.0  0.7 435336 129752 ?       Ss   Aug19   0:02 /opt/conda/bin/python /opt/conda/bin/mlflow server --backend-store-uri postgresql+psycopg2://mlops:mlops@postgres/mlflow --host 0.0.0.0:5000 --default-artifact-root artifacts HOSTNAME=62861bafe828 POSTGRES_PASSWORD=mlops PWD=/mlflow MLFLOW_S3_ENDPOINT_URL=http://minio:9001 HOME=/root LANG=C.UTF-8 MLFLOW_TRACKING_URI=postgresql+psycopg2://mlops:mlops@postgres/mlflow AWS_SECRET_ACCESS_KEY=minioadmin SHLVL=0 POSTGRES_USER=mlops AWS_ACCESS_KEY_ID=minioadmin LC_ALL=C.UTF-8 PATH=/opt/conda/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin POSTGRES_DB=mlflow _=/opt/conda/bin/mlflow

 

root        15  0.0  0.0  15852  4248 ?        Ss   Aug19   0:01 /usr/sbin/sshd LANGUAGE= LC_TIME= LC_CTYPE= LC_MONETARY= TERM= LC_COLLATE= PATH=/opt/conda/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/sbin:/sbin LC_ADDRESS= LANG=C.UTF-8 LC_TELEPHONE= LC_MESSAGES= LC_NAME= LC_MEASUREMENT= LC_IDENTIFICATION= LC_ALL=C.UTF-8 PWD=/ LC_NUMERIC= LC_PAPER= HOME=/root

 

root        21  0.0  0.1  27780 23100 ?        S    Aug19   2:32 /opt/conda/bin/python /opt/conda/bin/gunicorn -b 0.0.0.0:5000:5000 -w 4 mlflow.server:app HOSTNAME=62861bafe828 POSTGRES_PASSWORD=mlops PWD=/mlflow MLFLOW_S3_ENDPOINT_URL=http://minio:9001 HOME=/root LANG=C.UTF-8 MLFLOW_TRACKING_URI=postgresql+psycopg2://mlops:mlops@postgres/mlflow AWS_SECRET_ACCESS_KEY=minioadmin SHLVL=0 POSTGRES_USER=mlops AWS_ACCESS_KEY_ID=minioadmin LC_ALL=C.UTF-8 PATH=/opt/conda/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin POSTGRES_DB=mlflow _=/opt/conda/bin/mlflow _MLFLOW_SERVER_FILE_STORE=postgresql+psycopg2://mlops:mlops@postgres/mlflow _MLFLOW_SERVER_ARTIFACT_ROOT=artifacts

 

root      2394  0.0  0.7 435480 127108 ?       Sl   Aug26   0:06 /opt/conda/bin/python /opt/conda/bin/gunicorn -b 0.0.0.0:5000:5000 -w 4 mlflow.server:app HOSTNAME=62861bafe828 POSTGRES_PASSWORD=mlops PWD=/mlflow MLFLOW_S3_ENDPOINT_URL=http://minio:9001 HOME=/root LANG=C.UTF-8 MLFLOW_TRACKING_URI=postgresql+psycopg2://mlops:mlops@postgres/mlflow AWS_SECRET_ACCESS_KEY=minioadmin SHLVL=0 POSTGRES_USER=mlops AWS_ACCESS_KEY_ID=minioadmin LC_ALL=C.UTF-8 PATH=/opt/conda/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin POSTGRES_DB=mlflow _=/opt/conda/bin/mlflow _MLFLOW_SERVER_FILE_STORE=postgresql+psycopg2://mlops:mlops@postgres/mlflow _MLFLOW_SERVER_ARTIFACT_ROOT=artifacts

root      7767  0.0  0.0  16500  7712 ?        Ss   Aug19   0:00 sshd: root@notty                                                                                                                                                                                                                                                                                                                  t
root      9785  0.0  0.6 410012 102144 ?       Sl   Aug27   0:04 /opt/conda/bin/python /opt/conda/bin/gunicorn -b 0.0.0.0:5000:5000 -w 4 mlflow.server:app HOSTNAME=62861bafe828 POSTGRES_PASSWORD=mlops PWD=/mlflow MLFLOW_S3_ENDPOINT_URL=http://minio:9001 HOME=/root LANG=C.UTF-8 MLFLOW_TRACKING_URI=postgresql+psycopg2://mlops:mlops@postgres/mlflow AWS_SECRET_ACCESS_KEY=minioadmin SHLVL=0 POSTGRES_USER=mlops AWS_ACCESS_KEY_ID=minioadmin LC_ALL=C.UTF-8 PATH=/opt/conda/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin POSTGRES_DB=mlflow _=/opt/conda/bin/mlflow _MLFLOW_SERVER_FILE_STORE=postgresql+psycopg2://mlops:mlops@postgres/mlflow _MLFLOW_SERVER_ARTIFACT_ROOT=artifacts

root     13482  0.0  0.6 409756 102000 ?       Sl   Aug28   0:03 /opt/conda/bin/python /opt/conda/bin/gunicorn -b 0.0.0.0:5000:5000 -w 4 mlflow.server:app HOSTNAME=62861bafe828 POSTGRES_PASSWORD=mlops PWD=/mlflow MLFLOW_S3_ENDPOINT_URL=http://minio:9001 HOME=/root LANG=C.UTF-8 MLFLOW_TRACKING_URI=postgresql+psycopg2://mlops:mlops@postgres/mlflow AWS_SECRET_ACCESS_KEY=minioadmin SHLVL=0 POSTGRES_USER=mlops AWS_ACCESS_KEY_ID=minioadmin LC_ALL=C.UTF-8 PATH=/opt/conda/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin POSTGRES_DB=mlflow _=/opt/conda/bin/mlflow _MLFLOW_SERVER_FILE_STORE=postgresql+psycopg2://mlops:mlops@postgres/mlflow _MLFLOW_SERVER_ARTIFACT_ROOT=artifacts

root     16465  0.0  0.0      0     0 ?        Zs   Aug29   0:04 [ipython] <defunct>

root     20899  0.0  0.0   5752  3628 pts/0    Ss   08:23   0:00 bash PATH=/opt/conda/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin HOSTNAME=62861bafe828 TERM=xterm POSTGRES_USER=mlops POSTGRES_PASSWORD=mlops POSTGRES_DB=mlflow AWS_ACCESS_KEY_ID=minioadmin AWS_SECRET_ACCESS_KEY=minioadmin MLFLOW_TRACKING_URI=postgresql+psycopg2://mlops:mlops@postgres/mlflow MLFLOW_S3_ENDPOINT_URL=http://minio:9001 LANG=C.UTF-8 LC_ALL=C.UTF-8 HOME=/root

root     20931  0.0  0.0   9392  3080 pts/0    R+   08:42   0:00 ps auxwwwe CONDA_EXE=/opt/conda/bin/conda _CE_M= HOSTNAME=62861bafe828 POSTGRES_PASSWORD=mlops PWD=/mlflow CONDA_PREFIX=/opt/conda MLFLOW_S3_ENDPOINT_URL=http://minio:9001 HOME=/root LANG=C.UTF-8 MLFLOW_TRACKING_URI=postgresql+psycopg2://mlops:mlops@postgres/mlflow CONDA_PROMPT_MODIFIER=(base)  AWS_SECRET_ACCESS_KEY=minioadmin TERM=xterm _CE_CONDA= CONDA_SHLVL=1 SHLVL=1 POSTGRES_USER=mlops AWS_ACCESS_KEY_ID=minioadmin CONDA_PYTHON_EXE=/opt/conda/bin/python CONDA_DEFAULT_ENV=base LC_ALL=C.UTF-8 PATH=/opt/conda/bin:/opt/conda/condabin:/opt/conda/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin POSTGRES_DB=mlflow _=/bin/ps

root     27460  0.0  0.6 410012 102000 ?       Sl   Aug23   0:09 /opt/conda/bin/python /opt/conda/bin/gunicorn -b 0.0.0.0:5000:5000 -w 4 mlflow.server:app HOSTNAME=62861bafe828 POSTGRES_PASSWORD=mlops PWD=/mlflow MLFLOW_S3_ENDPOINT_URL=http://minio:9001 HOME=/root LANG=C.UTF-8 MLFLOW_TRACKING_URI=postgresql+psycopg2://mlops:mlops@postgres/mlflow AWS_SECRET_ACCESS_KEY=minioadmin SHLVL=0 POSTGRES_USER=mlops AWS_ACCESS_KEY_ID=minioadmin LC_ALL=C.UTF-8 PATH=/opt/conda/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin POSTGRES_DB=mlflow _=/opt/conda/bin/mlflow _MLFLOW_SERVER_FILE_STORE=postgresql+psycopg2://mlops:mlops@postgres/mlflow _MLFLOW_SERVER_ARTIFACT_ROOT=artifacts