PHP

Share the SQLSERVER connection timeout encountered by the customer today and my solution. The customer's environment is SQLSERVER2005 and WINDOWS2003SP232 bits. The connection timeout time is 2013-8-521: the following SQLERRORLOG is intercepted

First Class: Integer Data bit: bit Data Type represents 0, 1 or NULL, that is, true, false. 1byte.int: 4 bytes are used to store positive and negative numbers. the storage range is-2 ^ 31 to 2 ^ 31-1.smallint. Positive and Negative values are stored

During the transactionalreplicationtroubleshooting process, the following scenario is often encountered: the customer executes a few millions of lines of updates on the release end, resulting in performance degradation. The customer wants to know

1. Call two stored procedures ------------------------------------------------------------------ table [dbo]. [id] in [aaa_test] is the primary key --., @ p_namevarchar (50 ). (,) VALUES (@ p_id, @ p_name )., @ p_namevarchar (50 ). (,) VALUES (@

In DBA's work, the data dictionary is equivalent to our book and pen, which are inseparable from each other all the time. Whether you are looking at the status or monitoring, you need the support of the data dictionary. This article lists the

In this article, Centos6.0 first popularized the following Backup terms: Hot Backup: Read and Write are not affected; warm backup: only read operations can be performed; cold backup: offline backup; read and write operations are suspended; we back

Dynamic Setting of variables may cause unexpected side effects, such as refreshing dirty blocks from the buffer. Be careful with the settings that can be modified online, because they may cause the database to do a lot of work. Sometimes a variable

Databaselink allows you to create databaselink between databases to perform DML operations on data of a user in a remote database, but not DDL operations .. Databaselink allows you to create databaselink between databases to perform DML operations

Sometimes the database cannot be started because the data file is damaged for some reason. How can this problem be recovered? The following is a simulation experiment. 1. first create a tablespace TEST, and then create a table test in the tablespace

In database operations, we often encounter garbled code, which is really disturbing. Although we haven't fully understood some of the principles, we can summarize some experiences, guide later. Me In database operations, we often encounter garbled

Is Chinese character encoding always difficult for a well-known mysql database? This article uses mysql5.5 as an example. The installation method has been considered here. I only want to say one thing: to smoothly insert data into the database for

Self-reflection series carelessness led to GG synchronization failure bear recently joined a new company, with a buddy with the same level of OCM partner DBA, because of GoldenGate operation is not very familiar, so in yesterday's operation

SQLServer divides transaction log files into multiple VLF (VirtualLogFile), that is, virtual log files. 1. Four statuses of VLF: 1. active. Indicates an active transaction (unfinished transaction) in VLF ). 2. recov SQLServer divides transaction log

During Normal O & M, DBAs often encounter insufficient disk space due to the large SQL server log file. In this case, you need to compress the log file to release disk space, the following describes how to shrink a log file. During Normal O & M,

Cold backup means that when the database is shut down normally, it will provide us with a complete database. Cold backup is a way to copy key files to another location. Advantages: 1. Cold backup means that when the database is shut down normally,

MySQL5.6.10 official version has been released for many days. MySQL5.6 adds the partition replacement function. Today, let's try out the partition replacement function. Two example tables. t1 is a partition table, t MySQL5.6.10 official version has

Usecnblogs -- ylb: 1, space-short Message -- Message (messageId (200), -- number [PK, ID] consigneevarchar (200), -- recipient addresservarchar ), -- Sender titlevarchar (200), -- title contenttext, -- content pubdatestateReadvarch Use cnblogs --

1. Each node that traverses the index tree is a page. The index tree has three types of nodes: root node, intermediate node, and leaf node. (1) The root node and the intermediate node only contain the entry value and entry pointer of the next node. 1

A transaction is an atomic SQL query statement and can be considered as a unit of work. If the database engine can successfully apply all query statements to the database, it will execute all the queries. A transaction is an atomic SQL query

New project accepted, master-slave database replication synchronization error, ErrorCode1292 (invaliddatatype) Error SQL: updatewavesetIS_WAVED0, LEVEL1, SOURCE_TB_NAMEnull, SOURCE_IDnull, UPDATE New project accepted, master-slave database