Basic principles:
Smaller is usually better: consumes less disk memory and CPU cache.
Simple: For example, shaping is less expensive than character type. Use date types to store dates instead of strings. Use shaping to store IP
MySQL database-One of the foreign key lists is moreOne of the foreign key linked lists is moreForeign key linked list: is a table through the foreign key to join the primary key of table B, the establishment of a linked list relationshipOne-to-many:
Transferred from: http://blog.csdn.net/hotdust/article/details/51524469FromHttp://www.2cto.com/database/201303/193062.htmlHttp://www.itnose.NET/detail/6399027.htmlThere are two ways to unlock the state of a deadlock:The first type:1. Check if the
This article translated from: https://dev.mysql.com/doc/connector-python/en/SummaryThis manual describes how to install and configure MySQL Connector/python,mysql Connector/python is a standalone driver for Python and MySQL services to communicate,
Tag: Client timeout invalid calling SQL statement APT Comm begins beginFirst, you need to add MySQL-related references in C # inusing MySql.Data.MySqlClient;Second, connect MySQL, create a Connection object, and then open its start objectNew
Export:The following command-line specific usage is as follows: Mysqldump-u user name-p password-d database name name Script name;1, export the database to DBNAME table structure (where the username is root, password is dbpasswd, the generated
1. Create a database
CREATE {DATABASE | Sehema} [IF not EXISTS] db_name [[DEFAULT]] CHARACTER SER [=] Charset_name
{} 2 is selected[] is optional
Creating a Text1 database directory create databases Text1;
Creating a
IntroducedUse Zabbix's low-level auto-discovery function to complete single-host multi-port monitoring, see low_level_discovery, the overall monitoring of percona-like Zabbix monitoring plug-ins, but with the mymonitor.pl replacement of the script
In fact, MySQL default maximum number of connections is 100, may be in the large amount of time caused by the connection is not on the database. The solution:1. If your MySQL database uses the my.cnf file configurationLocate the file/etc/my.cnfThe
1. Information_schemaINFORMATION_SCHEMA is the MySQL information database.The library is able to view MySQL database, table below. permissions, and other information.This library is generated by default in the database. Information_schema is
One, try not to be a word database do operations1, try not to do the database operation,2, move the complex operation to the CPU3, apply MySQL as simple as possibleSecond, the Control table data volume1, Pure int no more than 1000w2, with char not
MySQL Learning notes- custom functions1. Introduction to Custom FunctionsCustom functions: User-defined Functions (user-defined function,udf) are a way to extend MySQL, using the same functionality as built-in functionsTwo prerequisites for a custom
mariadb10.x installation mode is Yum, when you enable Gtid replication, you are prompted to Mysql.gtid_slave_pos solutions that are not foundThe cause is unknownSolution:/usr/share/mysql/mysql_system_tables.sql is a script that creates system
Mac installation MySQL is not as intelligent as win (no brain), but also requires some configuration steps. Online tutorials are not specific enough to find a few integrated to install, so leave a mark, help others reduce the time loss:1. Go to the
The difference between char and varchar:1) Range of values:Char: Value range: 0~255VARCHAR: Range of values: 0~655352) space occupancy and speed:Char: fixed-length string, large space-intensive, fast, generally used for the constant-size form
And then the previous writeSelect a special columnFor a chestnut: I want to give these pet people a day, I need to know the names of pet and their birthdays. What am I going to do?The operation is as follows:SELECT name, birth from pet;mysql> SELECT
MySQL function library, this library is an external function library! This function provides common functions for working with MySQL databases, such as connecting to a MySQL server, opening a database, executing SQL statements, and so on. So the
1. The current Nginx adoption is the source package installation method (Yum installation failed),: http://nginx.org/en/download.htmlMy installation package here is: nginx-1.12.0.tar.gz2. Before installing Nginx, I need to install Pcre, the Pcre
Installing MySQL under CentOS is really not as easy as it is imagined, here I summarize the problems encountered1. ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)This problem typically occurs
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