# Memory Pessimistic Lock - Enable
__*Memory pessimistic lock usage*__
+ Open memory pessimistic lock online
```
CREATE TABLE users (
    id BIGINT,
    name VARCHAR(100),
    PRIMARY KEY(id)
);
ALTER TABLE users CACHE;
```

------------------------------------------------------------
Can be turned on and off dynamically online:

```
> set config tikv pessimistic-txn.pipelined='true';
> set config tikv pessimistic-txn.in-memory='true';
```

We can also configure it via a TiKV profile:

```
[pessimistic-txn]
pipelined = true
in-memory = true
```