Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.7.4
-
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/ROUTINES
- Closed