Programming VIP

1, Redis persistence RDB snapshot 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 ...

catalogue preface 1, View phpMyAdmin version 2, phpmyadmin common getshell methods 1. Premise 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 summary preface phpMyAdmin is a MySQL databa ...

preface    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 ...

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 ...

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 ...

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 ...

background 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 ...

brief introduction Delete data in batch according to table primary key POST http://{Tcaplus_REST_URL} Request syntax Http request #Tencent cloud console RESTful Endpoint, ip:80, port: 80 by default http://172.17.0.22 #Tcallusdb local docker RESTful Endpoint, ip:31001, port default 31001 http://9.135.8.93:31001 Http head nameRequiredRes ...

brief introduction 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 ...

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 ...