NAV: SLTechnology News&Howtos > Database >

• 

  In-depth understanding of Java: introduction to custom annotations (Annotation)

  To learn more about annotations, we must be able to define and use our own annotations, and before defining our own annotations, we must understand the syntax of meta-annotations and related definition annotations provided to us by Java. Meta-annotations: the function of meta-annotations is to be responsible for annotating other notes. Java5.0 fixed

  2022-06-01 18:01:54 Views: 291
• 

  Hyperledger Fabric enables CouchDB to be a state database

  Hyperledger Fabric enables CouchDB as a state database. Overview 1. The data request flow super book uses the endorsement / consensus model, and the simulation execution and block verification are performed separately in the nodes of different roles. The simulation execution is concurrent, so that you can mention

  2022-06-01 18:01:39 Views: 285
• 

  View the real execution plan of oracle

  A total of three step;step1: when sql is executed, add hint: / * + gather_plan_statistics*/step2: find out the sql id of sql: select * from v$sql s

  2022-06-01 18:01:39 Views: 264
• 

  Asura Monitoring is used in combination with grafana

  Environment preparation 1. Install grafana to create an installation directory according to your own habits. This article is located in the current directory # cd # wget https://s3-us-west-2.amazonaws.com/grafana-rele

  2022-06-01 18:01:35 Views: 300
• 

  How to change the configuration of Redis

  This article shares with you how to change the configuration of Redis. The editor thought it was very practical, so I shared it with you to learn. The following information is about the use of commands to change the configuration of Redis. Command will change the behavior of the Redis server only during the current session or until you run it

  2022-06-01 18:01:35 Views: 211
• 

  Solve the problem of "ORA-12170: TNS: connection timeout"

  The database can be accessed normally on the virtual machine, but when "ORA-12170:TNS: connection timeout" occurs when connecting to the database on the physical machine, you can use the following ideas to solve the problem. First, check the network 1.ping ip address to check the network problems to see if ping can be reached; 2.t

  2022-06-01 18:01:35 Views: 218
• 

  Summary of experiment on partition of mysql table

  The draft is lost and published incompletely. later reorganizing the mysql partition technology can effectively solve the shortcomings of horizontal split and vertical split, and the maneuverability and efficiency are better. The following is a summary of some experiments. The InnoDB engine needs to be set in the configuration file: innodb_file_p

  2022-06-01 18:01:33 Views: 234
• 

  [MySQL] [ProxySQL] Analysis of mysql_ users Table

  [MySQL] [ProxySQL] Analysis of mysql_users Table 1. Table definition and field description table DDL definition: CREATE TABLE mysql_users (username VARCHAR NOT

  2022-06-01 18:01:30 Views: 287
• 

  Automatically generate DAO and entity classes using MyBatis Generator

  GeneratorConfig.xml file:

  2022-06-01 18:01:29 Views: 255
• 

  Pg_hba.conf and pg_ident.conf

  Default content of pg_hba.conf after initialization: # TYPE DATABASE USER ADDRESS METHOD# "local" is for Unix domain socket connecti

  2022-06-01 18:01:29 Views: 283
• 

  The method of deleting all data tables in a mysql library in batches

  Bulk delete mysql all data tables in a library method delete table drop table table name; if there are 100 tables, execute them manually 100 times, it crashes when you think about it. Here is a scenario that uses the information_ schema library to delete data in bulk

  2022-06-01 18:01:29 Views: 302
• 

  SQL Server transaction

  2. T-SQL query statement details transaction and lock designer: Yang Wen anti-pseudo code: although thousands of waves are hard, blowing out the yellow sand to the golden SQL Server ensures data consistency by supporting transaction mechanisms. Case: in daily life, you may have used bank transfer, bank transfer operation

  2022-06-01 18:01:21 Views: 224
• 

  MongoDB modify data update and save method

  Earlier, I briefly introduced how MongoDB inserts data. Then the data is inserted into the database and the data may be modified. In MongoDB, it provides a way to modify data: update. Next, let me briefly talk about how to use update. First of all, we fuck

  2022-06-01 18:01:18 Views: 252
• 

  Dynamic scaling of redis cluster cluster-deleting master and slave nodes

  Goal: remove a group of master and slave from the cluster (5007cue 5008) after adding 5007cue 5008 master-slave service node in the previous section, the current situation of the cluster is as follows: b3363a81c3c59d57143cd3323481259c044e66d2

  2022-06-01 18:01:18 Views: 280
• 

  Initialize the outgoing task

  -- initialize the summary of the outgoing order, remove the task list, and clear the wave number update out_sale_billing_m set sf_ycw_sl=' No 'where DJBH =' XHBB00000414140';BE.

  2022-06-01 18:01:18 Views: 255
• 

  InnoDB data dictionary-dictionary table loading

  1. When InnoDB starts, you need to initialize the library if you create a new database, and you need to create relevant information about dictionary management. The function innobase_start_or_create_for_mysql calls dict_create to complete this

  2022-06-01 18:01:18 Views: 239
• 

  SQLPLUS of Oracle

  Sqlplus environment variables and shortcut operations: time class: set time onset timing on format class: set linesize 180set pagesize 999Operation Mark: set sqlprompt

  2022-06-01 18:01:17 Views: 275
• 

  MySQL user management, common SQL statements, MySQL database backup and recovery

  Mysql user Management 1. Create a normal user and authorize [root@gary-tao ~] # mysql-uroot-p'szyino-123'Warning: Using a password on the

  2022-06-01 18:01:01 Views: 247
• 

  Conception and implementation of OSS.Core warehouse based on Dapper encapsulation (expression parsing + Emit)

  Recently, while I am not busy, I am planning to build a complete open source project. I will explain the reasons and the entire project framework later. Since it is necessary to build a complete project, data warehousing access is essential. In this article, I mainly introduce my understanding of warehousing in this new project (OSS.Core).

  2022-06-01 18:01:01 Views: 233
• 

  ORACLE RAC 11.2.0.4 ORA-01172 and ORA-01151 errors are reported after startup

  Environment description operating system: redhat6.4 64-bit oracle version: 11.2.0.4 RAC (two nodes) disk array: Hongbin 3300e problem description when RAC cluster was implemented years ago, there was only one set of paths and another set of redundancy in the operating system where the rac cluster was located.

  2022-06-01 18:01:01 Views: 225