1, Redis persistence
By default, redis saves the in memory database snapshot in the name dump RDB binary file. Redis can be set (save N M) to automatically save the dataset (the whole memory at the current time) as an RDB file when the condition of "at least M changes to the dataset in N seconds" is met. You can also en ...
Added by alexcrosson on Mon, 21 Feb 2022 18:01:27 +0200
1, View phpMyAdmin version
2, phpmyadmin common getshell methods
2. Website physical path acquisition method
3. Get shell through into outfile
4. Write shell through log file
5. Write shell through slow query
6. Create database and table and write to webshell
phpMyAdmin is a MySQL databa ...
companies in the Internet industry must encrypt the sensitive fields of the database. There are many schemes. The most direct one is to write an encryption and decryption tool class and then process it manually in each business logic. This method is obviously unrealistic in slightly large-scale projects, which is not ...
Added by cfemocha on Mon, 21 Feb 2022 10:29:44 +0200
Mysql log management
1, MySQL log management
The default log storage location of MySQL is / usr/local/mysql/data
There are two ways to open logs: through configuration files or through commands The log opened through command modification is temporary and will be closed after the service is shut down or restarted
MySQL common log types and s ...
Added by MikeUK on Mon, 21 Feb 2022 10:16:57 +0200
1. Multi meter
1.1 multi table description
In actual development, a project usually needs many tables to complete. For example, the database of a mall project needs many tables: user table, classification table, commodity table, order table
1.2 disadvantages of single meter
1.2.1 data preparation
Create a database db3CREATE DATABASE db ...
Added by markszy on Mon, 21 Feb 2022 07:16:34 +0200
1. Concept: Java database connectivity, Java database connection, Java language operation database
JDBC essence: it is actually a set of rules defined by the official (sun company) to operate all relational databases, that is, interfaces. Each database manufacturer implements this interface and provides database driver jar package. We can use ...
Added by Pehape on Mon, 21 Feb 2022 06:58:21 +0200
MySQL has become the first choice for most companies with low-cost and rich Internet resources. Although the performance is excellent, how to better use the so-called "good horse with good saddle" has become a compulsory course for development engineers. We often see requirements such as "proficient in MySQL", &q ...
Delete data in batch according to table primary key
#Tencent cloud console RESTful Endpoint, ip:80, port: 80 by default
#Tcallusdb local docker RESTful Endpoint, ip:31001, port default 31001
Added by Flame000 on Mon, 21 Feb 2022 04:36:53 +0200
Obtain relevant records according to the primary key index, which is defined in the table definition proto file. The primary key index is an index designed based on the primary key field. The interface also supports the return of filter fields. Specify the field name to be returned through the Select parameter; The number of ...
Added by rosegarden on Mon, 21 Feb 2022 04:35:16 +0200
Slow query and slow log
Query and start of slow log
Query whether the slow log is enabled
mysql> show variables like 'slow_query_log';
| Variable_name | Value |
| slow_query_log | OFF |
1 row in set (0.00 sec)
Enable slow query log
# It is convenien ...