NAV: SLTechnology News&Howtos > Database >

• 

  Mysql5.7.22 source code compilation and installation

  Mkdir / tools & & cd / toolsmysql download https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22.tar.gz download b

  2022-06-01 21:34:13 Views: 220
• 

  MySQL's database object viewing tool mysqlshow

  Mysqlshow: a database object viewing tool that is used to quickly find out which databases, tables, columns, or indexes exist in the database. Option:-- count displays statistics for databases and tables-k displays indexes in specified tables-I displays table status information without any

  2022-06-01 21:34:13 Views: 295
• 

  Essential difference between left join and right join (illustration)

  1, test1 Table 2 t1.id2 Test2 Table 3, query 1 SELECT t1.id id1 left join (1 Table as condition) SELECT t1.id id1, t1.id1 A1, t1.id2 b1, t2.id1 a2, t2.id2 b2

  2022-06-01 21:33:57 Views: 272
• 

  How to build MySQL Database on CVM Centos7

  How to build MySQL database on CVM Centos7? Many people don't know much about it. Today, in order to give you a better understanding of how to build a MySQL database on Centos7 on CVM, let's summarize the following. Let's take a look at it. Download MySQL's

  2022-06-01 21:33:56 Views: 220
• 

  How to connect to redis with pomelo

  Today, the editor to share with you is how to use pomelo to connect redis, many people do not understand, today, in order to let you know more about the method of connecting pomelo to redis, so to sum up the following content, let's look down together. I'm sure you'll get something. Pom

  2022-06-01 21:33:43 Views: 251
• 

  Mongodb log management

  # cut out the log contents and automatically generate new date-generated history files: method 1: mongod-v-- logpath / var/log/mongodb/mongos.log method 2: kill-SIGUSR1 {pid

  2022-06-01 21:33:43 Views: 241
• 

  Oracle some of the more commonly used commands (continuous updates)

  Method 1: login will display the version number [oracle@ogg1 ~] $sqlplus / as sysdba # sometimes directly enter # sqlplusSQL*Plus: Release 11.2.0.3.0

  2022-06-01 21:33:40 Views: 282
• 

  Database-transaction and relational database paradigm

  First, the database is a system software that stores and manages data according to the data structure, and the software system that manages the database is called the database management system. Second, the relational database paradigm means that when designing a relational database, we should abide by the design principles. Design a good relationship by following these rules

  2022-06-01 21:33:40 Views: 218
• 

  MySql Learning Notes (6): scanning range

  The type column of explain indicates the scanning range of this query. There are seven kinds of scans, and the effects are listed from top to bottom: system > const > eq_ref > ref > range > index > all. Data preparation: CREATE TABLE `t

  2022-06-01 21:33:39 Views: 260
• 

  Redis basic command

  1. Get the keys pattern symbolic meaning of the list of key names that conform to the rules? Match a character * matches any number of characters [] matches any character between parentheses, and you can use the "-" symbol to indicate a range\ x matching character x, which is used to escape symbols. If you want to match? You need it.

  2022-06-01 21:33:39 Views: 252
• 

  Statements that are often used in Oracle databases but are hard to remember

  1. Associate and update table operations. For example, if we need to operate on a table, it is usually OK to update, but sometimes the conditions have to be related. There are some differences between this oracle and mysql, so I'll just say oracle: update sys_r.

  2022-06-01 21:33:39 Views: 218
• 

  New feature of Oracle 12.2-online move table

  Before the Oracle12.2 version, the table was locked with exclusive when performing move operations on the table, and the DML operation could not be performed on the table. Although the move operation has an ONLINE clause, it only applies to IOT tables, not to heap tables. This means move the watch.

  2022-06-01 21:33:39 Views: 288
• 

  Basic operation and backup of mysql database

  1. Basic view and login: mysql-uroot-pshow databases; # # View database use mysql; # # enter database mysqlshow tables; # # View table desc user

  2022-06-01 21:33:19 Views: 286
• 

  Grafana basic profile

  What is the official interpretation of Grafana: grafana is an open source program for visualizing large measurement data, providing a powerful and elegant way to create, share, and browse data. Dashboard shows the data from your different metric data sources. Grafa

  2022-06-01 21:33:19 Views: 272
• 

  How to deal with the lack of SWAP space when installing Oracle

  When installing Oracle, the installation may fail because we do not allocate enough swap space. The processing steps are as follows: SWAP space is 2G [root@linux01 oracle] # free total

  2022-06-01 21:33:18 Views: 212
• 

  Non-ORACLE official PL/SQL configuration

  1. Download Instant C from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

  2022-06-01 21:33:15 Views: 272
• 

  Common error processing in Installation Oracle11gR2 RAC

  Chapter VI, error processing 6.1 root.sh script execution failed processing when installing grid, the error in executing the rootsh footer is as follows: Adding Clusterware entries to inittabUSM driver in

  2022-06-01 21:33:15 Views: 251
• 

  Rman-- backup command

  RMAN complete / / parameter files, control files, data files, archive logs, do not back up online log files RMAN > backup database;RMAN backup is divided into copy physical backup: the source file is as big as the backed up file backup logic backup

  2022-06-01 21:32:45 Views: 276
• 

  Build Zabbix3.2 under Centos7.2 (simple)

  Zabbix (zbix) is an enterprise-level open source solution based on WEB interface that provides distributed system monitoring and network monitoring functions. Zabbix can monitor various network parameters to ensure the safe operation of the server system, and provides a flexible notification mechanism to allow

  2022-06-01 21:32:45 Views: 247
• 

  Oracle sets the width of SQLPlus result display, ORACLE sqlplus prompt setting

  First, the results of SQLPlus queries can be adjusted according to their own screen conditions: we know that in sqlplus mode, select queries often encounter returned record breaks, and at this time we often set row width, column width and page records. Set line width: set

  2022-06-01 21:32:23 Views: 252