NAV: SLTechnology News&Howtos > Database >

• 

  TABLE ACCESS BY INDEX ROWID BATCHED, one of the new features of Oracle 12c

  At the beginning of Oracle12c, we often see the "TABLE ACCESS BY INDEX ROWID BATCHED" operation when we get the execution plan of the SQL statement, so what exactly does this operation mean? What's the use? Below

  2022-06-01 07:05:25 Views: 258
• 

  MySQL installation-free configuration

  MySQL installation-free configuration 1. Open the file my-huge.ini and save it as my.ini, add the following configuration to the my.ini file, and then put it in [mysqld] basedir=E:/share/mysq under C:/windows.

  2022-06-01 07:05:25 Views: 282
• 

  About innodb_rollback_on_timeout testing

  When innodb_rollback_on_timeoutinnodb_lock_wait_timeout first saw innodb_rollback_on_timeout, he didn't understand transactio well.

  2022-06-01 07:05:24 Views: 256
• 

  Msyql root does not have permission to log in

  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) can be entered as bin/mysql-

  2022-06-01 07:05:24 Views: 292
• 

  Analysis of PostgreSQL DBA (20)-WAL full-page-write

  Full-page-write at T1, database successfully executes checkpoint; at T2, DML statement is executed, and relevant data is written to WAL (WAL buffer is ignored here); at T3, the transaction is committed; at T4 BGW

  2022-06-01 07:05:22 Views: 204
• 

  Dynamically increasing the risk of database restart brought by CPU-- Technology Life Series No. 46-- the story of me and the data center

  In the online production system, for some reasons, there will be some unexpected performance problems from time to time. If we cannot solve the emergency problems immediately, sometimes adjusting the system hardware resources is a fast and effective way to solve the emergency. After ensuring the normal operation of the system, do root cause analysis from the root.

  2022-06-01 07:05:18 Views: 229
• 

  [MySQL] deadlock case 8

  Deadlock is actually a very interesting and challenging technical problem, probably every DBA and some developer friends will encounter in the process of work. I will continue to write a series of case studies on deadlocks, hoping to be helpful to friends who want to know about deadlocks. Case study 2.1 Business

  2022-06-01 07:05:17 Views: 300
• 

  Double-click Hot standby for Building MySQL Database in linux Environment

  Prepare the server because the (binary log) binlog format may be different between different versions of Mysql, so the best combination is that the Mysql version of the master (Master) server and the slave (Slave) server are the same or lower, the master server version

  2022-06-01 07:05:12 Views: 246
• 

  Comparison and summary of advantages and disadvantages of AWS RDS MySQL and MariaDB Galera Cluster

  The MySQL service provided by AWS RDS MySQL Amazon deploys high availability zone, single master node and hidden slave node, automatically realizes HA switching, and can be expanded online to exceed the capacity of a single database deployment to handle high-read database load. 1. Advantages: (1)

  2022-06-01 07:05:11 Views: 295
• 

  [foam original] cmd: import and export Oracle remote Dmp files

  Orcal's dmp can be excruciating at times. Here you record the magic spell of easily importing and exporting dmp files. Import (Imp) imp SXZZ/SXZZ@10.16.175.50/xaptdb file=E:\ bjsxz

  2022-06-01 07:05:09 Views: 301
• 

  Introduction to Oracle Text

  Oracle Text provides indexing, word and topic search, and viewing functions for text in query applications and document classification applications. To design an Oracle Text application, first determine the type of query you expect to run. Once you know the type, you can choose the most for the task

  2022-06-01 07:05:05 Views: 299
• 

  Use sysbench to test MySQL

  Due to the update of the sysbench version, some command options have changed. Query help to change as appropriate. Https://yq.aliyun.com/articles/66651?spm=5176.100239.blogcon

  2022-06-01 07:05:02 Views: 228
• 

  Database backup, batch backup

  Database backup mysqldump-uroot-p123456-P3306-- single-transaction database_name > / data/dbname.sql.gz Note: production ring

  2022-06-01 07:04:56 Views: 288
• 

  MySQL5.7 Online DDL

  1. ALter table) in general, alter table will make a temporary copy of the original table, and then apply the table to the copy, and then delete the original table, rename copy. In this process, the original table is external

  2022-06-01 07:04:56 Views: 292
• 

  Numi3 for Mac (mini text Calculator)

  Numi for mac is a calculator tool for macOS systems. Numi supports currency, length, area, volume, time, temperature and data size. Concise language style plus refreshing grammar coloring, each calculus and bill can be permanently saved in text form, it

  2022-06-01 07:04:48 Views: 298
• 

  How to tune Oracle SQL series articles: introduction to query optimizer

  How to tune Oracle SQL part 4: an introduction to query optimizer concepts. 4 query optimizer concepts this chapter describes the most important concepts related to the query optimizer and its main components. 4.1 query optimizer introduces query optimizer (referred to as optimal for short)

  2022-06-01 07:04:45 Views: 248
• 

  Analysis on the Storage format of Oracle basic data types-- physical ROWID

  Original link: https://www.modb.pro/db/22554?cyn abstract: describes the physical ROWID type storage structure of the Oracle database Oracle's ROWID is used to uniquely identify a record in the table, which is the data in the

  2022-06-01 07:04:42 Views: 269
• 

  Oracle 12c rac vip and Monitoring Failur

  Environment: aix 7.1, oracle 12.1.0.2 rac-3 nodes. After the hardware failure, the hardware engineer replaced the intranet card. For some reason, there was a problem with the resource VIP, so he had to add VIPsrvctl add vip-node first.

  2022-06-01 07:04:42 Views: 227
• 

  PostgreSQL DBA (46)-PG Operator classes and families

  Pg_am has been briefly mentioned in the previous section. Taking hash as an example, we introduce that hash index cannot support related operations such as greater than or equal to or less than or equal to. We know that we need information to confirm which data types and operators are accepted by the access method. [pg12@localhost

  2022-06-01 07:04:42 Views: 250
• 

  How to eliminate the security risks of MySQL account

  (1)。 Give the MySQL account the minimum permissions it needs, and avoid granting alter,grant permissions to the MySQL account (2). Deleting anonymous accounts can easily lead to security risks. It is recommended to delete them. Execute the following SQL statement to delete all anonymous accounts in the permission table.

  2022-06-01 07:04:42 Views: 209