After installing MySQL, the default boot will not start automatically, you need to manually set up MySQL let it boot from boot.First, with the Chkconfig command to see if MySQL is not in a manageable list, the command is:Chkconfig--listMessagebus
Pre-array Recycling production account access range, that is [email protected] "%" of the account naming method, modified into a number of front-end application deployment of the machine IP as the standard, modified to [email protected] "IP address."
MySQL Performance optimization Related:To view a running SQL process:# mysql-u root-p ' xxxx '-e "show processlist;"Generally sleep too much will consume higher CPU and other resources# mysql-u root-p ' xxxx '-e "show processlist;" | grep Sleep | Wc-
Index overview
1) All MySQL column types can be indexed and using indexes on related columns is the best way to improve the performance of select operations.2) Depending on the storage engine, you can define the maximum number of indexes and
One, MySQL storage engine Second, how the storage engine chooses
Whether the transaction is supported
Retrieving and adding speed
Lock mechanism
Cache
Whether full-text indexing is supported
Whether foreign keys are
Record itOriginal: http://www.rjfw.com.cn/qamain/prevView.action?id=40482017200000031MySQL master-slave configuration (clear idea)MySQL master-slave configuration. My humble opinion is tested in the following environment:Operating system where the
To connect to a database:$con = mysql_connect (server address, user name, password);Select database:$select = mysql_select_db (database name);$select = mysql_select_db (' user ');To close the database:mysql_close (variables connected to the database)
MySQL settings variable is in the My.cnf file, after modifying the configuration file will need to restart the MySQL service to take effect. But on-line server is not allowed to restart the random, we can use the command to directly modify the value
Xtrabackup at the time of the backup while reading the Redolog and bin-log position, and finally apply the Redolog to the database file, it is possible to implement the hot standby machine, do not lock the table to synchronize the master data to
Read Catalogue
What is a view
Properties of the View
The role of the view
Use occasions
View instance 1-Create view and query data operations
View instance 2-delete and change data operation
Other
What is a
First, FOREIGN KEY constraintsEnsure the integrity of the data.To define a FOREIGN KEY constraint:Foreign keys can be defined directly in the CREATE statement foreign key current table name (field name) References target table name (primary key of
There was a problem starting up after the binary installation (MySQL is installed under/APPLICATION/MSYQL):[[email protected] bin]#/etc/init.d/mysqld startStarting mysql.170320 22:21:51 Mysqld_safe the File/usr/local/mysql/bin/mysqldDoes not exist
1.1 RequirementsDatabase 3 million user data, traverse get all users, various combinations associated, get to a new JSON, save to Redis.1.2 DifficultiesDatabase is much more, it is impossible to single-threaded query all the data to memory.1.3
About MySQL startup item, listen to its name and know its meaning. is to import a VBS script into C:\Documents and Settings\All users\"Start menu \ program \ startup, if the administrator restarts the server, then it will automatically invoke the
Recently started to learn MySQL, because the school is a bit miscellaneous, to my head, to clarify the idea for a long time ....Now just a little thought, first write down for everyone to refer to, in fact, only me haha haha ~ ~ ~I use the Express
The master-slave server describes more than one server, which requires MySQL to connect remotely, soRememberOff firewall off firewall shut down firewall1, the master-slave server for the following actions :1.1. Consistent version1.2. Initialize
Environment Description:Red Hat Enterprise Linux Server Release 6.5Mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz1. Create users and Groups:[[email protected] ~] - + MySQL [[email protected] ~] - -p MySQL2. Create the installation package upload
Multi-Table query and Table query
Multi-Table query1. Category:* Merge result sets (understanding)* Connection Query* SubqueryMerge result set* The table to be merged is required,The column type is the same as the number of columns.* UNION: removes
Mysql date and character conversion, mysql date conversion
Today, I found some usage of the MySQL database date conversion function on the Internet. Here I will record it:
Mysql date and character conversion
Date_format (date, '% Y-% m-% D ')-----
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