Suddenly Yii application become too slow

Hi,

I was developing an yii2 application after installing jui though composer update my application become slow when i opened the profiler i found that a query is taking too long time to execute even on blank pages that query is being executed .

can some tell what this query is doing and how to tackle this deadly slow query why it is being executed.

00:49:31.557 14946.1 ms yii\db\Command::query

SELECT

kcu.constraint_name,


kcu.column_name,


kcu.referenced_table_name,


kcu.referenced_column_name

FROM information_schema.referential_constraints AS rc

JOIN information_schema.key_column_usage AS kcu ON

kcu.constraint_catalog = rc.constraint_catalog AND


kcu.constraint_schema = rc.constraint_schema AND


kcu.constraint_name = rc.constraint_name

WHERE rc.table_name = ‘user’

Can someone help

Thank you!

Can some body point me in right direction

My processing time isincreasing because of these queries.

eg:

Total processing time: 16,601 ms; Peak memory: 4.961 MB.

05:10:18.046 3729.2 ms yii\db\Command::query

SELECT

kcu.constraint_name,


kcu.column_name,


kcu.referenced_table_name,


kcu.referenced_column_name

FROM information_schema.referential_constraints AS rc

JOIN information_schema.key_column_usage AS kcu ON

kcu.constraint_catalog = rc.constraint_catalog AND


kcu.constraint_schema = rc.constraint_schema AND


kcu.constraint_name = rc.constraint_name

WHERE rc.table_name = ‘user’

Thanks

That’s recent commits from master. Was fixed about 30 minutes ago so update and try again.

Thanks

please share where can i read about what was the problem.