Polardb and Polardb -x

PolarDB and PolarDB -X Introduction:

PolarDB and PolarDB -X.In order to facilitate the small partners to easily and quickly understand the related use problems of the PolarDB open source database, the community will give a unified answer to the high-quality questions in the selected group through this column every week, hoping to be helpful to everyone.

PolarDB and PolarDB -X.In order to facilitate the small partners to easily and quickly understand the related use problems of the PolarDB open source database, the community will give a unified answer to the high-quality questions in the selected group through this column every week, hoping to be helpful to everyone.

PolarDB for PostgreSQL Q&A Featured


1,
Q: Disk fragmentation will occur when the unlogged table is updated. Do I need auto vacuum? Or is the data also stored in memory?
A: All will generate garbage, unlogged table is not a memory table.
2,
Q: Can Polar Stack operator only be installed on physical machines? Running the command on the virtual machine did not list any disks.
A: It can be a virtual machine, but the disk must be a shared storage disk, which needs to support the scsi or nvme protocol.
3.
Q: SQL in Greenplum (there are associations between tables, the amount of data is very small, only a few thousand) suddenly executes very slowly. It used to run in seconds, but now it can't run in 10 minutes. This situation should be from aspects. investigation?
A: You can check the lock wait and execution plan first.
4.
Q: When will PolarDB call the remount interface of
polarfs ? A : It is not called by default. It is only a necessary capability of fs and needs to be provided. It does not mean that DB must rely on this interface.
PolarDB -X Q&A Featured
1. Q : What is the difference between
PolarDB and PolarDB- X?
A: Regarding the difference between PolarDB -X and X-DB and PolarDB , please refer to the Zhihu column: https://zhuanlan.zhihu.com/p/296392729 , in short, PolarDB = MySQL with a large single disk; PolarDB - X=A bunch of ordinary MySQL clusters. If you have a large amount of data, read a lot, and write more than a single machine can bear, you can use PolarDB . If you have a large amount of data , read a lot, and write a lot, you can use PolarDB- X.
2,
Q: How to restart the instance after pxd tryout starts, and how to restart the instance after the machine restarts?
A: docker ps -a finds the container corresponding to PolarDB -X, and then restarts the container
3.
Q: After the database is deleted , should the table space of the database be released manually?
A : In theory, no, the bulk of the disk may be binlog , you can directly go to dn show databases.
4.
Q: Does PolarDB -X support creating temporary tables?
A : Not supported.

Related Articles

Explore More Special Offers

  1. Short Message Service(SMS) & Mail Service

    50,000 email package starts as low as USD 1.99, 120 short messages start at only USD 1.00