maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

Stored procedures are slow in MariaDB and MySQL. I reported a bug for this, and Elena Stepanova's comment explains the reason, or maybe one of the reasons. The bug is:
https://jira.mariadb.org/browse/MDEV-8254

MariaDB 10.1 is not slower than other versions. From my tests, MySQL 5.7 is almost thrice slower (wtf...), and in one case it caused the OOM to kill mysqld (wtf!?!?).

Suggestion: try to avoid using @user_variables. Replace them with local_variables. NEW. and OLD. variables in triggers are ok. Queries are ok. I think that the only problem is access to variables.

Regards,
Federico



--------------------------------------------
Mar 19/4/16, Bruce Carlson <Bruce.Carlson@xxxxxxxxxx> ha scritto:

 Oggetto: [Maria-discuss] Mariadb 10.1.13 slow stored procedures
 A: "maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Martedì 19 Aprile 2016, 01:24
 
 
 
  
  
 
 
 
 
 HI All, 
    
 Just a quick question to
 start with, does anybody know why MariaDB 10.1.13 is
 extremely slow running stored procedures.
 
 
 
 I have searched for as much as I can find and have made sure
 the database and table character sets and compilation seta
 are identical but still stored procedures with lots of joins
 and internal variables is running hundreds of times slower
 than the old version
  5.3.
 
 
 
 I have checked all system variables and they are identical
 in both systems (where they exist in both systems)
 
 
 
 Any assistance or advice would be greatly appreciated.
 
 
 
 If I need to supply more information please let me know.
 
    
 Both versions are running
 on windows server 2008 R2 
    
    
 Kind Regards, 
 
 
 
 
 
 
 Bruce Carlson 
 
 
 
 
    
 
 
 
 -----Segue allegato-----
 
 _______________________________________________
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp