Re: Add index for mysql table with ndbcluster storage engine
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
Subject
Views
Written By
Posted
1832
May 28, 2016 10:54PM
Re: Add index for mysql table with ndbcluster storage engine
1025
May 29, 2016 10:57PM
890
June 01, 2016 12:44AM
858
June 01, 2016 10:44PM
898
June 09, 2016 02:57AM
879
June 10, 2016 05:32AM
772
June 10, 2016 05:40AM
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.