NAV: SLTechnology News&Howtos > Database >

• 

  MySQL MHA switchover online handover process

  1. During the switching process, note that you need to close the masterha_ manager [root @ es3 ~] # masterha_master_switch-- master_state=alive-- conf=/root

  2022-06-01 06:54:59 Views: 299
• 

  MySQL InnoDB row lock optimization recommendation

  Because InnoDB storage engine implements row-level locking, although the performance loss caused by the implementation of locking mechanism may be higher than that of table-level locking, it is much better than MyISAM's table-level locking in terms of overall concurrency processing capacity. When the system concurrency is high, Inn

  2022-06-01 06:54:59 Views: 292
• 

  Percona5.7.11 Startup error report (server-id)

  Today's first attempt to use and learn the new features of percona5.7.11 can not start the database log-error error 2016-04-22T03:17:44.297472Z 0 [ERROR] Y after setting up bin_log

  2022-06-01 06:54:59 Views: 289
• 

  Introduction and installation of MySQL distributed Cluster MyCAT (1)

  The predecessor of MyCAT background MyCAT is Alibaba on June 19, 2012. the formal open source database middleware Cobar,Cobar is already open source Amoeba, but after its author Chen Silu left to go to Shanda, Alibaba internally considered A.

  2022-06-01 06:54:56 Views: 239
• 

  Interpretation of PostgreSQL Source Code-MVCC#16 (vacuum procedure-lazy_vacuum_index function # 1)

  This section briefly introduces the processing flow of manual vacuum execution by PostgreSQL, and mainly analyzes ExecVacuum- > vacuum- > vacuum_rel- > heap_vacuum_rel- > lazy_scan_hea.

  2022-06-01 06:54:55 Views: 298
• 

  MySQL implements password-less login (mysql_config_editor)

  There is a business requirement to dump MySQL the database data from a host, but you do not want the business staff to know the password of a specific MySQL user. You can use the mysql_config_editor command to implement one. The test environment A machine IP is 192.16.

  2022-06-01 06:54:55 Views: 267
• 

  A summary of Oracle Timezone

  Original: http://blog.itpub.net/9765498/viewspace-539881 background description: if you need to support an internationalized application, then the database-side internationalization feature support is particularly important. Oracl

  2022-06-01 06:54:49 Views: 226
• 

  Error caused by inconsistent configuration of ORA-07445 [kslgetl () + 80] ORA-00108 hostname

  Environment: Oracle 10.2.0.4, Red Hat Linux4.5 32bit3.8 International Working Women's Day that day, a DB server died due to hardware failure. Fix the restored DB to the new server through backup, and the restored DB is useless.

  2022-06-01 06:54:49 Views: 269
• 

  ORACLE exp/imp Import error IMP-00009&IMP-00028&IMP-00015

  On August 14, 2017, an implementation colleague encountered an error IMP-00009&IMP when importing the dmp file exported by exp using imp. The specific error is shown in the figure. The reason for the error may be that the dmp file itself is incomplete. If you still want to import data, you can check the dmp file.

  2022-06-01 06:54:49 Views: 246
• 

  Oracle database defragmenting tables

  The source of table fragmentation when there are many deletions against a table, the table will produce a large number of fragments. The space freed by the delete operation is not immediately reused by the insert operation, or even will never be reused. How to determine if there are table fragments-- collecting table statistics SQL > exec dbms_sta

  2022-06-01 06:54:48 Views: 239
• 

  Solution to the problem of master-slave non-synchronization in mysql

  Environment introduction: I here one or two, the master copy of the mysql: 192.10.0.243 192.10.0.244 through the keepalived mapping vip:192.10.0.118, the current vip on 243s. Due to

  2022-06-01 06:54:48 Views: 250
• 

  MySQL SQL Optimization-override Index (covering index)

  CREATE TABLE `user_ group` (`id` int (11) NOT NULL auto_increment, `uid` int (11) NOT NULL, `group_ id` in

  2022-06-01 06:54:48 Views: 232
• 

  Oracle scheduling Schedule feature (part I)-job

  At the host level, I want to perform some scheduled tasks, usually using crontab. Convenient and practical, so is there a concept of scheduled tasks in oracle? The introduction of Oracle Scheduler is used to manage and plan the Job of the database through it

  2022-06-01 06:54:48 Views: 240
• 

  [PG Management] related to postgresql database management

  -- single user initiates postgres-- single-D / pgdata/10/data postgres-- single-user role when multi-user mode does not receive all commands, you can use the phase repair system in which a single user connects to the database initdb

  2022-06-01 06:54:47 Views: 222
• 

  Sqlserver's summary of filestream file stream and filetable file table

  Personal understanding: the external tables of FileStream, Filetable, and Oracle are a bit like, but not exactly like, the similarity is that the actual data in the table is stored in the file system, and the table only records metadata. The data from the Oracle external table is stored in the file system, using d

  2022-06-01 06:54:47 Views: 257
• 

  Principle and Management of MongoDB replica set

  A MongoDB replica set (Replica Set) is a cluster of MongoDB instances, consisting of a primary node (primary) and multiple standby nodes (Secondary). Through Repication, the data is updated by prim

  2022-06-01 06:54:47 Views: 269
• 

  Sqoop Import Relational Database-decrypt Sqoop

  As a bridge between Hadoop and traditional database, Sqoop plays an important role in data import and export. Through the exposition of the basic grammar and functions of Sqoop, we deeply decrypt the function and value of Sqoop. What is Apache Sqoop?Cloud

  2022-06-01 06:54:43 Views: 289
• 

  Oracle standard database audit

  Oracle standard database audit can audit and track various permission operations of ordinary users (excluding SYS). 1. The basic method of standard database audit 1. Opening the standard database audit initialization parameter audit_trail is a static parameter, which determines how to start it.

  2022-06-01 06:54:42 Views: 282
• 

  Cinematic Film LUTs (15 post-movie luts color presets)

  Editor to bring you Cinematic Film LUTs, a post-movie LUTS preset package, you can easily achieve movie-level color adjustment, including luts preset what to import tutorials, beginners can also easily use, is your work better ~ macz to understand the use of preset introduction

  2022-06-01 06:54:16 Views: 233
• 

  Oracle dg archive synchronization failed

  Problem: after the DG is built, the archive of the master database cannot be automatically synchronized to the standby database. Troubleshooting: main database alarm log error: PING [ARC2]: Heartbeat failed to connect to standby 'cjcdb

  2022-06-01 06:54:13 Views: 289