NAV: SLTechnology News&Howtos > Database >

• 

  About VO read record

  About VO read record getRowCount () Counts the total number of rows in this row set. Calculate the total number of rows in this rowset This method retrieve

  2022-06-01 06:22:06 Views: 273
• 

  Summary of MySQL master-slave replication data

  1. Copy principle official reference document: http://dev.mysql.com/doc/refman/5.6/en/replication.html blog address 1: http://blog.csdn.net/mchdb

  2022-06-01 06:22:06 Views: 283
• 

  Row lock of InnoDB transaction lock-locking in update phase of delete process

  1. The introduction of delete process is divided into two stages: search and update. Lock the clustered index record during the search phase, refer to the previous article. During the update phase, the clustered index record is tagged with delete, and then the search secondary index record

  2022-06-01 06:22:03 Views: 263
• 

  Learning Session overlapping problems (6)-- Ultimate Optimization

  Following the previous Session overlapping problem learning (2), this is the description of the problem and requirements, the execution time is 90 seconds http://blog.itpub.net/29254281/viewspace-2150229/Session overlapping problem learning

  2022-06-01 06:22:03 Views: 217
• 

  10046 event

  The 10046 event of Oracle can track the SQL statements executed by the application and get the number of parses. Information such as the number of execution, CPU usage time and so on. This is very useful for us to analyze and locate database performance problems. 10046 event is oracle

  2022-06-01 06:22:02 Views: 265
• 

  SQL Server High availability Best practices in the Cloud

  Compared with locally deployed databases, cloud databases can provide users with more flexibility and scalability, and the price is also lower. But cloud systems often have problems, so we must always pay attention to high availability and disaster recovery. Dav, a senior technology extension worker at SIOS Technology.

  2022-06-01 06:22:00 Views: 224
• 

  Start the error report after mysql is powered off

  The mysql database connected to a network management system cannot be started. The database version 5.5.36 views the error log information: check the MySQL startup log and find the "InnoDB: The log sequence number in ibdata"

  2022-06-01 06:22:00 Views: 283
• 

  MySQL Foundation: how to control when sql executes errors when setting up a bc website

  Normal execution of line sentences build bc website Q < 277.03.4.83.6 > for example, execute several normally executed statements, the example commands are as follows: select version (); select "Hello LiuMiao" as "Gre"

  2022-06-01 06:21:59 Views: 204
• 

  Mysql 5.6Master and Slave active / standby handoff

  -- master/slave switch records for later search environment: master:rhel 6.6mysql 5.6192.168.15.101salve:rhel 7.2mysql 5.6192.168.15.

  2022-06-01 06:21:59 Views: 296
• 

  Guide to fixing Oracle Weblogic Server Java deserialization vulnerabilities (CVE-2018-2628)

  WebLogic deserialization vulnerability (CVE-2018-2628) Security Alert TAGOracle WebLogic, CVE-2018-2628, deserialization concern level Red. This vulnerability is easy to exploit and can directly obtain system control permissions.

  2022-06-01 06:21:54 Views: 252
• 

  Brief introduction of MySQL deferred replication

  The company has a production library of mysqlAB replication architecture, one master and one slave structure, which is automatically done every Monday morning. Everything is fine, but today (assuming Saturday) accidentally deleted a table, from the library will also be deleted by mistake. Suppose there are several years of business data in this table, how about

  2022-06-01 06:21:49 Views: 205
• 

  Check to the directory with the file

  Disk format, hang disk [root@k10148008056 ~] # fdisk-l [root@k10148008071 ~] # df-ThFilesystem Type Size Used Avail

  2022-06-01 06:21:48 Views: 294
• 

  Using python to analyze the performance trend of Oracle Database

  1. With the rapid growth of the business demand of the information system, the relationship between the business system is becoming more and more complex, and the performance problems of the information system are becoming more and more prominent. once the information system performance problems and unavailability problems occur, it will seriously affect the stable operation of the information system and user experience. Combined with the practice of operation and maintenance, database performance problems are caused.

  2022-06-01 06:21:48 Views: 296
• 

  Detailed explanation of RAC process

  The RAC background process LMON:LOCK Monitor Processes, also known as Global enqueue service monitor, monitors the status of the entire cluster and maintains the memory structure of GCS to monitor processes that are terminated abnormally.

  2022-06-01 06:21:46 Views: 281
• 

  [security] Oracle Security Management and Audit (2)

  "Oracle Security Management and Audit (2)" New year recruitment: China Oracle Elite Alliance 170513055 Group introduction: this group is a technology-sharing community, where you can enjoy master-level technical lectures and the opportunity to participate in Oracle.

  2022-06-01 06:21:42 Views: 208
• 

  Summary and Summary of MySQL Master-Slave delay solution

  MySQL master-slave delay is divided into the following four categories: mixed mode no index or SQL slow pager grep-v Sleep;show processlist view to the executing SQL solution on the slave library: 1.SQL is relatively simple

  2022-06-01 06:21:42 Views: 234
• 

  Operation, concept and Parameter interpretation of parallel parallelism

  Which scenarios can use parallelism table scan, fast full index scans, partition index range scans (local index only) create table as, cr

  2022-06-01 06:21:42 Views: 287
• 

  The use of RMAN (1)

  1. RMAN Overview RMAN realizes the backup of data files, control files, archived log files and database server parameter files with the help of database server. RMAN also allows the use of script files for database backup and recovery, and scripts are saved in the database without writing

  2022-06-01 06:21:39 Views: 239
• 

  The solution of ORA-01031 error when logging into Oracle under Windows platform

  Today, there is an ORA-01031 error (essentially insufficient permissions) when logging in to oracle. By querying the login authentication method of Oracle and using sysdba identity to connect to the database instance, the authentication method used is operating system authentication, and this authentication operation process is the operating system.

  2022-06-01 06:21:38 Views: 206
• 

  Analysis process of abnormal downtime caused by MySQL Bug

  This article mainly uses a bug to record how to analyze the crash information of a MySQL bug. Version: Percona 5.7.17-11 I, database restart log analysis terminate called after throwing

  2022-06-01 06:21:38 Views: 301