Now that you see this article, you must know what PHP and MySQL are all about, I will not be wordy. But why do you continue to read this article? It may be that you used to copy and paste some code, and did not really understand the meaning of the
Show tables or show tables from database_name;Explanation: Displays the names of all tables in the current databaseshow databases;Explanation: Displays the names of all databases in MySQLShow Processlist;Explanation: Displays all the processes that
The learning of SET statements:Practice of defining User variables using SelectChange the following statement to the form of select:Set @VAR = (select sum (amount) from penalties);My changes:Select @VAR: = (select sum (amount) from penalties);I can
Author:skateTime:2015/01/19MySQL Cluster global listUsage:# monrep-hUsage:monrep [-D dbname]-D Database Cluster name-H Display Basic Help#For example, one of my clusters is called DBX, which is used as follows:# monrep-d DBXPurpose of implementation:
1. Table DesignFollowing the three paradigms, but when necessary to do data redundancy, for example: In the permissions model may use 5 table User table, Role table, permission table, as well as User Role association table and Role Permission
Method 1: Use the Set password commandMysql-u Rootmysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');Method 2: Use Mysqladminmysqladmin-u root Password "Newpass"If Root has already set a password, use the following
I'm going to do a high-availability MySQL recently. Make sure that the data in the two databases is consistent with the MySQL master replication method. Combined with LVS and keepalived (Keepalived+lvs's settings will be written in a separate
Setup method:Step one setA service suit (192.168.1.43) user is backup, 123456, synchronized database is test;B Service Suit (192.168.1.23) user is root, 123456, synchronized database is test;Step Two configuration Mysql.ini:A server#Replication
Specific procedures:Turn off MySQL:1 # service mysqld stop(If the service command does not exist, CD/ETC, execute mysqld stop) Then:1 # (sudo) mysqld_safe--skip-grant-tables(after the command completes, the terminal may not prompt for the next
1.mysql master-Slave configuration Slave I/o: Fatal error:the Slave I/o thread stops 2013-10-09 12:37:33Category: LINUXSlave I/o: Fatal error:the Slave I/O thread stops because master and Slave have equal MySQL server UUIDs; These uuids must is
1. connect to the server through the shellSsh-l root-p Port IPAfter entering the password, enter the server 2, Create a folder where database backup data resides mkdir/mysql/mysqldata_backup 3. Create and edit filesVi/usr/sbin/bakmysqlThe
Shell> mysql-uroot-p//root user connection to MySQL, default password is emptyNote: Most of MySQL commands need to be ";" (semicolon) end, not sensitive to capitalization!mysql> show databases; Show Database listMysql> use database name//select the
Why does the title have to be named? Commen sence refers to things everyone should know, but often people will be slightly more of these things, or to these things smattering, today I summarize my own in MySQL encountered some commen sense types of
Log information:INFO 2015-01-13 10:44:36,078 org.springframework.beans.factory.xml.XmlBeanDefinitionReader:Loading XML bean Definitions from class path resource [Org/springframework/jdbc/support/sql-error-codes.xml]INFO 2015-01-13 10:44:36,140
MySQL Trigger TriggerTrigger (Trigger): Monitors a situation and triggers an action.Trigger creation Syntax four elements: 1. Monitoring location (table) 2. Monitoring Events (Insert/update/delete) 3. Trigger Time (After/before) 4. Trigger Event
Processing of full space of MYSQLibdata1Disk Space cleaning of MYSQL server in Chengdu2.7.1 project nameChengdu Project2.7.2 Problem Description90% disk space2.7.3 impact ScopeScheduled downtime2.7.4 Problem AnalysisThe disk space of the database is
View and add table partitions in MYSQL
View and add table partitions in MYSQL
1. View table partitions
SELECT partition_name part, FROMWHERE
2. Add Table partitions
Alter table td_sendmessagelog add partition ( PARTITION p20150210 VALUES LESS THAN (
MySQL backup script based on Innobackupex
Innobackupex is part of Xtrabackup, and its essence is to call xtrabackup. The main difference is that Xtrabackup not only supports the innodb engine, but also supports the xtradb engine. This article mainly
Mysql usage highlights
1. Environment: windows, MySQL Server 5.5, Navicat forMySQL
2. Mysql common SQL statements
SQL classification:
DDL-Data Definition Language (CREATE, ALTER, DROP, DECLARE)
DML-data manipulation language (SELECT, DELETE, UPDATE,
Configuration items I have adjusted to improve mysql PerformanceSkip-external-locking: skips the external lock. To understand this parameter, you must first understand external-locking (external locking is used to lock the MYISAM data table under
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