• Sergey Vojtovich's avatar
    MDEV-14505 - Threads_running becomes scalability bottleneck · 159a6c2e
    Sergey Vojtovich authored
    Instead of updating global counter, calculate Threads_running on the fly.
    All threads having command != COM_SLEEP are included.
    
    Behaviour changes:
    
    Previously SHOW STATUS and SHOW GLOBAL STATUS returned the same values
    representing global status. Now SHOW STATUS always returns 1 indicating that
    current session has 1 thread running.
    
    Previously only threads that were executing dispatch_command() or running events
    were accounted by Threads_running. Now it is rough equivalent of
    SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST WHERE state!='Sleep'
    159a6c2e
sql_class.cc 228 KB