1) System Environment descriptionMYSQL 5.5 Master-slave node127.0.0.1:3306 main node, manual stop service for verifying master-slave switching effect127.0.0.1:3307 from Junction 1127.0.0.1:338 from Node 2, in order to verify the master-slave
Authorization, when the user is created, you need to authorize the user, MySQL is interesting in that it is for the user and host in pairs to authorize. That is, the same user is from a different host, and the permissions may be different.GRANT
Sometimes, when using MySQL, you may find that even though a table deletes a lot of data, the data and index files of this table are surprisingly small. This is because when MySQL deletes data (especially text and blobs), it leaves a lot of data
Recently depressed, the conversion between the underlying type and Java type is unclear, and by the way the information on the Internet lists some types to remindMysql1, integers:
MySQL data type
Meaning (Signed)
[MySQL FAQ] Series-What you don't know about the table is the full of those thingstime 2014-08-21 12:18:56 mysql Chinese web Originalhttp://imysql.com/2014/08/21/mysql-faq-howto-deal-with-table-full.shtmlTheme MySQL When we want to write new data
Get user nickname nickname with emoji expression, converted to character code is this form "\xf0\x9f\x91\x8d\xe6\x94 ...",The following error may occur with direct savecaused By:java.sql.SQLException:Incorrect string value: ' \xf0\x9f\x98\x84 '
Linux installation MySQL diagram (transferred from Baidu Experience)
1 Find out if MySQL was previously installed, use the following command:Rpm-qa|grep-i MySQLIf the following package is displayed, the MySQL is
1. Installing ApacheStart Apache with/etc/init.d/httpd startApache Default program Directory is/var/www/html2. Install MySQLYum-y install MySQL Mysql-serverStart MySQL with/etc/init.d/mysqld startMysql_secure_installation press ENTER to prompt to
Modify the MySQL configuration file my.cnf, the path is/ETC/MY.CNF
Write a line skip-grant-tables in the configuration file, save and exit after adding, as650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/79/74/wKioL1aR-HfzDOxdAAAZwP_l6kQ1
In other words, this installation of MySQL is really twists, did not expect such trouble. I installed it with Yum Source and first provided some things to install MySQL with yum.Must be well equipped with Yum source, yum source problems can be
ApacheAssume that the RPM package is installed. The installation path should be under the/ETC/HTTPD folderApache configuration file:/etc/httpd/conf/httpd.confApache Module Path:/usr/sbin/apachectlWeb folder:/var/www/htmlAssuming the use of source
Here's the code to export the stored procedure1 # mysqldump-u database user name-p-n-t-d-r database name > file name Where-D represents--no-create-db,-N for--no-data,-T for--no-create-info, and-R for export function and procedure. So the code above
Given what has been done recently, it is necessary to solve the problem of slow SQL, now add a little bit of SQL statement performance analysis of the explain !Comprehensive return data situation, analysis of the parameters, you can understand the
/* 1. First solve the Internet 1-1. Refer to the Networked status file # cd/etc/sysconfig/network-scripts # vi ifcfg-eth0 1-2. Edit the Networking form See figure 1-2 1-3. Restart Network # service Network Restart | /etc/init.d/network Restart 2.
TestUnlock the main MySQL first> unlock tables;Delete a table> Use db1; > show tables; > drop table help_category;Go and see it from MySQL.> Use db1; > Show tables;No help_category.///////////////////////////////////////////////////////////////////
Mysql databases are queried by day, yesterday, the first seven days, the last thirty days, the quarter, and the year. mysql databases are queried by thirty days.
Today, I spent some time sorting out the code for MySQL to find data for the current
100 MySQL adjustment and optimization tips, MySQL adjustment and optimization
MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 101 tips for adjusting and
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