MySQL Forums
Forum List  »  InnoDB

potential bug and/or not understanding behavior
Posted by: megatron from space
Date: August 21, 2022 07:26PM

Hi all-

I originally directed this to Squirrel SQL but it may not
be their issue. I can't get multiple queries to show up in processlist
or in connections option in the workbench.

I set autocommit off, and then I do a partial transaction.
It doesn't show up in the processlist at all.
I think if it is a partial query, it show up in processlist.
If not, how can you tell what is going on with a partial transaction?

Do you have any ideas why it doesn't list the partial queries?

Please see below...

I feel about as crazy as a gang of loons right now .
mysql Ver 8.0.30-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

THANKS for any assistance!

mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)
mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)
mysql> update a1 set bar = 'qy' where foo = 2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 126 | Waiting on empty queue | NULL |
| 8 | root | localhost | mydb | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
potential bug and/or not understanding behavior
112
August 21, 2022 07:26PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.