Category: MySQL 5.6
-
Post Views: 21 1. Reference URL:https://www.shuijingwanwq.com/2021/12/29/5622/, Laravel 8.x is deployed to Heroku, based on PostgreSQL implementation. Therefore, some steps can be omitted. 2. In the local development environment, the Laravel native environment has been deployed. Open URL:http://larabbs.local/, the response 200. as shown in Figure 1 3. Verify your installation, to verify your CLI installation, use the heroku –version command. Current…
-
Post Views: 15 1. Request parameter: filter[and][0][or][0][title][like]=\, the generated sql is as follows, the search result is empty. as shown in Figure 1 2. Check the value of the field title in the table plan, one of the records exists \. In theory, it is possible to query a record. as shown in Figure 2 3. Execute SQL in Navicat…
-
Post Views: 13 1. The comments of the table are garbled. as shown in Figure 1 2. The comments of the fields are garbled. as shown in Figure 2 3. The values in the table are garbled. as shown in Figure 3 4. Add at the beginning of the sql file: set names utf8mb4; 5. Table comments, field comments, and…
-
Post Views: 12 1. In CakePHP v2.6.4, an error is reported: sqlstate[HY000][2002]connection timed out. as shown in Figure 1 2. Print the database connection information and find that the host address is the intranet IP, and the container cannot be accessed 3. Adjust to the external network IP, print the database connection information, and the container can be accessed normally.…
-
Post Views: 14 1. When the data length of PA_LOG is: 6.16 GB, as shown in Figure 1 2. Get the first page of the log list, the response time is about 1000ms, which is acceptable, as shown in Figure 2 3. Get the last page of the log list, the response timeout: 504 gateway time-out, as shown in Figure…
-
Post Views: 17 1. When the environment of the application running is the development environment, that is, when the value of yii_env is dev, close the schema cache and edit environments/dev/common/config/main-local.php 2. When the application running environment is the production environment, that is, when the value of yii_env is prod, turn on the schema cache, edit environments/dev/common/config/main-local.php 3. After enabling…
-
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 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: 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…