Category:Database
-
Time:2019-12-15
I. memcached practice foundation 1. Introduction to memcached Free and open source, high performance, distributed memory object caching system Effect: Data cache Storage session SMS verification code storage installMemcached is based on libevent, so libevent needs to be installed before memcached is installed 2. Memcached common commands Set commandStore the value (data value) in the […]
-
Time:2019-12-15
By jeskson Source: front end tavern of dada MySQL management, database management and data table management, user management. Initialize database, create database, view database, delete database. Create data table, view data table, modify data table, delete data table. User management, creating and deleting users, granting and retrieving user rights, setting and changing user passwords. Database […]
-
Time:2019-12-15
background In the project, Oracle BPM products are used to coordinate office work and workflow. Recently, Party A’s father complained that it took a long time to approve, hoping to achieve an average time of 1 second. Party A’s father asked for it, but he couldn’t help it, so he started a painful optimization process. […]
-
Time:2019-12-15
Structural benchmarking RDBMS MongoDB Elasticsearch Table Collection Index Row Document Document Column Field Field Schema Schema Mapping SQL DSL Noun interpretation RDBMS RDBMS is the relational database management system, which organizes data into related rows and columns. The computer software for managing RDBMS is the relational database management system. The commonly used database software includes […]
-
Time:2019-12-15
Source: apachecn zetcode translation project Translator: Flying Dragon Protocol: CC by-nc-sa 4.0 Contribution Guide This project needs to be proofread. Please submit pull request. Please be brave to translate and improve your translation. Although we pursue excellence, we don’t require you to be perfect, so please don’t worry about translation mistakes – in most cases, […]
-
Time:2019-12-15
Redis itself is a TCP server in CS mode. The client can send multiple requests through a socket. After each request command is issued, the client will usually block and wait for the redis server to process. After the redis server finishes processing, the result will be returned to the client. Because we know that […]
-
Time:2019-12-15
First,SQLSERVER TruncateUse When you no longer need the watch, use the drop; when you still want to keep the table, but want to delete all records, use the truncate; when you want to delete some records(always with a WHERE clause)delete. TruncateIt is a SQL syntax that can quickly empty all the data in the table. […]
-
Time:2019-12-15
Systems and software CentOS 7.0postgresql9.6 Download and install yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm yum install postgresql96 yum install postgresql96-server To configure Modify listening address vi /var/lib/pgsql/9.6/data/postgresql.conf Remove the comment of “listen” address =’localhost “and change it to” listen “addresses = ‘*’ Modify the IP segment of an accessible user vi /var/lib/pgsql/9.6/data/pg_hba.conf Change the content of the host […]
-
Time:2019-12-15
*The difference between different functions of obtaining time select DATE_FORMAT(NOW()); — 2019-05-28 17:55:34 select CURDATE(); — 2019-05-28 select CURTIME(); — 17:55:34 Get current date SELECT DATE_FORMAT(NOW(), ‘%Y-%m-%d’); — 2019-05-28 or select DATE_FORMAT(now(),’%Y-%m-%d %h:%i:%s’); — 2019-05-28 05:55:34 or select CURDATE(); — 2019-05-28 Get the date one month ago SELECT DATE_SUB(CURDATE(),INTERVAL 1 MONTH) — 2019-04-28 Get the […]
-
Time:2019-12-15
Swoole MySQL Proxy A MySQL database connection pool developed by swoole based on MySQL protocol. principle The database connection is stored in memory as an object. When the user needs to access the database, the connection will be established for the first time. Instead of establishing a new connection, an established free connection object will […]
-
Time:2019-12-15
outline Purpose of articleThis paper aims to extract a set of thinking framework of distributed idempotent problem, rather than to solve a specific distributed idempotent problem. In this framework, there will be some examples.Article objectiveI hope that readers can design a complete idempotent solution that is in line with their own business through this thinking […]
-
Time:2019-12-15
Five modules (XML / bean / mapper / service / controller) are generated automatically by using mybatis plus. Here, I will practice crud under mybatis plus framework It’s still the original springboot project Mybatis plus is also an enhanced version of mybatis. It does not change the original functions of mybatis, but adds some new […]