When the database is in use, the default binlog is kept in one file (about 1.1G), resulting in a very large file, so you may need to delete some binlog log files when necessary:
To delete a log file:
Mode one:
[Root@master-mysql data]# grep-e
One, slow query log configuration
Turn on the slow query log to configure the sample:
/etc/mysql/my.cnf[Mysqld]Log-slow-queries
Add the above configuration entry in the MY.CNF configuration file and restart the MySQL service, when the MySQL slow
My Date
The first date format we get is this: 2009-2-12 or 2009-3-3 or 2009-10-12, we can do this by combining SQL statements: (three examples)
The code is as follows
Copy Code
@1select * from user where birthday> ' 2009
Optimizing parameter configuration During installation improves service performance
Install MySQL under Linux the default configuration installed MySQL is not necessarily working in the best performance state, you need to optimize it. Generally
The following error occurred while compiling MySQL:
The code is as follows
Copy Code
Checking for tgetent in-ltermcap ... noChecking for termcap functions Library ... configure:error:No curses/termcap Library found
SELECT column_name (s) from table_name as Alias_name
SELECT column_name as Alias_name from table_name
Suppose we have two tables: "Persons" and "Product_orders" respectively. We assign them the alias "P" and "Po" respectively. Now, we want to
The MySQL5.0 version of the installation diagram tutorial is for beginners, and the current mysql5.0.96 is the latest stable version.MySQL Download address http://www.jb51.net/softs/2193.htmlThe following is the MySQL installation diagram, with the
After installing MySQL, the system gives a default password and then says if you forget the default password ... I copied the default password and took one step, which was the beginning of my long journey. His password is too complicated, of course,
One, Zoning Concepts
partitions allow multiple portions of a single table to be allocated across the file system according to the specified rules. Different parts of the table are stored as separate tables in different places. MySQL has been
Copy Code code as follows:
Update dede_addonsoft SET dxylink=replace (Dxylink, '. zip ', '. rar ') where aid > 45553;
Copy Code code as follows:
Update ' table_name ' SET field = replace (field, '. rar ', '. 7z ');
I installed million MySQL on the CentOS6.4, unable to enter through the root, because the installation, and did not set the root password, there seems to be an initial random password, but do not remember, too troublesome, directly reset the root
Class one or four isolation level
The SQL standard defines 4 classes of isolation, including specific rules that define which changes are visible inside and outside the transaction and which are not. The low-level isolation level generally supports
What just caught our attention is that the MySQL manual has modified the license, which is a change from MySQL 5.5.30 to 5.5.31, which affects all pages in the man folder in the source pack. The move is a clear indication of the very unfriendly
The following mysqld options affect security:
·--allow-suspicious-udfs
This option controls whether a user-defined function with only the XXX character can be loaded in the main function. By default, this option is turned off, and only UDF with at
First, make a decision whether you want to use the latest development version or the final stable version. In the MySQL development process, there are several release series at the same time, each release at different stages of maturity:
· MySQL 5.2
The purpose of this article is simply to tell friends how to compile MySQL code, and perhaps some people think that the code compiled from the Windows platform MySQL is somewhat complicated, but it is not. If you have any questions about the
MySQL database is divided into two types, one is the traditional data table format, one is to support the transaction of the data table-type (INNODB,BDB, which is mainly based on InnoDB), I introduce the MySQL transaction processing database
System environment: ubuntu server 12.10x64 (mysql comes with the system)When we need to modify the MySQL configuration file my. cnf (my. ini in windows) for some settings, we need to restart MySQL after the modification.The path of my. cnf file
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service