View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0028240 | mantisbt | db mysql | public | 2021-04-12 05:26 | 2021-05-12 09:34 |
Reporter | sintaq | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | closed | Resolution | no change required | ||
Summary | 0028240: High cost statement based on MySQL Workbench performance report | ||||
Description | Got 2 statement that interest me. Are these normal? Below is the statement that executed with highest number but 0 warning. Refer image 2 Another statement is below with the highest warning. Refer image 1 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
You have not pasted the whole SQL, but it seems like it's querying the information_schema.
The high usage is easily explained, as the statement is executed whenever the database API is initialized (i.e. connection is established), as documented here): Applications that use the database should also configure their connection to the server each time they connect. This can be done by executing a SET NAMES 'utf8' statement after connecting. As for the warning, I don't know - maybe you can tell us more about what it is ? |
|
sintaq, You did not provide any feedback; I am therefore resolving this issue as "no change required". Feel free to reopen the issue at a later time and provide the requested information. |
|