How / when does mysql compile stored procedures?

We intend to use mysql stored procedures to handle all database work for one project. There are several applications (different languages) that use the same database, and I am sure that there are many repetitions of SQL code in these applications.

And then, while reading something about mysq, I stumbled upon http://www.joinfu.com/2010/05/mysql-stored-procedures-aint-all-that/
The article says that stored procedures are compiled every time creating a new db connection.
Will mysql compile ALL (at least 3 digits) stored procedures in the database?

+5
source share
2 answers

. , . , , , , , , .

, MySQL, , , - - , , .

. , , , , . , , . .

+5

MySQL . , , .

. .

+3

All Articles