AnilBafila
(Anilbafiladev)
September 30, 2015, 7:28pm
1
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!
AnilBafila
(Anilbafiladev)
September 30, 2015, 11:47pm
2
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
samdark
(Alexander Makarov)
October 1, 2015, 11:21am
3
That’s recent commits from master. Was fixed about 30 minutes ago so update and try again.
AnilBafila
(Anilbafiladev)
October 2, 2015, 4:50am
4
Thanks
please share where can i read about what was the problem.