Category:Database

  • Memcached practice foundation

    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 […]

  • [soul torture] do you really understand the management and use of MySQL?

    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 […]

  • Oracle BPM 11g approval performance optimization

    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. […]

  • Forced benchmarking of relational database with mongodb and elasticsearch

    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 […]

  • Zetcode database tutorial

    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, […]

  • [redis] pipeline packaging processing mode

    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 […]

  • Use of truncate

    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. […]

  • Postgresql9.6 installation under Linux

    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 […]

  • MySQL time query

    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 […]

  • Smproxy 1.2.9 release! New status command monitoring panel function

    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 […]

  • Trilogy of solutions to distributed idempotent problems

    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 […]

  • Crud based on mybatis plus

    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 […]