PHP

I haven't posted any articles for a long time! Hard Disk Selection 1. If the hard disk has conditions, try to select a SAS disk. If there is no bad money, you can choose SSD, funsion-io, and so on. You can also consider SATA based on the selected

In daily work, because I am not familiar with the InnoDB engine, many people in the group have mistakenly deleted InnoDBibdata (data files) and ib_logfile (redolog redo transaction log files ), the result is a cup. For example In daily work, because

I recently used programming implementation on SQL Server Management Tasks in my project. I have some experiences and want to share with you some knowledge about SMOSQLCLRSSIS in my work, in China Recently, I have used programming for SQL Server

Recently, I have performed Database Synchronization and backup. After I subscribe to the primary database through [copy] provided by SQLService, the subscriber (slave database) cannot determine the subscribe to the slave database because of an

Whether the index view is physically stored in the database and some opinions on using the index view. Preface I wrote this topic in my article but did not write it casually, but no one else can see it without writing it in the essay, because the

During the construction of the website, a highly scalable architecture design ensures that the existing system can be expanded at a low cost when the website business volume and access volume reach zero threshold. The most difficult part of the

HenriqueLoboWeissmann is a software developer from Brazil and co-founder of itexto, a consulting company. Recently, Henrique wrote on his blog about some content about MongoDB, some of which deserve our attention, especially those who are interested

I have been reading this article a few days ago to correct and supplement "tempdb management in SQLServer": the management of tempdb in SQLServer has found that some of the content is not very accurate. The article said: like other user databases,

Scenario 1: When addkeyConnectionStringvalueserver127.0.0.1, database name, and u are used in the webconfig file to connect to the database, the database cannot be logged on normally, A lot of errors have occurred. Scenario 2: Use an IP address to

I. the content involved in this article (Contents) the content involved in this article (Contents) background (Contexts) implementation code (SQLCodes) Implementation Method 1 (One) implementation method 2 (Two) implementation Method 3 (Three)

I'm going to take a technical note on the Oracle index topic, because today I helped a friend in Shenzhen to test rman and found there was a ORA-XXXXX when restoring my raw data. I'm going to take a technical note on the Oracle index topic, because

Oracle10gLogicalDataGuard detailed setup process Detailed setup process of Oracle 10g Logical logging uard Logical standby is built on physical standby Oracle10g Physical DataGuard detailed construction process -- Stop the log application on

During the configuration of the maximum performance mode of the physical worker uard, the master database host edbjr2p1 slave Database Host edbjr2p21. create the master database [root @ edbjr2p1 ~] # Xhost + accesscontrol During the configuration

1. Create an empty table eygle2. Create the user eygle, which belongs to the eygle tablespace; grant the user DBA permission 3. log on to the DB as the egyle user, and create the table test_egyle4 and rman backup eg. 1. Create a table named empty

Configure Oraclelsnrctl and auto start 1. Set the host name [root @ www ~] # Catetcsysconfignetworkingyeshostnamewww. linuxidc Configure Oracle lsnrctl and auto start 1. Set host name [root @ www ~] # Cat/etc/sysconfig/networkNETWORKING =

1. Permission related: 1. Modify sqlsecuritySql code ALTERPROCEDUREwwwSQLSECURITYINVOKER; ALTERPROCEDUREwwwSQLSECURI .. 1. Permission related: 1. Modify sqlsecuritySql code ALTERPROCEDUREwwwSQLSECURITYINVOKER; ALTERPROCEDUREwwwSQLSECURI .. 1.

In SQL Server, I found that the online interpretations of the false offline are scattered. What exactly is the false offline interpretation? I have studied it at home over the past few days and collected a lot of online information. The Chinese

Let's take a look at this error log: InnoDB: Warning: alongsemaphorewait: -- Thread140593224754944haswaitedatbtr0cur. cline528for241.00secondsthesemaphore: X-lockonRW- Let's take a look at this error log: InnoDB: Warning: alongsemaphorewait: --

Splits strings. MYSQL version. Because MYSQL does not support recursion and does not support returning results of the table type, the code is cumbersome. I use two functions and a stored procedure. -- Obtain the total number of delimiters. DE Splits

The AlwaysOn technology supported by SQLServerAlwaysOn architecture and principles by Du Fei SQLServer2012 focuses on the advantages of failover clusters, database images, and log transmission, but they are different. The unit of the Failover