MySQL 연결 / 스프링 schema.sql, data.sql / Flyway

MySQL 연결

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/indexdb?serverTimezone=UTC&characterEncoding=UTF-8
#indexdb 이것은 환경에 적합한 데이터베이스 이름을 적어주시면됩니다.
spring.datasource.username=root
spring.datasource.password=root

package com.example.demo;

import lombok.extern.slf4j.Slf4j;
import org.springframework.boot.ApplicationArguments;
import org.springframework.boot.ApplicationRunner;
import org.springframework.stereotype.Component;

import javax.sql.DataSource;

@Slf4j
@Component
public class TableLister implements ApplicationRunner {

    private final DataSource dataSource;

    public TableLister(DataSource dataSource) {
        this.dataSource = dataSource;
    }

    @Override
    public void run(ApplicationArguments args) throws Exception {
        try(var con = dataSource.getConnection();
        var rs = con.getMetaData().getTables(null,null,"%",null)){
            while (rs.next()){
                log.info("{}",rs.getString(3));
            }
        }
    }
}

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.2.4.RELEASE)

2020-02-14 03:02:03.700  INFO 5196 --- [  restartedMain] com.example.demo.DemoApplication         : Starting DemoApplication on DESKTOP-6HPEM1U with PID 5196 (D:\example\springboot2_DB_example1\target\classes started by k in D:\example\springboot2_DB_example1)
2020-02-14 03:02:03.711  INFO 5196 --- [  restartedMain] com.example.demo.DemoApplication         : No active profile set, falling back to default profiles: default
2020-02-14 03:02:03.766  INFO 5196 --- [  restartedMain] o.s.b.devtools.restart.ChangeableUrls    : The Class-Path manifest attribute in C:\Users\k\.m2\repository\org\glassfish\jaxb\jaxb-runtime\2.3.2\jaxb-runtime-2.3.2.jar referenced one or more files that do not exist: file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/jakarta.xml.bind-api-2.3.2.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/txw2-2.3.2.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/istack-commons-runtime-3.0.8.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/stax-ex-1.8.1.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/FastInfoset-1.2.16.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/jakarta.activation-api-1.2.1.jar
2020-02-14 03:02:03.767  INFO 5196 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2020-02-14 03:02:03.767  INFO 5196 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2020-02-14 03:02:04.280  INFO 5196 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2020-02-14 03:02:04.285  INFO 5196 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JDBC repositories in DEFAULT mode.
2020-02-14 03:02:04.295  INFO 5196 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 7ms. Found 0 JDBC repository interfaces.
2020-02-14 03:02:04.301  INFO 5196 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2020-02-14 03:02:04.302  INFO 5196 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2020-02-14 03:02:04.305  INFO 5196 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 1ms. Found 0 JPA repository interfaces.
2020-02-14 03:02:04.475  INFO 5196 --- [  restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-02-14 03:02:04.692  INFO 5196 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2020-02-14 03:02:04.698  INFO 5196 --- [  restartedMain] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2020-02-14 03:02:04.698  INFO 5196 --- [  restartedMain] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.30]
2020-02-14 03:02:04.784  INFO 5196 --- [  restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2020-02-14 03:02:04.784  INFO 5196 --- [  restartedMain] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 1017 ms
2020-02-14 03:02:04.866  INFO 5196 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2020-02-14 03:02:05.161  INFO 5196 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2020-02-14 03:02:05.190  INFO 5196 --- [  restartedMain] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2020-02-14 03:02:05.227  INFO 5196 --- [  restartedMain] org.hibernate.Version                    : HHH000412: Hibernate Core {5.4.10.Final}
2020-02-14 03:02:05.298  INFO 5196 --- [  restartedMain] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
2020-02-14 03:02:05.418  INFO 5196 --- [  restartedMain] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.MySQL8Dialect
2020-02-14 03:02:05.737  INFO 5196 --- [  restartedMain] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2020-02-14 03:02:05.743  INFO 5196 --- [  restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2020-02-14 03:02:05.798  WARN 5196 --- [  restartedMain] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2020-02-14 03:02:06.012  INFO 5196 --- [  restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2020-02-14 03:02:06.122  WARN 5196 --- [  restartedMain] ion$DefaultTemplateResolverConfiguration : Cannot find template location: classpath:/templates/ (please add some templates or check your Thymeleaf configuration)
2020-02-14 03:02:06.278  INFO 5196 --- [  restartedMain] o.s.b.d.a.OptionalLiveReloadServer       : LiveReload server is running on port 35729
2020-02-14 03:02:06.343  INFO 5196 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2020-02-14 03:02:06.345  INFO 5196 --- [  restartedMain] com.example.demo.DemoApplication         : Started DemoApplication in 2.971 seconds (JVM running for 3.773)
2020-02-14 03:02:06.439  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : columns_priv
2020-02-14 03:02:06.439  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : component
2020-02-14 03:02:06.439  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : db
2020-02-14 03:02:06.439  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : default_roles
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : engine_cost
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : func
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : general_log
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : global_grants
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : gtid_executed
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : help_category
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : help_keyword
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : help_relation
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : help_topic
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : innodb_index_stats
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : innodb_table_stats
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : password_history
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : plugin
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : procs_priv
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : proxies_priv
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : role_edges
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : server_cost
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : servers
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : slave_master_info
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : slave_relay_log_info
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : slave_worker_info
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : slow_log
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : tables_priv
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : time_zone
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : time_zone_leap_second
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : time_zone_name
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : time_zone_transition
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : time_zone_transition_type
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : user
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : accounts
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : cond_instances
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : data_lock_waits
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : data_locks
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_errors_summary_by_account_by_error
2020-02-14 03:02:06.440  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_errors_summary_by_host_by_error
2020-02-14 03:02:06.441  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_errors_summary_by_thread_by_error
2020-02-14 03:02:06.441  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_errors_summary_by_user_by_error
2020-02-14 03:02:06.441  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_errors_summary_global_by_error
2020-02-14 03:02:06.441  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_stages_current
2020-02-14 03:02:06.441  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_stages_history
2020-02-14 03:02:06.441  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_stages_history_long
2020-02-14 03:02:06.441  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_stages_summary_by_account_by_event_name
2020-02-14 03:02:06.441  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_stages_summary_by_host_by_event_name
2020-02-14 03:02:06.441  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_stages_summary_by_thread_by_event_name
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_stages_summary_by_user_by_event_name
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_stages_summary_global_by_event_name
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_current
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_histogram_by_digest
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_histogram_global
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_history
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_history_long
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_summary_by_account_by_event_name
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_summary_by_digest
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_summary_by_host_by_event_name
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_summary_by_program
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_summary_by_thread_by_event_name
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_summary_by_user_by_event_name
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_statements_summary_global_by_event_name
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_transactions_current
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_transactions_history
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_transactions_history_long
2020-02-14 03:02:06.442  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_transactions_summary_by_account_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_transactions_summary_by_host_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_transactions_summary_by_thread_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_transactions_summary_by_user_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_transactions_summary_global_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_waits_current
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_waits_history
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_waits_history_long
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_waits_summary_by_account_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_waits_summary_by_host_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_waits_summary_by_instance
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_waits_summary_by_thread_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_waits_summary_by_user_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : events_waits_summary_global_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : file_instances
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : file_summary_by_event_name
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : file_summary_by_instance
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : global_status
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : global_variables
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : host_cache
2020-02-14 03:02:06.443  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : hosts
2020-02-14 03:02:06.444  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : keyring_keys
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : log_status
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_summary_by_account_by_event_name
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_summary_by_host_by_event_name
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_summary_by_thread_by_event_name
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_summary_by_user_by_event_name
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_summary_global_by_event_name
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : metadata_locks
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : mutex_instances
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : objects_summary_global_by_type
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : performance_timers
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : persisted_variables
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : prepared_statements_instances
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_applier_configuration
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_applier_filters
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_applier_global_filters
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_applier_status
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_applier_status_by_coordinator
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_applier_status_by_worker
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_connection_configuration
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_connection_status
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_group_member_stats
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : replication_group_members
2020-02-14 03:02:06.445  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : rwlock_instances
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : session_account_connect_attrs
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : session_connect_attrs
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : session_status
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : session_variables
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : setup_actors
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : setup_consumers
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : setup_instruments
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : setup_objects
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : setup_threads
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : socket_instances
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : socket_summary_by_event_name
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : socket_summary_by_instance
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : status_by_account
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : status_by_host
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : status_by_thread
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : status_by_user
2020-02-14 03:02:06.446  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : table_handles
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : table_io_waits_summary_by_index_usage
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : table_io_waits_summary_by_table
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : table_lock_waits_summary_by_table
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : threads
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : user_defined_functions
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : user_variables_by_thread
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : users
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : variables_by_thread
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : variables_info
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : CHARACTER_SETS
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : CHECK_CONSTRAINTS
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : COLLATION_CHARACTER_SET_APPLICABILITY
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : COLLATIONS
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : COLUMN_PRIVILEGES
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : COLUMN_STATISTICS
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : COLUMNS
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : ENGINES
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : EVENTS
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : FILES
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_BUFFER_PAGE
2020-02-14 03:02:06.447  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_BUFFER_PAGE_LRU
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_BUFFER_POOL_STATS
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_CACHED_INDEXES
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_CMP
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_CMP_PER_INDEX
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_CMP_PER_INDEX_RESET
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_CMP_RESET
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_CMPMEM
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_CMPMEM_RESET
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_COLUMNS
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_DATAFILES
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_FIELDS
2020-02-14 03:02:06.448  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_FOREIGN
2020-02-14 03:02:06.449  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_FOREIGN_COLS
2020-02-14 03:02:06.449  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_FT_BEING_DELETED
2020-02-14 03:02:06.449  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_FT_CONFIG
2020-02-14 03:02:06.449  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_FT_DEFAULT_STOPWORD
2020-02-14 03:02:06.449  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_FT_DELETED
2020-02-14 03:02:06.449  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_FT_INDEX_CACHE
2020-02-14 03:02:06.449  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_FT_INDEX_TABLE
2020-02-14 03:02:06.449  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_INDEXES
2020-02-14 03:02:06.449  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_METRICS
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_SESSION_TEMP_TABLESPACES
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_TABLES
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_TABLESPACES
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_TABLESPACES_BRIEF
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_TABLESTATS
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_TEMP_TABLE_INFO
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_TRX
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : INNODB_VIRTUAL
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : KEY_COLUMN_USAGE
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : KEYWORDS
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : OPTIMIZER_TRACE
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : PARAMETERS
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : PARTITIONS
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : PLUGINS
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : PROCESSLIST
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : PROFILING
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : REFERENTIAL_CONSTRAINTS
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : RESOURCE_GROUPS
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : ROUTINES
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : SCHEMA_PRIVILEGES
2020-02-14 03:02:06.450  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : SCHEMATA
2020-02-14 03:02:06.451  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : ST_GEOMETRY_COLUMNS
2020-02-14 03:02:06.451  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : ST_SPATIAL_REFERENCE_SYSTEMS
2020-02-14 03:02:06.451  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : ST_UNITS_OF_MEASURE
2020-02-14 03:02:06.451  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : STATISTICS
2020-02-14 03:02:06.451  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : TABLE_CONSTRAINTS
2020-02-14 03:02:06.451  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : TABLE_PRIVILEGES
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : TABLES
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : TABLESPACES
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : TRIGGERS
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : USER_PRIVILEGES
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : VIEW_ROUTINE_USAGE
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : VIEW_TABLE_USAGE
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : VIEWS
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : departments
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : dept_emp
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : dept_manager
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : employees
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : salaries
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : titles
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : articles
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : authorities
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : backup_usertbl
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : emp
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : emp_c
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : emp_se
2020-02-14 03:02:06.452  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : fulltexttbl
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : parttbl
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : users
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : usertbl
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : authorities
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : users
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : actor
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : address
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : category
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : city
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : country
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : customer
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : film
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : film_actor
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : film_category
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : film_text
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : inventory
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : language
2020-02-14 03:02:06.453  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : payment
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : rental
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : staff
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : store
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : authorities
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : users
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : sys_config
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : city
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : country
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : countrylanguage
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : current_dept_emp
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : dept_emp_latest_date
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : actor_info
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : customer_list
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : film_list
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : nicer_but_slower_film_list
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : sales_by_film_category
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : sales_by_store
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : staff_list
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : host_summary
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : host_summary_by_file_io
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : host_summary_by_file_io_type
2020-02-14 03:02:06.454  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : host_summary_by_stages
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : host_summary_by_statement_latency
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : host_summary_by_statement_type
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : innodb_buffer_stats_by_schema
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : innodb_buffer_stats_by_table
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : innodb_lock_waits
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : io_by_thread_by_latency
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : io_global_by_file_by_bytes
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : io_global_by_file_by_latency
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : io_global_by_wait_by_bytes
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : io_global_by_wait_by_latency
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : latest_file_io
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_by_host_by_current_bytes
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_by_thread_by_current_bytes
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_by_user_by_current_bytes
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_global_by_current_bytes
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : memory_global_total
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : metrics
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : processlist
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : ps_check_lost_instrumentation
2020-02-14 03:02:06.455  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : schema_auto_increment_columns
2020-02-14 03:02:06.456  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : schema_index_statistics
2020-02-14 03:02:06.456  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : schema_object_overview
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : schema_redundant_indexes
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : schema_table_lock_waits
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : schema_table_statistics
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : schema_table_statistics_with_buffer
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : schema_tables_with_full_table_scans
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : schema_unused_indexes
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : session
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : session_ssl_status
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : statement_analysis
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : statements_with_errors_or_warnings
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : statements_with_full_table_scans
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : statements_with_runtimes_in_95th_percentile
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : statements_with_sorting
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : statements_with_temp_tables
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : user_summary
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : user_summary_by_file_io
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : user_summary_by_file_io_type
2020-02-14 03:02:06.457  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : user_summary_by_stages
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : user_summary_by_statement_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : user_summary_by_statement_type
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : version
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : wait_classes_global_by_avg_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : wait_classes_global_by_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : waits_by_host_by_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : waits_by_user_by_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : waits_global_by_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$host_summary
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$host_summary_by_file_io
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$host_summary_by_file_io_type
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$host_summary_by_stages
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$host_summary_by_statement_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$host_summary_by_statement_type
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$innodb_buffer_stats_by_schema
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$innodb_buffer_stats_by_table
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$innodb_lock_waits
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$io_by_thread_by_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$io_global_by_file_by_bytes
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$io_global_by_file_by_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$io_global_by_wait_by_bytes
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$io_global_by_wait_by_latency
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$latest_file_io
2020-02-14 03:02:06.458  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$memory_by_host_by_current_bytes
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$memory_by_thread_by_current_bytes
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$memory_by_user_by_current_bytes
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$memory_global_by_current_bytes
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$memory_global_total
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$processlist
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$ps_digest_95th_percentile_by_avg_us
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$ps_digest_avg_latency_distribution
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$ps_schema_table_statistics_io
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$schema_flattened_keys
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$schema_index_statistics
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$schema_table_lock_waits
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$schema_table_statistics
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$schema_table_statistics_with_buffer
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$schema_tables_with_full_table_scans
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$session
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$statement_analysis
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$statements_with_errors_or_warnings
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$statements_with_full_table_scans
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$statements_with_runtimes_in_95th_percentile
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$statements_with_sorting
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$statements_with_temp_tables
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$user_summary
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$user_summary_by_file_io
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$user_summary_by_file_io_type
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$user_summary_by_stages
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$user_summary_by_statement_latency
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$user_summary_by_statement_type
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$wait_classes_global_by_avg_latency
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$wait_classes_global_by_latency
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$waits_by_host_by_latency
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$waits_by_user_by_latency
2020-02-14 03:02:06.459  INFO 5196 --- [  restartedMain] com.example.demo.TableLister             : x$waits_global_by_latency

---

# 연결풀설정

# 스프링 부트가 사용하는 기본 연결 풀은 히카리CP -> spring-boot-starter-jdbc 의존성을 추가하면 자동으로 설정
#spring.datasource.hikari.connection-timeout= 클라이언트가 풀에 접속할 때 대기하는 최대 시간, 기본값 30초(30000밀리초)
#spring.datasource.hikari.leak-detection-threshold= 연결 풀의 연결 객체가 고갈되기 전에 메시지를 출력해 가능한 연결 \
#  누수를 알려주는 시간으로, 밀리초
#spring.datasource.hikari.idle-timeout= 연결 풀의 연결 객체가 대기 상태로 변경될 떄까지 기다리는 시간, 기본값 10분(600000밀리초)
#spring.datasource.hikari.validation-timeout= 연결 풀의 연결 객체가 대기 상태로 검증할 떄까지 기다리는 시간, 기본값 5초(5000밀리초)
#spring.datasource.hikari.connection-test-query= 연결을 검증할 떄 사용하는 SQL 구문을 설정 ※ 주의 : 일반적으로 JDBC 4.0 이상 버전에서는 필요하지 않다.
##   기본값 none으로 설정하지 않는다는 의미
#spring.datasource.hikari.maximum-pool-size= 풀에 보관할 최대 연결 개수다. 기본값 10
#spring.datasource.hikari.minimum-idle= 풀에 유지할 최소 대기 연결 객체의 수, 기본값 10

#schema.sql에 초기 스키마
#data.sql에 테이블에 입력할 데이터
# 또는 schema-<데이터베이스 플랫폼 이름>sql,과 data-<데이터베이스 플랫폼 이름>.sql 를 사용해 특정 데이터베이스에 특화된 초기 데이터 설정 가능
# <데이터베이스 플랫폼 이름>은 spring.datasource.platform 속성에서 읽는다.

# 테이터베이스 초기화 속성
#spring.datasource.continue-on-error= 데이터베이스 초기화 오류가 발생했을 때 계속 진행할지 여부를 결정, 기본 false
#spring.datasource.data= 데이터 스크립트 참조 리소스 이름, 기본값 classpath:data
#spring.datasource.data-password= DML을 실행할 데이터베이스 비번, 기본값 일반적인 비번
#spring.datasource.data-username= DML을 실행할 데이터베이스 사용자 이름, 기본값 일반적인 사용자 이름
#spring.datasource.initialization-mode= 사용 가능한 DDL과 DML 스크립트를 사용해 데이터베이스를 초기화 하는 방식
# 기본값 EMBEDDED로 내장된 데이터베이스에서만 초기화를 실행
# NEVER(초기화 실행 안함), ALWAYS(모든 데이터베이스에서 실행)로 변경 가능
#spring.datasource.platform= DDL 혹은 DML 스크립트(schema-${플랫폼}.sql 혹은 data-${플랫폼}.sql)을 사용할 플랫폼을 설정, 기본값 all
#spring.datasource.schema= DDL 스크립트를 참조할 리소스 위치, 기본값 classpath:schema
#spring.datasource.schema-username= DDL 스크립트 실행할 데이터베이스 사용자 이름, 기본값 일반적인 사용자 이름
#spring.datasource.schema-password= DDL 스크립트 실행할 데이터베이스 비번, 기본값 일반적인 비번
#spring.datasource.separator= SQL 초기화 스크립트에서 구문을 나눌 구분자로, 기본값 ;(세미콜론)
#spring.datasource.sql-script-encoding= SQL 스크립트의 인코딩 방식을 설정한다, 기본값 플랫폼의 인코딩 방식을 따른다

추가

spring.datasource.initialization-mode=always

resoucres/schema.sql

drop table if exists customer;

create table customer
(
    ID    smallint AUTO_INCREMENT,
    NAME  varchar(50) not null,
    EMAIL varchar(50) not null,
    primary key (ID)
);

resoucres/data.sql

insert into customer (name, email) values
('Marten Deinum','marten.deinum@conspect.nl'),
('Josh Long','jlong@pivotal.com'),
('John Doe','John.doe@island.io'),
('Jane Doe','jane.doe@island.io');

package com.example.demo;

import lombok.extern.slf4j.Slf4j;
import org.springframework.boot.ApplicationArguments;
import org.springframework.boot.ApplicationRunner;
import org.springframework.stereotype.Component;

import javax.sql.DataSource;

@Slf4j
@Component
public class CustomerLister implements ApplicationRunner {
    private final DataSource dataSource;

    public CustomerLister(DataSource dataSource) {
        this.dataSource = dataSource;
    }

    @Override
    public void run(ApplicationArguments args) throws Exception {
        var query = "SELECT ID, NAME, EMAIL from CUSTOMER";
        try(var con = dataSource.getConnection();
        var stmt = con.createStatement();
        var rs = stmt.executeQuery(query)){
            while (rs.next()){
                log.info("Customer [id={}, name={}, email={}]",
                        rs.getLong(1), rs.getString(2), rs.getString(3));
            }
        }
    }
}

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.2.4.RELEASE)

2020-02-14 04:37:36.861  INFO 15372 --- [  restartedMain] com.example.demo.DemoApplication         : Starting DemoApplication on DESKTOP-6HPEM1U with PID 15372 (D:\example\springboot2_DB_example1\target\classes started by k in D:\example\springboot2_DB_example1)
2020-02-14 04:37:36.864  INFO 15372 --- [  restartedMain] com.example.demo.DemoApplication         : No active profile set, falling back to default profiles: default
2020-02-14 04:37:36.898  INFO 15372 --- [  restartedMain] o.s.b.devtools.restart.ChangeableUrls    : The Class-Path manifest attribute in C:\Users\k\.m2\repository\org\glassfish\jaxb\jaxb-runtime\2.3.2\jaxb-runtime-2.3.2.jar referenced one or more files that do not exist: file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/jakarta.xml.bind-api-2.3.2.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/txw2-2.3.2.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/istack-commons-runtime-3.0.8.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/stax-ex-1.8.1.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/FastInfoset-1.2.16.jar,file:/C:/Users/k/.m2/repository/org/glassfish/jaxb/jaxb-runtime/2.3.2/jakarta.activation-api-1.2.1.jar
2020-02-14 04:37:36.898  INFO 15372 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2020-02-14 04:37:36.899  INFO 15372 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2020-02-14 04:37:37.413  INFO 15372 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2020-02-14 04:37:37.419  INFO 15372 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JDBC repositories in DEFAULT mode.
2020-02-14 04:37:37.429  INFO 15372 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 7ms. Found 0 JDBC repository interfaces.
2020-02-14 04:37:37.435  INFO 15372 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2020-02-14 04:37:37.435  INFO 15372 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2020-02-14 04:37:37.438  INFO 15372 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 0ms. Found 0 JPA repository interfaces.
2020-02-14 04:37:37.599  INFO 15372 --- [  restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-02-14 04:37:37.778  INFO 15372 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2020-02-14 04:37:37.784  INFO 15372 --- [  restartedMain] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2020-02-14 04:37:37.785  INFO 15372 --- [  restartedMain] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.30]
2020-02-14 04:37:37.861  INFO 15372 --- [  restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2020-02-14 04:37:37.861  INFO 15372 --- [  restartedMain] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 962 ms
2020-02-14 04:37:37.920  INFO 15372 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2020-02-14 04:37:38.133  INFO 15372 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2020-02-14 04:37:39.598  INFO 15372 --- [  restartedMain] o.s.b.d.a.OptionalLiveReloadServer       : LiveReload server is running on port 35729
2020-02-14 04:37:39.833  INFO 15372 --- [  restartedMain] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2020-02-14 04:37:39.884  INFO 15372 --- [  restartedMain] org.hibernate.Version                    : HHH000412: Hibernate Core {5.4.10.Final}
2020-02-14 04:37:39.954  INFO 15372 --- [  restartedMain] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
2020-02-14 04:37:40.053  INFO 15372 --- [  restartedMain] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.MySQL8Dialect
2020-02-14 04:37:40.155  INFO 15372 --- [  restartedMain] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2020-02-14 04:37:40.159  INFO 15372 --- [  restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2020-02-14 04:37:40.193  WARN 15372 --- [  restartedMain] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2020-02-14 04:37:40.275  INFO 15372 --- [  restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2020-02-14 04:37:40.351  WARN 15372 --- [  restartedMain] ion$DefaultTemplateResolverConfiguration : Cannot find template location: classpath:/templates/ (please add some templates or check your Thymeleaf configuration)
2020-02-14 04:37:40.460  INFO 15372 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2020-02-14 04:37:40.462  INFO 15372 --- [  restartedMain] com.example.demo.DemoApplication         : Started DemoApplication in 3.849 seconds (JVM running for 4.571)
2020-02-14 04:37:40.464  INFO 15372 --- [  restartedMain] com.example.demo.CustomerLister          : Customer [id=1, name=Marten Deinum, email=marten.deinum@conspect.nl]
2020-02-14 04:37:40.464  INFO 15372 --- [  restartedMain] com.example.demo.CustomerLister          : Customer [id=2, name=Josh Long, email=jlong@pivotal.com]
2020-02-14 04:37:40.464  INFO 15372 --- [  restartedMain] com.example.demo.CustomerLister          : Customer [id=3, name=John Doe, email=John.doe@island.io]
2020-02-14 04:37:40.464  INFO 15372 --- [  restartedMain] com.example.demo.CustomerLister          : Customer [id=4, name=Jane Doe, email=jane.doe@island.io]

---

플라이웨이로 데이터베이스 초기화

데이터베이스 형상 및 버전 관리 도구를 사용해 데이터베이스 관리 작업을 지원한다.

플라이웨이는 데이터베이스 스키마의 변경 사항을 체계적으로 관리한다.

도움이되는 사이트

TOAST flyway : https://meetup.toast.com/posts/173

# resoucres/db/migration/ 밑에 파일생성
# 파일생성 규칙 V<순서>_<이름> ex) V1_first.sql
# 스크립트가 한번 실행되면, 스크립트를 더이상 수정할수 없고, 수정해서도 안된다. 수정하면 플라이웨이가 애플리케이션 시작을 막을것이다.
#spring.flyway.enabled= 기본값 true
#spring.flyway.locations=통합 작업 스크립트의 위치 지정, 기본값 classpath:db/migration
#spring.flyway.url= 데이터베이스 통합 작업을 진행할 JDBC 주소. 별도 설정없으면 데이터소스에 설정된 값을 사용
#spring.flyway.user= flyway에서의 자체 설정 시 사용하는 사용자이름
#spring.flyway.password= flyway에서의 자체 설정 시 사용하는 비번