Category: MySQL
-
Post Views: 15 1. Analysis of the SQL based on EXPLAIN is as follows, as shown in Figure 1 2. The index of the PA_plan_task table is shown in Figure 2 3. After adding the index: IDX_GROUP_ID, IDX_CREATE_USER_ID, IDX_IS_NOT_ISOLATED, the index of the PA_PLAN_TASK table is shown in Figure 3 4. Analysis of the first SQL based on EXPLAIN is…
-
Post Views: 13 1. The index of the PA_CONFIG_COLUMN table is shown in Figure 1, and the index of the PA_CONFIG_COLUMN_USER table is shown in Figure 2 2. Analysis of the first SQL based on Explain is as follows, type: displays the access type, which is a more important indicator, and the result value from good to bad is: system…
-
Post Views: 19 1. Edit and update the UI of the task type and step settings of the tenant to complete the design after the interface is implemented. Implementation of the previous version:https://www.shuijingwanwq.com/2019/11/14/3605/, in the previous version, the task type can be implemented at the same time: the task type can be (add, delete, rename its name, sort), and the…
-
Post Views: 13 1. The requirements for editing and updating the tenant’s task type and step settings have changed, and users need to allow users to add task types independently, and then select some of them from the 18 steps to add to the newly added task type. Implementation of the previous version:https://www.shuijingwanwq.com/2019/11/06/3583/, in the previous version, only the user…
-
Post Views: 18 1. Open the task configuration table, as shown in Figure 1 2. Open the task step configuration table, as shown in Figure 2 3. Now there are new requirements: Based on different tenants, the task configuration and task step configuration can be customized. Therefore, it is decided to create a new tenant’s task configuration table and tenant’s…
-
Post Views: 57 1. The current table design (the relationship between the topic selection and the resource), the field: plan_id indicates which topic selection ID the record belongs to, as shown in Figure 1 2. In the editing topic page, 2 resource files are uploaded, as shown in Figure 2 3. After saving the topic, open the resource table and…
-
Post Views: 44 1. Since the log message is stored in the log table of mysql, in the production environment, a large amount of data has been accumulated, and the data length of the log table has reached hundreds of gigabytes. Therefore, it is decided to implement the timing deletion of log messages based on the console command line, and…
-
Post Views: 15 1. View the task list page of Zen Tao, and its sorting is based on the descending order of ID, as shown in Figure 1 2. After clicking on the consumption field, the triangle is displayed as dark, indicating that the current sorting is based on the consumption ascending order, and if its value is the same,…
-
Post Views: 14 1. Open the URL in Postman:http://api.pcs-api.localhost/v1/plans/have?login_id=2e368664c41b8bf511bcc9c65d86dbc3&login_tid=f347ba5bb18cb3fbef94c0b37c796bf5&filter[and][0][or][0][title][like]=Shenzhen &Filter[status][neq]=0&filter[and][0][or][1][keyword]= keyword, as shown in Figure 1 2. Print request parameter: $requestParams 3. Print the filter: $filter 4. The final generated SQL is as follows, as shown in Figure 2 5. The current requirement is that the field keyword, keywords, multiple uses, and numbers are separated, and accurate matching is required,…
-
Post Views: 50 1. Data validation failed in Yii 2.0: the source publishing user ID must be a string. as shown in Figure 1 2. The reason is the field: source_pub_user_id was int(11) in the table before, and later modified to varchar(64), in the model file regenerated based on GII, the verification rules are as follows 3. The interface has…