NAV: SLTechnology News&Howtos > Database >

• 

  Brief introduction of redi+keepalive

  Redis concept Redis is an open source (BSD licensed), in-memory data structure storage system that can be used as database, cache, and messaging middleware. It supports many types of data structures, such as string (strings), hash (hashes)

  2022-06-01 22:40:12 Views: 265
• 

  Mysql5.6 installation and deployment

  Mysql5.6 install is installed and deployed in pre-compiled binary mode. Compared with compilation and installation, it does not need to be compiled and can be used after my.cnf initialization is modified. It is recommended to use this method in production environment. Download files domestic mirror sources download faster, there is no need to go to the official website

  2022-06-01 22:40:11 Views: 243
• 

  Cache database Memcached-- installation and management database operation

  1. Introduction to Memcached: (1) introduction: Memcached is a high-performance distributed in-memory object caching system for dynamic Web applications to reduce database load. It improves dynamics by caching data and objects in memory to reduce the number of times the database is read.

  2022-06-01 22:40:02 Views: 205
• 

  Database cross-database query

  Due to the rapid development of micro-service technology, in our architecture, each micro-service will correspondingly connect to a database, and the tables associated with each database (such as user tables, business tables, etc.) will synchronize data with each other. Other data operations are independent (such as log tables, operation tables, etc.). This design is based on

  2022-06-01 22:39:56 Views: 208
• 

  Hadoop balancer hbase balancer

  During the operation of Hadoop equalizer Hadoop, the blocks of its datanode will become more and more unbalanced, and the unbalanced cluster will cause some datanode to be relatively busier. Hadoop's equalizer is a daemon. It reallocates the block, changing the block from the busy d

  2022-06-01 22:39:55 Views: 222
• 

  MongoDB modifies data through Save

  1. View the collection show collections2. View the data in the collection db.runoob.find (). Pretty () 3. Modify multiple pieces of data in the collection db.runoob.save ({"_ id": ObjectId ("

  2022-06-01 22:39:41 Views: 255
• 

  MySQL 8.0 resource group effectively solves the CPU alarm caused by slow SQL

  The role of the resource group is to isolate resources (you can understand it as the hardware configuration checked when activating the CVM). Assign the slow SQL thread id online to a core of the CPU and let it run slowly, so as not to affect the overall performance of the CPU. Create a resource group mysql > create resou

  2022-06-01 22:39:41 Views: 238
• 

  The giant sequoia database won the bid of Zhangjiakou Bank and Baoding Bank, and the layout of North China was upgraded again.

  Recently, the giant sequoia database won the bid of Zhangjiakou Bank and Baoding Bank project, and the application business scenarios include online business, data center, etc., which marks a further step in the banking layout of the giant sequoia database. City commercial bank is a kind of bank of great significance in our country at present. In recent years, with the change of market, the opportunity of city commercial bank is more and more.

  2022-06-01 22:39:41 Views: 301
• 

  List chain / list structure

  Lpush key value function: insert the value into the link header rpop key function: return and delete the list tail element rpush,lpop: do not explain lrange key start stop (starting from 0) lrange k

  2022-06-01 22:39:24 Views: 247
• 

  Oracle View SQL execution Plan 1--explain plan

  Syntax: explain plan for + target SQLselect * from table (dbms_xplan.display); eg:SQL > explain plan for select e

  2022-06-01 22:39:23 Views: 302
• 

  Use SQL to query table information in Sybase ASA 12

  In the Sybase central tool, we can often see the following page: yesterday, a customer happened to need to export such a copy of table data, so I wrote the following SQL statement to query table information: SELECT tbl.table_

  2022-06-01 22:39:19 Views: 208
• 

  When a copy is added after a new exchange Database is installed, the

  After the newly installed exchange Database, the following failure occurs when adding replicas. After reloading the database, the replication status is still prompted to fail. [cause Analysis] when creating a replica for database03 before, there must be no more than 5 mailbox server databases.

  2022-06-01 22:39:16 Views: 279
• 

  Database creation and basic knowledge

  1. Database operation: create: create databases xxx; use: use xxx; delete: drop databases xxx; display: show databases; data type: numeric: 1. Integer: bit

  2022-06-01 22:39:16 Views: 207
• 

  Oracl migrates the database 100%, does not lose tables and data, and recovers without error reminders

  Must: use the exp/imp command (plsql import is not allowed) to prepare the work select 'alter table' | | table_name | | 'allocate extent;' from user_tables

  2022-06-01 22:39:15 Views: 262
• 

  Brief introduction and deployment of replication set Cluster Architecture of MongoDB Cluster

  Replication set introduction replication cluster architecture voting mechanism replication cluster member description priority 0 replication set member arbitration node architecture replication set cluster environment deployment environment description pre-preparation environment configuration file start MongoDB instance configuration replication set replication set common commands modify priority replication set test creation

  2022-06-01 22:38:53 Views: 202
• 

  Mongodb replica set Link configuration

  Mongodb://username:password@192.168.56.101:27017192.168.56.102:27017192.168.56.103:27017/db_name?r

  2022-06-01 22:38:53 Views: 287
• 

  SQLBatch Runner--SQL Server batch execution

  SQL Server often manages different data by sub-database, such as one database per branch. SQL Server DBA therefore often needs to manage dozens of databases. If a large number of libraries need to execute scripts, especially if there is more than one script

  2022-06-01 22:38:47 Views: 261
• 

  Use the SQL Compare command line to automate database deployment

  SQL Compare is a tool for comparing and synchronizing SQL Server database structures. More than 150000 database administrators, developers, and testers now use it. When testing the local database, temporarily storing or activating the database of the remote server, SQL

  2022-06-01 22:38:46 Views: 220
• 

  ORA-12838: cannot read/modify

  Insert insert data Times error: SCOTT@prod > insert / * + append * / into scott.employee select * from scott.employee; 3584

  2022-06-01 22:38:46 Views: 285
• 

  Hbase REST API

  Rest api-- http://wiki.apache.org/hadoop/Hbase/Stargatecurl-H "Accept: text/xml" http://itr-hbas

  2022-06-01 22:38:46 Views: 267