1. master server configuration file# for advice The change settings# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html[Mysqld]# Remove Leading # and set to the amount of RAM for the most important data# Cache in MySQL. Start
Today, all MySQL slave replication from the server is abnormally interrupted, landed on one of the platform to execute show slave status\g, found the following error:--Last_error:error ' Operation DROP USER failed for ' guest ' @ ' localhost ' on
Installation configuration and uninstallation of MySQL:Installation:(1) Put the green version of MySQL free install package on the D drive, the command line into the MySQL green version of the bin directory after decompression:CD D:\mysql-5.6.35-win3
I had two problems writing a collection today.1. MySQL server has gone away2. Maximum execution time of seconds exceededThe capture program is written to run about a minute after the MySQL server has gone away, found that MySQL inside the
Many online configuration tutorials, I also refer to other people's tutorial completed, mainly encountered the following several issues, if someone later met the same hope to write a hint to you.1.MY.CNF file ConfigurationThe server_id configured in
Original address: http://www.jb51.net/article/43306.htm1. View MySQL Execution planSELECT * from where STATUS<>4;2. Information contained in the execution plan(1). IDMeaning, indicating the order of the select sentence or action table.Eg1:id the
1.select_type Simple: It represents a single select, with no union and sub-queryDependent union:union dependent outer-layer queryDependent subquery:subquery dependent outer-layer query2.typeSystem: Table has only one row, this is a const type of
If the two table is associated with a field that is not set in the table structure, it cannot be used even if the index is set.For details, please refer to:Https://yq.aliyun.com/articles/69138?spm=5176.100239.bloglist.185.xQpeswFor MySQL explain,
##############################2017-08-08 notesFirst, optimize the part1. Tuning of operating system parameters2. Database Parameter tuning3. Firewall settings, etc.#############################Second, the installation part1. Create users and Groups#
MySQL TransactionMySQL transaction is mainly used to deal with large-scale and high-complexity data. For example, in the Personnel Management system, you delete a person, you need to delete the basic information of the person, but also to delete the
For data optimization, choose the most appropriate data type, not the largest.
Plastic
TINYINT: Signed Value-128-127 (250)
Unsigned value 0-255accounts for 1 bytes;2.SMALLINT: Signed Value-32768-32767 (60,005)Unsigned
Background: Full Library backupBackup process:1. Generate DB list, write DB name to file2. Define the backup function and write the result to the SQL file3. Compress files to reduce disk usage4. Set the number of days to retain, periodically delete
Creating a table is a simple way to create a table person (number INT (11), name VARCHAR (255birthday DATE), or create TABLE IF not EXISTS person (number INT (11), name VARCHAR (255), birthday DATE); View MySQL CREATE table: Copy code show create
Linux Installation Mysqllinux NetworkingIP A View network informationModify/etc/sysconfig/network-scripte/ifcfg-eth0Onboot value of the file, no change to YesTo restart the Network service:Service network restart//or compare the original
Detailed description of MySQL master-slave replication read/write splitting, detailed description of mysql master-slave read/write
MySQL Master/Slave settings
MySQL master-slave replication, the read/write splitting settings are very simple:
Modify
Configure MySQL 5.7 and mysql Database Service on Windows
Including the process of initializing the root user password and two Common Problems
1. Download the MySQL zip package
Go to [MySQL official website] (http://dev.mysql.com/downloads/mysql)
Mysql 5.7 is a simple method for changing passwords.
This is the official website. After mysql5.7 is installed, a default password will be generated, saved in mysql. log, found it, and changed
Official Document address
Https://dev.mysql.com/doc/
Solve the problem that Mysql cannot contract because the transaction log and log file are too large.
1. ms SQL SERVER 2005
-- 1. Clear logsExec ('dump TRANSACTION database name WITH NO_LOG ')-- 2. truncate transaction logs:Exec ('backup LOG database
MySQL lock Processing Analysis and mysql lock Processing Analysis
MySQL/InnoDB Lock analysis has always been a difficult topic. During my work, I often ask questions from my colleagues. At the same time, Weibo often receives MySQL lock-related
Spring integrates mybatis to implement mysql read/write splitting and mybatismysqlPreface
When the number of website users reaches a certain scale, the database becomes the bottleneck of the website because of the high load pressure. Fortunately,
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