Tag: MySQL
-
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: 18 Seamlessly migrate from Windows WSL2 to Ubuntu bare metal, build Go development environments based on existing MySQL/Redis containers, and access custom networks. 📌 Preface I have been learning in Windows 10 + WSL2 before go-gin-learning Project, now to brand new Ubuntu 26.04 system. I hope to continue to use Docker to isolate the sending environment, and at…
-
Post Views: 27 Recently, I was tossing about the Baidu indexing problem of a WordPress site, and by the way, I experienced a new AI IDE in China, and recorded the process, hoping to help everyone. Cause: Baidu Sitemap commit has been unavailable My website shuijingwanwq.com In the Baidu search resource platform, the Sitemap submission function has always been displayed:…
-
Post Views: 20 This article is a development environment for the ‘From Windows to Ubuntu: Complete Guide to Migration and Configuration’ series.It is suitable for developers who have completed the Ubuntu system installation and hope to build an efficient, isolated and multi-version database environment. Why use Docker to manage databases? Under Windows, I am used to running a separate database…
-
Post Views: 40 1. There are 10,000 parameters in the IN condition (the upper limit of the product needs to be 10,000), resulting in a long query time, and the interface response timeout. as shown in Figure 1 2. When the number of parameters of PLAT_ORDER_ID is reduced from 10000 to 5, the interface response does not time out, and…
-
Post Views: 25 During the recent interview exchange, the interviewer asked me TiDB landing practice grasp the depth. In the 2014 PHP back-end research and development, I have deeply cultivated mysql high concurrency, big data table architecture evolution and performance optimization, from stand-alone tuning, master-slave copy, to sharding-jdbc/mycat The whole set of manual sub-bank sub-tables has been deeply implemented. Although…
-
Post Views: 36 1. Open the background URL of the website and report an error: Unable to connect to database: canT connect to local mysql server through socket/var/lib/mysql/mysql.sock(2) 2. Fix the problem of MySQL connection error, check the ISC framework (Interspire shopping cart, old e-commerce system) configuration file, and confirm that the connection is the local database. as shown in…
-
Post Views: 19 1. View the response data in the interface, and the reasoning is that the checkin_location_coordinates in the response field is the point type of mysql. as shown in Figure 1 2. Decide to adjust the query sql, use mysql spatial functions (such as st_x and st_y) to extract the latitude and longitude, and avoid direct manipulation of…
-
Post Views: 18 1. Verify the fields that conform to the MySQL field type Decimal(8,2) in Lavavel 9. as shown in Figure 1 2. The final realization is as follows 3. Try respectively: -4 (fail), 0 (success), 5 (success), 999999.99 (success), 999999.990 (success), 999999 .991 (failed), 9999990.99 (fail), 0.09 (success), 0.009 (fail), 0.0000001 (failed), in line with expectations. as shown…