NAV: SLTechnology News&Howtos > Database >

• 

  Sql server 2012 database mirroring

  Sql server 2012 database mirroring the following configure database mirroring through a domain account: 1. Environment preparation 1. Prepare the computer AD02 for the domain controller / DNS server (sz1card1.com), IP:192.168.2.218/24

  2022-06-01 07:19:21 Views: 242
• 

  Wechat is often delayed, what should I do if I can't get the message? Quickly check whether these three functions are enabled.

  Recently, my friend told me that there was a delay in the Wechat message. I don't know if this has happened to you. If so, let's take a look at what's going on, so we often don't get the news. Delay reason 1, network delay 2, shutdown Wechat background notification caused 3, Wechat do not disturb mode on

  2022-06-01 07:19:15 Views: 345
• 

  Start mysql error without updating PID file solution

  Error occurred when compiling and installing mysql startup: Starting MySQL. ERROR! The server quit without updating PID file & # 40StringUniverse Datagram MySQL Universe f

  2022-06-01 07:19:14 Views: 221
• 

  Summary of ORACLE BITMAP and simple experiment

  1. The outline of bitmap: 1. Definition, what is a bitmap index: an index represented by a bitmap. Oracle establishes a bitmap for each key value of the column at the bottom of the selection degree. Each bit in the bitmap may correspond to multiple columns, and a bitmap equal to 1 indicates that a specific row contains this.

  2022-06-01 07:19:14 Views: 279
• 

  MySQL Advanced part (02): index system Partition, B-Tree structure description

  The source code of this article: GitHub point here | | GitEE point here 1. Introduction to index 1. The basic concept is to make clear what index is: index is a kind of data structure, data structure is the way that computers store and organize data, and it refers to the number that has one or more specific relationships with each other.

  2022-06-01 07:19:08 Views: 248
• 

  Fix mysql slave replication 1032 error

  There is a 1032 error in a slave library. What is the 1032 error? let's take a look at [root@BLAVDP021 ~] # perror 1032MySQL error code 1032 (ER_KEY_NOT_FOUND).

  2022-06-01 07:19:08 Views: 216
• 

  Zabbix proxy Agent monitors usage deployment

  The working principle of Zabbix proxy: 1. How it works: Zabbixproxy is a monitoring proxy server, which collects the monitored data and stores it in the buffer first. The storage time can be set by configuration file, and then transferred to Zabbixserver; monitor.

  2022-06-01 07:19:07 Views: 220
• 

  Introduction of MySQL optimistic lock and pessimistic lock

  Optimistic lock is not included in the database and needs to be implemented by ourselves. Optimistic lock refers to the operation of the database (update operation), the idea is very optimistic, that this operation will not lead to conflict, in the operation of the data, there is no other special processing (that is, no lock), but after the update

  2022-06-01 07:19:06 Views: 234
• 

  Fields of type varchar store sorting of pure numbers

  If the type of the table field is varchar, but it stores pure numbers, how to sort them according to the size of the numbers? The following methods can be implemented for both mysql and oracle, such as order by field + 0order by field * 1, etc.

  2022-06-01 07:19:06 Views: 215
• 

  How to realize the integration of gray routing and traffic protection based on Nacos and Sentinel

  On the premise of realizing grayscale publishing and routing functions, Nepxion Discovery framework combines Nacos and Sentinel to implement another layer of protection measures for traffic, which can better achieve the purpose of enterprise-level traffic security control. Its functions include: encapsulating the remote configuration center and this

  2022-06-01 07:19:06 Views: 243
• 

  Innblock tool | InnoDB page observation tool

  Innblock | InnoDB page observation tool special thanks to the author, who is an early student of Zhi Ju Tang. The original idea of writing such a tool was also recognized and encouraged by teacher Ye Jinrong. This idea also consumed several nights of rest. I would like to thank Ye Jinrong again.

  2022-06-01 07:19:06 Views: 229
• 

  PostgreSQL DBA-pgAdmin (Don't do this: Don't use serial)

  No zuo no die series, from wiki of pg. This section is about: don't use serial. The reason is: The serial types have some weird behaviors that ma

  2022-06-01 07:19:05 Views: 231
• 

  SQL structured query language-- DDL language

  1. An overview of SQL structured query language SQL is the standard language used in relational databases, and its implementation based on IBM was first approved in 1986. In 1987, the International Organization for Standardization (ISO) adopted ANSI (American National Organization for Standardization) SQL as an international standard.

  2022-06-01 07:19:05 Views: 261
• 

  Oracle 10g dg switching step record

  Http://www.orafaq.com/node/2078[@more@] transliterates the switch operation written by foreigners, and the foreigner's documents are still well written. Of course, the actual switching process may also involve any backstage operation in addition to the operation of oracle itself.

  2022-06-01 07:19:05 Views: 277
• 

  Max_connect_errors Settin

  Number of max_connect_errors error connections default max_connect_errors = 10 error connections exceeding max_connect_errors will be reported an error by mysql, MySql Host is

  2022-06-01 07:19:05 Views: 240
• 

  Mysql master-slave status monitoring script

  Goal: to monitor the status of the Mysql slave library and alarm if you copy an exception from the library: 1. First look up the four parameter values of the Mysql slave library (show slave status according to this command); they are the IO thread, SQL thread and replication delay time of the slave library.

  2022-06-01 07:19:04 Views: 221
• 

  Oracle steps to move control files under Linux

  1. View the control file [oracle@dbserver ~] $sqlplus / as sysdbaSQL > desc v$controlfileSQL > select * from v$controlfil

  2022-06-01 07:19:04 Views: 244
• 

  Oracle SYSAUX tablespace maintenance

  1. Statistics (1) change Historical Statistics Save date select dbms_stats.get_stats_history_retention from dual;exec dbms_stats.alter_s

  2022-06-01 07:18:55 Views: 271
• 

  MySQL Daily SQL Optimization considerations

  1. Avoid using the double percent sign "% col%" in the MySQL SQL query condition to avoid using "% col%" to use the index in the where condition, and doing a full table scan affects the query efficiency 2. Avoid functions appearing in where conditions for example: where year ('ac

  2022-06-01 07:18:55 Views: 274
• 

  Mysql Learning-installation

  First, extract the mysql installation package. Note that the downloaded mysql package must be consistent with the operating system version. [root@node1 soft] # lsmysql-5.7.11-1.el5.i686.rpm-bundle.tar [ro

  2022-06-01 07:18:54 Views: 226