NAV: SLTechnology News&Howtos > Database >

• 

  SQL Server query Optimization and transaction processing

  Blog catalog 1, index 2, view 3, stored procedure 4, system stored procedure 5, trigger 6, transaction 7, lock 1, index provides pointers to data values stored in the specified column in the table, and then arranges the pointers in the specified order, followed by the pointer to the column containing the value. 1. What is a cable

  2022-06-01 22:23:06 Views: 262
• 

  [4] build HA high availability hadoop-2.3 (deploy and configure HBase

  [1] build HA High availability hadoop-2.3 (Planning + Environment preparation) [2] build HA High availability hadoop-2.3 (install zookeeper) [3] build HA High availability hadoop-2.3 (deployment configuration hadoop--cdh6.

  2022-06-01 22:23:03 Views: 295
• 

  RocketMQ enterprise deployment solution

  Background A lot of businesses of the company are using RocketMQ, the early business volume is small, there is no problem, and they do not pay much attention to the availability of the cluster, so the whole company's business shares a cluster, with the increase of the company's business volume, the business relies more and more heavily on the RocketMQ cluster, and begins to think about cluster split.

  2022-06-01 22:22:57 Views: 212
• 

  Special permissions-SUID,SGID,Sticky study notes

  SUID: when running a program, the owner of the corresponding process is the owner of the program file itself, not the initiator, chmod SUID FILENAME (add SUID permission) chmod Umurs FILENAME (remove SUID permission)

  2022-06-01 22:22:56 Views: 289
• 

  Mongo replication set + fragmentation to realize massive data storage

  MongoDB Auto-Sharding solves the problem of mass storage and dynamic capacity expansion, but it is still some distance from the high reliability and high availability required by the actual production environment, so there is a "Replica Sets + Sharding" solution: Sh.

  2022-06-01 22:22:56 Views: 218
• 

  MongoDB replication set Construction & simulated switching of Master Server

  The preface Mongodb replication set consists of a set of Mongod instances (processes), including one Primary node and multiple Secondary nodes. All data of Mongodb Driver (client) is written to Primary,Seconda.

  2022-06-01 22:22:51 Views: 221
• 

  [giant Sequoia Database SequoiaDB] Giant Sequoia Tech | four steps, quick

  1. Background SequoiaDB Giant Sequoia Database is a financial-level distributed database, including distributed NewSQL, distributed file system and object storage, and high-performance NoSQL storage modes, corresponding to distributed online transactions, unstructured data and content management, respectively.

  2022-06-01 22:22:51 Views: 206
• 

  Distribution order reduction

  Delete select t.djbh _ sj = 'XSGYMA00419243';select t.meme Rowi' by deleting the details and summaries of distribution orders generated by documents.

  2022-06-01 22:22:51 Views: 231
• 

  Introduction to MySQL Master-Slave replication

  1.1 introduction to the principle of MySQL Master-Slave replication MySQL Master-Slave replication is an asynchronous replication process (although it generally feels real-time), and data will be replicated from one MySQL database (we call it Master) to another MySQL database (we call it

  2022-06-01 22:22:48 Views: 214
• 

  Introduction to JDBC's notes

  From the beginning of the design of 1.JDBC, Java technology developers have realized the great potential of Java in database applications. Since 1995, they have been working on extending the Java standard class library to make it possible to access databases using SQL. They initially hoped that by extending Ja

  2022-06-01 22:22:47 Views: 207
• 

  [PostgreSQL] Database backup and recovery (pg_rman)

  [root@wallet01 ~] # rpm-ivh pg_rman-1.3.8-1.pg96.rhel6.x8664.rpm [root @ wallet01 ~] # su-postgres [po

  2022-06-01 22:22:47 Views: 209
• 

  Basic configuration and use of MyCat Database

  With the rapid development of computer and information technology, the scale of industry application system expands rapidly, and the amount of data generated by industry application increases explosively, easily reaching hundreds of TB or even hundreds of PB, which has far exceeded the processing power of traditional computing technology and information system.

  2022-06-01 22:22:41 Views: 200
• 

  Mysql database capacity query

  1. View all database capacity sizes Mysql "> select table_schema as' database', sum (table_rows) as' records', sum (truncate (data_length/1)

  2022-06-01 22:22:41 Views: 250
• 

  SQL grammar prompt tool SQL Prompt to help you know SQL_VA

  SQL Prompt automatically retrieves according to the object name, syntax and code snippet of the database to provide users with appropriate code choices. Automatic script settings make the code easy to read-especially useful when developers are not familiar with scripts. SQL Prompt installation can be used, can be greatly improved

  2022-06-01 22:22:38 Views: 249
• 

  Talking about the Scheme of Database Cluster

  Single-point database is often the performance bottleneck in the system, so a variety of caching mechanisms are usually introduced in the system design to avoid frequent access to the database. In addition, because of the importance of the database, the requirement of high availability can not be avoided, because once the database is down, basically the whole system cannot.

  2022-06-01 22:22:13 Views: 232
• 

  Add, delete and modify operations in MongoDB

  Addition, deletion, modification and search of MONGODB: note: the field "_ id" is the GUID that the database adds to us by default, the purpose is to ensure the uniqueness of the data 1, add insert1, syntax: db. Collection .insert ({"key1": value1, "key2"

  2022-06-01 22:22:13 Views: 291
• 

  MHA High availability Cluster basic deployment (pure combat)

  MHA High availability Cluster basic deployment MHA Overview MHA is currently a relatively mature solution for MySQL high availability developed by youshimaton, a Japanese company that works for Facebook. Failure in MySQL high availability environment

  2022-06-01 22:22:13 Views: 296
• 

  Talk about the solutions to the deletion of database table records

  [fault category] (1) Fault type: database table record deletion (2) typical characteristics: 1. There is no data or only part of the data in the data table. The client can not query the complete information (3) damage degree star evaluation: ★★★★ [solution] (1) recovery process 1. Detection process: (

  2022-06-01 22:22:13 Views: 277
• 

  Clob field processing in oracle database

  1. Specify the string type to be inserted as clob. You can use a procedure or stored procedure example: DECLAREREALLYBIGTEXTSTRING CLOB: = 'massive string to be inserted'; BEGININSERT INTO test

  2022-06-01 22:22:09 Views: 216
• 

  Problems encountered in MySQL Learning

  Because you want to change careers to test, so study the database. Record the problems encountered and their solutions. 1. A 1045 error will be prompted every time you log in. 1045-Access denied for user 'root'@'localhost' (usi

  2022-06-01 22:22:09 Views: 235