Turn off Bin-log Log
When the Bin-log log is turned on, many mysql-bin.0000*-like files are generated and may take up a lot of hard disk space. For their own test machine or hard disk more nervous VPS, and do not need to do master,slave
Antelope is a innodb-base file format, Barracude is a file format introduced after Innodb-plugin, and Barracude also supports Antelope file formats. The difference between the two is:
File format
Support Row format
mysql| Stored Procedures | tutorials
Author: MySQL AB; translation: Chen Bong
Introduction Introduction
The MySQL 5.0 new features tutorial is written for old MySQL users who need to understand the new features of version 5.0. The simple
MySQL Database Basics (ii)--mysql character set and garbled parsing one, character set and encoding 1, Character set introductionCharacters (Character) are all kinds of words and symbols, including the national text, punctuation, graphic symbols,
Xtrabackup IntroductionPercona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM backup also need to add a table lock). Xtrabackup supports all
1. Enter Mysqladmin processlist into the Mysql/bin directory;2. Start MySQL and enter show Processlist;If you have SUPER privileges, you can see all the threads, otherwise you will only see the thread that you initiated (this is the thread that the
Php+mysql database development similar to Baidu's search function: Chinese and English participle + full-text Search
Chinese participle:
A) Robbe php Chinese word extension: http://www.boyunjian.com/v/softd/robbe.htmlI. Robbe full version
An introduction
The principle of two indexes
Three-indexed data structures
Three MySQL index management
Four Test indexes
Five correct use index
Six query optimization artifact-explain
The basic steps of seven-slow query
When inserting a very simple SQL statement, MySQL always complains:[SQL] INSERT into ORDER (IdACTIVITY_ID,Order_type,PhoneOrder_amount,Order_state,Pay_type)VALUES(' 4 ',' 2121313 ',' 1 ',' 13552444989 ',' 1 ',' 1 ',' 1 ')[ERR] 1064-you has an error
Open Apache First, enter the localhost return on the browser if the screen is displayed: It works! Such as:This means your Apache is open.To configure Apache under window:1. Locate the http.conf file in the Apache installation directory to open this
Original source: http://www.cnblogs.com/luckcs/articles/2543607.htmlMySQL Master-slave Replication (master-slave) and read-write separation (mysql-proxy) practicesAs the most widely used free database in the world, MySQL believes that all engineers
MySQL database programs that can run on a local version of Windows have been available from MySQL AB since version 3.21, and the daily download percentage of MySQL is very large. This section describes the process of installing MySQL on Windows. The
1, download yaf Source package yaf-2.2.9.tar.gz, and upload it to the server specified location, and then unzip and install:[Email protected] src]# TAR-XVF yaf-2.2.9.tar.gzEnter the extracted directory:[Email protected] src]# CD yaf-2.2.9One
The difference between timestamp,datetime,int types in MySQL and their pros and cons int1. Occupies 4 bytes of 2. After indexing, the query is 3 faster. Conditional range searches can be used using BETWEEN4. You cannot use the time function
Read a lot of online on the Linux operating system to build a Web server tutorial, so I myself also tested a lot, but today tested Ubuntu 12.04 Build Web Site Server (mysql+php+apache environment), feel this suitable for beginners. So here's to
A beginner's database, a record of what you've learned. I used the MySQL database to manage with MySQL Workbench. Here's a quick introduction to using MySQL Workbench to build a database, create a new table, and add data to a table.Click on the
Why is the filtered column value always 100% in Mysql explain extended?1. execute the Mysql explain extended command to output a column of filtered (MySQL5.7 outputs filtered by default ), it indicates the percentage of rows in the returned results
Analysis of Index Condition Pushdown (under the ICP Index Condition) and Multi-Range Read (MRR Index Multi-Range lookup) query optimization in MySQL,
Source: http://www.cnblogs.com/wy123/p/7374078.html(The Source retained is not the right of
BKJIA, December 10 (Internet headlines) Amazon's RDS Service Relational Database Service (Relational Database Service) has brought us a MySQL Database server in the cloud, making the concept of "Database as a Service" a reality, it provides a fast
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