MySQL

The following articles mainly describe the actual application code of MySQL cache query and the description of MySQL cache query size, fragmentation, cache clearing, and monitoring of MySQL cache query performance, the following is a description of

How to configure the MYSQL database:Generally, you just need to modify my. ini and point it to the database directory.Liu yongfa (yongfa365) Blog has tested the simplest method:1. net stop mysql2. Open C: Program FilesMySQLMySQL Server

# Vi mysqlusers.txt Create databaseDataname;Grant all privileges onDataname. *Username@ Localhost identified'Password';Flush privileges; #/Usr/local/mysql/bin/mysql-u root-pPassword The blue italic part is the corresponding user name

The following articles mainly introduce the five configuration parameters that closely affect MySQL performance. I saw the five configuration parameters that closely affect MySQL performance on the relevant website a few days ago, I think it's good.

Foreign key: Data consistency and integrity are maintained to control data stored in the foreign key table. Associate two tables. The foreign key can only reference the values of columns in the External table! For example: A and B Table a

Environment:Master server: centos 5.2 mysql 5.1.35 source code IP: 192.168.1.22Slave server: centos 5.2 mysql 5.1.35 source code IP: 192.168.1.33Configuration:I. master server1.1 create a replication user with the replication slave permission.Mysql>

As we all know, query optimization is an inevitable topic in any database. Optimization is the most challenging task for database engineers. MySQL open source database is no exception. In fact, I believe that database optimization is not as

There are many articles on the Internet that teach you how to configure a MySQL server. However, considering the differences in server hardware configurations and specific applications, the practices in these articles can only be used as a reference

High-performance index policiesCreating a correct index and using it properly play a key role in the query performance. We have introduced the capabilities and weaknesses of various indexes. The following describes the power of indexes. There are

The hidden space of MySQL is implemented by setting the environmental variable TMPDIR. If TMPDIR is not set, MySQL uses the default value of the system, usually/tmp,/var/tmp, or/usr/tmp. MySQL uses the value of the environmental variable TMPDIR as

This article compares datetime and timestamp in MySQL through examples. Although the two methods actually represent the same type, there are still some differences. Same Display The display format of the TIMESTAMP column is the same as that of the

Description: This is an article about mysql performance, mysql performance optimization, and mysql performance optimization. There are many mysql performance optimization solutions on the Internet. However, mysql optimization is more troublesome and

I. Introduction==========This document describes how to install and configure a MySQL cluster based on two servers. MySQL can continue to run when any server encounters a problem or goes down. Note!Although this is a MySQL cluster based on two

  Add a mysql group and a mysql user   [Root @ test mysql] # groupadd mysql [Root @ test mysql] # useradd-g mysql   Compilation and Installation   Tar-zxvf mysql-5.1.35.tar.gz ./Configure/ -- Prefix =/usr/local/mysql/ -- Localstatedir =/data/mysql

  By default, Mysql cannot be accessed through a remote machine. You can enable remote access through the following configuration. My Mysql environment is ubuntu + mysql5 1. Modify/etc/mysql/my. conf, bind-address, and specify as the actual IP

  An ERROR is reported when mysql is started in FreeBSD! The server quit without updating PID file, which is usually used to view The. err log in The database directory. It records some specific error information, which is quite useful for

1. If the Key is null, the column value can be repeated, indicating that the column has no index or a non-leading column with a non-unique composite index.2. If the Key is PRI, this column is an integral part of the primary Key.3. If the Key is UNI,

The database installed on the local machine can be accessed by a local program, but the machine of the colleague cannot be connected. It is found that remote access is not enabled for the mysql database.The solution is as follows:--------------------

Today, I encountered a problem about deleting a foreign key column. I found that:SQL codeShow create table userfans;Java code| Userfans | create table 'userfans '('Id' int (11) not null AUTO_INCREMENT,'Status' int (11) default null,'Update _ time'

Create USER 'itpro' @ '%' identified by '201312 '; 1. d: \ mysql \ bin \> mysql-h localhost-u root// You can access the MySQL server.Mysql> update user set host = '%' where user = 'root ';Mysql> select host, user from user;2. mysql> grant all