My code is a large amount of data to improve paging efficiency test code --Improve paging efficiency: to achieve paging only read display data, you need to create a database in the database "testforpaging" Use testforpaging Go --Create TABLE
MySQL is a multithreaded, Structured Query Language (SQL) database server. SQL is the most popular database language in the world. MySQL performs very well, runs very fast, and is very easy to use. is a very good database.
Download
1.mysql User creation:shell> MySQL--user=root MySQLMysql> GRANT all privileges in *.* to monty@localhost identified by ' something ' with GRANT OPTION;
Mysql> GRANT all privileges in *.* to monty@ "%" identified by ' something ' with GRANT OPTION;
Web site backend database to MySQL, now use Perl to connect the database is much more convenient.
The Dbi,perl makes it easy to connect to a database:
#!/bin/perl
Use DBI;
# Connect to Target DBMy $dbh = Dbi->connect
Home can be found on the Internet are Redhat systems and so on, the Ubuntu system MySQL cluster does not introduce articles, I now write to write Ubuntu this MySQL cluster method. Novice don't scold me, hehe.
Introducing the network environment:
Even though we have powerful reporting tools like the Microsoft Crystal Report and other flexible customer management tools in our current era, Microsoft Excel is still the most common tool when analyzing sales statistics and revenue information.
MySQL for small and medium-sized sites, enough to use. Everyone knows that SQL (Structure query Language, Structured Query language), if you use other databases, you will find that SQL statements in MySQL usage is similar, not difficult to grasp.
As long as the description of several day-to-day use of the query can be optimized place, only special circumstances can be used, do not expect any circumstances are set up, optimization is a long process of practice!
Optimization of maximum and
I. BACKGROUND
Before I wrote about SQL Server data Migration Automation article: SQL Server database Migration folk prescription, in the previous article designed a temporary table, this temporary table records the relocation configuration
XA transaction support is limited to INNODB storage engines.
MySQL XA implementations are for external XA, where the MySQL server acts as a resource manager, and the client program acts as the transaction manager. "Internal XA" is not implemented.
Each MyISAM index file (. MYI) has a counter at the head that can be used to check whether a table is properly closed. If you get the following warning from check table or MYISAMCHK, this counter is already out of sync:
clients are using or haven't
Most server administrators know that the MySQL database management system (RDBMS) is a highly flexible software block with a wide range of startup options that can be used to modify related behavior. However, most people are not aware that standard
In some cases, MySQL can use the index directly to satisfy an order BY or GROUP by clause without having to do extra sorting. Although an order by is not exactly the same as an index, an index can be used, as long as the unused index portion and all
1. MySQL Username and password
* MySQL uses user names for authentication purposes, regardless of UNIX user name (login name) or Windows user name. By default, most MySQL clients try to log on using the current UNIX username as the MySQL username,
MySQL 5.1 employs an authentication protocol based on the password-mix algorithm, which is incompatible with the protocol used by the earlier client (before 4.1). If you upgrade the server to 4.1, connecting with an earlier client may fail with the
In the previous section, a cross-host Docker container cluster was built by using the overlay network. Below, in this cross-host Docker container cluster environment, build MySQL database cluster.MySQL master-slave automatic backup and automatic
Innodb_autoinc_lock_mode This parameter controls the behavior of the associated lock when inserting data into a table with auto_increment columns;It can be set to achieve performance and security (master-slave data consistency) balance"0" Let's sort
GitlabDatabase ExchangeMysqlDatabaseInstall first Mysql I'll take the test here . Yum installed a 5.6 of theEdit Yum.repo[Mysql56-community]Name=mysql 5.6Community
Common SQL Tuning Tips and SQL Tuning tuningtips
Create an appropriate index (refer to correct database index creation)
Replace OR with UNION (applicable to index columns)
Replace in and not in with exist and not exist
Do
SQL query optimizes the where condition sorting fields and the mysteries of using the index by limit. Strange slow SQL
Let's take a look at two SQL statements.Article 1:
Select * from acct_trans_log WHERE acct_id = 1000000000009000757 order by
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