23 precautions for using MySQL

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

Experience in solving 100% of mysql cpu usage

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

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.

How to install MySQL in Ubuntu Linux

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,

Beginners must read MySQL database FAQ Summary

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

Practical Methods for automatic MySQL database backup in Linux

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

MySQL database optimization (1)

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

Detailed analysis: an alternative method for backing up MySQL Databases

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

Detailed description of Mysql table creation and index usage specifications

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

Parse the information_schema database of MySQL

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,

Comparison of Two Methods for parsing database pages (comparison of row_number () over () and top)

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

The difference between parsing mysql binary logs to process transactions and non-transactional statements

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.

Mysql basics: Detailed description of mysqld_safe startup Execution Process

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]

Brief summary of Mysql backup and recovery and tee command usage

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

How to use memory in mysql Cache

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

How to parse Mysql multi-table queries

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

Parsing auto_increment in mysql

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

Discussion: How to query the currently running SQL statements in MySQL

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

Follow the step-by-step learning method of mysql optimization using the heat-resistance protocol.

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 steps

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

Total Pages: 3233 1 .... 3095 3096 3097 3098 3099 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.