MySQL

Download: wget http://blog.s135.com/soft/linux/nginx_php/mysql/mysql-5.1.33.zip Installation: Unzip mysql-5.1.33.zip CD mysql-5.1.33.zip . /Configure -- prefix =/usr/local/MySQL -- enable-validator -- With-extra-charsets = Complex --

The latest PHP 5.0 + MySQL 5.0 + win2003.I personally think it is necessary to write a tutorial because many aspects are different from those of the old version.To be honest, I also read many official documents to solve many strange problems. =====

The following articles mainly introduce the disadvantages of MySQL indexes and the actual operations of MySQL indexes, which deserves our attention, we may not know that using indexes too much will cause abuse. Therefore, MySQL indexes also have

MySQL prepare Syntax: PREPARE statement_name FROM preparable_ SQL _statement;/* definition */ EXECUTE statement_name [USING @ var_name [, @ var_name]...];/* EXECUTE the preprocessing statement */ {DEALLOCATE | DROP} PREPARE statement_name/* delete

This article mainly tells you about the detailed installation steps of MySQL 5.0 on windows. MySQL 5.0 still accounts for the majority of windows applications, if you are curious about this newly developed technology, the following articles will

During MySQL query time period, it will be more efficient to select INT, or will it be more efficient to select DateTime? To solve this problem, we will perform a test to see whether INT or DateTime should be used in the MySQL query

Guidance:The use of the MySQL database engine can improve the efficiency of work, so the MySQL database engine is favored by many large and small enterprises. If you want to learn the quick guidance of the MySQL database engine, continue to read it

1. Preface MySQL is a fully networked cross-platform relational database system and a distributed database management system with a client/server architecture. It has the advantages of strong functions, ease of use, convenient management, fast

Description of mysql cpu usage by 100%In the morning, I helped a friend solve the Mysql cpu usage problem of 100%. I sorted it out and recorded the experience in this article. Recently, the CPU usage of MYSQL service process (mysqld-nt.exe) on a

Mysql-workbench is a database design tool officially provided by mysql. It is completely free of charge,I used 5.0 in the past. It is okay to run it in win7. But after I download the new version 5.2.9 today, it cannot run,When preparing to give up,

MySQL high availability solution: MHA-based automatic failover ClusterComparison of common high availability solutions for MySQL (from the official manual) Only MySQL Cluster and DRBD + Heartbeat are available for automatic database failover. These

MySQL learning footprint record 13 -- JOIN table -- inner join... ON learning database join table this section content almost vomit blood, read ON the introduction and Baidu to the content, always feel a blank face ..... maybe I have a poor

Mysql tuning three steps (slow query and explain profile) often encounter some SQL problems in performance tests. In fact, the most problems encountered in performance tests over the past few years are databases, either high I/O or high cpu, Data

This article introduces how to remotely access the mysql database. If you need it, you can refer to it. Solution: 1. Change the table method. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you

There are many ways to delete duplicate records. Here I summarize a variety of SQL statements for deleting restart records, such as deleting duplicate id data and searching for duplicate records, remove the smallest record, delete the repeat record,

Simple configuration-Allow mysql to be remotely called by other machines MYSQl is installed on a linux server of the company. When I access the MySQL service through mysql-Front on the console of the client, the prompt that mysql server cannot be

Recently, the CPU usage of MYSQL service process (mysqld-nt.exe) on a friend host (Windows 2003 + IIS + PHP + MySQL) is 100% high. This host has about 10 databases, which are called for 10 Websites respectively. According to A Friend test, lead to

If this problem is not solved, MySQL cannot actually process Chinese characters. The reason for this problem is that MySQL is case insensitive when querying strings, in programming MySQL, The ISO-8859 character set is generally used as the default

An important application is how to change the password when the root user password is forgotten. You can ignore loading the authorization table when starting the MySQL server.MySQL uses a user name and password in many ways different from Unix or

The MySQL administrator should know how to set the MySQL user account by specifying which users can connect to the server, where to connect, and what to do during connection. MySQL3.22.11 introduces two statements that are easier to perform this