PHP

Today we are talking about setting up and playing games. It is still quite smooth. We will record the process to facilitate future queries. VPS is installed with Ubuntu and purchased at DigitalOcean. What is his advantage? The price is cheap and the

Mysql common query: groupby, left join, subquery, havingwhere I went to two relatively popular Internet companies for an interview a few days ago. I encountered a problem in SQL, first, let's take a brief look at score1 and groupby in the

Many people know that the Oracle listener has always had a security risk. If security measures are not set, users who can access the listener can close the listener remotely. Example D: lsnrctlstopeygleLSNRCTLfor32-bitWindows: Version10.2.0.3.0 Many

I. stored Procedure 1. stored Procedure classification a stored procedure is a database object that is stored in a database and can be executed by an application through a single call. It also allows users to declare variables and execute conditions,

Steps for effectively disabling the Oracle deadlock process: 1. Check which process is locked. V $ DB_OBJECT_CACHE view: SELECT * FROMV $ DB_OBJECT_CACHEWHEREOWNER process owner ANDCLOCKS! 0; 2. Check which SID is used. The SID can be used to know

1. Does MySQL5.1 storage program and function play a role in replication? Yes, the standard behavior executed in the storage program and function is copied from the master MySQL server to the slave server. 2. Can the stored programs and functions

MYSQL automatic backup policy selection and Practice (transfer) currently popular backup methods: 1. Logical backup: use mysql's mysqldump tool for backup. Back up SQL files. Advantage: the biggest advantage is that it can work with the running

Analysis and Solution to the Problem that PHP cannot access remote mysql. First, the remote server can be accessed remotely. The problem I encountered was: There are three servers A, B, and C, and C is the server. B can use PHP to successfully

I. Impact of server hardware on MySQL performance ① disk tracing capability (Disk IO), we now use SAS15000 hard disks. MySQL performs a large number of complex query operations every second. You can imagine the disk read/write volume. Therefore,

The following article describes how to sort out some common MySQL questions and answers on the CU. If you are interested in the actual operations, you can click here to view the following articles. In general, you can use MySQL (the best combination

The parallel execution of SQL queries has been extended from the learning of Dremel and Impala, so I took this opportunity to learn more about the parallel computing of relational databases and relational algebra. Speedup and ScaleupSpeedup are two

[51CTO quickly translated from toutiao.com in September 22] If you want to give you a minute to become the president of Oracle, you are not required to wear LarryEllison's expensive suit on his yacht, but let you decide the fate of MySQL. What do

One of the most powerful features of Oracle view is that it can create a view with errors. For example, if the field in the view does not exist in the base table, the view can still be created successfully, One of the most powerful features of

I. SQL fast-Structured Query Language (SQL) is a standard language used to query relational databases. It includes several keywords and consistent syntax to facilitate database components (such as tables, indexes, and fields). The following is an

After the last zipmap analysis, the content about the redis source code struct has actually ended, because there are several operation classes related to the struct below, they are merged into the struct package. These files include t_hash.c, z_list,

The following describes how to install the DataGuardCPUPSU patch. For more information, see [Oracle] CPUPSU patch installation tutorial. the Primary uard requires both Primary and Standby to be patched, so the steps are more complex. The main steps

The following article mainly introduces the MySQL event scheduler (eventsched). The event scheduler we tested this time was executed in the MySQL environment, and it adds another related function, it can be used as a new scheduled task scheduler.

The following article describes how to correctly master the characteristics of Dynamic tables in MySQL databases. It can be said that dynamic tables are frequently used in MySQL databases, therefore, it is also important to master the dynamic tables

The following articles mainly introduce the practical operation solutions that allow MySQL to support Chinese characters. MySQL to support Chinese characters is also favored to some extent as MySQL databases are generated, the following is a

I have already written the first article about how to build a Mongo database replica set on the windows platform: How to build a Mongo database replica set on the windows platform. Article 2: in this article, we will summarize the replica set and