MySQL Explain detailed explain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements. Using the method, add explain to the SELECT statement: such as:
Example: Prepare two virtual machines, system CentOS6.5 mysql free compile source packageNaming two hosts in master and slave;master:192.168.3.116slave:192.168.3.251 (Address please configure according to the actual situation)Download and
The following is personal understanding, if there are errors, but also to correct!!Most of MySQL's transactional storage engine is not a simple row-level lock, based on the promotion of concurrency performance considerations, they generally
NGINX:rpm-ivh http://nginx.org/packages/centos/7/x86_64/RPMS/nginx-1.8.0-1.el7.ngx.x86_64.rpm View: Yum Info nginx Installation: Yum install nginxservice nginx start mysql:CentOS 7 in the Yum source does not seem to install the MySQL mysql-sever
1. Mysqld-install; Load MySQL2. net start MySQL; Start MySQL3. Create DATABASE student; Create a database4. Show databases; View all Databases5. Use student; Using the current database6. Describe student; View Header Detail Information7. mysql>
The strength of the password was enhanced in MySQL 5.6, and the Validate_password plugin was introduced. Support for password strength requirements.This plugin requires version: 5.6.6 or laterInstallation method:1. Install the plug-in: (By default,
(1) Kill all MySQL connection processesFor i in ' mysql-uroot-pzhangyun-bse ' show Processlist | Grep-v "Show Processlist" | awk ' {print '} 'DoMysql-uroot-pzhangyun-e "Kill $i"DoneNote: The show processlist process of its own command is filtered
See a realityThere is a bank account formCREATE TABLE Account(ID int primary KEY,Balance float);Now there is a PHP program , to complete the 1 yuan, go to 2 Number on the accountPHP $mysqli=NewMysqli ("localhost","Root","hsp123","Test");
Database Basic TypesChar fixed-length string char (10) memory two-bit 10-bit query has advantagesvarchar variable-length string varchar (10) Two-bit two-bit storage advantageEnumeration type can only take oneThe set type can take multipleBinary type
What is a triggerSimply put, a table has something (INSERT, delete, update operation), and then automatically trigger the execution of several pre-written SQL statements;Features and functionsFeatures: The action that triggers the event and the SQL
Precautions:As long as the following 4 points, 2 MySQL can be installed simultaneously to a machine PS: Can extrapolate, a machine as long as you load enough, want to install a few can. Here are 2 examples:My test server is configured to 2 6-core
# Check the MySQL server system process ~ Ps-aux|grep mysqlmysql 1103 0.0 0.3 492648 51780 ? SSL 14:04 0:21/usr/sbin/mysqldsharon 15918 0.0 0.0 15940 968 pts/4 s+ 21:36 0:00 grep--color=auto mysql# check MySQL server
To create a user:' username '@'host'password';Description: username– You will create the user name, host– specifies which host on which the user can log on, if localhost is available to local users, you can use the wildcard% if you want the user to
With regard to the benefits of MySQL indexing, if the correct design and use of the indexed MySQL is a Lamborghini, then no design and use of the index of MySQL is a human tricycle. For tables that do not have an index, a single-table query might be
Install mysql5.6 today, as soon as this step to report the following error. Originally tried to add the-fpic parameter, but did not know where to go 650) this.width=650; "title=" Image () "style=" border-top:0px; border-right:0px; border-bottom:0px;
MyCAT log analysis and mycat log
MyCAT logs cannot be obtained for running information about MyCAT. For example, if MyCAT adopts read/write splitting, how does MyCAT execute a query statement, and which node each shard is distributed.
The default
Mysql database lock causes and solutions, mysql database
A database is a shared resource used by multiple users, just like an operating system. When multiple users access data concurrently, multiple transactions can access the same data
[MySql learning experience], mysql learning experience
1. Install MySql
1. Install the decompressed version
:
Http://dev.mysql.com/downloads/mysql/
Installation and configuration Tutorial:
MySql5.5 What should I do if I forget the root password? mysql5.5root Password
When mysql5.5 is used, suddenly the root password is forgotten. Why can't I log on? It's very anxious. What should I do? This article describes how to solve mysql5.5's
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