MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limits. Here are 101 tips for adjusting and optimizing MySQL installation. Some of the techniques are specific to the
Wen/Ho DengchengGuide:The MySQL kernel technology researcher from the NetEase Research Institute, Ho Dengcheng, InnoDB the multi-version control (abbreviated: MVCC) of the MySQL database and the storage engine, doing in-depth research and detailed
Original: MySQL Writing timed task eventsScene:For example: A system, the user can only have one time a day of the lottery, after the day can not be smoked, but after 24:00 points after the user to re-own a lottery opportunity. a task like this,
1. install linux
I will introduce the FTP installation method here. The installation method in this way is faster than the installation from CDROM, and
You cannot continue the installation because you cannot read the CD during the installation
1. Local backupCompile an automatic backup script:Vim/var/lib/mysql/autobakThe content is as follows:
Copy codeThe Code is as follows: cd/data/home/mysqlbak
Rq = 'date + % Y % m % d'
/Usr/local/mysql/bin/mysqldump sqldb -- flush-logs-uroot-p123456 --
The following articles mainly introduce the disadvantages of MySQL indexes and the actual operations of MySQL indexes, which deserves our attention, we may not know that using indexes too much will cause abuse. Therefore, MySQL indexes also have
// If no data exists, insert new data
$ SQL = "INSERT INTO {$ ecs-> table ('cat _ lang ')} (cat_id, lang_id, cat_name, keywords, cat_desc)
VALUES ({$ cat_id}, {$ k}, '{$ val ['cat _ name']}', '{$ val ['keyword']}', '{$ val ['cat _ desc']}')
On
Copy codeThe Code is as follows: DELIMITER $
Set @ stmt = 'select userid, username from myuser where userid? And? ';
Prepare s1 from @ stmt;
Set @ s1 = 2;
Set @ S2. = 100;
Execute s1 using @ s1, @ s2;
Deallocate prepare s1;
$
DELIMITER;
For a query
The following articles mainly introduce MySQL stress testing tools. We all know that the application rate of MySQL databases is not low in practice, and MySQL databases are generally used in small and medium-sized enterprises, the following articles
On April 9, September 11, I attended the technical salon MySQL performance optimization and spatial database development practices jointly held by infoq and Baidu. the content shared by Liu Bin from Baidu is very helpful to those who are currently
How to run the script in mysql. Taking running niuzi. SQL as an example, mysqlniuzi. SQL
Suppose you want to run the Script: F: \ hello world \ niuzi. SQL
Method 1:In the command line (Database not connected), enter mysql-h localhost-u root-p
One-Click Reset mysql root Password script, mysqlroot
@ Echo off title mysql: find the installation path of mysqlfrom the registration table and write the file mysql.txt reg query HKLM \ SYSTEM \ ControlSet001 \ Services \ MySQL | find/I "ImagePath">
1. Install cmake
MySQL 5.5 and later versions have been replaced by the cmake tool./configure compilation and configuration method.
Therefore, we must first compile and install the cmake tool in the system source code.
# Wget
To implement a mysql proxy, we need to understand and implement the mysql communication protocol first. In this way, the proxy can be used to build a bridge between the client and the server.Mixer mysql protocol implementation mainly refer to
When MySql is started in windows 7, the error Table 'mysql. plugin 'doesn' t exist solution: 64-bit Windows 7, install mysql5.27 _ win64, and customize the installation to D:/database/mysql. In the last step of initialization, the configuration file
Mysql character set and verification analysis use case first let's look at an example: there is a user table www.2cto.com User (username VARCHAR (5) character set utf8COLLATE utf8_general_ci); There is a record ('username '); and ('username'); Use
Solution for MySQL to forget the root password: www.2cto.com 1. if you forget the MySQL root Password, use the following methods to reset the password: 1. KILL the MySQL process in the system; killall-TERM mysqld 2. run the following command to
What is database/table sharding technology I. Overview table sharding is a popular concept. Especially under heavy load, table sharding is a good way to distribute database pressure. First, you need to understand why Table sharding is required. What
SQL union all usage and example tutorial, and SQL union all efficiencyThe UNION operator is used to merge the result sets of two or more SELECT statements.
UNION combines multiple tables (or result sets) and returns them as a single result set;Union
1. Export data.
First, describe your environment: Mac OS X 10.8.3, MySQL Community Server 5.6.10, and MySQL Workbench 5.2.47.
I want to migrate the data in the local database to another machine, so I used the import/export function in Workbench to
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