NAV: SLTechnology News&Howtos > Database >

• 

  Install and configure SQL Server 2016 With SP1

  Install and configure SQL Server 2016 With SP1Part1: create service startup account Part2: install Part3: configuration Part4: install SSMS download SSMS: https://msdn.microsof

  2022-06-01 07:54:52 Views: 225
• 

  Mysql-5.7.17 binlog query

  Because sometimes it will appear, suddenly which field or table will be deleted, we need to know what content, when and who deleted it, then we can find out from the binlog log what you need 1.binlogbinlog is the binary log, it records the number.

  2022-06-01 07:54:52 Views: 251
• 

  The solution of Common error report in MySQL Master-Slave synchronization

  There are two threads when the database master and slave are synchronized: the IO thread and the SQL thread. A common error occurs around these two threads. IO thread: record the contents of the main library binlog log to the local relay log file. There are two reasons why the IO thread reports an error. The first is when the main library information is specified.

  2022-06-01 07:54:47 Views: 237
• 

  The Construction of RAC by Oracle 11gR2 (5)-- install Oracle and build Library

  Oracle 11gR2 build RAC (5)-- install Oracle and build library system environment: operating system: RedHat EL5Cluster: Oracle GI (Grid Infrastructure) Oracle:

  2022-06-01 07:54:17 Views: 257
• 

  Database tables: zone table system_district

  Regional table [system_district] data model building table script-Table structure for system_district--

  2022-06-01 07:54:17 Views: 216
• 

  Oracle prerequisite statement

  Oracle_11g Common SQL statements (required for Senior Engineers) Oracle_11g Common SQL statements (essential for Senior Engineers)-- quit SQLPLUSexit;-- to change the system(sys) account password

  2022-06-01 07:54:16 Views: 208
• 

  Invalidation of key expiration time of REDIS master-slave architecture

  Redis is used to store users' reward ticket information, in principle, it is cleared every day, and now it is set to expireAt (zero). But recently, according to the operation feedback, some users have abnormal tickets. After checking with log, it is found that the key specified to expire at zero has not expired on time, from the database.

  2022-06-01 07:54:16 Views: 236
• 

  Sql select nesting

  Select * from (select XXX from XXX) as an inner join (select xxxx from xx) as b where a.xx=b.xxselect

  2022-06-01 07:54:16 Views: 215
• 

  The usage of oracle decode function

  The oracle decode function, which will be executed regardless of whether the result of the query satisfies the select statement in the 'PRIMARY', parameter. You can know the set autotrace traceonlyselect dec by viewing the execution plan

  2022-06-01 07:54:09 Views: 261
• 

  Redis performance Monitoring tool

  Environment description OS:centos 6.6_x64DB:redis 3.0.3192.168.1.91-> database server 192.168.1.92-- > monitor host 2. Download path of monitoring tool redis-stat:

  2022-06-01 07:54:09 Views: 244
• 

  Tips of ORACLE 12C ADRCI- veteran driver

  DBA skills when you check the database log every day, do you still need to find the directory yourself? just learn to use ADRCI. How do I usually use it? you might as well try it. Adrci actually has a lot of places we can study, and help can be self-taught. $adrc

  2022-06-01 07:54:09 Views: 205
• 

  [Oracle Database] Event 10046

  [oracle@king01 ~] $sqlplus / as sysdbaSQL > @ user_sessions_all.sql+--

  2022-06-01 07:54:08 Views: 220
• 

  Does not currently know of SID given

  Log.xml error message in oracle TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

  2022-06-01 07:54:08 Views: 262
• 

  Python operates the MySQL of the database

  Python operation database MySQL 1. Install Python-MySQLdb module Python-MySQLdb is a database operation module, Python through it to achieve a variety of operations on mysql data. If you want to install the source code, you can

  2022-06-01 07:54:07 Views: 276
• 

  The harm of slow query in MySQL database

  1. When a slow query occurs in a MySQL database, it is dangerous. Once there are other DDL operations, the waiting of the whole database may be divided into the following situations: when the table is a MyiSAM table, there are slow queries on the table, no blocking of Select, and other DML,DDL of the table.

  2022-06-01 07:54:04 Views: 268
• 

  Solaris 10 (x86) to build Oracle 10g RAC-- configure system environment (1)

  Solaris 10 (x86) build Oracle 10g RAC-- configure system environment (1) system environment: operating system: Solaris 10 (x86-64) Cluster: Oracle CRS 10.2.0.1.

  2022-06-01 07:54:04 Views: 263
• 

  Redis backup recovery

  Note: [to restore, simply move the backup files to the redis installation directory and restart the service. For RDB persistence, just move dump.rdb to the installation directory. For aof persistence, move appendonly.aof to the installation directory. If it is RD, move the appendonly.aof to the installation directory.

  2022-06-01 07:54:03 Views: 246
• 

  Navicat Premium error: ORA-12541:TNS:no listener

  1. The listener snooping service is not started. Enter the service in the windows window-"start in the list of services, oracle snooping or 2." Modify the listener.ora file in oracle (product\ 11.2.0\ dbh

  2022-06-01 07:54:03 Views: 204
• 

  12c ADG delay alarm

  12c ADG delays the alarm, and when the delay disappears, the alarm disappears automatically. DGMGRL > show configuration;Configuration-dg_config Protection Mode: Max

  2022-06-01 07:54:03 Views: 210
• 

  Chapter 0: basic Operation of oracle_sql statement

  Command to save screen output in sql: spool / tmp/a.txt* perform any sql operation spool offho cat / tmp/a.txt launch sqlplus tool: su-oracle$l

  2022-06-01 07:54:02 Views: 277