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
 
-