MySQL Forums
Forum List  »  NDB clusters

Re: Add index for mysql table with ndbcluster storage engine
Posted by: urgen sherpa
Date: May 29, 2016 10:57PM

Update : found out that table cannot be altered when used by remote users. i could alter same table belonging to different database not used by remote user.

mysql> show processlist;

+---------+--------------+-----------------------------+---------------+---------+------+-----------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+--------------+-----------------------------+---------------+---------+------+-----------------------------------+------------------+
| 1 | system user | | | Daemon | 0 | Waiting for event from ndbcluster | NULL |
| 3383487 | remote_user01| remote.example.com:51567 | staff_db | Sleep | 0 | | NULL |
| 3388329 | root | localhost | staff_db | Query | 0 | init | show processlist |
| 3388422 | remote_user02| remote.example.com:41311 | staff_db | Sleep | 531 | | NULL |
| 3388511 | remote_user02| remote.example.com:41554 | staff_db | Sleep | 522 | | NULL |
| 3389659 | remote_user02| remote.example.com:45603 | staff_db | Sleep | 405 | | NULL

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.