Extended_info column is empty in stats_mysql_processlist

Polyglot Projects ProxySQL
1

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

1 Like
2

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

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';
1 Like
3

Thanks, works like a charm :slight_smile:

1 Like