Category: SQL
-
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: 19 1. The article involving the 1st table, the Penguin number: cpa_qq_article, the field needs to be verified: the uniqueness of the title, the structure of the table is shown in Figure 1 2. The task of the application of the channel involved in the second table, the application task of the channel: CPA_CHANNEL_APP_TASK, field: task_id and the…
-
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: 56 1. When saving tasks in Zen Dao, respond to 405, prompt: I’m sorry, because the URL you visit may pose a security threat to the website, your access is blocked. as shown in Figure 1 2. Carefully analyze the saved task content, there is the union all keyword, as shown in Figure 2 3. Delete union all,…
-
Post Views: 17 1. Get the task list of the application of the Penguin, the list is empty, as shown in Figure 1 2. Types of published articles: standard (normal, graphic) articles, successful publishing (that is, the storage is successful), check the sql statement of the publishing task, as shown in Figure 2 3. Get the task list of the…
-
Post Views: 14 1. Perform database migration in Yii 2.0: the MediumText type of MySQL. The four text types are TinyText, Text, MediumText, and LongText. Only supported: text 2. Reference file: \vendor\yiisoft\yii2\db\schemabuildertrait.php, copy to \console\db\mysql\schemabuildertrait.php, refer to the implementation of the text type, add support for tinytext, mediumtext, and longtext 3. In the database migration file, refer to the newly…
-
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: 14 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…