Oracle 11gR2是目前新系统应用比较广泛的Oracle版本，根据官方路线图，11.2.0.4是11g末期的一个版本。应该说，11gR2之后，Oracle
Oracle 11gR2是目前新系统应用比较广泛的Oracle版本，根据官方路线图，11.2.0.4是11g末期的一个版本。应该说，11gR2之后，Oracle直接提供了完整升级版本，可以直接安装高版本的数据库系统，不需要从基础版本逐步升级。
本篇主要记录以11.2.0.4为基础，单实例条件下Oracle补丁安装过程。
1、补丁包和环境介绍
首先确定数据库版本，笔者以一台全新安装Oracle 11gR2单实例进行安装，具体版本为11.2.0.4。
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 – Production
进行操作的补丁文件如下：
[root@XXX-PROD-DB upload]# cd patch/
[root@XXX-PROD-DB patch]# ls -l
total 282772
-rw-r--r--. 1 root root 407030 Jul 15 09:03 p19852360_112040_Generic.zip
-rw-r--r--. 1 root root 71580583 Jul 15 09:03 p20299013_112040_Linux-x86-64.zip
-rw-r--r--. 1 root root 12335412 Jul 15 09:03 p20299015_112040_Linux-x86-64.zip
-rw-r--r--. 1 root root 40486165 Jul 15 09:03 p20406239_112040_Linux-x86-64.zip
-rw-r--r--. 1 root root 112087303 Jul 15 09:02 p20834611_112040_Linux-x86-64.zip
-rw-r--r--. 1 root root 52648436 Jul 15 09:02 p6880880_112000_Linux-x86-64.zip
注意：其中p6880880_112000_Linux-x86-64.zip是新版本OPatch，一般而言打补丁都需要更新最新的OPatch。
2、升级OPatch组件
首先需要以覆盖方式升级OPatch组件。
[oracle@XXX-PROD-DB ~]$ cd $ORACLE_HOME
[oracle@XXX-PROD-DB dbhome_1]$ ls -l | grep OPatch
drwxr-xr-x. 8 oracle oinstall 4096 Jul 16 10:08 OPatch
备份OPatch目录，并用解压zip文件替换。
[oracle@XXX-PROD-DB dbhome_1]$ cp /upload/patch/p6880880_112000_Linux-x86-64.zip $ORACLE_HOME
[oracle@XXX-PROD-DB dbhome_1]$ ls -l | grep p6880880_112000_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 52648436 Aug 4 08:42 p6880880_112000_Linux-x86-64.zip
[oracle@XXX-PROD-DB dbhome_1]$ mv OPatch OPatch_BK
[oracle@XXX-PROD-DB dbhome_1]$ ls -l | grep OPatch
drwxr-xr-x. 8 oracle oinstall 4096 Jul 16 10:08 OPatch_BK
解压OPatch文件。
[root@XXX-PROD-DB ~]# cd /u01/app/oracle/product/11.2.0/dbhome_1
[root@XXX-PROD-DB dbhome_1]# ls -l | grep p6880880_112000_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 52648436 Aug 4 08:42 p6880880_112000_Linux-x86-64.zip
[root@XXX-PROD-DB dbhome_1]# unzip p6880880_112000_Linux-x86-64.zip
[root@XXX-PROD-DB dbhome_1]# ls -l | grep OPatch
drwxr-x---. 10 root root 4096 Mar 31 17:10 OPatch
drwxr-xr-x. 8 oracle oinstall 4096 Jul 16 10:08 OPatch_BK
[root@XXX-PROD-DB dbhome_1]# chown -R oracle:oinstall OPatch
[root@XXX-PROD-DB dbhome_1]# ls -l | grep OPatch
drwxr-x---. 10 oracle oinstall 4096 Mar 31 17:10 OPatch
drwxr-xr-x. 8 oracle oinstall 4096 Jul 16 10:08 OPatch_BK
OPatch是一个命令脚本工具，为方便起见，可以将其加入到PATH环境变量中。
[oracle@XXX-PROD-DB dbhome_1]$ cd ~
[oracle@XXX-PROD-DB ~]$ vi .bash_profile
（篇幅原因，有省略……）
ORACLE_SID=XXXCDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
PATH=$PATH:$ORACLE_HOME/bin:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch
export ORACLE_SID
export ORACLE_BASE
export ORACLE_HOME
export PATH
".bash_profile" 23L, 409C written
查看OPatch版本。
[oracle@XXX-PROD-DB ~]$ opatch version
OPatch Version: 11.2.0.3.10
OPatch succeeded.
2、补丁19852360_112040
补丁19852360_112040是一个简单的补丁，主要是针对JDBC相关的补丁类型。原则上，不需要进行关库操作。
[root@XXX-PROD-DB patch]# unzip p19852360_112040_Generic.zip
Archive: p19852360_112040_Generic.zip
creating: 19852360/
inflating: 19852360/README.txt
creating: 19852360/files/
creating: 19852360/files/jdbc/
（篇幅原因，有省略……）
inflating: 19852360/etc/xml/GenericActions.xml
inflating: 19852360/etc/xml/ShiphomeDirectoryStructure.xml
进入解压目录，注意：要确保补丁文件的文件权限设置。
[oracle@XXX-PROD-DB ~]$ cd /upload/patch/
[oracle@XXX-PROD-DB patch]$ ls -l
total 282776
drwxr-xr-x. 4 oracle oinstall 4096 Oct 20 2014 19852360
-rw-r--r--. 1 root root 407030 Jul 15 09:03 p19852360_112040_Generic.zip
[oracle@XXX-PROD-DB patch]$ cd 19852360/
[oracle@XXX-PROD-DB 19852360]$ ls -l
total 20
drwxr-xr-x. 4 oracle oinstall 4096 Oct 20 2014 etc
drwxr-xr-x. 3 oracle oinstall 4096 Oct 20 2014 files
-rw-rw-r--. 1 oracle oinstall 10858 Oct 28 2014 README.txt
[oracle@XXX-PROD-DB 19852360]$
注意：无论DBA经验多丰富，在进行补丁的时候，一定要参考每个补丁的readme.txt文件，遵循官方步骤进行操作。用成熟技术、用官方步骤是我们确保成功的重要原则。
首先，进行补丁先决条件检查。
[oracle@XXX-PROD-DB 19852360]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-22-39AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
没有发现问题，，可以直接进行补丁。
[oracle@XXX-PROD-DB 19852360]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/19852360_Aug_04_2015_10_21_09/apply2015-08-04_10-21-09AM_1.log
Applying interim patch '19852360' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
Backing up files...
Patching component oracle.dbjava.jdbc, 11.2.0.4.0...
Patching component oracle.dbjava.ic, 11.2.0.4.0...
Verifying the update...
Patch 19852360 successfully applied
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/19852360_Aug_04_2015_10_21_09/apply2015-08-04_10-21-09AM_1.log
OPatch succeeded.
3、补丁20299013_112040
解压补丁文件：
[root@XXX-PROD-DB patch]# unzip p20299013_112040_Linux-x86-64.zip
inflating: 20299013/18522509/files/lib/libserver11.a/qerel.o
inflating: 20299013/18522509/files/lib/libserver11.a/knahs.o
（篇幅原因，有省略……）
inflating: 20299013/18522509/etc/config/actions.xml
inflating: 20299013/18522509/etc/config/inventory.xml
inflating: PatchSearch.xml
设置owner权限。
[root@XXX-PROD-DB patch]# chown -R oracle:oinstall 20299013/
[root@XXX-PROD-DB patch]# ls -l
total 282840
drwxr-xr-x. 4 oracle oinstall 4096 Oct 20 2014 19852360
drwxrwxr-x. 8 oracle oinstall 4096 Mar 4 18:30 20299013
补丁20299013_112040是一个补丁集合，多个经过验证的安全补丁集合防止，是可以统一进行补丁操作的。
[oracle@XXX-PROD-DB 20299013]$ ls -l
total 88
drwxr-xr-x. 4 oracle oinstall 4096 Mar 4 18:30 17478514
drwxr-xr-x. 4 oracle oinstall 4096 Mar 4 18:30 18031668
drwxr-xr-x. 4 oracle oinstall 4096 Mar 4 18:30 18522509
drwxr-xr-x. 4 oracle oinstall 4096 Mar 4 18:30 19121551
drwxrwxr-x. 4 oracle oinstall 4096 Mar 4 18:30 19769489
drwxrwxr-x. 4 oracle oinstall 4096 Mar 4 18:30 20299013
-rw-r--r--. 1 oracle oinstall 3068 Mar 4 18:30 patchmd.xml
-rw-rw-r--. 1 oracle oinstall 54747 Apr 12 10:40 README.html
-rw-r--r--. 1 oracle oinstall 21 Mar 4 18:30 README.txt
进行先决性检查。
[oracle@XXX-PROD-DB 20299013]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-28-53AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
验证通过，说明当前系统安装补丁和将要安装补丁之间没有冲突。但是，执行apply的时候就有问题。
[oracle@XXX-PROD-DB 20299013]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-29-25AM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-29-25AM_1.log
OPatch failed with error code 73
报错信息中包括了日志内容，一旦出现Oracle错误，各种日志是进行诊断的最好方法。
[root@XXX-PROD-DB patch]# cd /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/
[root@XXX-PROD-DB opatch]# ls -l
total 36
drwxr-xr-x. 2 oracle oinstall 4096 Aug 4 10:21 19852360_Aug_04_2015_10_21_09
drwxr-xr-x. 2 oracle oinstall 4096 Aug 4 10:06 lsinv
-rw-r--r--. 1 oracle oinstall 2050 Aug 4 10:06 opatch2015-08-04_10-06-22AM_1.log
-rw-r--r--. 1 oracle oinstall 1665 Aug 4 10:22 opatch2015-08-04_10-22-39AM_1.log
-rw-r--r--. 1 oracle oinstall 2021 Aug 4 10:28 opatch2015-08-04_10-28-53AM_1.log
-rw-r--r--. 1 oracle oinstall 10540 Aug 4 10:29 opatch2015-08-04_10-29-25AM_1.log
-rw-r--r--. 1 oracle oinstall 1872 Aug 4 10:29 opatch_history.txt
[root@INTCTL-PROD-DB opatch]# ls -l | grep 2015-08-04_10-29-25
-rw-r--r--. 1 oracle oinstall 10540 Aug 4 10:29 opatch2015-08-04_10-29-25AM_1.log
--日志片段：
[Aug 4, 2015 10:29:31 AM] Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/proc at Tue Aug 04 10:29:31 CST 2015
[Aug 4, 2015 10:29:31 AM] Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/lib/liborasdkbase.so.11.1 at Tue Aug 04 10:29:31 CST 2015
[Aug 4, 2015 10:29:31 AM] Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/lib/liborasdkbase.so.11.1 at Tue Aug 04 10:29:31 CST 2015
[Aug 4, 2015 10:29:31 AM] Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/wrap at Tue Aug 04 10:29:31 CST 2015
[Aug 4, 2015 10:29:31 AM] Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/wrap at Tue Aug 04 10:29:31 CST 2015
[Aug 4, 2015 10:29:31 AM] Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/e2eme at Tue Aug 04 10:29:31 CST 2015
[Aug 4, 2015 10:29:31 AM] Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/e2eme at Tue Aug 04 10:29:31 CST 2015
[Aug 4, 2015 10:29:31 AM] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Aug 4, 2015 10:29:31 AM] Finishing UtilSession at Tue Aug 04 10:29:31 CST 2015
[Aug 4, 2015 10:29:31 AM] Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-29-25AM_1.log
[Aug 4, 2015 10:29:31 AM] Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Aug 4, 2015 10:29:31 AM] StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:5717)
[Aug 4, 2015 10:29:31 AM] StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:697)
[Aug 4, 2015 10:29:31 AM] StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1082)
[Aug 4, 2015 10:29:31 AM] StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Aug 4, 2015 10:29:31 AM] StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[Aug 4, 2015 10:29:31 AM] StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[Aug 4, 2015 10:29:31 AM] StackTrace: java.lang.reflect.Method.invoke(Method.java:592)
[Aug 4, 2015 10:29:31 AM] StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:317)
[Aug 4, 2015 10:29:31 AM] StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2575)
[Aug 4, 2015 10:29:31 AM] StackTrace: oracle.opatch.OPatch.main(OPatch.java:626)
经过分析，认为是Oracle数据库和监听器启动状态。安装补丁的时候，最好还是能够停机进行。
[oracle@XXX-PROD-DB 20299013]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-AUG-2015 10:37:25
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully
[oracle@INTCTL-PROD-DB 20299013]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 4 10:37:32 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
进行OPatch Apply操作。
[oracle@XXX-PROD-DB 20299013]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-38-47AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013
（篇幅原因，有省略……）
Composite patch 20299013 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-38-47AM_1.log
OPatch succeeded.
补丁成功。
注意：此时完成的是数据库软件、数据库实例的升级。但是数据库对象却没有升级。之后重启数据库，要进行脚本升级执行。
[oracle@XXX-PROD-DB 20299013]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 4 10:41:37 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 5227814912 bytes
Fixed Size 2262368 bytes
Variable Size 1140853408 bytes
Database Buffers 4076863488 bytes
Redo Buffers 7835648 bytes
Database mounted.
Database opened.
执行脚本。
SQL> @?/rdbms/admin/catbundle.sql psu apply
SQL> COMMIT;
Commit complete.
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_INTCDB_APPLY_2015Aug04_10_42_39.log
查看补丁内容信息：
[oracle@XXX-PROD-DB 20299013]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-45-21AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-08-04_10-45-21AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
How does MySQL index cardinality affect query performance?Apr 14, 2025 am 12:18 AMMySQL index cardinality has a significant impact on query performance: 1. High cardinality index can more effectively narrow the data range and improve query efficiency; 2. Low cardinality index may lead to full table scanning and reduce query performance; 3. In joint index, high cardinality sequences should be placed in front to optimize query.
MySQL: Resources and Tutorials for New UsersApr 14, 2025 am 12:16 AMThe MySQL learning path includes basic knowledge, core concepts, usage examples, and optimization techniques. 1) Understand basic concepts such as tables, rows, columns, and SQL queries. 2) Learn the definition, working principles and advantages of MySQL. 3) Master basic CRUD operations and advanced usage, such as indexes and stored procedures. 4) Familiar with common error debugging and performance optimization suggestions, such as rational use of indexes and optimization queries. Through these steps, you will have a full grasp of the use and optimization of MySQL.
Real-World MySQL: Examples and Use CasesApr 14, 2025 am 12:15 AMMySQL's real-world applications include basic database design and complex query optimization. 1) Basic usage: used to store and manage user data, such as inserting, querying, updating and deleting user information. 2) Advanced usage: Handle complex business logic, such as order and inventory management of e-commerce platforms. 3) Performance optimization: Improve performance by rationally using indexes, partition tables and query caches.
SQL Commands in MySQL: Practical ExamplesApr 14, 2025 am 12:09 AMSQL commands in MySQL can be divided into categories such as DDL, DML, DQL, DCL, etc., and are used to create, modify, delete databases and tables, insert, update, delete data, and perform complex query operations. 1. Basic usage includes CREATETABLE creation table, INSERTINTO insert data, and SELECT query data. 2. Advanced usage involves JOIN for table joins, subqueries and GROUPBY for data aggregation. 3. Common errors such as syntax errors, data type mismatch and permission problems can be debugged through syntax checking, data type conversion and permission management. 4. Performance optimization suggestions include using indexes, avoiding full table scanning, optimizing JOIN operations and using transactions to ensure data consistency.
How does InnoDB handle ACID compliance?Apr 14, 2025 am 12:03 AMInnoDB achieves atomicity through undolog, consistency and isolation through locking mechanism and MVCC, and persistence through redolog. 1) Atomicity: Use undolog to record the original data to ensure that the transaction can be rolled back. 2) Consistency: Ensure the data consistency through row-level locking and MVCC. 3) Isolation: Supports multiple isolation levels, and REPEATABLEREAD is used by default. 4) Persistence: Use redolog to record modifications to ensure that data is saved for a long time.
MySQL's Place: Databases and ProgrammingApr 13, 2025 am 12:18 AMMySQL's position in databases and programming is very important. It is an open source relational database management system that is widely used in various application scenarios. 1) MySQL provides efficient data storage, organization and retrieval functions, supporting Web, mobile and enterprise-level systems. 2) It uses a client-server architecture, supports multiple storage engines and index optimization. 3) Basic usages include creating tables and inserting data, and advanced usages involve multi-table JOINs and complex queries. 4) Frequently asked questions such as SQL syntax errors and performance issues can be debugged through the EXPLAIN command and slow query log. 5) Performance optimization methods include rational use of indexes, optimized query and use of caches. Best practices include using transactions and PreparedStatemen
MySQL: From Small Businesses to Large EnterprisesApr 13, 2025 am 12:17 AMMySQL is suitable for small and large enterprises. 1) Small businesses can use MySQL for basic data management, such as storing customer information. 2) Large enterprises can use MySQL to process massive data and complex business logic to optimize query performance and transaction processing.
What are phantom reads and how does InnoDB prevent them (Next-Key Locking)?Apr 13, 2025 am 12:16 AMInnoDB effectively prevents phantom reading through Next-KeyLocking mechanism. 1) Next-KeyLocking combines row lock and gap lock to lock records and their gaps to prevent new records from being inserted. 2) In practical applications, by optimizing query and adjusting isolation levels, lock competition can be reduced and concurrency performance can be improved.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
WebStorm Mac version
Useful JavaScript development tools
VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
