System environment:
CentOS 6.5/7.0 x86_64
Fedora x86_64
Brief introductionPercona server is a derived version of MySQL, focusing on improvements to MySQL database server under Linux/bsd, with a significant improvement in
Read the connection string from the action profile properties, the data connection through the string, you need to write three files where two are Java classes, one is a file with the suffix. Properties, and the file is placed under the SRC working
N in Int (n) is not a restricted field, the range of values for int is fixed (0 to 4294967295) or (-2147483648 to 2147483647)Then n this value is for zero when the value in the field is insufficient, but must contain zerofill, for exampleCREATE
MySQL Cluster is a high-utility, high-redundancy version of MySQL suitable for distributed computing environments. It employs the NDB Cluster storage engine, allowing multiple MySQL servers to run in 1 Cluster. MySQL Cluster is a technology that
Constraints* The constraint is added to the column, to constrain the column!1. PRIMARY KEY constraint (unique identifier)Non-empty * * *Unique * * *Quoted * * * ** When a column of a table is designated as the primary key, the column cannot be empty
Reprint:http://www.itokit.com/2012/0515/73932.htmlWhen the server is put on the LAN for testing, the database access speed is still very fast. However, when the server is placed outside the network, the database access speed becomes very slow.Later
Directory
One, get the total number of processes under MySQL user
Second, host performance status
Third, CPU utilization
Four, disk IO volume
Five, swap volume [memory]
VI, Database performance status
Seven, QueryLog
MySQL Character set problem is mainly two concepts, one is character sets, one is collations, the former is the character content and encoding, the latter is the former to compare the rules of the operation. These two parameter sets can be specified
MySQL performance tuning and architecture design--1th chapter MySQL Basic introductionPreface:As one of the most popular open source database software, MySQL database software has been widely known. But in order to take care of the readers who are
Category: 4. Software Design/Architecture/testing 2010-01-08 17:48 5635 people read reviews (3) favorite reports Loadrunnermysql script Database SQL Server TestRecently did a few weeks of loadrunner test, have some experience, recorded, in order
Reprint Please specify source: http://blog.csdn.net/l1028386804/article/details/468331791 overview
MySQL Cluster is a highly practical, scalable, high-performance, high-redundancy version of MySQL for distributed computing environments, and
Password Not forgottenMethod One:Outside the MySQL system, use the Mysqladmin# mysqladmin-u root-p Password "test123"Enter Password: "Enter the original password"Method Two:By logging in to the MySQL system# mysql-uroot-p Enter Password: "Enter the
Original link: http://www.cnblogs.com/c840136/articles/2388512.html A new feature is introduced in the mysql5.1.x release, which, as the name implies, is an event, timed task mechanism that performs a specific task within a specified time unit, so
Mysql to prevent repeated insert record summary, mysql to prevent insertion Summary
Summary of methods for preventing repeated insert records in mysql
There are many methods to prevent repeated inserts of records in mysql. ignore, Replace, and on
Percona utility-Introduction to pt-kill, perconapt-kill
Pt-kill is an excellent tool for kill MySQL connection and is part of percona toolkit, when the maximum number of connections is exceeded due to a large number of idle connections and a
MySQL Workbench usage (image and text ),
MySQLWorkbenchIt is a visual database design tool recently released by MySQL AB. This tool is a dedicated tool for designing MySQL databases.
: Http://www.bkjia.com/database/29494.html
MySQLWorkbench has many
Open Source Distributed Database middleware MyCat source code analysis series, middleware mycat
MyCat is an open-source Distributed Database middleware that is currently very popular. It has spent some time researching its implementation methods
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