Category: MySQL 5.6
-
Post Views: 45 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: 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…
-
Post Views: 17 1. Table: Fields in pub_log: The type of data is: text, as shown in Figure 1 2. Table: field in pub_log: data structure of data is: json, the formatted data is as follows, as shown in Figure 2 3. The current requirement is that if “channel_app_task_status”: 6, it needs to be changed to: “channel_app_task_status”: 7, that is,…
-
Post Views: 15 1. HTML escape characters appear in SyntaxHighlighter 3.x of WordPress 4.9.8, and newline tags are automatically added, etc., as shown in Figure 1 2. The expected format should not appear HTML escape characters, as shown in Figure 2 3. For a long time, there were no HTML escape characters. I am not sure whether it was caused…
-
Post Views: 53 1. In the development environment, the execution of the database migration command fails: 1071 Specified key was too long; Max key length is 767 bytes, as shown in Figure 17 2. Run sql in the database in the development environment, and report an error: #1071 – specific key was too long; max key length is 767 bytes,…