Category: Tencent Cloud

回退版本至 2.10.6 后,继续运行 python migrate.py。数据迁移成功。为何迁移了数据库 0 下的健的总数:53,原因在于自建 Redis 中的数据在变化中所导致。 0

Based on Python script, realize Redis data migration (self-built Redis migrate to Tencent Cloud brings Redis itself)

Post Views: 11 1. Reference URL:https://blog.csdn.net/zhanghan18333611647/article/details/81434786. Implemented through the program (Python version 2.x ). Create a new migrate.py file. 2. On the self-built Redis machine, connect the self-built Redis and Tencent Cloud come with...

重新升级后,reserved 状态的队列数量快速变化为 0 ,查看标准输出日志文件,stdout_logfile = /data/logs/yii-copy-asset-queue-worker-stdout.log。attempt 的值分别等于 140、136。 0

Yii2 queue extension, in the Redis driver, when the info command prints information about the queue status, the analysis of the queued state queue

Post Views: 15 1. Yii2 queue extension, in the Redis driver, when the info command prints information about the queue status, the queue of the reserved state has always existed. Check the system log,...

在 CakePHP v2.6.4 中,报错:SQLSTATE[HY000] [2002] Connection timed out。 0

In CakePHP v2.6.4, an error is reported: sqlstate[HY000][2002]Analysis of the connection timed out

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...

在 bash sleep 60 秒 的情况下,很难出现并发锁定的情况。或者增加更多的容器,或者提升执行命令行的频率。设置 bash sleep 10 秒。已经出现并发锁定(防止同一个租户下的用户同步同时在多个容器中执行)的情况。当部署为集群时,已经可以保证同一个租户下的用户同步,在某一时间段,仅在 1 个容器中执行。理论上的计算公式,一个租户的同步时间间隔为:4 / 3 * 10 = 13,结果单位为秒。符合设计预期。总结:部署的容器数量不要超过租户的数量,以防止并发锁定的情况过于频繁。 0

In Yii 2.0, the cluster implementation of the console commands, the lock implementation of the Redis model (to ensure that even if multiple servers are running the command line, the tasks run by each server are not repeated to improve the overall processing performance of the command line)

Post Views: 16 1. Docker deployment, the implementation of Crontab (Bash Sleep) based on Supervisor, to reduce memory usage, refer to:https://www.shuijingwanwq.com/2019/10/12/3555/. /console/controllers/cmcConsoleUserController.php 2. Break ends the execution of the current Foreach structure, that is,...

由于 Supervisor 仅启动 1 个 queue/listen,因此,一旦某一队列处于 reserved,则其他队列只好一直处于 waiting 状态,所以,临时决定 remove 命令删除作业,以启动程序的继续正常运转,查看 log 表,其 message 字段内容,可以确定队列 ID 值为:159,info 命令打印关于队列状态的信息时,reserved 状态的队列数量减少 1,done 状态的队列数量增加 1,符合预期 0

Yii2 queue extension, in the Redis driver, when the info command prints information about the queue status, the deletion of the queue in the reserved state

Post Views: 14 1. Check the log table, the content of the message field is as follows: 2. The analysis found that after publishing the article queue event handler, and after the job execution...

在 第 10 步骤执行完毕后,Docker 容器的 CPU:9.9%,内存:541MB,内存增加了 160MB 左右,每 1000 条数据的添加,内存会增加 20 MB 左右。因此,优化的重点在于第 2 个命令行脚本。 0

The command-line script implemented based on Yii 2.0, during the continuous operation, the analysis and solution of excessive memory occupancy

Post Views: 18 1. When the amount of data in MySQL and Redis is small, the CPU of the Docker container: 0.02%, and the memory: 298MB, as shown in Figure 1 and Figure 2...