Partition Subtable for MySQL

1. Why divide tables?The database data becomes larger and larger, with too much data in a single table.This results in slower queries and database performance bottlenecks due to the lock mechanism of tables, which can seriously affect application operations.One mechanism in mysql is table and row locking to ensure data integrity.A table lock m ...

Added by johnnyblaze9 on Thu, 04 Jun 2020 03:09:26 +0300

Deploy asynchronous download service

Asynchronous Download 1, Background At present, the system is slow to download large files, slow to export, a large number of interfaces occupy server bandwidth and other problems, which seriously affect the user experience. Based on this background, the asynchronous download function is developed and implemented. 2, Project structure Brain ...

Added by fuzz01 on Tue, 26 May 2020 18:42:40 +0300

Linux command (22) useradd command

useradd command Function Description: add user or update default new user information Usage: useradd [options] login_name option explain -u,--uid UID When adding a new user, specify the UID number manually. The default is the UID+1 of the previous user, the UID usage range (CentOS6) 500 +, (CentOS7) 1000+ -g,--gid group_name When a ...

Added by j152 on Mon, 25 May 2020 14:46:35 +0300

Ctssecuritytestcases - listeningportstest locates tcp port and pid

Ctssecuritytestcases - listeningportstest locates tcp port and pid [problem description] cts failures armeabi-v7a CtsSecurityTestCases android.security.cts.ListeningPortsTest#testNoListeningLoopbackTcpPorts Tool: 9.0 μ R11 05-06 17:11:28.649 17375 17391 E TestRunner: android.security.cts.ListeningPortsTest$ListeningPortsAssertionError: 05-0 ...

Added by tibiz on Thu, 07 May 2020 19:59:45 +0300

De1ctf 2020 web [hard ﹣ pentest ﹣ 1] character free injection & SYSVOL restore group policy password

Open the source code directly, see that it is a file upload, check the file size and pass a Check() function judgment, and take a look at the Check() function function Check(){ $BlackExts = array("php"); $ext = explode(".", $_FILES["file"]["name"]); $exts = trim(end($ext)); $file_content = file_get_contents($_FILES["file"]["tmp ...

Added by mrjameer on Thu, 07 May 2020 10:23:40 +0300

Build LVS-DR load balancing cluster and maintained LVS high availability load balancing cluster

18.11 LVS DR mode construction preparation Three machines have public IP. Scheduler (director) IP: 192.168.230.135 real server1(real1) IP: 192.168.230.130 real server2(real2) IP: 192.168.230.145 VIP: 192.168.230.200 Start building Configure director [root@cham002 ~]# vim /usr/local/sbin/lvs_dr.sh #! /bin/bash echo 1 > /proc/s ...

Added by buddysal on Mon, 04 May 2020 07:27:43 +0300

for loop, while loop, break out of loop

for loop General format: for var in item1 item2 ... itemN do command1 command2 ... commandN done Write in one line: for var in item1 item2 ... itemN; do command1; command2... done; eg: Requirement: sum the numbers from 1 to 100. [root@dl-001 sbin]# vim sum.sh #!/bin/bash sum=0 for i in `seq ...

Added by samafua on Thu, 30 Apr 2020 13:57:53 +0300

shell script seven: if structure conditional sentence knowledge and Practice

7, Knowledge and practice of if structure conditional sentence (1) if conditional single and double branch syntax 1. Single branch if condition then instructions fi 2. Bifurcate if condition then instructions else Instruction set 2 fi (2) if conditional multi branch statement 1. Structure of statement if condition 1 then ...

Added by crishna369 on Wed, 29 Apr 2020 17:46:38 +0300

8.2 introduction to common modules: sys,os,time,random

sys: Introduction: it mainly includes functions related to the interaction between python compiler and system. Common functions: import sys print(sys.argv)#Name of this file,Parameters when the program is already running #[As in the command window python3 mysys.py Parameter 1 Parameter 2] #Then parameter 1 is sys.argv[1],And so on print(sys. ...

Added by argh2xxx on Wed, 15 Apr 2020 21:28:59 +0300

bash-shell Advanced Programming--Operators and Related Topics

Operators and related topics Operator assignment Assigning, initializing, or modifying the value of a variable = A general assignment operator that can be used for arithmetic and string assignments. var=12 car=bmw # Cannot have a blank character after the = sign Don't confuse = assignment operator with = test operator ...

Added by killerz on Wed, 01 Apr 2020 09:34:59 +0300