The tutorial of helping customers use MySQL (www.bkjia.com) is worth noting. The following are 23 notes for MySQL:
1. If the connection between the client and the server needs to span and pass through an untrusted network, you need to use an SSH
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
Notes for beginners when using MySQL (download | for Linux:
1. If the connection between the client and the server needs to span and pass through an untrusted network, you need to use an SSH tunnel to encrypt the communication of the connection.
2.
Install MySQL
Sudo apt-get install mysql-server
This should be very simple, and I don't think there is much problem with the installation, so I will not talk about it much. Let's talk about the configuration below.
Configure MySQL
Note: In Ubuntu,
1. Question about re-assigning the initial value of an auto-increment field? ALTERTABLEtblAUTO_INCREMENT = 1; 2. How to Implement the function of adding fields in mysql? Createtableabc (idint (10) notnullauto_incremnetprimarykey, Namevarchar
Regular MySQL backup is an important task, but manual operations are too cumbersome and difficult to avoid any omissions. You can use the following method to regularly back up data.◆ 1. Create a backup folder# Cd/www# Makedir backup◆ 2. Compile the
The database optimization tutorial of the Helper House (www.bkjia.com) is very complicated, because it requires a good understanding of system optimization. Although the optimization effect is good if you do not know much about the system or
Using MySQL for database backup has a very regular database backup method, which has the same concept as other database servers, but have you ever thought about it, mySQL will have a simpler backup method using the file directory, and it will be
1. When creating a MySQL table, the field must be set to a non-empty value and the default value of the field must be set.2. When creating a MySQL table, if the field needs to be NULL, you need to set the default value of the field. The default
The information_schema database is generated after mysql 5.0. A virtual database does not exist physically.The information_schema database is similar to the "Data Dictionary" and provides a way to access database metadata, that is, Data. For example,
Today, the teacher gave me a review of the pages in the database. In general, today is a good day, because I have not forgotten what I learned before. Now, go to the topic,First, let's talk about the top method.The top method is to remove the data
During the execution of transactional statements, the server will perform additional processing. When the server executes multiple transactions in parallel, in order to record them together, the concept of transaction cache needs to be introduced.
The basic process of mysqld_safe script execution:1. Search for basedir and ledir.2. Search for datadir and my. cnf.3. Check my. cnf. For details about the options, see the annotations in the attachment.4. parse the groups [mysqld] and [mysqld_safe]
Backup Data method:I. SQL statements.Locks tables tablename READ; // READ lockBefore trying to LOCK a table, lock tables is not TRANSACTION-safe. It implicitly commits all active transactions and starts a TRANSACTION implicitly (for example, start
2 points firstEnabling cache also brings about overhead, mainly in the following aspects:Before starting the query, you must check the cache.If the query is cached but not in the result set, saving the data after the result is generated will incur a
Query is the core of the database. The following describes how to implement Mysql multi-Table query. If you have encountered any problems in Mysql multi-Table query, take a look.Mysql multi-Table query:Copy codeThe Code is as follows:Create table if
When I visited the Forum today, I found a seemingly simple problem, but it attracted wide attention:This is a very early interview question:A table contains an ID auto-incrementing primary key. After 17 records are inserted, records 15, 16, and 17
Run the status command to view the Slow queries item. If the value is greater than 0 for a long time, the query execution time is too long.Copy codeThe Code is as follows:Reference content is as follows:Mysql> status;--------------Mysql Ver 11.18
In the second set
1. show status like 'com % 'is equivalent to show status session like 'com %' for a hundred years -- display the current console statusShow global status like 'com % '-- displays the number of times the database has been started
MySQL master/Master synchronization Configuration
Server Name
IP
System
MySQL
Odd.example.com
192.168.1.116
Rhel-5.8
5.5.16
Even.example.com
192.168.1.115
Rhel-5.8
5.5.16
Assume that the
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