# Extended\_info column is empty in stats\_mysql\_processlist

**URL:** <https://forums.percona.com/t/extended-info-column-is-empty-in-stats-mysql-processlist/15846>\
**Category:** ProxySQL\
**Created:** [May 26, 2022, 2:26pm UTC](https://forums.percona.com/t/extended-info-column-is-empty-in-stats-mysql-processlist/15846 "2022-05-26T14:26:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aleksandar\_Kostovski](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aleksandar_kostovski/32/6608_2.png) [@Aleksandar\_Kostovski](https://forums.percona.com/u/Aleksandar_Kostovski)\
**Post date:** [May 26, 2022, 2:26pm UTC](https://forums.percona.com/t/extended-info-column-is-empty-in-stats-mysql-processlist/15846/1 "2022-05-26T14:26:34Z")

</div>

Hi,

I am using ProxySQL version 2.3.2-percona-1.1, codename Truls

and I am trying to disable multiplexing globally in order to check some theory of mine with

UPDATE global\_variables SET variable\_value=0 WHERE variable\_name=‘mysql-multiplexing’;  
LOAD MYSQL VARIABLES TO RUNTIME;  
SAVE MYSQL VARIABLES TO DISK;

However when I try to check if it’s effective in stats\_mysql\_processlist the extended\_info column remains NULL for all sessions

Why is extended\_info empty ?

Thanks,

Aleksandar

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [May 27, 2022, 6:27pm UTC](https://forums.percona.com/t/extended-info-column-is-empty-in-stats-mysql-processlist/15846/2 "2022-05-27T18:27:11Z")

</div>

Hi @Aleksandar_Kostovski welcome to the Percona forums!  
You need to enable the extended info as it is disabled by default:

```auto
update global_variables set variable_value=1 where variable_name = 'mysql-show_processlist_extended';
load mysql variables to runtime;
select * from runtime_global_variables where variable_name='mysql-show_processlist_extended';

```

---

<div class="post-metadata">

**Author:** ![Aleksandar\_Kostovski](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aleksandar_kostovski/32/6608_2.png) [@Aleksandar\_Kostovski](https://forums.percona.com/u/Aleksandar_Kostovski)\
**Post date:** [May 31, 2022, 8:19am UTC](https://forums.percona.com/t/extended-info-column-is-empty-in-stats-mysql-processlist/15846/3 "2022-05-31T08:19:46Z")

</div>

Thanks, works like a charm 🙂