NAV: SLTechnology News&Howtos > Database >

• 

  Switching between the three protection modes of Dta Guard

  -- each time the switch command is executed, check the protection mode select database_role,protection_mode,protection_level from before and after the switch. Modify the archive parameter.

  2022-06-01 18:36:49 Views: 213
• 

  Windows installation of MySQL 5.7.19 and related problem handling

  First of all, we need to install vc++2013 first, or else we may not find the msvcr110.dll file http://www.microsoft.com/zh-cn/download/details.aspx?id=407.

  2022-06-01 18:36:48 Views: 278
• 

  12c to the next level

  After the initial version of the production system is installed, it must be upgraded. Check the version upgrade information, the specific upgrade process and other small videos come out. SQL > col comments for a50SQL > set linesize 200SQL > sel

  2022-06-01 18:36:48 Views: 293
• 

  Mysql5.7 binary installation notes

  Check whether the system has installed mysql or its dependencies, and delete it first if it has been installed, otherwise an error will be reported when installing with yum in step 4: [root@mysql01 Packages] # yum list installed | grep m

  2022-06-01 18:36:48 Views: 294
• 

  Mysql table defragmentation

  View the size of tables, indexes, and fragments in the database: select round (sum (data_length/1024/1024), 2) as data_length_MB,round (sum (index_leng)

  2022-06-01 18:36:47 Views: 272
• 

  Spring MVC series: (6) small cases of adding users

  1. Add database table using sqlplus to open database sqlplus scott/tiger to create emps data table create table emps (id varchar (32) not null)

  2022-06-01 18:36:46 Views: 291
• 

  The first sight of mongodb

  Recently found that mongodb this nosql is very popular, their own simple study, send something out, we can discuss. MongoDB is written in C++ language and is an open source database system based on distributed file storage. Add more sections under high load

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

  Dbcp, c3p0, jndi in Database connection Pool Technology

  No matter what persistence technology you use, you must access the database through a data connection, which in Spring is obtained through a data source. In previous applications, data sources are generally provided by Web application servers. In Spring, you can not only get responses through JNDI

  2022-06-01 18:36:46 Views: 257
• 

  Oracle knowledge carding

  Create tablespace user1 datefile''size 20m / / Extensible autoextend off for creating a tablespace autoextend on// data file named User1

  2022-06-01 18:36:45 Views: 222
• 

  Several commands commonly used in mysql

  Query class show databases;-- View all database names show tables;-- View all data table names of the current database, you need to first use the database create database database name;-- create a database

  2022-06-01 18:36:45 Views: 225
• 

  Installation and configuration of redis extension in mac

  Today, the editor will bring you an article about the installation and configuration of redis extensions in mac. The editor thinks it is very practical, so I will share it for you as a reference. Let's follow the editor and have a look. Redis is a high-performance key-value database. The output of redis

  2022-06-01 18:36:44 Views: 269
• 

  How to solve the delay of master-slave synchronization in MySQL

  This article mainly tells you briefly how to solve the MySQL master-slave synchronization delay. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope that how to solve the MySQL master-slave synchronization delay this article can bring you

  2022-06-01 18:36:43 Views: 229
• 

  On the arrangement of knowledge of MySQL Relational Database

  This article mainly introduces the MySQL relational database, the content of the article is carefully selected and edited by the author, has a certain pertinence, and is of great significance to everyone's reference, so let's learn about the MySQL relational database with the author. Relational database 1 defines relational data

  2022-06-01 18:36:42 Views: 293
• 

  The specific writing method of mysql update statement

  The following mainly brings you the specific writing of the mysql update statement, hoping that these contents can bring you practical use, which is also the main purpose of this article when I edit the specific writing of the mysql update statement. All right, don't talk too much nonsense, let's just read the following. Updat in MySQL

  2022-06-01 18:36:42 Views: 269
• 

  Specific steps to quickly create an index for mysql millions of data

  Let's take a look at the specific steps to quickly create an index for MySQL millions of data. I believe you will benefit a lot after reading it. There are not many words in the text. I hope this short article is what you want. Start the preparatory work, user table structure:

  2022-06-01 18:36:37 Views: 298
• 

  The cause and solution of mysql connection error report

  What if an error is reported in the mysql connection? I believe that many novice rookies can do nothing about this. Through the summary of this article, I hope you can find a solution. Here are the reasons and solutions for reporting errors in mysql connections. The error is as follows: ERROR 1129 (HY000): Host

  2022-06-01 18:36:36 Views: 208
• 

  Introduction to mysql Storage engine

  I don't know if you have any knowledge about the similar mysql storage engine before. Today I'm here to tell you a little bit about it. If you are interested, let's take a look at the body. I believe you will gain something after reading the introduction of mysql storage engine. Mysql

  2022-06-01 18:36:36 Views: 288
• 

  Application of MySQL CVM and solution of cmake error report

  The following brings you about the application of MySQL CVM and the solution to cmake error. I'm sure you've read similar articles. What's the difference between what we bring to everyone? Let's take a look at the body. I believe that after reading the MySQL CVM application and cmake error resolution office

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

  Introduction to MyISAM and InnoDB, two kinds of storage engines of MySQL

  Let's talk about the two storage engines of MySQL, MyISAM and InnoDB. The secret of the text is that it is close to the topic. So, let's not talk about gossip. let's just read the following. I'm sure you'll finish reading this article on MySQL's two storage engines, MyISAM and InnoDB.

  2022-06-01 18:36:36 Views: 217
• 

  MySQL 5.7How is the quickest way to determine the master node with a single MGR?

  This article is mainly about how the MySQL 5.7MGR single master can quickly determine the master node. If you are interested, let's take a look at this article. I believe that after reading the MySQL 5.7MGR single master how to determine the master node most quickly, it will be of some reference to you.

  2022-06-01 18:36:35 Views: 217