i installed pixie reference <a href="https://docs.px.dev/installing-pixie/install-gui

Hi <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="

pixie can not collect mysql data？ about pixie HOT 2 OPEN

lddlww commented on June 10, 2024

pixie can not collect mysql data？

from pixie.

Comments (2)

ddelnano commented on June 10, 2024

Hi @lddlww, can you please provide more information on the client and server in this test? The px/mysql_data script will filter out anything that doesn't originate from a pod (source). Could you be running the client process outside of a pod?

from pixie.

lddlww commented on June 10, 2024

can you please provide more information on the client and server in this test?

yes

kubectl get all -n mysqlcloud

NAME                         READY   STATUS    RESTARTS   AGE
pod/mysql-794776ccb5-rc876   1/1     Running   0          40h

NAME                     TYPE       CLUSTER-IP    EXTERNAL-IP   PORT(S)          AGE
service/mysql-nodeport   NodePort   10.96.0.182   <none>        3306:32143/TCP   40h

NAME                    READY   UP-TO-DATE   AVAILABLE   AGE
deployment.apps/mysql   1/1     1            1           40h

NAME                               DESIRED   CURRENT   READY   AGE
replicaset.apps/mysql-794776ccb5   1         1         1       40h

mysql -h10.96.0.182 -P3306 -p

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t1             |
+----------------+
mysql> delete from t1 where id=1;
Query OK, 1 row affected (0.00 sec)
mysql> select sleep(5);
+----------+
| sleep(5) |
+----------+
|        0 |
+----------+
1 row in set (5.00 sec)
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.43    |
+-----------+
1 row in set (0.00 sec)

mysql --version

mysql  Ver 8.0.34-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

i used mysql -h10.96.0.182 -P3306 -p to access mysqld pod，and do some sqls，but there nothing info in px/mysql_data within live UI or script output

from pixie.

Recommend Projects