1. Preparatory work
Download MySQL's latest installation-free version mysql-noinstall-5.1.53-win32.zip, extract to related directories, such as: d:\\ Mysql-noinstall-5.1.53-win32. This is the root directory of MySQL.
2. Configure
There are
In MySQL, there are two field types that are confusing, that is, text and blobs, especially bloggers who write their own blog do not know to change to their own blog positive text segment select text or blob type.
Here are a few differences:
I.
Recently learning Java and database, think of the previous written student management system, are downloaded from the Internet, perfunctory. There is nothing to do, but also write their own one, but not many functions to achieve.
Development
MySQL parameter optimization for beginners, is more difficult to understand things, in fact, this parameter optimization, is a very complex thing, for different sites, and its online volume, access, number of posts, network conditions, as well as
On the internet to find a piece of MySQL technical article, feel good, translate it to share under.Original Author: Mike PetersI've sorted out 7 ways to fix the MySQL database, when a simple reboot doesn't work for the database, or when a table
The simple format that MySQL gives user permission commands can be summarized as:
Copy Code code as follows:
Grant permission on database object to user [identified by ' Password ']
The most commonly used, to get the master and
MyBatis is a Java Persistence framework that associates an object with a stored procedure or SQL statement through an XML descriptor or annotation.
MyBatis is free software distributed under Apache License 2.0, and is a branch version of Ibatis 3.0.
1. Use MyISAM instead of InnoDB
To be completely wrong or to refute a reason:
First of all, the original said MyISAM is used by default, and actually to the MySQL 5.5.x,innodb has become the default table engine.
In addition, the simple use of
When we use the traditional mysql_connect, mysql_query method to connect query database, if the filter is not strict, there is SQL injection risk, resulting in the site was attacked, out of control. Although you can use the mysql_real_escape_string (
This file contains the results of different benchmark tests.
The number in the after test result () represents the number of SQL commands executed in the exact test. A test can have a lot of different parameters, and here's just a rough look.
This paper discusses the way to improve the performance of MySQL database, and gives the concrete solution from 8 aspects.
1, select the most applicable field properties
MySQL can support a large amount of data access, but generally speaking, the
MySQL allows you to select columns from more than one table at a time. We'll leave this to the "Retrieving information from multiple Tables" section.
1. Specify the search criteria
To limit the set of records retrieved by the SELECT statement, you
The MySQL instance manager supports many command-line options. The Execute./mysqlmanager--help command can be simply listed. There are the following options:
·--help,-?
Displays a help message and exits.
·--bind-address=name
The binding address
1. Define
The MySQL query optimizer's job is to select the appropriate execution path for the query statement. The code for the query optimizer is generally variable, which is not the same as the storage engine. Therefore, you need to understand
Semi-consistent IntroductionFor those familiar with MySQL, or have seen InnoDB source of friends, may have heard of a fresh noun: semi-consistent read. What is semi-consistent read? The following paragraph, excerpt from the semi-consistent read
The cache is stored in an application table and applied by a hash value that includes the following factors, the query itself, the database currently being queried, the version of the client protocol, and other information that may affect the return
1. View the maximum number of connectionsShow variables like '%max_connections% ';2. Modify the maximum number of connectionsSet GLOBAL max_connections = 200;The following article is mainly to introduce you to the MySQL maximum connection number of
Transferred from: http://www.cnblogs.com/kissdodog/p/4173337.htmlMySQL is divided into regular users and root users. These two types of users have different permissions.First, the Authority tableWhen you install MySQL, a database named MySQL is
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