NAV: SLTechnology News&Howtos > Database >

• 

  Mariadb installation

  Cd / usr/local/srcwget https://downloads.mariadb.com/MariaDB/mariadb-10.2.6/bintar-linux-glibc_214-x8

  2022-06-01 07:22:41 Views: 222
• 

  Redis cluster cluster building (add, delete, modify, check): 5.0.2

  Environment introduction: 1:centos 7; 2:redis version 5.0.2; 3: installation method: compilation and installation; 4:. Create a cluster node IP address 10.42.166.105purl 6379 10.42.1

  2022-06-01 07:22:41 Views: 252
• 

  C language programming report

  C language programming report after the last aircraft game production, I feel that C language programming, more interesting, but also make me have a deeper understanding and understanding of this course. This time we learned how to learn C language operation files to permanently save data and how to write large-scale structured programs based on functions.

  2022-06-01 07:22:41 Views: 270
• 

  Three methods of moving File path move datafile in Sqlserver

  There are three ways for sqlserver to move files: 1, set up database separation, then copy files to a new directory, add 2, set database offline, copy files to new directories, and then ALTER DATABASE XX MODIFY FILE & # 40tern

  2022-06-01 07:22:40 Views: 286
• 

  Statistics after the unified unit of Oracle group by and case when

  Table data select * from ware_info21 sulfuric acid 1.0000 kg 2 hydrochloric acid 2.0000 kg 3 potassium permanganate 3.0000 tons 4 potassium permanganate 4.0000 kg 5 potassium permanganate 5000.0

  2022-06-01 07:22:40 Views: 291
• 

  Commonly used SQL statements

  1.select count () from mysql.user;// finds the number of rows in the user table of the mysql library mysql > select count () from mysql.user;//count () in

  2022-06-01 07:22:40 Views: 275
• 

  The construction process of GTID replication

  1. What is GTID?GTID (Global Transaction ID) is the number for a committed transaction and is a globally unique number; GTID is actually made up of UUID+TID. Where UUID is a MySQL real.

  2022-06-01 07:22:40 Views: 260
• 

  Introduction to Mysql engine

  The Mysql engine introduces that the Innodb storage engine supports transactions, row-level locks and foreign keys in OLTP, high concurrency through multi-version concurrency control MVCC, and four isolation levels of SQL (default repeatable). Provide insert bu

  2022-06-01 07:22:39 Views: 243
• 

  Enq:SQ-contention (SQ lock) test

  Oracle uses the following three locks to manage Sequence: row cache lock: during the call to Sequnece.nextval. It is obtained when the data dictionary information is physically modified. Seque assigned to the NOCACHE attribute

  2022-06-01 07:22:39 Views: 287
• 

  Persistent RDB of Redis

  Dbfilename redis.db / / persistent file dir / home/redis/6379 / / the directory where the file is located save 9001 / / 900s modify a key to save once save 30010

  2022-06-01 07:22:27 Views: 207
• 

  Three Solutions of Chinese display garbled in MySQL5.7 under Windows Environment

  Recently, I encountered some problems in the process of migrating data from Oracle to MySQL, including the display of garbled Chinese characters. After the data is imported successfully, the content of the Chinese field cannot be displayed properly. Later, it was found that the character set setting on the client side was correct, and the character set setting on the server side was not supported.

  2022-06-01 07:22:27 Views: 249
• 

  Tencent Xu Chunming: HBase practice and Innovation in Internet Financial Industry

  This article is based on the content of teacher Xu Chunming's live speech at the Ninth China Database Technology Conference (DTCC) on May 11, 2018. About the lecturer: Xu Chunming, head of Tencent Financial and payment Database platform Group, has more than 10 years of working experience in the database industry and is good at My.

  2022-06-01 07:22:27 Views: 291
• 

  How to keep data consistency during mysqldump backup

  Mysqldump has different internal implementations for different types of storage engines. It is mainly aimed at two types of storage engines: storage engines that support transactions (such as InnoDB) and storage engines that do not support transactions (such as MyISAM). Let's take a look at the implementation of these two storage engines:

  2022-06-01 07:22:23 Views: 226
• 

  Here comes the PostgreSQL database that is hotter than this summer!

  What is PostgreSQL? Cloud database PostgreSQL is a powerful enterprise-level relational database management system built by JD.com Cloud based on open source PostgreSQL version 10.6. PostgreSQL has "available in the world"

  2022-06-01 07:22:23 Views: 219
• 

  [Oracle] Device Checks for ASM-This is a pre-check

  When Oracle11g RAC installs grid. The following warning appears during the condition check, Device Checks for ASM-This is a pre-check to verify if the s

  2022-06-01 07:22:22 Views: 294
• 

  Analysis of Oracle RMAN backup and Compression principle

  RMAN backup principle: when the RMAN client connects to the target database and executes the backup command, RMAN will open a corresponding number of channels to work, each channel has a corresponding service process in the target database, and RMAN will first call DBMS_RC

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

  SQL Server maintains and manages remotely through web.

  Now many applications are deployed to the cloud, so the database needs to be managed and maintained remotely, so it is more safe and convenient to operate based on web. The TreeSoft database management software is developed using JAVA and adopts a stable and universal springMVC+JDBC architecture.

  2022-06-01 07:22:19 Views: 296
• 

  Sqlserver 2014 Standard Edition does not support features

  Restore sqlserver 2014 Enterprise Edition backup error with sqlserver 2014 Standard Edition: 5% processed. 10% has been processed. 15 per cent has been processed. 20% has been processed. 25 per cent has been processed. Percent processed

  2022-06-01 07:22:19 Views: 211
• 

  Creation and use of Oracle materialized View (1)

  The creation of Oracle materialized view and the use of http://blog.csdn.net/tegwy/article/details/8935058 first look at the simple creation statement: create materialized view

  2022-06-01 07:22:16 Views: 291
• 

  PostgreSQL DBA (127C)-Develop (JDBC failover&load balance)

  PostgreSQL JDBC Driver provides the Failover and Load balance of the database at the driver level. The related parameters include: targetServerType = StringAllows open

  2022-06-01 07:22:16 Views: 285