当SQL Query跑得很慢的时候...-- Random IO

新浪博客示例
本文为新浪博客的一个示例链接,具体内容未给出,通常包含博主分享的各种心得、教程或行业见解。
http://blog.sina.com.cn/s/blog_4cd36be30100jj6m.html
24-Jun-2025 07:49:42.304 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server.服务器版本: Apache Tomcat/9.0.106 24-Jun-2025 07:49:42.308 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 服务器构建: Jun 5 2025 19:02:30 UTC 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 服务器版本号: 9.0.106.0 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 操作系统名称: Windows 10 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS.版本: 10.0 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 架构: amd64 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java 环境变量: C:\jdk-11.0.7 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java虚拟机版本: 11.0.7+8-LTS 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM.供应商: Oracle Corporation 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\develop\tomcat\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.lang=ALL-UNNAMED 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.lang.invoke=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.lang.reflect=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.io=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.util=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.util.concurrent=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.util.logging.config.file=C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d\conf\logging.properties 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote= 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote.port=1099 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote.ssl=false 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote.password.file=C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d\jmxremote.password 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote.access.file=C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d\jmxremote.access 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.rmi.server.hostname=127.0.0.1 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djdk.tls.ephemeralDHKeySize=2048 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dsun.io.useCanonCaches=false 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dignore.endorsed.dirs= 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcatalina.base=C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcatalina.home=C:\develop\tomcat\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106 24-Jun-2025 07:49:42.312 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.io.tmpdir=C:\develop\tomcat\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106\temp 24-Jun-2025 07:49:42.315 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent 使用APR版本[1.7.4]加载了基于APR的Apache Tomcat本机库[1.3.1]。 24-Jun-2025 07:49:42.315 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR功能:IPv6[true]、sendfile[true]、accept filters[false]、random[true]、UDS [true]。 24-Jun-2025 07:49:42.315 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL配置:useAprConnector[false],useOpenSSL[true] 24-Jun-2025 07:49:42.319 信息 [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL成功初始化 [OpenSSL 3.0.14 4 Jun 2024] 24-Jun-2025 07:49:42.447 信息 [main] org.apache.coyote.AbstractProtocol.init 初始化协议处理器 ["http-nio-8080"] 24-Jun-2025 07:49:42.460 信息 [main] org.apache.catalina.startup.Catalina.load 服务器在[326]毫秒内初始化 24-Jun-2025 07:49:42.509 信息 [main] org.apache.catalina.core.StandardService.startInternal 正在启动服务[Catalina] 24-Jun-2025 07:49:42.509 信息 [main] org.apache.catalina.core.StandardEngine.startInternal 正在启动 Servlet 引擎:[Apache Tomcat/9.0.106] 24-Jun-2025 07:49:42.523 信息 [main] org.apache.coyote.AbstractProtocol.start 开始协议处理句柄["http-nio-8080"] 24-Jun-2025 07:49:42.538 信息 [main] org.apache.catalina.startup.Catalina.start [77]毫秒后服务器启动 已连接到服务器 [2025-06-24 07:49:42,553] 工件 ssmd539t:war: 正在部署工件,请稍候… 24-Jun-2025 07:49:49.697 信息 [RMI TCP Connection(2)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars 至少有一个JAR被扫描用于TLD但尚未包含TLD。 为此记录器启用调试日志记录,以获取已扫描但未在其中找到TLD的完整JAR列表。 在扫描期间跳过不需要的JAR可以缩短启动时间和JSP编译时间。 2025-06-24 07:49:49 -0 [RMI TCP Connection(2)-127.0.0.1] INFO - Root WebApplicationContext: initialization started 2025-06-24 07:49:50 -109 [RMI TCP Connection(2)-127.0.0.1] INFO - Refreshing Root WebApplicationContext: startup date [Tue Jun 24 07:49:50 CST 2025]; root of context hierarchy 2025-06-24 07:49:50 -186 [RMI TCP Connection(2)-127.0.0.1] INFO - Loading XML bean definitions from class path resource [spring/spring.xml] 2025-06-24 07:49:50 -466 [RMI TCP Connection(2)-127.0.0.1] INFO - Loading XML bean definitions from class path resource [spring/spring-mybatis.xml] 2025-06-24 07:49:51 -1415 [RMI TCP Connection(2)-127.0.0.1] ERROR - maxIdle is deprecated 2025-06-24 07:49:51 -1512 [RMI TCP Connection(2)-127.0.0.1] INFO - {dataSource-1} inited Tue Jun 24 07:49:52 CST 2025 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 2025-06-24 07:49:52 -2419 [Druid-ConnectionPool-Create-2093990188] ERROR - create connection error, url: jdbc:mysql://127.0.0.1:3306/ssmd539t?useUnicode=true&characterEncoding=UTF-8&tinyInt1isBit=false, errorCode 0, state 08001 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
06-25
server: servlet: context-parameters: messageConfig: ZWBMessageConfig, MessageConfig, SCLAMessageConfig error.whitelabel.enabled: false compression.enabled: true tomcat: max-connections: ${TOMCAT_MAX_CONNECTIONS:8192} threads: max: ${TOMCAT_THREADS_MAX:200} min-spare: ${TOMCAT_THREADS_MIN_SPARE:200} port: 8081 shutdown: graceful spring: # 参考 https://docs.spring.io/spring-boot/appendix/application-properties/index.html config: import: # ロジックシナリオ定義YAMLファイル - logic-scenario-default.yml - logic-scenario.yml datasource: driver-class-name: org.postgresql.Driver url: jdbc:postgresql://${POSTGRESQL_HOST:192.168.22.247}:${POSTGRESQL_PORT:5433}/${POSTGRESQL_DATABASE:postgres} username: ${POSTGRESQL_USER:postgres} password: ${POSTGRESQL_PASSWORD:postgres} tomcat: # 参考 https://docs.spring.io/spring-boot/appendix/application-properties/index.html#application-properties.data.spring.datasource.tomcat default-auto-commit: false min-idle: ${DATASOURCE_TOMCAT_MIN_IDLE:2} initial-size: ${DATASOURCE_TOMCAT_INITIALIZE_SIZE:2} max-idle: ${DATASOURCE_TOMCAT_MAX_IDLE:2} max-active: ${DATASOURCE_TOMCAT_MAX_ACTIVE:2} test-while-idle: ${DATASOURCE_TOMCAT_TEST_WHILE_IDLE:true} time-between-eviction-runs-millis: ${DATASOURCE_TOMCAT_TIME_BETWEEN_EVICTION_RUNS_MILLIS:3000000} validation-query: ${DATASOURCE_TOMCAT_VALIDATION_QUERY:SELECT 1} validation-query-timeout: ${DATASOURCE_TOMCAT_VALIDATION_QUERY_TIMEOUT:3} max-wait: ${DATASOURCE_TOMCAT_MAX_WAIT:3000} connection-properties: connectTimeout=${DATASOURCE_TOMCAT_CONNECTTIMEOUT:3};socketTimeout=${DATASOURCE_TOMCAT_SOCKETTIMEOUT:300};ApplicationName=${spring.application.name}; # rpf-zwb-readonly-datasource: # # リードオンリーデータソース設定 # # PostgreSQL JDBC # driver-class-name: org.postgresql.Driver # url: jdbc:postgresql://${POSTGRESQL_RO_HOST:localhost}:${POSTGRESQL_RO_PORT:15432}/${POSTGRESQL_RO_DATABASE:webap_dev} # username: ${POSTGRESQL_RO_USER:webap_dev_user} # password: ${POSTGRESQL_RO_PASSWORD:MyPassword@123} # tomcat: # # 参考 https://docs.spring.io/spring-boot/appendix/application-properties/index.html#application-properties.data.spring.datasource.tomcat # default-auto-commit: false # min-idle: ${DATASOURCE_RO_TOMCAT_MIN_IDLE:2} # initial-size: ${DATASOURCE_RO_TOMCAT_INITIALIZE_SIZE:2} # max-idle: ${DATASOURCE_RO_TOMCAT_MAX_IDLE:2} # max-active: ${DATASOURCE_RO_TOMCAT_MAX_ACTIVE:2} # test-while-idle: ${DATASOURCE_RO_TOMCAT_TEST_WHILE_IDLE:true} # time-between-eviction-runs-millis: ${DATASOURCE_RO_TOMCAT_TIME_BETWEEN_EVICTION_RUNS_MILLIS:3000000} # validation-query: ${DATASOURCE_RO_TOMCAT_VALIDATION_QUERY:SELECT 1} # validation-query-timeout: ${DATASOURCE_RO_TOMCAT_VALIDATION_QUERY_TIMEOUT:3} # max-wait: ${DATASOURCE_RO_TOMCAT_MAX_WAIT:300000} # connection-properties: connectTimeout=${DATASOURCE_RO_TOMCAT_CONNECTTIMEOUT:3};socketTimeout=${DATASOURCE_RO_TOMCAT_SOCKETTIMEOUT:300};ApplicationName=${spring.application.name}; transaction: default-timeout: ${TRANSACTION_DEFAULTTIMEOUT:300} jackson: # JSON項目名のCase規則 property-naming-strategy: SNAKE_CASE # LOWER_CAMEL_CASE / LOWER_CASE / SNAKE_CASE / UPPER_CAMEL_CASE / KEBAB_CASE # JSONパーサー設定 parser: INCLUDE_SOURCE_IN_LOCATION: false # ソース参照情報(JSON内容)を含めない # JSONデシリアライズ設定 deserialization: FAIL_ON_UNKNOWN_PROPERTIES: true # DTOに未定義のフィールドを検知するとエラーとする # JSON日付フォーマット指定 date-format: "yyyy-MM-dd'T'HH:mm:ssXXX" time-zone: "Asia/Tokyo" kafka: bootstrap-servers: ${KAFKA_BROKER_LIST:192.168.22.215}:9092 jaas.enabled: true properties.security.protocol: ${KAFKA_SECURITY_PROTOCOL:PLAINTEXT} properties.sasl.mechanism: ${KAFKA_SASL_MECHANISM:GSSAPI} properties.sasl.jaas.config: org.apache.kafka.common.security.plain.PlainLoginModule required username="${KAFKA_USER:null}" password="${KAFKA_PASSWORD:null}"; consumer: auto-offset-reset: earliest cloud: gcp: firestore: enabled: false function: definition: ssha5007Consumer; stream: # 参考 https://docs.spring.io/spring-cloud-stream/docs/4.1.x/reference/html/spring-cloud-stream.html#_configuration_options default: consumer: maxAttempts: ${KAFKA_BINDINGS_CONSUMER_MAX_ATTEMPTS:3} backOffInitialInterval: ${CONSUMER_RETRY_INTERVAL:1000} bindings: ssha5007Consumer-in-0: destination: ${POS_INFORMATION_OUTPUT_TOPIC:ane-1-shelf-dev-7-topic} group: ssha5007Consumer-in-group contentType: application/json consumer: partitioned: true concurrency: ${KAFKA_BINDINGS_CONSUMER_CONCURRENCY:1} warmup-out-0: destination: ${BINDINGS_DESTINATION_WARMUP_TOPIC:online-warmup-dummy-topic} contentType: application/json kafka: # 参考 https://docs.spring.io/spring-cloud-stream/docs/4.1.x/reference/html/spring-cloud-stream-binder-kafka.html#_configuration_options binder: brokers: ${KAFKA_BROKER_LIST:localhost} autoCreateTopics: true configuration: security: protocol: ${KAFKA_SECURITY_PROTOCOL:PLAINTEXT} sasl: jaas: config: org.apache.kafka.common.security.plain.PlainLoginModule required username="${KAFKA_USER:null}" password="${KAFKA_PASSWORD:null}"; mechanism: ${KAFKA_SASL_MECHANISM:GSSAPI} # Producer Configuration retries: 3 batch.size: 16384 linger.ms: 1 enable.idempotence: true buffer.memory: 33554432 request.timeout.ms: 3000 transaction.timeout.ms: 3000 # Not to use spring.cloud.stream.kafka.binder.required-acks to avoid a bug. # https://github.com/spring-cloud/spring-cloud-stream-binder-kafka/issues/558 acks: "all" # Consumer Configuration isolation.level: read_committed max.poll.records: 1 max.poll.interval.ms: 1020000 auto-add-partitions: true min-partition-count: ${KAFKA_PARTITION_COUNT:1} replicationFactor: -1 transaction: transaction-id-prefix: ${spring.application.name}-${random.uuid} enableObservation: true bindings: ssha5007Consumer-in-0: consumer: enable-dlq: true dlq-name: ${POS_JOURNAL_DEAD_LETTER:ane-1-shelf-dev-7-dead-letter} autoCommitOnError: false application: name: shelf-subscriber-ssha5007-application mybatis: # 参考 https://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/#configuration mapper-locations: - classpath*:/jp/co/sej/ssc/**/*-sql-map.xml # サンプルAP用SQL Mapファイル configuration: map-underscore-to-camel-case: true default-statement-timeout: ${MYBATIS_DEFAULT_STATEMENTTIMEOUT:300} log-impl: ${MYBATIS_LOG_IMPL:org.apache.ibatis.logging.stdout.StdOutImpl} # ログ設定 logging: level: # root: info # web: trace # sql: debug # org.springframework: # security: info com.nec.jp.rpf.zwb.framework: info com.nec.jp.rpf.zcp.framework: info '[jp.co.sej.ssc]': ${AP_LOG_LEVEL:INFO} '[jp.co.sej.ssc.cl]': ${AP_LOG_LEVEL_CL:WARN} # フレームワーク設定 rpf-zwb-framework: # アプリケーションサービスタイプ指定。 サービスのタイプによってrest/subscriberのいずれかを指定。省略時はrest。 application-service-type: subscriber # データソースルーティング設定 single / primary-and-readonly # プライマリーおよび、リードオンリーデータソース利用時は primary-and-readonly を指定。 # 単一データソース利用時は single を指定。 # 項目省略時は single # datasource-routing: primary-and-readonly # フレームワークロガー設定 logger: operation: # リクエスト・レスポンス JSONマスキングログ出力設定 masking-logger: masked-output-value: xxmaskedxx # マスキング出力文字列を指定。 項目省略時は '**masked**' rest-api: # REST APIサービス request-logging: true # リクエストログ出力 出力する:true / 出力しない:false 項目省略時は false response-logging: true # レスポンスログ出力 出力する:true / 出力しない:false 項目省略時は false rest-cooperation: # RESTサービス連携 request-logging: true # リクエストログ出力 出力する:true / 出力しない:false 項目省略時は false response-logging: true # レスポンスログ出力 出力する:true / 出力しない:false 項目省略時は false stream-subscriber: # 分散メッセージング(Pub/Sub) Subscriber サービス subscribe-logging: true # サブスクライブログ出力 出力する:true / 出力しない:false 項目省略時は false stream-publisher: # 分散メッセージング(Pub/Sub) Publisher publish-logging: true # パブリッシュログ出力 出力する:true / 出力しない:false 項目省略時は false cloud: stream: # Subscriber サービス設定 subscriber: # 業務ロジックのResultTypeに対する例外スロー対象を設定。FATAL/ERROR/WARN を指定。その他の値や指定がない場合は例外スローしません。 # DLQを設定している場合、例外スローにより該当メッセージがDLQに格納されます。 # throw-exception-level: FATAL # SubscriberでシナリオロジックサービスのシナリオID引数を省略した場合のシナリオID default-scenario-id: SUBSCRIBE_SSHA5007 # サンプルAP設定(テスト用) rpf-zwb-example: test-property: testvalue # Spring Boot Actuator設定 management: health: pubsub: enabled: false # 参考 https://docs.spring.io/spring-boot/appendix/application-properties/index.html#appendix.application-properties.actuator endpoints: web: base-path: / health: probes.enabled: true # Kubernetes Probes # Micrometer Tracing用 tracing: baggage: # HTTPヘッダーで渡される情報とBaggageで渡されるキーを定義 remote-fields: requester, X-DELIVERY-STORE-DIVISION, baggageInfo correlation: # requesterは指定せず、ロジックでThreadContextに取り込む。指定すると、Baggage操作、Baggage送信時に更新されるため fields: baggageInfo propagation: type: B3 sampling: probability: 0.0 # RESTサービス連携 cooperation: time-options: read-timeout: ${COOPERATION_TIMEOPTIONS_READTIMEOUT:5000} connect-timeout: ${COOPERATION_TIMEOPTIONS_CONNECTTIMEOUT:3000} retry-limit: ${COOPERATION_TIMEOPTIONS_RETRYLIMIT:0} domain-name: ${COOPERATION_DOMAIN_NAME:localdomain} retry-for-kafka: # retryable-exceptions-disabled: true retryable-exceptions: org.apache.kafka.common.errors.UnknownProducerIdException: true org.apache.kafka.common.errors.InvalidPidMappingException: true traverse-causes: true 哪个是管运行超时的
10-10
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值