NAV: SLTechnology News&Howtos > Database >

• 

  Oracle forgot the user's login password

  C:\ Users\ neusoft > sqlplus/nolog-- start SQLPLUS without connecting SQL*Plus: Release 11.2.0.1.0 Production on Thursday October

  2022-06-01 06:11:28 Views: 203
• 

  Mysql percona-toolkit Swiss Army knife

  Check master / slave delay master library:. / pt-heartbeat-- user=root-- password=123456-D test-- master-server-id=1-- create-table--

  2022-06-01 06:11:28 Views: 222
• 

  A case of SQL tuning in SQL Server

  Environment: Microsoft SQL Server 2016 (SP2-CU3) Enterprise Edition question SQL:select RowNumber = ROW_NUMBER () OVER

  2022-06-01 06:11:28 Views: 240
• 

  Mysql PXC Cluster Cerebral fissure and grastate.dat Modification experiment

  Three servers do mysql PXC cluster 172.31.217.182 bd-dev-mingshuo-182172.31.217.183 bd-dev-mingshuo-183172.31.217.8

  2022-06-01 06:11:25 Views: 227
• 

  Soulver for Mac (built-in computer text editor) 3.4.3

  Soulver for Mac is a text editing tool that allows quick calculations and currency conversion. Soulver for Mac selects numbers and calculates your answers as you type. Calculate multiple rows and refer to previous rows, just like a spreadsheet, but

  2022-06-01 06:11:25 Views: 251
• 

  The bidding results of China Mobile OLTP database were released, and five domestic manufacturers won the bid.

  On July 15, China Mobile Information Technology Co., Ltd. (hereinafter referred to as: China Mobile) announced the winning candidates for the joint innovation project of self-controllable OLTP database, including 1000 sets of tender for main and standby database with an amount of 40 million yuan, and 500 sets of distributed bid packages with an amount of 200 yuan.

  2022-06-01 06:11:24 Views: 221
• 

  Slow log cutting of multi-project hundred libraries and hundred meters

  Problem description: multiple projects, some projects sub-library sub-table distributed in multiple nodes, therefore, the cutting and collection of slow logs is extremely necessary for slow log analysis. Implementation: ① environment prepares Host1: ftp server (192.168.xx.xxx) for collection

  2022-06-01 06:11:20 Views: 279
• 

  [Mysql] deadlock generated by two insert statements

  Background: check the status log and find that there are two insert deadlocks RECORD LOCKS space id 388 page no 27032 n bits 616 index `idx_svcorders

  2022-06-01 06:11:20 Views: 293
• 

  MySQL randomly selects Resources-- Optimization

  In the previous article: http://blog.itpub.net/29254281/viewspace-2120294/, Order by rand () has some performance problems when the amount of data is large. Set autoco

  2022-06-01 06:11:19 Views: 205
• 

  PostgreSQL DBA (116)-pgAdmin (Don't do this:Don't use money&serial)

  No zuo no die series, from wiki of pg. This section is about: don't use money. The reason is: moneyIt's a fixed-point type, implemented as a mach

  2022-06-01 06:11:19 Views: 252
• 

  Mysql login error mysql: unknown variable & # 039 investors basedir =

  Use mysql to log in to the database and report an error [root@localhost ~] # mysql-uroot-pmysql: unknown variable 'basedir=/usr' cause: the box in the configuration file

  2022-06-01 06:11:19 Views: 292
• 

  Configure always on mode of SQL 2016 for SharePoint 2016 (3)

  After selecting the replication database server, let's set the endpoint to ensure that port 5022 on the firewall is allowed to configure the listener. The AG listener is actually a virtual address. Through this address and IP, the front-end application can automatically detect the high availability group of the SQL from

  2022-06-01 06:11:14 Views: 269
• 

  Research on the Fault of MySQL system Table

  Recently, during the inspection, I found the following error in the mysql error log: 1779986 2015-10-06 00:06:37 7f5215214700 InnoDB: Error: Table "mysql".

  2022-06-01 06:11:14 Views: 230
• 

  Tomcat 5.5Configuring MySQL database connection pool

  Tomcat 5.5Configuring MySQL database connection pool [@ more@] 1 Environment description JDK 1.5Tomcat 5.5.4MySQL 4.0.20MySQL JDBC 3.0.15Commons dbcp

  2022-06-01 06:11:14 Views: 213
• 

  [RAC] RAC delete node

  First, the plan second, the train of thought is clear step1: delete the instance step2: delete the oracle software step3: delete the GI software step4: delete the node after the verification 3, delete the node process 1. Deleting an instance is done by policy-ma

  2022-06-01 06:11:06 Views: 267
• 

  Correct use of index

  The reason why MySQL can retrieve data efficiently, it can be said that it all depends on the index. In the process of using the index, you should pay attention to several points. 1. MySQL uses the leftmost matching principle when using the index. If it is a single-column index, it is easy to understand, if it is a multi-column index, such as idx_a

  2022-06-01 06:11:06 Views: 277
• 

  About Fatal NI connect error 12170 error

  This kind of error log is often found in the log during the Oracle database inspection, but it usually does not affect the customer's use. The overall error report is as follows:

  2022-06-01 06:11:00 Views: 276
• 

  A preliminary study on the causes of the explosion of mysql temporary table space, temporary table space and ibtmp1 table space

  Answer in the form of the question: first, under what circumstances will MySQL create a temporary table (Internal Temporary Table Use in MySQL)? I list three 1. UNION queries; 2. Insert into se

  2022-06-01 06:11:00 Views: 260
• 

  [Mysql] mysql Open course-mysql5.7 replication feature

  The basic knowledge of GTID BEGIN;INSERT INTO innodb_tbl (…) ; INSERT INTO myisam_tbl (...) ; COMMIT; uses temporary table BEGIN;INSERT INTO in transactions

  2022-06-01 06:10:59 Views: 279
• 

  Path Finder for mac (document Management tool) v9.3.5

  Path Finder mac is an easy-to-use file management tool on Mac and a user-friendly application that allows you to compare and synchronize folders, view hidden files, and browse the file system using dual-pane and full keyboard navigation to save you time.

  2022-06-01 06:10:56 Views: 252