To some small script that rarely complains, but recently imported a 10+m SQL script, but repeated the error:
Error occured at:2014-03-24 11:42:24Line no.:85Error Code:2006-mysql server has gone away
Finally found the reason, the original is MySQL
Advantages and disadvantages of MySQL log backups
Benefits: is to revert to a point in time, or an operation SQL statement
Disadvantage: A large log file is generated
MySQL log recovery method in Windows
1. Open MySQL LogFind [mysqld] in the
For PHP and MySQL connection on many blogs are explained, in order to MySQL query, modify, insert and other operations master, this article describes how to use MySQL to do a login registration modify the Password page.
Which, as follows
1. Login-
How MySQL takes random data out of a tablePreviously discussed this problem in the group, the comparison is interesting. MySQL's syntax is really fun. They all want to use PHP to achieve random, but take out more than two times as if the query.
MySQL "Since ancient times" has a mysterious handler command, and this command is not SQL standard syntax, you can reduce the optimizer for SQL statements parsing and optimization overhead, thereby improving query performance. See here, may have a
1> the compressed file mysql-noinstall-5.1.6-alpha-win32.zip into a directory, set the Mysql_home in the environment variable, and add%mysql_home%\bin to path.
2> creates the My.ini configuration file, which reads as follows: [mysqld]
The table logic here is divided according to the number of user_name groups in the T_group table.
Because this is the case, the index on the field alone user_name the bad index. Can not play the obvious effect of name.
1, test procedure.
DELIMITER
Verify that the MySQL service is available in the list of computer services
(1) Right-click on the Desktop computer icon appears menu list options, selected management (there are several ways to open the computer Local Service list, here is just
DescriptionAccording to the investigation, the above server thread cache Thread_cache_size is not set, or is set too small, this value indicates that the number of stored threads in the cache can be recycled, and if there is room in the cache when
Windows1, MySQL is some environment variables can be set,
Can enter: show variables; you can view the current environment variable settings;
2, some of these variables are related to the setting of the character,
Can enter: Show variables
In the previous article to introduce the MySQL use of a simple tutorial (ii)
Two tables with the same structure in MySQL are merged: (Note that two tables are required for the same structure)
There are two table father and person with the
Introduction
Today (August 5, 2015 5:34 PM) makes an adjustment to the structure of a table in a database, adds several fields, and then refreshes the previous data, refreshing it by matching one of the existing field URLs, and then updating the
To modify the database character set:
Copy Code code as follows:
ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE ...];
change the table default character set and all character columns (Char,varchar,text)
If the user enters a Web page and inserts it into the MySQL database, there is an opportunity to leave the security issue known as SQL injection open. This lesson will teach you how to help prevent this from happening and help protect scripts and
The MySQL count function is the simplest function, a very useful calculation, and the number of records expected to be returned by a SELECT statement.
To understand the EMPLOYEE_TBL table that the Count function considers has the following records:
Suppose you have a table:
Copy Code code as follows:
CREATE TABLE users (id int (6) Not NULL auto_increment,primary KEY (ID), user_name VARCHAR (m) not null,emails VARCHAR (x) T NULL);
Initialize the table and add some
A simple expression.MyISAM is a non transactional storage engine.InnoDB is a storage engine that supports transactions.InnoDB engines are more suitable for inserting and updating operations than more applicationsand MyISAM is suitable for frequent
Infinite class Classification 、、、 but efficiency is not the best ... Do you have code for faster and better efficiency?
When you use recursion to wait for more categories, it can affect efficiency!
Please share!
Class.sql
----
The structure '
1. Order of executionStatement Template:(8) SELECT (9) DISTINCT (one) (1) from [left_table](3) join (2) On (4) WHERE (5) GROUP by (6) With (7) Having (10) ORDER by Execution order:1.FROM: Performs a cartesian product (Cartesian product) (cross
Problem:CREATE TABLE A ( ID varchar (primary) key, ver int, ...)There are federated indexes on the Id,ver, 10,000 dataWhy is the select ID from the A order by ID particularly slow?and select ID from A ORDER by id,ver very fastMy watch has
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