Tag: index
-
Post Views: 85 1. In the performance environment, the list interface response timeout. as shown in Figure 1 2. Determine the sql of the interface to execute, connect the mysql of the performance environment in the local environment, and then view the generated sql in Laravel Telescope, and find a select count(*) as aggregate FROM is much longer than other…
-
Post Views: 24 1. An interface request response timeout, because count(*) SQL takes 54 seconds. The amount of data in the table exceeds 10 million. as shown in Figure 1 2. The table field Shipping_Type has an index to add, and its value is only 1 and 2 possibilities. Decide to add the where condition Shipping_Type in (1,2). The query…
-
Post Views: 20 1. TortoiseGit detects that the file does not exist, but has been temporarily stored as “Add” or “Modify” in “Index”. The Submit dialog box cannot be handled. Do you want to recover or delete it from the index? Recover this file from the index (E) Remove this file (R) from the index and ignore it. as shown…
-
Post Views: 15 1. In postman postman :http://api.pcs-api.localhost/v1/mobile/rtcs/invite-accept, the data in the body is written in the redis cache in the format of an array, as shown in Figure 1 The data in the body will change every time the request is requested, and the implementation logic in the program is as follows: 3. Check the difference set of the…
-
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…