NAV: SLTechnology News&Howtos > Database >

• 

  Handling methods of Common synchronous replication faults in MySQL

  1. Delete a record in the Master node, and the Slave node cannot find the record and report an error. Take the method: stop slave;set global sql_slave_skip_counter=1;start slave;2

  2022-06-01 07:20:50 Views: 244
• 

  Using binlog to restore Database

  When learning mysql backup, I deeply feel that the backup and restore function of mysql is not as powerful as oracle; for example, a very common recovery scenario: based on point-in-time recovery, oracle can quickly restore the database through the rman tool, but m

  2022-06-01 07:20:50 Views: 244
• 

  Repair of REDO Log loss in ORACLE non-Archive Mode

  Step 1: complete datafile,controlfile,spfile/pfile step 2: restore the log. The original cold journal is useless, please don't use it! ) SQL > select member from v$logfile

  2022-06-01 07:20:47 Views: 262
• 

  Using xstart to remotely connect linux graphical user interface

  Double-click xstart to enter: / usr/bin/xterm-ls-display $DISPLAY if you report an error: install xterm:yum install-y xterm on the remote machine and return, click 'run', and you will

  2022-06-01 07:20:47 Views: 265
• 

  MySQL big table deletes the correct posture

  1. Background in the production environment, there may be a need to delete an unimportant large table, because the large table takes up a lot of disk space. If we drop this table directly, it usually takes more than 20 seconds. We will always feel that the master MySQL will be stuck. Now we will give everyone a correct deletion posture. 2. First of all, I

  2022-06-01 07:20:47 Views: 211
• 

  Some commonly used queries in postgresql10

  Query the validity of the index select d.tablenamejia.relname, (case c.indisvalid when true then 'valid' else 'invalid' end) isvalid

  2022-06-01 07:20:47 Views: 267
• 

  [architecture] personal understanding of Oracle segment blocks

  1. Segment chunks are the logical concept of Oracle databases. Block belongs to zone, zone belongs to segment 2. When Oracle creates a table, it allocates a segment to hold the table. It can be understood that a table is a segment. 3. Point 2 is not accurate enough. Actually, Ora

  2022-06-01 07:20:46 Views: 243
• 

  Key points of performance Analysis of mysql Database Server

  1. View slow queries if slow queries are confirmed, then slow queries should be measured instead of measuring the overall server performance to capture MySQL queries to slow log files. You can capture all queries by setting long_query_time to 0. Query response time is measured in microseconds.

  2022-06-01 07:20:38 Views: 219
• 

  Datastage gets the csv file and inserts it into the database

  Creator of datastage operating procedure document: Moonnight Maple date: 20180112 version: V1.01, processing Files the source file of this project comes from 10.126.124.39 server, 39 server does not enable ftp function, but directory sharing function is enabled.

  2022-06-01 07:20:38 Views: 203
• 

  MySQL Percona XtraBackup

  Red Hat Enterprise Linux Server release 6.6 (Santiago) [root@mysqlgc opt] # tar-xvf Percona-XtraBacku

  2022-06-01 07:20:37 Views: 290
• 

  Bang! This is the first shot in the domestic financial database.

  From internal self-research to opening up to the industry, TDSQL has developed for more than a decade, supporting the trust and trust of more than 500 + financial, government and enterprise institutions. To maintain continuous realistic and innovative, to meet customer needs, is our eternal persistence. In 2019, TDSQL technology continues to make breakthroughs and gains at the same time.

  2022-06-01 07:20:29 Views: 221
• 

  ToothFairy for Mac (one-click Bluetooth device connection switching software)

  Do you need an one-button Bluetooth device connection switching software? ToothFairy for Mac is a lightweight mac Bluetooth connection tool, which can connect AirPods or other Bluetooth headsets to Mac very quickly, and the connection switching can be completed with one click.

  2022-06-01 07:20:21 Views: 280
• 

  Database Patchsets patch

  Database patches can be found in the following two documents: database / GI PSU,SPU (CPU), Bundle Patches and Patchsets Patch number Quick reference (document ID 1922396.1) Assistant: Do

  2022-06-01 07:20:20 Views: 248
• 

  Sysctl command

  The sysctl command is used to dynamically modify kernel run parameters while the kernel is running, and the available kernel parameters are in the directory / proc/sys. It includes some advanced options for TCP/ip stacks and virtual memory systems, which allow experienced administrators to improve eye-catching system performance.

  2022-06-01 07:20:20 Views: 202
• 

  Dmp exported from gbk and imported into oracle of utf8

  The first step is to import the table structure: imp userid=xxx/password file yyy.dmp full=y rows=n log=yyy.log the above statement will not import data, only the structure, but there may be several errors

  2022-06-01 07:20:20 Views: 263
• 

  [MySQL] understanding of Pages flushed up to of SHOW ENGINE INNODB STATUS\ G

  1) Preface and question: let's first look at the screenshot Log sequence number-- the sequence number Log flushed up to generated by the log in memory-- the value that is brushed into the redo log, the number of bytes Pages flushed up

  2022-06-01 07:20:19 Views: 204
• 

  Mysql export files and backup operation notes

  Through SELECT... INTO OUTFILE statement exports a table MariaDB [(none)] > show databases;+-+ | Database

  2022-06-01 07:20:19 Views: 258
• 

  Express your experience in order to improve the efficiency of query

  In order to improve the query efficiency, the original blogger post http://www.cnblogs.com/zhangyabin---acm/p/5955001.html is in the same table for super-large business data, but there are no other business fields in the area.

  2022-06-01 07:20:19 Views: 246
• 

  Find the corresponding pid by port number

  Port 34048 [root@hs-152 ~] # lsof-i:34048COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAMEperl 22328 r

  2022-06-01 07:20:18 Views: 207
• 

  JProfiler 11 for Mac (Java Development and Analysis tool) 11.1.4 (11169) Activation

  JProfiler version 11 is a powerful Java development and analysis tool that can help programmers analyze your code data, identify memory leaks and understand thread problems. JProfiler 11 Mac HTTP client with remote tracking

  2022-06-01 07:20:18 Views: 230