some select statement can't be captured after enable profiling
Posted by: Terry Xia
Date: December 20, 2019 07:28PM

MySQL version is 5.5.34, when I set profiling=1, then I execute some SQL statement, most of them can be capture, but when I execute a view (this view is joined from 2 tables), and use "show profiles", it show system didn't capture the view. could you please tell me what the reason caused ? the total captured query_ID didn't reach the maximum of profiling_history_size. and how to change the value of profiling_history_size? many thanks!
I

Options: ReplyQuote


Subject
Written By
Posted
some select statement can't be captured after enable profiling
December 20, 2019 07:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.