FineJin

 laravel-sql-logger 패키지 사용

1. 패키지 설치

   composer require mnabialek/laravel-sql-logger

    

2. config/app.php 의 providers 등록

   Mnabialek\LaravelSqlLogger\Providers\ServiceProvider::class,

    

3. publishing

   php artisan vendor:publish --provider="Mnabialek\LaravelSqlLogger\Providers\ServiceProvider"

    

4. config/sql_logger.php 설정 

5. 또는 .env 에 동작 설정

   SQL_LOG_QUERIES=true

   SQL_LOG_SLOW_QUERIES=true

   SQL_SLOW_QUERIES_MIN_EXEC_TIME=100

   SQL_LOG_OVERRIDE=false

   SQL_LOG_DIRECTORY=logs/sql

   SQL_CONVERT_TIME_TO_SECONDS=false

   SQL_LOG_SEPARATE_ARTISAN=false

    

Ref

• http://laravel-tricks.com/tricks/display-all-sql-executed-in-eloquent

#!/bin/bash

sudo apt install tzdata

#한국설정
sudo  ln -sf /usr/share/zoneinfo/Asia/Seoul /etc/localtime

  
 #한국으로설정
timedatectl set-timezone 'Asia/Seoul'

sudo apt-get install python3-pip
sudo pip install --upgrade pip


wget http://apache.mirror.cdnetworks.com/spark/spark-2.4.3/spark-2.4.3-bin-hadoop2.7.tgz
tar -zxvf spark-2.4.3-bin-hadoop2.7.tgz

sudo pip install matplotlib

wget http://apache.tt.co.kr/zeppelin/zeppelin-0.8.1/zeppelin-0.8.1-bin-all.tgz

wget wget https://sdk-for-java.amazonwebservices.com/latest/aws-java-sdk.zip
wget https://talend-update.talend.com/nexus/content/repositories/libraries/org/talend/libraries/hadoop-aws-2.7.3-amzn-2/6.0.0/hadoop-aws-2.7.3-amzn-2-6.0.0.jar

#zeppelin presto driver
wget https://repo1.maven.org/maven2/com/facebook/presto/presto-jdbc/0.164/presto-jdbc-0.164.jar