NAV: SLTechnology News&Howtos > Database >

• 

  Pt-table-checksum of percona-toolkit

  The first part-brief introduction pt-table-checksum executes the check of the data block in the master database through SQL, then transmits the same statement to the slave database, and calculates the check of the data block on the slave database, finally compares the check value of the same block in the master-slave database to distinguish whether the master-slave data is inconsistent. Pt

  2022-06-01 10:59:27 Views: 257
• 

  Mongodb master-slave copy installation document

  Environment description IPRole10.240.216.151master10.240.216.152slave (standby master) 10.240.216.153slavemongodb is downloaded and installed in 10.

  2022-06-01 10:59:26 Views: 204
• 

  Rhel7.2 install oracle 12C

  OS:RHEL7.2ORACLE 12Cstep1: install the required rpm package yum install binutils libX11 compat-libcap1 libXau compat-libstdc+

  2022-06-01 10:58:56 Views: 226
• 

  MySQL to see which indexes are not in use

  SELECTOBJECT_SCHEMA,OBJECT_NAME,INDEX_NAMEFROM performance_schema.table_io_waits_summary_by_index_us

  2022-06-01 10:58:53 Views: 222
• 

  Automatic initialization of SQL Server 2017 AlwaysOn AG (2)

  Prerequisite file path requirements in SQL Server 2016, automatic seeding requires that the data and log file paths are the same on each SQL Server instance that participates in the availability group. In SQL Server 2017, you can

  2022-06-01 10:58:53 Views: 249
• 

  How to create a new connection database in navicat

  A few days ago to share with you how to install Navicat, there is no time to get on the bus friends can poke this article: hand-in-hand to teach you to install Navicat-- reliable Navicat installation tutorial. Today, I'd like to share with you some simple tutorials and specific tutorials for using Navicat.

  2022-06-01 10:58:47 Views: 225
• 

  How to use case when expressions and decode functions correctly?

  I believe that many partners in the development process are useful to case when expressions and decode functions, then there will be a small partner like me at first have a lot of doubts, when to use case when, when to use decode? What's the difference between the two?

  2022-06-01 10:58:44 Views: 207
• 

  High-availability PXC for MYSQL

  Introduction Percona XtraDB Cluster is a high availability and extensibility solution for MySQL users, based on Percona Server. It includes Write Set REPlication patches, using Gale

  2022-06-01 10:58:14 Views: 264
• 

  Oracle Rman fixes logical bad blocks

  RMAN data block recovery trial Rman can achieve block-level data recovery, in the traditional recovery methods, that is, a data block of a data file is damaged, resulting in the whole data file can not be tried, at this time, the whole data file must be restored through backup. Obviously, such an approach will take longer.

  2022-06-01 10:58:14 Views: 257
• 

  ANSI_NULLS and QUOTED_IDENTIFIER in SqlServer

  SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO will have the above code when creating stored procedures in SQL Server. What exactly does it mean? ANSI_NULLS, such as the following table, when the column

  2022-06-01 10:58:13 Views: 295
• 

  Conversion between oracle 11G DG physical backup and snapshot backup

  Convert physical slave to snapshot slave: close the secondary RAC instance of the physical slave (if it is a RAC environment). Keep the slave in mount state and convert to snapshot slave: alter database convert to snapshot standby

  2022-06-01 10:58:13 Views: 299
• 

  Mysql5.7 ibtmp1 file is too large

  Received an alarm that the disk space of a MySQL5.7 server is insufficient. When the amount of data of the service is 20g, what causes the insufficient disk space? After investigation, it is found that there is an ibtmp1 file under the data directory that is very large, with 949G. # du-sh

  2022-06-01 10:58:12 Views: 303
• 

  Expdp Times ORA-31693 ORA-31617 ORA-195 error

  Today, I made a mistake in the data Times. I found an error indicating similar permissions, but after modifying the permissions, I still reported an error all the time. Some netizens also encountered the same error, but it may be that there is only one node in my rac environment, which may have something to do with the cluster cluster.

  2022-06-01 10:58:12 Views: 264
• 

  Exchange powershell notes

  Query all banned domain accounts and transfer them to an OUget-aduser-Filter *-SearchBase "DC=contoso,DC=com" in batch | foreach {if ($_ .domain)

  2022-06-01 10:58:12 Views: 303
• 

  Oracle materialized view

  An overview of materialized views the materialized view of Oracle is a database object that includes a query result, which is a local copy of remote data, or is used to generate summary tables based on the summation of data tables. Materialized views store data based on remote tables, which can also be called snapshots. Materialized views can be used in advance.

  2022-06-01 10:58:08 Views: 218
• 

  Advanced MySQL Database (9)-- Vernier

  MySQL database advanced (9)-cursor 1, cursor introduction 1, cursor introduction cursor design is a data buffer idea, used to store the results of the execution of SQL statements. A cursor is a mechanism that can extract one record at a time from a result set that includes multiple data records. Although the cursor can traverse

  2022-06-01 10:58:08 Views: 281
• 

  MySQL database backup Shell script

  This script backs up the data from the database on the remote host or the local host locally. Back up the production libraries of the MySQL database except information_schema, performance_schema, and mysql. MyS when backing up

  2022-06-01 10:58:08 Views: 237
• 

  A statement displays the value as a percentage, including%

  Select cast (cast (0.1234) 100 as numeric (10)) as varchar (50)) +'%'

  2022-06-01 10:58:07 Views: 275
• 

  Mariadb master-slave synchronization

  This article is the download address of the built mariadb-10.0.17 version: https://downloads.mariadb.org/interstitial/mariadb-10.0.17/source/maria

  2022-06-01 10:57:57 Views: 288
• 

  The database connects two tables horizontally (displayed in the form of a table).

  Join two tables with no associated fields horizontally. In work, for the display of some reports, you need to show the data in two tables without related fields, and join horizontally, for example, the data of the following two tables: SELECT * FROM STUDENT select

  2022-06-01 10:57:57 Views: 245