PHP

A database is migrated from SQLSERVER2000 to SQLSERVER2008R2. Currently, database names are replaced by DataBaseName (the actual database names are also replaced by DataBaseName ), there is no problem during the migration. you have configured

The MySQL architecture is master-slave (master-slave), and the master node is automatically switched to slave when the master node fails. You can also set it as a dual master, but there is a drawback: when the pressure on the master is very high,

We know that MySQL supports horizontal partitioning. Let's try to optimize the query on a partitioned table. In general, the optimization principle is the same as the optimization for individual tables, ensuring that We know that MySQL supports

At login was told that the test user is locked 1, with the dba role of the user login, unlock, first set the specific time format, in order to view the specific time SQLaltersessionsetnls_date_formatyyyy-mm-ddhh24: mi: ss At login was told that the

The DBA needs to know when recreating the control file, but it may not be able to reproduce the system throughout his career. First of all, it is emphasized that backup is the safest, quickest, and effective recovery method. If a DBA does not plan

After completing the one-way replication configuration of ogg, you will naturally want to push forward a layer to achieve two-way replication. In actual applications, there are many problems faced by two-way replication: 1. if both databases update

Since MySQL5.5 released its first version, a new record is added to the GRANT permission list: PROXY. Do not think this is the previous MySQLProxy. In fact, this is used as a vest for users. Let's come Since MySQL5.5 released its first version, a

Next to the above article: ixdba. blog.51cto. com289555188038514: Install the OracleClusterware (1) Decompression package. Here we assume that all the database software is under the rac directory. Next to the above article:

1. The application scenario is applicable to scenarios where OracleRAC is not compatible with applications and must be removed as a single instance. application cases: Host: alex1, alex2 & nb .. 1. The application scenario is applicable to scenarios

In SQL Server tables, two special columns may exist. One is Identity and the other is GUID. First, you can use the IDENTITY attribute to implement the ID column. This allows developers to specify an ID (IdentitySeed attribute) for the first row

Recently, I used my free time to write a file backup tool, because many files on my disk are very important, such as many PPT files and handouts. Therefore, frequent backup is required, and because there are many such files, Incremental backup is

As SQLINJECTION attacks increase significantly, Microsoft recently released three free tools to help website administrators and detect risks and block possible attacks. Scrawlr: download. spidynamics. comProductsscrawlr, a tool developed by

We found that this change started from a change a few days ago. The customer asked me to decompress a table that contains partitions for six years (by day, and then there are 10 sub-partitions by branch ). The data volume is small, only 1.7 GB.

The database on a project used the. mdf file and. ldf file for a few months. The total number of. ldf files reached 100 GB, so that the hard disk would be cracked. This is because a large amount of redundant data exists in a data table due to

1. Basic Concept concurrency control: It mainly takes into account the situation that multiple users simultaneously access the same data in the database. Sqlserver is designed with two types of concurrent access control mechanisms: Lock and row

I wrote more than 140 articles without knowing the tools needed to write a good blog. At the beginning, I didn't use any tools. I used QQ to write a few words at the top, draw a few arrows and then gradually see their blog posts in others' blog

1. Why do I need to use transactions? A transaction is a single unit of work. If a transaction succeeds, all data modifications made in the transaction will be committed and become a permanent component of the database. If the transaction encounters

This article summarizes and analyzes some commonly used SQL statements. For your reference, you may need it. 1. SQL row and column conversion problem: Suppose there is a student Partition Table (tb) as follows: name course score Zhang San Chinese 74

This is mysql master-slave replication configuration related content: server-id1log-binmysql_logbinlogbin-logslave-skip-errors1062, 1205max_ B .. This is the configuration related to mysql master database for master-slave replication: server-id =

When MySQL uses the innodb engine, the page size defaults to 16 KB, which is too large for many applications, many applications that run well in other data, such as ORACLE, are migrated to innodb, and I/O pressure is high. When MySQL uses the innodb