Re: Add index for mysql table with ndbcluster storage engine

[urgen sherpa]

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