Details
-
Type:
Bug
-
Status: Confirmed (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.7.4
-
Fix Version/s: None
-
Component/s: metadata
-
Labels:
-
Environment:SUSE11
Description
Recently, i use mariadb jdbc replace of mysql jdbc in our project. After replcing i found there is heavyer time costs of page reload in one of my forward app. To figure out why i has a below comparsion, i found it's the deal of the methond connection.getMetaData().getProcedureColumns().
in my case mariadb jdbc cost more 8 -10 times than MySQL jdbc.
Then i trace the source of mariadb jdbc i found that Mariadb JDBC actually queries the system table INFORMATION_SCHEMA.PARAMETERS to obtain a ResultSet describing stored procedures, which means that the performance of this method will gradually decline as the data volume of the system table increases.
Attachments
Issue Links
- is caused by
-
MDEV-20609 Full table scan in INFORMATION_SCHEMA.PARAMETERS
-
- Confirmed
-