MySQL

Once secretly interviewed two units, all mentioned the optimization of MySQL problem, so after a lot of learning database optimization knowledge. The optimization of the construction database is probably mainly the optimization of the index, because

Data extracted from the two tables inline, where the Category_name field has the same content, want to merge fields with the same content, add the Amount field to the tableSELECT C.Category_name,Count(*)  asTask_num,sum(T.Amount)  asAmount_num

This is my first day in Beijing University high-tech company. "The first week to self-study mainly to adapt to current javaweb development mainstream technology, so to develop a program demo as the first week of the task schedule.Mission Objective:

MySQL Character set support (Character set supports) has two aspects:The character set (Character set) and the Sort method (Collation).Support for character sets is refined to four levels:Servers (server), database, data tables (table), and

Mysql> SHOW GLOBAL STATUS like ' innodb%read% '; +---------------------------------------+---------+| variable_name | Value |+---------------------------------------+---------+| Innodb_buffer_pool_read_ahead_rnd | 0 | | Innodb_buffer_pool_read_ahead

1. mysql Installation source codeNote Check this step, the MySQL source code installed;2, the production of makefile documents;Generate Makefile FileQmake "Includepath+=c:\mysql\include" "Libs+=c:\mysql\lib\debug\libmysql.lib"-O Makefile

#!/bin/bash## update_problem-updates problem record in database################################################################ Determine SQL location & Set Variable#Mysql= ' which MySQL ' "Problem_task-u testuser"####################################

1.PDO IntroductionPDO (PHP Data Object) is something added to PHP 5, which is a significant feature of PHP 5, since php4/php3 before PHP 5 is a bunch of database extensions to connect and process with each database, what Php_mysql.dll, Php_

In MySQL, the data file is stored in the path specified in My.cnf DataDir, the table engine used by the different file formats, the number of table files will vary. MySQL has a variety of table engines, the table extension is not the same, such as

Use MySQLSELECT * from user \g;UPDATE user Set Password=password (' root ') where user= ' root 'Grant all on *. * to root@ '% ' identified by ' root ' Last set password discovery does not work, originally forgot one step very

A transaction (Transaction) is a program execution Unit (unit)that accesses and possibly updates various data items in a database. Transactions are the basic unit of recovery and concurrency control. In a relational database, a transaction can be

Recently, the company's BBS pressure is growing, table deadlock more and more serious.In the case of other optimizations, the MyISAM engine to the InnoDB engine is also included in the plan.The reference URL is as follows: simple, but pay attention

1. Installation1. See if you have mSQL installedyum list installed mysql*-qa | grep mysql*2. See if there are any installation packagesYum list mysql*3. Install the MySQL clientYum install MySQL4. Installing the MySQL ServiceYum Install

0. DescriptionMySQL service version best consistent, inconsistent may cause problemsmaster database ip:192.168.0.10Slave database ip:192.168.0.111. Modify Master server Mastervi /etc/my.cnf[mysqld]log-bin=mysql-bin #[must be] enable binary log

Nothing, two weeks ago. The results of the import and export of MySQL are now forgotten again.It is even more tragic that the same three blog, now looks like the same strenuous, the contents of the inside. So write a note for yourself.Environment:

The InnoDB engine differs from the MyISAM engine. MyISAM InnoDB row-level lock non-object security things security full-text indexing full-text

Four, conditional judgment function 1, if (EXPR,V1,V2) function: To establish the return result V1, otherwise the result V2 example: Select Id,if (grade>=60, ' Pass ', ' fail ') from T;2, Ifnull (V1,V2) Function: If blank display v2, otherwise v1

Install MySQL under CentOS7--Download MySQLhttp://mirrors.sohu.com/mysql/MySQL-5.6/Http://mirrors.sohu.com/mysql/MySQL-5.6/MySQL-5.6.24-1.linux_glibc2.5.x86_64.rpm-bundle.tarOne. Preparatory work--File after downloadMysql-5.6.24-1.linux_glibc2.5.x86_

Method one: After ignoring the error, continue syncingThis method is applicable to the case that the data of master-slave database is not very different, or the data can not be completely unified, the data requirements are not strict.Stop

MySQL master-slave switchMaster stop, from the bossThe steps are as follows:1 Confirm that all synchronization operations have been completed from the server:Stop slave Io_threadShow ProcesslistUntil you see the status: XXX has read all relay log