MySQL

Before installing mysql5.5 in centos compilation and installation, uninstall Mysql5.0 in CentOS. [Root @ localhost ~] # Yum remove mysql compile and install cmake www.2cto.com download the cmakesource code package cmake-2.8.4.tar.gz, mv to

MySQL uses string Truncation in MySQL when creating a view today, which is very convenient. I feel that the string function of MySQL intercepts characters, which is more powerful than program interceptions (such as PHP or JAVA). So I want to make a

MySQL root User Password Reset 1. First, stop the running MySQL process Linux and run killall-TERM MySQLd Windows. If it is written as a service, run: net stop MySQL, if it is not loaded as a service, you can close it directly in the Process Manager.

Set TimeStamp for multiple timestamp in mysql. The Default value is DEFAULT CURRENT_TIMESTAMP. The value of timestamp is automatically updated as the table changes. The value is on update CURRENT_TIMESTAMP. However, because a table ON www.2cto.com

Mysql and oracle batch processing run SQL file and oracle import dmp file mysql batch processing run SQL: www.2cto.com net stop mysql net start mysql echo Wscript. sleep (3000)> sleep. vbs start/w wscript.exe sleep. vbs del/Q sleep. vbs mysql-f-u

Mysql built-in profiling performance analysis tool 1. show variables like '% profiling %'; (view profiling information) www.2cto.com2. set profiling = 1; (enable profiling)3. Run the SQL query example: select goods_name from ecs_goods where goods_id

Using mysql command line to export SQL is actually very simple. You only need two steps. First, enter the mysql command line, enter the database name for use, and then enter source test. SQL can export all the data in the Test table. You can use

Architecture diagram: Replication principlesMysql Replication is an asynchronous Replication process, from a MySQL node (called the Master node) to another MySQL node (called the Slave ). The entire replication process between the Master and Slave

Mysql error: 150 foreign key ERROR error 1005 (HY000): Can't create table '****. frm' (errno: 150) www.2cto.com problem 1. Make sure the referenced tables and fields exist; 2. The fields that make up the foreign key must be indexed (the fields that

Example of Master-Slave Data Synchronization for Mysql Server: How can I synchronize data from A Master server to A Slave server by using server A as the Master server (Master) and server B1 and server B2 as the Slave server (Slave, let's take a

Mysql-mmm-monitor Service Startup error, no compilation related Class: The Singleton package solves the following error prompts during compilation and the error resolution process; [html] www.2cto.com [root @ DB1 mmm_deps] # cd/etc/init. d/[root @

Optimization of mysql nested queries and nested query of table queries is poorly optimized as I mentioned above. Without special considerations, table queries are more effective than nested queries. Although the two queries share the same meaning,

When the MySQL command line fails to enable slow. log, you need to check slow. log. However, it has been found that slow. log has not been written for a long time. Www.2cto.com looked at the server settings: root @ (none) 01:13:41> show global

MySQL's unique user mechanism is confusing for beginners of MySQL. MySQL user names are not as simple as MS-SQL and Oracle databases. Similar to the firewall, it also includes the login limit mechanism. For example, for the following three MySQL

Sharding of different data forms in Mysql can be divided into two Sharding modes based on the Sharding rule type. One is to split the data to different databases (hosts) based on different tables (or Schemas). Such splitting can be called vertical

The results of the mysql in function are different from expected. After the exception of null is processed several times, the number of accounts in the game reaches. Some operations on the whole point lead to slow server response. Later, I found

It is important to carefully select the optimal MySQL Data Type. Why? Performance can be improved, and the principle is as follows: ● storage (memory, disk), thus saving I/O (retrieval of the same data) ● computing, and then reducing the CPU load

In many cases, mysql only requires local connection, that is, local connection (the server itself). This is also the case by default, and remote connection is not supported by default.But sometimes, when we need to separate mysql from a host or

Background of MySQL5.5 primary key lock reading problems some people have discussed that when MySQL 5.5 adds a primary key to a large table, the read will be locked. It is suspected that it is related to fast index creation. Here is a brief

Many of our friends prefer to use third-party tools to import and export data. In fact, our mysql comes with this tool, as long as it can be operated in command mode, of course, it can also be used in php. The method is the same as below. If you