There is no problem not worth solving, and no technology not worth learning!
Post Views: 52 1. When clearing the table in MySQL 5.7, there are more than 3 million records in the table, and when there are more than 2 million records left, prompt: 1206 – The total number of locks Exceeds the lock tablesize. as shown in Figure 1 2. Reference: The total number of locks exceds. 3. This problem can…
👨💻 Personal Brand
Wang Shiqiang | PHP & Go Technical Consultant
15+ years of backend development experience specializing in system maintenance, architecture optimization, performance tuning, and Linux administration.
Technical blogger since 2013 with 1,000+ original articles.
Available for consulting, long-term maintenance, and remote collaboration.
.env (14) 404 (13) add (17) Aliyun (19) Apache (13) Array (19) browser (14) Cache (13) CentOS (23) chrome (18) Client (11) command line (13) composer (42) composer.json (22) composer install (13) composer update (14) console (14) Container (25) curl (15) Database (11) database migration (16) delete (32) Docker (31) Dockerfile (15) ECS (12) environment variable (20) error (24) escape (12) Failed (13) file (16) filter (20) fopen (11) FORMAT (12) function (13) Git (27) GitHub (16) Gitlab (15) Go (34) Go 1.26 (12) GraphQL (24) GraphQL API (14) hosts (11) http (21) https (20) Installation (13) Interface (19) Jenkins (12) Jquery (13) json (24) Laravel (36) Laravel 6 (56) Laravel 9 (25) Lighthouse (17) Lighthouse 5 (14) Linux (15) Memory (11) Migrate (13) Migration (11) Module (17) MySQL (76) MySQL 5.7 (21) Nginx (45) Node.js (12) normalize.css (29) OKX (15) PHP (63) php.ini (24) PHP 7.1.12 (22) PHP 7.4 (26) phpmyadmin (15) PhpStorm (24) Polylang (24) postman (18) Query (17) queue (16) Rancher (24) Redis (38) Refactoring (12) require (12) response (13) RESTful (27) RESTful API (23) rules (12) setting (12) Shell (13) Shopify (19) Shopify CLI (12) SQL (24) String (15) TortoiseGit (15) Ubuntu (35) update (20) VPN (13) Windows 10 (46) WireGuard (22) WordPress (48) Wstunnel (11) Yii (40) Yii 2 (70) Yii 2.0 (51)