Skip to content

Instantly share code, notes, and snippets.

@joshdurbin

joshdurbin/1 systemctl status proxysql

Last active January 2, 2026 22:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save joshdurbin/c8d415fd3d092e521cd849d0005f5fe7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save joshdurbin/c8d415fd3d092e521cd849d0005f5fe7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
1 systemctl status proxysql
[production][us-central1][joshua.durbin@proxysql-store-22-13w0]:~$ systemctl status proxysql
● proxysql.service - High Performance Advanced Proxy for MySQL
Loaded: loaded (/etc/systemd/system/proxysql.service; enabled; preset: enabled)
Active: active (running) since Mon 2025-12-15 11:37:55 UTC; 2 weeks 4 days ago
Main PID: 756 (proxysql)
Tasks: 85 (limit: 19168)
Memory: 8.9G
CPU: 1month 2w 1d 22h 41min 6.130s
CGroup: /system.slice/proxysql.service
├─ 756 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
├─ 757 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
├─ 512413 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
├─ 811139 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
├─1412525 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
├─2578774 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
├─3340684 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
├─3670164 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
├─3684809 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
└─4125760 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
Jan 02 20:09:26 proxysql-store-22-13w0 split-brain-blocker[2696025]: No multiple writeable masters detected.
Jan 02 20:10:08 proxysql-store-22-13w0 split-brain-blocker[2698564]: No multiple writeable masters detected.
Jan 02 20:10:50 proxysql-store-22-13w0 split-brain-blocker[2698919]: No multiple writeable masters detected.
Jan 02 20:14:19 proxysql-store-22-13w0 split-brain-blocker[2700737]: No multiple writeable masters detected.
Jan 02 20:15:49 proxysql-store-22-13w0 split-brain-blocker[2701516]: No multiple writeable masters detected.
Jan 02 20:16:06 proxysql-store-22-13w0 split-brain-blocker[2701680]: No multiple writeable masters detected.
Jan 02 20:16:26 proxysql-store-22-13w0 split-brain-blocker[2701855]: No multiple writeable masters detected.
Jan 02 20:18:06 proxysql-store-22-13w0 split-brain-blocker[2702743]: No multiple writeable masters detected.
Jan 02 20:18:47 proxysql-store-22-13w0 split-brain-blocker[2703094]: No multiple writeable masters detected.
Jan 02 20:20:48 proxysql-store-22-13w0 split-brain-blocker[2706292]: No multiple writeable masters detected.
Raw
1 systemd-cgtop -m -n 1
[production][us-central1][joshua.durbin@proxysql-store-22-13w0]:~$ systemd-cgtop -m -n 1
Control Group Tasks %CPU Memory Input/s Output/s
system.slice 503 - 13.7G - -
/ 670 - 11.5G - -
system.slice/proxysql.service 85 - 8.9G - -
system.slice/dragent.service 59 - 1.2G - -
system.slice/agent-proxysql-stats.service 7 - 1.2G - -
system.slice/systemd-journald.service 1 - 671.4M - -
user.slice 11 - 376.1M - -
system.slice/google-osconfig-agent.service 22 - 221.2M - -
system.slice/filebeat-logstash.service 22 - 179.5M - -
system.slice/syslog-ng.service 4 - 144.3M - -
system.slice/teleport.service 26 - 136.8M - -
system.slice/consul.service 24 - 106.9M - -
system.slice/cron.service 1 - 100.1M - -
system.slice/agent-proxysql.service 7 - 76.7M - -
system.slice/telegraf.service 21 - 67.5M - -
system.slice/prometheus-sql-exporter.service 20 - 66.9M - -
system.slice/google-guest-agent-manager.service 39 - 44.5M - -
system.slice/consul-template.service 23 - 41.2M - -
system.slice/prometheus-postfix-exporter.service 19 - 39.8M - -
system.slice/choria-server.service 21 - 39.4M - -
system.slice/querychecker.service 21 - 38.4M - -
system.slice/prometheus-node-exporter.service 21 - 37.8M - -
system.slice/unbound.service 4 - 33.6M - -
system.slice/healthcheck.service 3 - 19.6M - -
system.slice/google-guest-agent.service 17 - 19.0M - -
system.slice/networkd-dispatcher.service 1 - 15.7M - -
system.slice/unattended-upgrades.service 2 - 15.5M - -
system.slice/google-guest-compat-manager.service 13 - 14.9M - -
system.slice/gcp-migration-trigger.service 1 - 11.1M - -
user.slice/user-5089.slice 6 - 10.5M - -
system.slice/logfile2syslog.service 1 - 10.4M - -
init.scope 1 - 9.4M - -
system.slice/system-postfix.slice 4 - 8.5M - -
system.slice/system-postfix.slice/postfix@-.service 4 - 8.4M - -
user.slice/user-5089.slice/session-125376.scope 4 - 7.4M - -
system.slice/systemd-resolved.service 1 - 6.2M - -
user.slice/user-5080.slice 5 - 6.1M - -
system.slice/ssh.service 1 - 5.6M - -
system.slice/haveged.service 1 - 5.4M - -
system.slice/polkit.service 3 - 5.0M - -
system.slice/systemd-udevd.service 1 - 4.3M - -
system.slice/chrony.service 2 - 4.1M - -
user.slice/user-5080.slice/user@5080.service 2 - 3.4M - -
system.slice/systemd-networkd.service 1 - 2.8M - -
user.slice/user-5089.slice/user@5089.service 2 - 2.7M - -
user.slice/user-5080.slice/session-123614.scope 3 - 2.5M - -
system.slice/dbus.service 1 - 2.0M - -
Raw
1 systmed unit file for proxysql
[Unit]
Description=High Performance Advanced Proxy for MySQL
After=network.target
Wants=agent-proxysql.service agent-proxysql-stats.service
[Service]
Type=forking
EnvironmentFile=-/etc/default/proxysql
RuntimeDirectory=proxysql
ExecStart=/usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf $PROXYSQL_OPTS
PIDFile=/var/lib/proxysql/proxysql.pid
SyslogIdentifier=proxysql
Restart=always
RestartSec=5s
User=proxysql
Group=proxysql
PermissionsStartOnly=true
UMask=0007
LimitNOFILE=102400
LimitCORE=1073741824
ProtectHome=yes
NoNewPrivileges=true
CapabilityBoundingSet=CAP_SETGID CAP_SETUID CAP_SYS_RESOURCE
RestrictAddressFamilies=AF_INET AF_INET6 AF_UNIX AF_ALG
ProtectSystem=full
PrivateDevices=yes
[Install]
WantedBy=multi-user.target
Raw
2 free -m
[production][us-central1][joshua.durbin@proxysql-store-22-13w0]:~$ free -m
total used free shared buff/cache available
Mem: 15999 11737 1195 0 3402 4261
Swap: 0 0 0
Raw
2 htop filtered for proxysql
[production][us-central1][joshua.durbin@proxysql-store-22-13w0]:~$ htop
0[||||||||||||||||||||||||||| 31.2%] 4[|||||||||||||||||||||||||| 29.1%] 8[|||||||||||||||||||| 23.0%] 12[|||||||||||||||||| 20.6%]
1[|||||||||||||||||||||||| 27.7%] 5[||||||||||||||||||||||||| 29.7%] 9[|||||||||||||||||| 20.9%] 13[||||||||||||||| 17.8%]
2[||||||||||||||||||||||||| 29.7%] 6[||||||||||||||||||||||||||| 31.6%] 10[|||||||||||||||| 18.1%] 14[||||||||||||||||||| 21.5%]
3[||||||||||||||||||||||||| 28.7%] 7[|||||||||||||||||||||||||||||| 34.7%] 11[||||||||||||||| 16.7%] 15[||||||||||||||||||||||||||||| 32.7%]
Mem[||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| 11.0G/15.6G] Tasks: 67, 447 thr, 160 kthr; 3 running
Swp[ 0K/0K] Load average: 3.24 3.22 3.19
Uptime: 18 days, 08:38:48
[Main] [I/O]
PID△USER PRI NI VIRT RES SHR S CPU% MEM% TIME+ Command
756 proxysql 20 0 38796 11948 2484 S 0.0 0.1 0:00.00 ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
757 proxysql 20 0 3163M 947M 9556 S 292.1 5.9 1087h46m │ └─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
758 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 25:26.65 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
759 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:14.29 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
767 proxysql 20 0 3163M 947M 9556 S 3.2 5.9 4h32:51 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
768 proxysql 20 0 3163M 947M 9556 R 15.8 5.9 61h25:39 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
769 proxysql 20 0 3163M 947M 9556 S 1.6 5.9 3h57:38 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
770 proxysql 20 0 3163M 947M 9556 S 15.8 5.9 61h21:06 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
771 proxysql 20 0 3163M 947M 9556 S 1.6 5.9 3h57:18 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
772 proxysql 20 0 3163M 947M 9556 S 18.5 5.9 61h22:00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
773 proxysql 20 0 3163M 947M 9556 S 1.1 5.9 3h57:11 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
774 proxysql 20 0 3163M 947M 9556 R 15.8 5.9 61h24:23 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
775 proxysql 20 0 3163M 947M 9556 S 0.5 5.9 3h57:35 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
776 proxysql 20 0 3163M 947M 9556 S 18.5 5.9 61h21:53 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
777 proxysql 20 0 3163M 947M 9556 S 1.1 5.9 3h57:16 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
778 proxysql 20 0 3163M 947M 9556 S 16.3 5.9 61h23:19 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
779 proxysql 20 0 3163M 947M 9556 R 1.1 5.9 3h57:28 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
780 proxysql 20 0 3163M 947M 9556 S 15.8 5.9 61h21:51 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
781 proxysql 20 0 3163M 947M 9556 S 1.1 5.9 3h57:25 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
782 proxysql 20 0 3163M 947M 9556 S 16.3 5.9 61h22:25 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
783 proxysql 20 0 3163M 947M 9556 S 1.1 5.9 3h57:19 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
784 proxysql 20 0 3163M 947M 9556 S 17.4 5.9 61h24:36 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
785 proxysql 20 0 3163M 947M 9556 S 1.1 5.9 3h57:36 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
786 proxysql 20 0 3163M 947M 9556 S 16.3 5.9 61h19:03 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
787 proxysql 20 0 3163M 947M 9556 S 1.1 5.9 3h57:14 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
788 proxysql 20 0 3163M 947M 9556 S 17.9 5.9 61h24:27 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
789 proxysql 20 0 3163M 947M 9556 S 1.6 5.9 3h57:19 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
790 proxysql 20 0 3163M 947M 9556 S 16.9 5.9 61h19:16 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
791 proxysql 20 0 3163M 947M 9556 S 1.6 5.9 3h57:57 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
792 proxysql 20 0 3163M 947M 9556 S 16.3 5.9 61h20:10 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
793 proxysql 20 0 3163M 947M 9556 S 1.1 5.9 3h57:23 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
794 proxysql 20 0 3163M 947M 9556 S 20.6 5.9 61h20:40 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
795 proxysql 20 0 3163M 947M 9556 S 1.1 5.9 3h57:27 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
796 proxysql 20 0 3163M 947M 9556 S 17.4 5.9 61h16:37 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
798 proxysql 20 0 3163M 947M 9556 S 1.6 5.9 3h57:36 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
799 proxysql 20 0 3163M 947M 9556 S 14.8 5.9 61h19:38 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
800 proxysql 20 0 3163M 947M 9556 S 1.6 5.9 3h57:25 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
801 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 2:26.16 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
802 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 2:10.45 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
803 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
804 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 19:30.11 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
805 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 1:20.58 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
806 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 1:49.38 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
807 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 1:48.83 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
808 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 18:51.49 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
809 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 20:11.66 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
810 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 14:18.43 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
811 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 31:48.25 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
812 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:46.13 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
813 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 31:26.78 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
814 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 5:23.95 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
4558 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:17.59 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
4559 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:17.54 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
4568 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:17.61 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
4569 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 3:07.31 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
7364 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 31h57:16 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
512413 proxysql 20 0 3095M 1125M 1124 S 0.0 7.0 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
512414 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
811139 proxysql 20 0 3115M 1139M 968 S 0.0 7.1 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
811140 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
1412525 proxysql 20 0 3095M 881M 1096 S 0.0 5.5 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
1412526 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2578774 proxysql 20 0 3115M 974M 968 S 0.0 6.1 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2578775 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2662523 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:53.30 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2662524 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:53.40 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2662525 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:53.09 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2662526 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:53.04 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2662527 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:53.09 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2662528 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:53.28 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2695554 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2701181 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.01 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2701526 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2701566 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2701640 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2701641 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
2701818 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
3340684 proxysql 20 0 3054M 1034M 1252 S 0.0 6.5 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
3340685 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
3670164 proxysql 20 0 3115M 931M 1032 S 0.0 5.8 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
3670165 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
3684809 proxysql 20 0 3163M 945M 904 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
3684810 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
4125760 proxysql 20 0 3075M 801M 1188 S 0.0 5.0 0:00.00 │ ├─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
4125761 proxysql 20 0 3163M 947M 9556 S 0.0 5.9 0:00.00 │ └─ /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
F1Help F2Setup F3SearchF4FILTERF5List F6SortByF7Nice -F8Nice +F9Kill F10Quit
Raw
2 ps stats
[production][us-central1][joshua.durbin@proxysql-store-22-13w0]:~$ ps -p 756 -o pid,ppid,cmd,%mem,rss,vsz
PID PPID CMD %MEM RSS VSZ
756 1 /usr/bin/proxysql --idle-th 0.0 11948 38796
[production][us-central1][root@proxysql-store-22-13w0]:~# ps -C proxysql -o pid,ppid,rss,vsz,etimes,cmd --sort=-rss
PID PPID RSS VSZ ELAPSED CMD
757 756 1221556 3231196 1587680 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
756 1 11948 38796 1587680 /usr/bin/proxysql --idle-threads -c /etc/my-proxysql.cnf --initial
Raw
3 cat proxysql cgroup memory stats
[production][us-central1][joshua.durbin@proxysql-store-22-13w0]:~$ cat /sys/fs/cgroup/system.slice/proxysql.service/memory.stat
anon 7378522112
file 17424384
kernel 104382464
kernel_stack 1392640
pagetables 50012160
sec_pagetables 0
percpu 3240
sock 14073856
vmalloc 20480
shmem 0
file_mapped 6406144
file_dirty 106496
file_writeback 0
swapcached 0
anon_thp 48234496
file_thp 0
shmem_thp 0
inactive_anon 9472278528
active_anon 4096
inactive_file 450560
active_file 16973824
unevictable 0
slab_reclaimable 38365152
slab_unreclaimable 14242088
slab 52607240
workingset_refault_anon 0
workingset_refault_file 16295
workingset_activate_anon 0
workingset_activate_file 15083
workingset_restore_anon 0
workingset_restore_file 862
workingset_nodereclaim 0
pgscan 110167
pgsteal 89291
pgscan_kswapd 110148
pgscan_direct 19
pgsteal_kswapd 89272
pgsteal_direct 19
pgfault 18992775994
pgmajfault 257
pgrefill 33667
pgactivate 465438
pgdeactivate 29362
pglazyfree 0
pglazyfreed 0
thp_fault_alloc 107454
thp_collapse_alloc 37424
Raw
4 Anonymous 8806116 KB --> ~8.8gb
[production][us-central1][root@proxysql-store-22-13w0]:~# for pid in $(pidof proxysql); do echo "=== PID $pid ==="; cat /proc/$pid/smaps_rollup; done
=== PID 4125760 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 821480 kB
Pss: 611432 kB
Pss_Dirty: 611333 kB
Pss_Anon: 611333 kB
Pss_File: 98 kB
Pss_Shmem: 0 kB
Shared_Clean: 1512 kB
Shared_Dirty: 244548 kB
Private_Clean: 0 kB
Private_Dirty: 575420 kB
Referenced: 6412 kB
Anonymous: 819968 kB
LazyFree: 0 kB
AnonHugePages: 10240 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
=== PID 3684809 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 969052 kB
Pss: 758539 kB
Pss_Dirty: 758433 kB
Pss_Anon: 758433 kB
Pss_File: 106 kB
Pss_Shmem: 0 kB
Shared_Clean: 1548 kB
Shared_Dirty: 246768 kB
Private_Clean: 0 kB
Private_Dirty: 720736 kB
Referenced: 8508 kB
Anonymous: 967504 kB
LazyFree: 0 kB
AnonHugePages: 12288 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
=== PID 3670164 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 954320 kB
Pss: 750890 kB
Pss_Dirty: 750783 kB
Pss_Anon: 750783 kB
Pss_File: 106 kB
Pss_Shmem: 0 kB
Shared_Clean: 1548 kB
Shared_Dirty: 229568 kB
Private_Clean: 0 kB
Private_Dirty: 723204 kB
Referenced: 8512 kB
Anonymous: 952772 kB
LazyFree: 0 kB
AnonHugePages: 12288 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
=== PID 3340684 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 1059448 kB
Pss: 858982 kB
Pss_Dirty: 858883 kB
Pss_Anon: 858883 kB
Pss_File: 98 kB
Pss_Shmem: 0 kB
Shared_Clean: 1512 kB
Shared_Dirty: 228896 kB
Private_Clean: 0 kB
Private_Dirty: 829040 kB
Referenced: 8456 kB
Anonymous: 1057936 kB
LazyFree: 0 kB
AnonHugePages: 12288 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
=== PID 2578774 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 998948 kB
Pss: 787208 kB
Pss_Dirty: 787102 kB
Pss_Anon: 787102 kB
Pss_File: 106 kB
Pss_Shmem: 0 kB
Shared_Clean: 1548 kB
Shared_Dirty: 246652 kB
Private_Clean: 0 kB
Private_Dirty: 750748 kB
Referenced: 8508 kB
Anonymous: 997400 kB
LazyFree: 0 kB
AnonHugePages: 14336 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
=== PID 1412525 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 903348 kB
Pss: 699068 kB
Pss_Dirty: 698962 kB
Pss_Anon: 698962 kB
Pss_File: 106 kB
Pss_Shmem: 0 kB
Shared_Clean: 1548 kB
Shared_Dirty: 230840 kB
Private_Clean: 0 kB
Private_Dirty: 670960 kB
Referenced: 8496 kB
Anonymous: 901800 kB
LazyFree: 0 kB
AnonHugePages: 12288 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
=== PID 811139 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 1166964 kB
Pss: 962662 kB
Pss_Dirty: 962555 kB
Pss_Anon: 962555 kB
Pss_File: 106 kB
Pss_Shmem: 0 kB
Shared_Clean: 1548 kB
Shared_Dirty: 230832 kB
Private_Clean: 0 kB
Private_Dirty: 934584 kB
Referenced: 6464 kB
Anonymous: 1165416 kB
LazyFree: 0 kB
AnonHugePages: 12288 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
=== PID 512413 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 1152620 kB
Pss: 944821 kB
Pss_Dirty: 944722 kB
Pss_Anon: 944722 kB
Pss_File: 98 kB
Pss_Shmem: 0 kB
Shared_Clean: 1512 kB
Shared_Dirty: 239000 kB
Private_Clean: 0 kB
Private_Dirty: 912108 kB
Referenced: 8456 kB
Anonymous: 1151108 kB
LazyFree: 0 kB
AnonHugePages: 12288 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
=== PID 757 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 1095508 kB
Pss: 898687 kB
Pss_Dirty: 893010 kB
Pss_Anon: 893010 kB
Pss_File: 5677 kB
Pss_Shmem: 0 kB
Shared_Clean: 4680 kB
Shared_Dirty: 219868 kB
Private_Clean: 5004 kB
Private_Dirty: 865956 kB
Referenced: 1094940 kB
Anonymous: 1085824 kB
LazyFree: 0 kB
AnonHugePages: 8192 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
=== PID 756 ===
55e4b56fd000-7ffe997ba000 ---p 00000000 00:00 0 [rollup]
Rss: 11948 kB
Pss: 3920 kB
Pss_Dirty: 3584 kB
Pss_Anon: 3584 kB
Pss_File: 336 kB
Pss_Shmem: 0 kB
Shared_Clean: 2484 kB
Shared_Dirty: 6556 kB
Private_Clean: 0 kB
Private_Dirty: 2908 kB
Referenced: 6940 kB
Anonymous: 9464 kB
LazyFree: 0 kB
AnonHugePages: 6144 kB
ShmemPmdMapped: 0 kB
FilePmdMapped: 0 kB
Shared_Hugetlb: 0 kB
Private_Hugetlb: 0 kB
Swap: 0 kB
SwapPss: 0 kB
Locked: 0 kB
Raw
4 fd type rollup
for pid in $(pidof proxysql); do echo "=== PID $pid ==="; ls -l /proc/$pid/fd | awk '{print $NF}' | sed 's/.*-> //' \
| awk '
/^socket:/ {c["socket"]++}
/^pipe:/ {c["pipe"]++}
/^anon_inode:/ {c["anon_inode"]++}
/^\/memfd:/ {c["memfd"]++}
/^\// {c["file"]++}
END {for (k in c) print k, c[k]}'; done
=== PID 4125760 ===
pipe 66
socket 3001
file 11
anon_inode 19
=== PID 3684809 ===
pipe 66
socket 2979
file 11
anon_inode 19
=== PID 3670164 ===
pipe 66
socket 2868
file 11
anon_inode 19
=== PID 3340684 ===
pipe 66
socket 3039
file 11
anon_inode 19
=== PID 2578774 ===
pipe 66
socket 3026
file 11
anon_inode 19
=== PID 1412525 ===
pipe 66
socket 2847
file 11
anon_inode 19
=== PID 811139 ===
pipe 66
socket 2932
file 11
anon_inode 19
=== PID 512413 ===
pipe 66
socket 3048
file 11
anon_inode 19
=== PID 757 ===
pipe 66
socket 2969
file 10
anon_inode 19
=== PID 756 ===
file 2
Raw
4 fd usage
[production][us-central1][root@proxysql-store-22-13w0]:~# for pid in $(pidof proxysql); do echo "=== PID $pid ==="; ls /proc/$pid/fd | wc -l; done
=== PID 4125760 ===
3097
=== PID 3684809 ===
3075
=== PID 3670164 ===
2965
=== PID 3340684 ===
3135
=== PID 2578774 ===
3122
=== PID 1412525 ===
2943
=== PID 811139 ===
3028
=== PID 512413 ===
3144
=== PID 757 ===
3107
=== PID 756 ===
2
Raw
4 process cmdline and status
[production][us-central1][root@proxysql-store-22-13w0]:~# for pid in $(pidof proxysql); do echo "=== PID $pid ==="; cat /proc/$pid/cmdline; echo; cat /proc/$pid/status; done
=== PID 4125760 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: Admin
Umask: 0007
State: S (sleeping)
Tgid: 4125760
Ngid: 0
Pid: 4125760
PPid: 757
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 4096
Groups: 116 993
NStgid: 4125760
NSpid: 4125760
NSpgid: 755
NSsid: 755
VmPeak: 3148800 kB
VmSize: 3148800 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 821192 kB
VmRSS: 821156 kB
RssAnon: 819968 kB
RssFile: 1188 kB
RssShmem: 0 kB
VmData: 3120312 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5996 kB
VmPTE: 5400 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 1
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000380000
SigCgt: 00000001000156a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 1
nonvoluntary_ctxt_switches: 0
=== PID 3684809 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: Admin
Umask: 0007
State: S (sleeping)
Tgid: 3684809
Ngid: 0
Pid: 3684809
PPid: 757
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 4096
Groups: 116 993
NStgid: 3684809
NSpid: 3684809
NSpgid: 755
NSsid: 755
VmPeak: 3239324 kB
VmSize: 3239324 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 968408 kB
VmRSS: 968408 kB
RssAnon: 967504 kB
RssFile: 904 kB
RssShmem: 0 kB
VmData: 3210808 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5996 kB
VmPTE: 5456 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 1
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000380000
SigCgt: 00000001000156a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 1
nonvoluntary_ctxt_switches: 5
=== PID 3670164 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: Admin
Umask: 0007
State: S (sleeping)
Tgid: 3670164
Ngid: 0
Pid: 3670164
PPid: 757
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 4096
Groups: 116 993
NStgid: 3670164
NSpid: 3670164
NSpgid: 755
NSsid: 755
VmPeak: 3189964 kB
VmSize: 3189964 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 953804 kB
VmRSS: 953804 kB
RssAnon: 952772 kB
RssFile: 1032 kB
RssShmem: 0 kB
VmData: 3161464 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5996 kB
VmPTE: 5420 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 1
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000380000
SigCgt: 00000001000156a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 1
nonvoluntary_ctxt_switches: 2
=== PID 3340684 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: Admin
Umask: 0007
State: S (sleeping)
Tgid: 3340684
Ngid: 0
Pid: 3340684
PPid: 757
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 4096
Groups: 116 993
NStgid: 3340684
NSpid: 3340684
NSpgid: 755
NSsid: 755
VmPeak: 3128252 kB
VmSize: 3128252 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 1059224 kB
VmRSS: 1059188 kB
RssAnon: 1057936 kB
RssFile: 1252 kB
RssShmem: 0 kB
VmData: 3099768 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5996 kB
VmPTE: 5384 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 1
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000380000
SigCgt: 00000001000156a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 1
nonvoluntary_ctxt_switches: 0
=== PID 2578774 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: Admin
Umask: 0007
State: S (sleeping)
Tgid: 2578774
Ngid: 0
Pid: 2578774
PPid: 757
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 4096
Groups: 116 993
NStgid: 2578774
NSpid: 2578774
NSpgid: 755
NSsid: 755
VmPeak: 3190100 kB
VmSize: 3190100 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 998368 kB
VmRSS: 998368 kB
RssAnon: 997400 kB
RssFile: 968 kB
RssShmem: 0 kB
VmData: 3161592 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5996 kB
VmPTE: 5424 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 1
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000380000
SigCgt: 00000001000156a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 1
nonvoluntary_ctxt_switches: 0
=== PID 1412525 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: Admin
Umask: 0007
State: S (sleeping)
Tgid: 1412525
Ngid: 0
Pid: 1412525
PPid: 757
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 4096
Groups: 116 993
NStgid: 1412525
NSpid: 1412525
NSpgid: 755
NSsid: 755
VmPeak: 3169416 kB
VmSize: 3169416 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 902896 kB
VmRSS: 902896 kB
RssAnon: 901800 kB
RssFile: 1096 kB
RssShmem: 0 kB
VmData: 3140920 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5996 kB
VmPTE: 5412 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 1
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000380000
SigCgt: 00000001000156a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 1
nonvoluntary_ctxt_switches: 1
=== PID 811139 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: Admin
Umask: 0007
State: S (sleeping)
Tgid: 811139
Ngid: 0
Pid: 811139
PPid: 757
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 4096
Groups: 116 993
NStgid: 811139
NSpid: 811139
NSpgid: 755
NSsid: 755
VmPeak: 3190032 kB
VmSize: 3190032 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 1166384 kB
VmRSS: 1166384 kB
RssAnon: 1165416 kB
RssFile: 968 kB
RssShmem: 0 kB
VmData: 3161528 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5996 kB
VmPTE: 5420 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 1
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000380000
SigCgt: 00000001000156a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 1
nonvoluntary_ctxt_switches: 0
=== PID 512413 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: Admin
Umask: 0007
State: S (sleeping)
Tgid: 512413
Ngid: 0
Pid: 512413
PPid: 757
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 4096
Groups: 116 993
NStgid: 512413
NSpid: 512413
NSpgid: 755
NSsid: 755
VmPeak: 3169348 kB
VmSize: 3169348 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 1152268 kB
VmRSS: 1152232 kB
RssAnon: 1151108 kB
RssFile: 1124 kB
RssShmem: 0 kB
VmData: 3140856 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5996 kB
VmPTE: 5412 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 1
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000380000
SigCgt: 00000001000156a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 1
nonvoluntary_ctxt_switches: 0
=== PID 757 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: proxysql
Umask: 0007
State: S (sleeping)
Tgid: 757
Ngid: 0
Pid: 757
PPid: 756
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 8192
Groups: 116 993
NStgid: 757
NSpid: 757
NSpgid: 755
NSsid: 755
VmPeak: 3257836 kB
VmSize: 3231196 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 1614684 kB
VmRSS: 1058732 kB
RssAnon: 1049176 kB
RssFile: 9556 kB
RssShmem: 0 kB
VmData: 3202680 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5996 kB
VmPTE: 5496 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 76
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000380000
SigCgt: 00000001000156a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 7968632
nonvoluntary_ctxt_switches: 2198
=== PID 756 ===
/usr/bin/proxysql--idle-threads-c/etc/my-proxysql.cnf--initial
Name: proxysql
Umask: 0007
State: S (sleeping)
Tgid: 756
Ngid: 0
Pid: 756
PPid: 1
TracerPid: 0
Uid: 999 999 999 999
Gid: 993 993 993 993
FDSize: 64
Groups: 116 993
NStgid: 756
NSpid: 756
NSpgid: 755
NSsid: 755
VmPeak: 38796 kB
VmSize: 38796 kB
VmLck: 0 kB
VmPin: 0 kB
VmHWM: 12496 kB
VmRSS: 11948 kB
RssAnon: 9464 kB
RssFile: 2484 kB
RssShmem: 0 kB
VmData: 10740 kB
VmStk: 132 kB
VmExe: 9056 kB
VmLib: 5932 kB
VmPTE: 100 kB
VmSwap: 0 kB
HugetlbPages: 0 kB
CoreDumping: 0
THP_enabled: 1
Threads: 1
SigQ: 0/63893
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000000381000
SigCgt: 00000000000046a0
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
CapBnd: 00000000010000c0
CapAmb: 0000000000000000
NoNewPrivs: 1
Seccomp: 2
Seccomp_filters: 5
Speculation_Store_Bypass: thread vulnerable
SpeculationIndirectBranch: conditional enabled
Cpus_allowed: ffff
Cpus_allowed_list: 0-15
Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
Mems_allowed_list: 0
voluntary_ctxt_switches: 4
nonvoluntary_ctxt_switches: 3
Raw
5 data from proxysql stats.stats_memory_metrics
[production][us-central1][joshua.durbin@proxysql-store-22-13w0]:~$ sudo mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 559695235
Server version: 8.0.22 (ProxySQL Admin Module)
Copyright (c) 2009-2023 Percona LLC and/or its affiliates
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT * FROM stats.stats_memory_metrics;
+-----------------------------------+----------------+
| Variable_Name | Variable_Value |
+-----------------------------------+----------------+
| SQLite3_memory_bytes | 5677144 |
| jemalloc_resident | 807849984 |
| jemalloc_active | 501952512 |
| jemalloc_allocated | 421572296 |
| jemalloc_mapped | 936038400 |
| jemalloc_metadata | 32821384 |
| jemalloc_retained | 2069704704 |
| Auth_memory | 16359 |
| query_digest_memory | 103045460 |
| mysql_query_rules_memory | 21061 |
| prepare_statement_metadata_memory | 35820266 |
| prepare_statement_backend_memory | 288688 |
| mysql_firewall_users_table | 0 |
| mysql_firewall_users_config | 0 |
| mysql_firewall_rules_table | 0 |
| mysql_firewall_rules_config | 329 |
| stack_memory_mysql_threads | 268435456 |
| stack_memory_admin_threads | 109051904 |
| stack_memory_cluster_threads | 0 |
+-----------------------------------+----------------+
19 rows in set (0.03 sec)
Raw
5 random sql stats
[proxysql-store-22-13w0][][21:00:36][(none)] mysql> SELECT * FROM global_variables WHERE variable_name LIKE '%query_digest%';
+-------------------------------------------+----------------+
| variable_name | variable_value |
+-------------------------------------------+----------------+
| mysql-query_digests_max_digest_length | 2048 |
| mysql-query_digests_max_query_length | 65000 |
| mysql-query_digests_grouping_limit | 3 |
| mysql-query_digests_groups_grouping_limit | 10 |
| mysql-query_digests | true |
| mysql-query_digests_lowercase | false |
| mysql-query_digests_replace_null | false |
| mysql-query_digests_no_digits | false |
| mysql-query_digests_track_hostname | false |
| mysql-query_digests_keep_comment | false |
| mysql-query_digests_normalize_digest_text | false |
| admin-stats_mysql_query_digest_to_disk | 0 |
+-------------------------------------------+----------------+
12 rows in set (0.30 sec)
[proxysql-store-22-13w0][][21:00:37][(none)] mysql> SELECT COUNT(*), SUM(count_star) FROM stats_mysql_query_digest;
+----------+-----------------+
| COUNT(*) | SUM(count_star) |
+----------+-----------------+
| 228182 | 18629260 |
+----------+-----------------+
1 row in set (1.32 sec)
[proxysql-store-22-13w0][][21:00:49][(none)] mysql> SELECT COUNT(*) FROM stats_mysql_prepared_statements_info;
+----------+
| COUNT(*) |
+----------+
| 7601 |
+----------+
1 row in set (0.03 sec)
[proxysql-store-22-13w0][][21:00:56][(none)] mysql> SELECT * FROM stats_mysql_global;
+-----------------------------------------------+----------------+
| Variable_Name | Variable_Value |
+-----------------------------------------------+----------------+
| ProxySQL_Uptime | 1588985 |
| Active_Transactions | 4 |
| Client_Connections_aborted | 0 |
| Client_Connections_connected | 2679 |
| Client_Connections_created | 559585574 |
| Server_Connections_aborted | 436 |
| Server_Connections_connected | 208 |
| Server_Connections_created | 316905 |
| Server_Connections_delayed | 0 |
| Client_Connections_non_idle | 44 |
| mysql_backend_buffers_bytes | 1712992 |
| mysql_frontend_buffers_bytes | 175439872 |
| mysql_session_internal_bytes | 3926888 |
| Com_autocommit | 88523982 |
| Com_autocommit_filtered | 88523933 |
| Com_commit | 129229947 |
| Com_commit_filtered | 997733 |
| Com_rollback | 916162 |
| Com_rollback_filtered | 0 |
| Com_backend_change_user | 10359561 |
| Com_backend_init_db | 2979988580 |
| Com_backend_set_names | 14908153 |
| Com_frontend_init_db | 0 |
| Com_frontend_set_names | 58794 |
| Com_frontend_use_db | 5596366197 |
| Com_backend_stmt_prepare | 87019042 |
| Com_backend_stmt_execute | 118746718 |
| Com_backend_stmt_close | 0 |
| Com_frontend_stmt_prepare | 72944154 |
| Com_frontend_stmt_execute | 118746756 |
| Com_frontend_stmt_close | 54964226 |
| Questions | 23327179799 |
| Slow_queries | 87178 |
| GTID_consistent_queries | 0 |
| GTID_session_collected | 0 |
| Queries_backends_bytes_recv | 19007102215226 |
| Queries_backends_bytes_sent | 8865461643886 |
| Queries_frontends_bytes_recv | 9361474617217 |
| Queries_frontends_bytes_sent | 29983946793278 |
| Query_Processor_time_nsec | 0 |
| Backend_query_time_nsec | 0 |
| ConnPool_get_conn_latency_awareness | 0 |
| ConnPool_get_conn_immediate | 26409038 |
| ConnPool_get_conn_success | 10640164863 |
| ConnPool_get_conn_failure | 191201 |
| mysql_killed_backend_connections | 0 |
| mysql_killed_backend_queries | 12 |
| hostgroup_locked_set_cmds | 0 |
| hostgroup_locked_queries | 0 |
| mysql_unexpected_frontend_com_quit | 0 |
| mysql_unexpected_frontend_packets | 0 |
| queries_with_max_lag_ms__total_wait_time_us | 0 |
| queries_with_max_lag_ms__delayed | 0 |
| queries_with_max_lag_ms | 0 |
| backend_lagging_during_query | 0 |
| backend_offline_during_query | 0 |
| get_aws_aurora_replicas_skipped_during_query | 0 |
| automatic_detected_sql_injection | 0 |
| whitelisted_sqli_fingerprint | 0 |
| max_connect_timeouts | 20 |
| generated_error_packets | 20 |
| client_host_error_killed_connections | 0 |
| Client_Connections_hostgroup_locked | 0 |
| Mirror_concurrency | 0 |
| Mirror_queue_length | 0 |
| Selects_for_update__autocommit0 | 163040 |
| Servers_table_version | 2 |
| MySQL_Thread_Workers | 16 |
| Access_Denied_Wrong_Password | 0 |
| Access_Denied_Max_Connections | 0 |
| Access_Denied_Max_User_Connections | 0 |
| MySQL_Monitor_Workers | 8 |
| MySQL_Monitor_Workers_Aux | 0 |
| MySQL_Monitor_Workers_Started | 8 |
| MySQL_Monitor_connect_check_OK | 79428 |
| MySQL_Monitor_connect_check_ERR | 0 |
| MySQL_Monitor_ping_check_OK | 476550 |
| MySQL_Monitor_ping_check_ERR | 0 |
| MySQL_Monitor_read_only_check_OK | 3177725 |
| MySQL_Monitor_read_only_check_ERR | 4 |
| MySQL_Monitor_replication_lag_check_OK | 2542352 |
| MySQL_Monitor_replication_lag_check_ERR | 0 |
| MySQL_Monitor_dns_cache_queried | 0 |
| MySQL_Monitor_dns_cache_lookup_success | 0 |
| MySQL_Monitor_dns_cache_record_updated | 0 |
| MyHGM_myconnpoll_get | 10613947027 |
| MyHGM_myconnpoll_get_ok | 10613755826 |
| MyHGM_myconnpoll_push | 10613958033 |
| MyHGM_myconnpoll_destroy | 670 |
| MyHGM_myconnpoll_reset | 11675063 |
| SQLite3_memory_bytes | 5681216 |
| ConnPool_memory_bytes | 18508000 |
| Stmt_Client_Active_Total | 6923 |
| Stmt_Client_Active_Unique | 2989 |
| Stmt_Server_Active_Total | 93 |
| Stmt_Server_Active_Unique | 88 |
| Stmt_Max_Stmt_id | 10002 |
| Stmt_Cached | 7626 |
| Query_Cache_Memory_bytes | 7044955 |
| Query_Cache_count_GET | 110632686 |
| Query_Cache_count_GET_OK | 31253775 |
| Query_Cache_count_SET | 79378910 |
| Query_Cache_bytes_IN | 187176260852 |
| Query_Cache_bytes_OUT | 235561500468 |
| Query_Cache_Purged | 79377820 |
| Query_Cache_Entries | 1090 |
| new_req_conns_count | 0 |
| mysql_listener_paused | false |
| MySQL_Logger-circularBufferEventsSize | 0 |
| MySQL_Logger-circularBufferEventsDroppedCount | 0 |
| MySQL_Logger-totalEventsCopiedToMemory | 0 |
| MySQL_Logger-totalGetAllEventsTimeMicros | 0 |
| MySQL_Logger-circularBufferEventsAddedCount | 0 |
| MySQL_Logger-totalDiskCopyTimeMicros | 0 |
| MySQL_Logger-totalMemoryCopyTimeMicros | 0 |
| MySQL_Logger-totalEventsCopiedToDisk | 0 |
| MySQL_Logger-getAllEventsEventsCount | 0 |
| MySQL_Logger-getAllEventsCallsCount | 0 |
| MySQL_Logger-diskCopyCount | 0 |
| MySQL_Logger-memoryCopyCount | 0 |
+-----------------------------------------------+----------------+
120 rows in set (0.00 sec)
[proxysql-store-22-13w0][][21:01:01][(none)] mysql> SELECT hostgroup, srv_host, Queries, Bytes_data_sent, Bytes_data_recv,
ConnUsed, ConnFree, ConnOK, ConnERR, MaxConnUsed
FROM stats_mysql_connection_pool;
+-----------+-------------+------------+-----------------+-----------------+----------+----------+--------+---------+-------------+
| hostgroup | srv_host | Queries | Bytes_data_sent | Bytes_data_recv | ConnUsed | ConnFree | ConnOK | ConnERR | MaxConnUsed |
+-----------+-------------+------------+-----------------+-----------------+----------+----------+--------+---------+-------------+
| 2 | 10.128.0.47 | 1355958966 | 840886887887 | 2771937755445 | 1 | 27 | 40068 | 34 | 100 |
| 2 | 10.128.2.24 | 1355269037 | 840362043563 | 2769224097390 | 0 | 32 | 39513 | 260 | 167 |
| 2 | 10.128.2.72 | 5634 | 947133 | 2451461 | 0 | 0 | 1000 | 0 | 1 |
| 4 | 10.128.0.47 | 87553363 | 110713966812 | 275866934965 | 0 | 7 | 3811 | 16 | 23 |
| 4 | 10.128.2.24 | 87511761 | 110678758236 | 275754604828 | 1 | 7 | 3995 | 107 | 62 |
| 4 | 10.128.2.72 | 154 | 99256 | 113471 | 0 | 0 | 75 | 0 | 1 |
| 6 | 10.128.0.47 | 90959171 | 64829356373 | 536027184648 | 0 | 4 | 4736 | 0 | 20 |
| 6 | 10.128.2.24 | 90932940 | 64785089639 | 535275736242 | 0 | 5 | 4672 | 0 | 17 |
| 6 | 10.128.2.72 | 299 | 93739 | 484465 | 0 | 0 | 98 | 0 | 1 |
| 8 | 10.128.0.47 | 79919817 | 54321990224 | 514315348683 | 0 | 4 | 3252 | 0 | 38 |
| 8 | 10.128.2.24 | 79887290 | 54286208545 | 512495248131 | 0 | 6 | 3605 | 0 | 44 |
| 8 | 10.128.2.72 | 218 | 49423 | 77572 | 0 | 0 | 72 | 0 | 1 |
| 10 | 10.128.0.47 | 68230628 | 44968666562 | 517761137194 | 0 | 4 | 2813 | 0 | 40 |
| 10 | 10.128.2.24 | 68195693 | 44945101612 | 518109664801 | 0 | 4 | 3171 | 0 | 37 |
| 10 | 10.128.2.72 | 217 | 46575 | 384814 | 0 | 0 | 72 | 0 | 1 |
| 12 | 10.128.0.47 | 2288475 | 1253645320 | 5299740464 | 0 | 1 | 1936 | 0 | 9 |
| 12 | 10.128.2.24 | 2284743 | 1252923783 | 5553862060 | 0 | 2 | 2021 | 0 | 8 |
| 12 | 10.128.2.72 | 9 | 2471 | 266 | 0 | 0 | 3 | 0 | 1 |
| 14 | 10.128.0.47 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 14 | 10.128.2.24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 14 | 10.128.2.72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 16 | 10.128.0.47 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 16 | 10.128.2.24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 16 | 10.128.2.72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 | 10.128.2.72 | 398663602 | 161976141341 | 109933154458 | 3 | 33 | 30876 | 6 | 88 |
| 3 | 10.128.2.72 | 1274248168 | 1077350852993 | 1639462908850 | 0 | 0 | 41436 | 13 | 300 |
| 5 | 10.128.2.72 | 3225574779 | 3181303153602 | 4248501141111 | 0 | 28 | 45371 | 0 | 91 |
| 7 | 10.128.2.72 | 1731690883 | 1142540620069 | 1943555552384 | 3 | 16 | 36482 | 0 | 92 |
| 9 | 10.128.2.72 | 1335907358 | 933038954348 | 1549167829253 | 0 | 14 | 33773 | 0 | 162 |
| 11 | 10.128.2.72 | 196523316 | 136028009899 | 279001831833 | 0 | 8 | 13614 | 0 | 88 |
| 13 | 10.128.2.72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 15 | 10.128.2.72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+-----------+-------------+------------+-----------------+-----------------+----------+----------+--------+---------+-------------+
32 rows in set (0.00 sec)
[proxysql-store-22-13w0][][21:01:13][(none)] mysql> SELECT * FROM stats_mysql_connection_pool;
+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+------------+-------------------+-----------------+-----------------+------------+
| hostgroup | srv_host | srv_port | status | ConnUsed | ConnFree | ConnOK | ConnERR | MaxConnUsed | Queries | Queries_GTID_sync | Bytes_data_sent | Bytes_data_recv | Latency_us |
+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+------------+-------------------+-----------------+-----------------+------------+
| 2 | 10.128.0.47 | 3306 | ONLINE | 0 | 28 | 40068 | 34 | 100 | 1355974843 | 0 | 840895913473 | 2771968394843 | 221 |
| 2 | 10.128.2.24 | 3306 | ONLINE | 0 | 32 | 39513 | 260 | 167 | 1355285262 | 0 | 840371393395 | 2769252093809 | 221 |
| 2 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 1000 | 0 | 1 | 5634 | 0 | 947133 | 2451461 | 176 |
| 4 | 10.128.0.47 | 3306 | ONLINE | 0 | 7 | 3811 | 16 | 23 | 87553730 | 0 | 110714696777 | 275867031404 | 221 |
| 4 | 10.128.2.24 | 3306 | ONLINE | 0 | 8 | 3995 | 107 | 62 | 87512109 | 0 | 110679440102 | 275754702920 | 221 |
| 4 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 75 | 0 | 1 | 154 | 0 | 99256 | 113471 | 176 |
| 6 | 10.128.0.47 | 3306 | ONLINE | 0 | 4 | 4736 | 0 | 20 | 90960145 | 0 | 64829944646 | 536030340797 | 221 |
| 6 | 10.128.2.24 | 3306 | ONLINE | 0 | 5 | 4672 | 0 | 17 | 90933920 | 0 | 64785679942 | 535278748715 | 221 |
| 6 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 98 | 0 | 1 | 299 | 0 | 93739 | 484465 | 176 |
| 8 | 10.128.0.47 | 3306 | ONLINE | 0 | 4 | 3252 | 0 | 38 | 79920881 | 0 | 54322685438 | 514319521490 | 221 |
| 8 | 10.128.2.24 | 3306 | ONLINE | 0 | 6 | 3605 | 0 | 44 | 79888339 | 0 | 54286903074 | 512502579740 | 221 |
| 8 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 72 | 0 | 1 | 218 | 0 | 49423 | 77572 | 176 |
| 10 | 10.128.0.47 | 3306 | ONLINE | 0 | 4 | 2813 | 0 | 40 | 68231614 | 0 | 44969245489 | 517765707051 | 221 |
| 10 | 10.128.2.24 | 3306 | ONLINE | 0 | 4 | 3171 | 0 | 37 | 68196680 | 0 | 44945724497 | 518115078951 | 221 |
| 10 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 72 | 0 | 1 | 217 | 0 | 46575 | 384814 | 176 |
| 12 | 10.128.0.47 | 3306 | ONLINE | 0 | 1 | 1936 | 0 | 9 | 2288509 | 0 | 1253653870 | 5299745829 | 221 |
| 12 | 10.128.2.24 | 3306 | ONLINE | 0 | 2 | 2021 | 0 | 8 | 2284774 | 0 | 1252930544 | 5553864304 | 221 |
| 12 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 3 | 0 | 1 | 9 | 0 | 2471 | 266 | 176 |
| 14 | 10.128.0.47 | 3306 | ONLINE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 221 |
| 14 | 10.128.2.24 | 3306 | ONLINE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 221 |
| 14 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 176 |
| 16 | 10.128.0.47 | 3306 | ONLINE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 221 |
| 16 | 10.128.2.24 | 3306 | ONLINE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 221 |
| 16 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 176 |
| 1 | 10.128.2.72 | 3306 | ONLINE | 4 | 30 | 30876 | 6 | 88 | 398669566 | 0 | 161979055666 | 109934741822 | 176 |
| 3 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 41436 | 13 | 300 | 1274248168 | 0 | 1077350852993 | 1639462908850 | 176 |
| 5 | 10.128.2.72 | 3306 | ONLINE | 0 | 28 | 45371 | 0 | 91 | 3225595824 | 0 | 3181317444028 | 4248552337185 | 176 |
| 7 | 10.128.2.72 | 3306 | ONLINE | 0 | 19 | 36482 | 0 | 92 | 1731725512 | 0 | 1142562416869 | 1943608364792 | 176 |
| 9 | 10.128.2.72 | 3306 | ONLINE | 0 | 14 | 33773 | 0 | 162 | 1335924071 | 0 | 933050456187 | 1549190704807 | 176 |
| 11 | 10.128.2.72 | 3306 | ONLINE | 0 | 8 | 13614 | 0 | 88 | 196525314 | 0 | 136029826770 | 279002983533 | 176 |
| 13 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 176 |
| 15 | 10.128.2.72 | 3306 | ONLINE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 176 |
+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+------------+-------------------+-----------------+-----------------+------------+
32 rows in set (0.00 sec)
[proxysql-store-22-13w0][][21:01:30][(none)] mysql> SELECT * FROM global_variables WHERE variable_name IN (
'mysql-max_connections',
'mysql-free_connections_pct',
'mysql-connection_max_age_ms',
'mysql-query_digests_max_digest_length',
'mysql-query_digests_max_query_length',
'mysql-query_digests_keep_comment',
'mysql-threads',
'mysql-stacksize',
'admin-mysql_ifaces'
);
+---------------------------------------+----------------+
| variable_name | variable_value |
+---------------------------------------+----------------+
| admin-mysql_ifaces | 0.0.0.0:6032 |
| mysql-connection_max_age_ms | 300000 |
| mysql-free_connections_pct | 20 |
| mysql-max_connections | 50000 |
| mysql-query_digests_keep_comment | false |
| mysql-query_digests_max_digest_length | 2048 |
| mysql-query_digests_max_query_length | 65000 |
| mysql-stacksize | 1048576 |
| mysql-threads | 16 |
+---------------------------------------+----------------+
9 rows in set (0.00 sec)
Raw
6 core dump
OUT_BASE=/var/tmp/proxysql-gdb-$(date -u +%Y%m%dT%H%M%SZ)
mkdir -p "$OUT_BASE"
for PID in $(pidof proxysql); do
echo "=== Dumping PID $PID ==="
gdb -q -p "$PID" \
-ex "set pagination off" \
-ex "set confirm off" \
-ex "set print thread-events off" \
-ex "set logging file $OUT_BASE/gdb_report.$PID.txt" \
-ex "set logging on" \
-ex "echo === VERSION/ENV ===\n" \
-ex "show version" \
-ex "info proc exe" \
-ex "info sharedlibrary" \
-ex "echo \n=== THREADS/STACKS ===\n" \
-ex "info threads" \
-ex "thread apply all bt" \
-ex "thread apply all bt full" \
-ex "echo \n=== MEMORY MAPS ===\n" \
-ex "info proc mappings" \
-ex "maintenance info sections" \
-ex "echo \n=== CORE DUMP ===\n" \
-ex "gcore $OUT_BASE/proxysql.$PID.core" \
-ex "set logging off" \
-ex "detach" \
-ex "quit"
echo "=== Done with PID $PID ==="
done
echo "All dumps saved to: $OUT_BASE"
@joshdurbin
Copy link
Author

joshdurbin commented Jan 2, 2026

A prom expression for 30 days on the node shows extensive memory growth:

node_memory_AnonPages_bytes{node="proxysql-store-22-13w0.node.prd-us-central1.consul"} / 1024 / 1024 / 1024
Screenshot 2026-01-02 at 12 31 25

@joshdurbin
Copy link
Author

joshdurbin commented Jan 2, 2026

Same query, after a proxysql process restart.

Screenshot 2026-01-02 at 14 37 30

@joshdurbin
Copy link
Author

joshdurbin commented Jan 2, 2026

Same query, after a proxysql process restart, 1 hour view:

Screenshot 2026-01-02 at 14 37 37

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment