Skip to content

Investigate slow queries #551

Open
Open
@php-coder

Description

@php-coder

From production logs:

2016-10-12 22:35:18.249 INFO 914 --- [main] m.w.s.FilesystemImagePersistenceStrategy : Images will be saved into /data/uploads directory
2016-10-12 22:35:20.321 INFO 914 --- [main] MySQL : SLOW QUERY created: Wed Oct 12 22:35:20 MSK 2016 duration: 941 connection: 4 statement: 5 resultset: 0 message: Slow query (exceeded 500 ms, duration: 941 ms):SELECT * FROM TOGGLZ

2016-12-09 00:00:00.610 INFO 2038 --- [pool-1-thread-1] MySQL : SLOW QUERY created: Fri Dec 09 00:00:00 MSK 2016 duration: 566 connection: 19 statement: 19497 resultset: 0 message: Slow query (exceeded 500 ms, duration: 566 ms):SELECT COUNT(*) FROM users_activation WHERE created_at >= '2016-12-08 00:00:00'
2016-12-09 00:00:02.858 INFO 2038 --- [SimpleAsyncTaskExecutor-7] ru.mystamps.web.service.MailServiceImpl : E-mail with daily statistics for 08.12.2016 has been sent to [email protected] (lang: ru)

2017-02-16 22:37:17.780 INFO 17675 --- [SimpleAsyncTaskExecutor-14] MySQL : SLOW QUERY created: Thu Feb 16 22:37:17 MSK 2017 duration: 548 connection: 50 statement: 999 resultset: 0 message: Slow query (exceeded 500 ms, duration: 548 ms):commit

Some of them are old but I put them here for the record.

Metadata

Metadata

Assignees

No one assigned

    Labels

    area/optimizationThis change could speed up our siteenvironment/prodIssue affects only production environment

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions