How, using Python, can I find how long a MySQL query took? -

i'm connecting mysql mysqldb module. don't want use python's time functions: want know how long query ran within mysql, i.e. number see after i've run query within mysql directly.

i see thread addressed 1 dig down to, hoping since mysql reports number, python connection have picked somewhere.

may help?

set profiling = 1; run query; show profiles; 

see here:http://dev.mysql.com/doc/refman/5.7/en/show-profile.html

Ｂｅｃａｕｓｅ　ｏｆ　ｔｈｅ　ａｂｏｖｅ　ｃｏｍｍａｎｄｓ　ｗｉｌｌ　ｂｅ　ｒｅｍｏｖｅｄ　ｉｎ　ｔｈｅ　ｆｕｔｕｒｅ　ｖｅｒｓｉｏｎ，　 performance schema ｃａｎ　ｂｅ　ｕｓｅｄ　http://dev.mysql.com/doc/refman/5.7/en/performance-schema.html　ａｎｄ　http://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html．

Ｏｎ　ｔｈｅ　ａｂｏｖｅ　ｌｉｎｋｓ，　ｔｈｅｒｅ　ａｒｅ　ｍｏｒｅ　ｄｅｔａｉｌｓ　ｏｎ　query profiling using performance schema．