Discuz forum post table sharding graphic tutorial

How to split and manage posts? Path: [background] [webmaster] [Post table sharding] 1. before sharding a post, you must first close the site, to prevent problems during table sharding, you must back up the database before performing this operation. 2. forum_post (main table) must retain MB of data. the first time you access the Post table sharding function, you will see the default

How to split and manage posts

Operation path: [background] => [webmaster] => [Post table sharding]

1. Before you subscribe to a sub-table, you must first shut down the site. to prevent problems during the sub-table operation, you must back up the database before performing this operation.

2. forum_post (master table) must retain MB of data

When you access the Post table sharding function for the first time, you will see a base table named pre_forum_post by default. This table is installed with Discuz! Standard post table. The newly added table is automatically named as "pre_forum_post _ number" without manual intervention.

If the number of posts in the current primary table is large and the data size exceeds 10 GB, you can click "table sharding" next to the primary table to create a new primary table.

Shows how to create a table shard after it is created: