Category: RDS
-
Post Views: 15 The background of the accidentIn the process of debugging the WordPress multi-language tag synchronization script, the script adds batch query and deletes the logic of dirty labels in the script, and the script runs free of the script running under the massive data cycle. After the process is forced to terminate, the database is irreversible and severely…
-
Post Views: 11 1. Problem background When querying large data sets in Alibaba Cloud DMS, the problem of page turning restrictions is often encountered. When the amount of data exceeds 10,000 rows, the system will prompt ‘The result set page turning page supports up to 10,000 row records’. For example, the user displays 3,000 pieces of data per page, and…
-
Post Views: 26 Background my site www.shuijingwanwq.com It is a WordPress-based content station, with about 20,000 pages, and the average daily traffic is gradually increasing. The server uses Alibaba Cloud ECS (1 core 2GB), and the Web environment uses OneInStack (NGINX + PHP-FPM + Redis + Alibaba Cloud RDS MySQL). The website has been running smoothly until a large area…
-
Post Views: 19 1. Reference:Deploy Shopify PHP application to production environment (CentOS 7.7 64-bit in Alibaba Cloud, ECS, MySQL 5.7) 2. When the application: learn-php-app-ubuntu-2004-0605 is newly created and deployed the theme application extension. The test passed, in line with expectations. as shown in Figure 1 3. Upload the application in the local environment: learn-php-app-ubuntu-2004-0605 Web The code below is…
-
Post Views: 14 1. The external network address of the Alibaba Cloud RDS MySQL instance has been applied to connect. as shown in Figure 1 2. Failed to connect in Navicat for MySQL, error: 2003 – CANT connect to mysql server onRM-BP(10060 “Unknown Error”). as shown in Figure 2 3. To access RDS through the external network, you need to…
-
Post Views: 19 1. Enter the CentOS server based on Xshell 6, compress and package the website program directory, execute the compression command, and the execution result is shown in Figure 1 2. Connect to the FTP server based on FlashFXP, download the compressed package: shuijingwanwq.com-20191203.zip to the local, as shown in Figure 2 3. Connect to the MySQL server…
-
Post Views: 15 1. Reference URL:https://docs.phpmyadmin.net/zh_CN/latest/setup.html#installing-using-composer 2. Install and run the command based on composer, as shown in Figure 1 3. Enter the phpmyadmin-localhost directory, update phpmyadmin to the latest version, and run the command, as shown in Figure 2 4. Use the installer to generate the configuration file: config.inc.php, open the browser and use the /setup suffix to access,…
-
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,…