MySQL

MySQL log type has slow query log, binary log, error log, by default, the system only open the error log, because the open log will produce a large IO performance consumption.  Generally, the build system rarely opens the binary log (bin log), the

When Innodb_flush_log_at_trx_commit is set to 0, the log buffer is written once per second to the log file, and the log file is refreshed with disk operations, but no action is taken on a transactional commit. When this value is 1 (the default),

1 as a company needs to, the offline database needs to guide several data to the online database every few hours2 3[[email protected] BBS]#Rpm-qa | grep "expect"4Expect-5.44.1.15-5. el6_4.x86_645If there is no Yum-y Install expect6 71, SSH mapping8

Original: Two easy-to-ignore MySQL knowledgeWhy 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

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

Chengdu MySQL Server disk space cleanup2.7.1 Project NameChengdu Project2.7.2 Problem DescriptionDisk space 90%2.7.3 Impact RangePlanned downtimeAnalysis of 2.7.4 problemsDatabase disk space is full, view is log file causes2.7.5 SolutionsFirst, the

After installing MySQL in Linux after the error, just beginning to think that there is no password problem, in accordance with this article has been modified: Linux under the first login modified password modified should be correct, but again to

1, first to the MySQL official online to find;Website: http://dev.mysql.com/downloads/Discover the Yum MySQL repot option:2. Find the MySQL yum repo address in the URL above:http://dev.mysql.com/downloads/repo/yum/3. Find the need for a specific

Condition: ::: Table First (A: keyword), table later (b: field containing keyword a)question: : In table First, a as a keyword in table later, the number of B query bar, respectively, each keyword a corresponding table later B contains the number of

A php+mysql system, MySQL database has a user table, which has a code field, the type is int (11), this field is to save a random number, used to retrieve the password when the validation, the default value is 0.Retrieve password when the step is,

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

A while ago that QT release use MySQL program drive problem make big head (actually should be oneself too weak), get a few days also did not fix, give up is with that, tear collapse, reluctant. These two days to see how connectc/c++ use.Still old,

Two easily overlooked mysql knowledge, ignoring mysql knowledge Why is the title named? Commen sence refers to things that everyone should know, but often they will know something or know something about it, today I will summarize some commen sense

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

Mysql primary key auto-increment and Default Value Setting Create table 'ecm _ address' ('addr _ id' int (10) unsigned not null AUTO_INCREMENT, 'user _ id' int (10) unsigned not null default '0 ', 'consignee' varchar (60) not null default '',

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 (

11. Create and authorize a user in mysql 1. Create a user. // Log on to MYSQL @> Mysql-u root-p @> Password // Create a user Mysql> insert into mysql. user (Host, User, Password) values ("localhost", "abc", password ("1234 ")); // Refresh the system

MySQL series: innodb source code analysis and redolog recovery  1. recv_sys_t structure innodb will redo the logs of the redo log file when MySQL is started. The redo log is restored and controlled by a recv_sys_t structure. Its structure is as

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,