# Assign global variable to stored procedure variables

**URL:** <https://forums.percona.com/t/assign-global-variable-to-stored-procedure-variables/1292>\
**Category:** Other MySQL® Questions\
**Created:** [November 16, 2009, 6:01am UTC](https://forums.percona.com/t/assign-global-variable-to-stored-procedure-variables/1292 "2009-11-16T06:01:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [November 16, 2009, 6:01am UTC](https://forums.percona.com/t/assign-global-variable-to-stored-procedure-variables/1292/1 "2009-11-16T06:01:18Z")

</div>

How can i assign output of following global variable to other variable in stored procedure?

SHOW GLOBAL VARIABLES LIKE ‘innodb\_buffer\_pool\_size’  
(mysql 5.0)

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [November 16, 2009, 11:16pm UTC](https://forums.percona.com/t/assign-global-variable-to-stored-procedure-variables/1292/2 "2009-11-16T23:16:32Z")

</div>

Seemingly we cant assign that!!  
I was trying to do this.