Put it here for later inspection.1. Database, database server, database languageA database is a collection of persistent data that is used by an enterprise's application system and managed by a database management system;Database server, also known
This address: http://www.cnblogs.com/yhLinux/p/4036506.htmlSet the relevant options in the my.cnf configuration file and change to the corresponding character set.Set Database Encoding (sudo vi/etc/mysql/my.cnf):[Client] default -character-set = utf8
1. Practical Experience SectionOracle--->mysqlNumber--->int (12)Number (12,2)--->decimal (12,2) or float (12,2) or double (12,2)VARCHAR2--->varcharCLOB--->blob DATE--->date (or datetime)Oracle: Long can store 2G size characters, CLOB can store 4G
MySQL Insufficient disk space errorThe disk space is full and cannot be written in.141020 the: $: -Mysqld_safe starting mysqld daemon with databases from/alidata/server/mysql-5.6. -/Data the-Ten- - the: $: - 0[Warning] TIMESTAMP with implicit the
5.21 DB-015.22 DB-025.24 Virtual IP (cannot be the actual IP) + + Select VIPKeepalived Installation and ConfigurationInstalling keepalivedOn the 5.21:wget 650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/
Tcmalloc analysis of MySQL performance optimizationAuthor:echo Chen (Chenbin)Email:[email protected]blog:blog.csdn.net/chen19870707Date:october 10th, 2014Although the study found that Tcmalloc is not suitable for our existing game framework, but the
Database relies on the primary key, which is the cornerstone of the database physics model. There are only two uses of the primary key at the physical level:Uniquely identifies a row.As an object that can be effectively referenced by a foreign
Inux platform and Windows platform MySQL restart methodThe correct way to restart MySQL under Linux:1. mysql installed via RPM packageService mysqld Restart2. mysql installed from the source packageLinux shutdown mysql Command$mysql
Remember the MySQL data file operation experience want to get the latest information of a project, do function upgrade use, back up a copy of data also as local test data, file a bit large, I directly through the remote phpMyAdmin program export,
The binary log records all changes to the database so that any Slave can keep the data consistent by executing the Master binary log. The binary log contains only statements that may alter the database. Statements that are not yet possible to alter
Method One (stored procedure implementation):BeginDECLARE cnt INT DEFAULT 0;Select COUNT (*) into CNT from user;Set cnt = Round (cnt*0.9)-1;SELECT * from user limit CNT, 1;EndMethod two (direct query, only when the query permissions can be
The distinct (STR) function is used to remove duplicate records, but it is only possible to repeat for a certain field. For example: SELECT DISTINCT (name) from TableName; However, if you want to query the records of other field values, I started
Do not restart to modify the MySQL root password--------------------2014/09/28First, generally forget the password solution, need to restart MySQL1, Skip-grant-tablesOur common approach is to use the Skip-grant-tables option, and MYSQLD server does
To add a field: ALTER TABLE ' User_movement_log 'Add column Gatewayid int not null default 0 after ' RegionID ' (which field is added later) To delete a field: ALTER TABLE ' user_movement_log ' drop column Gatewayid To adjust the order of fields:
1, there are error prompts,
Slave I/o: Error connecting to master ' [email protected]:3306 '-retry-time:60 retries:86400, error_code:1045
WorkaroundRemove all binary log files from the server, including a master.info file
Mysql table names in linux/centos are case-insensitive.Scenario: Recently, the company switched the database from ORACLE to MYSQL. Since the table names in ORACLE are case insensitive, the problem of table names not found in mysql occurs, it is
For the locking mechanism of the MyISAM engine
This article describes the knowledge about the MyISAM engine locking mechanism in the mysql database. For more information, see.
This section describes the locking mechanism of the MyISAM engine.
In
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