MySQL

This article mainly introduces the MySQL configuration file my.cnf parameter optimization and Chinese explanation, very detailed in Chinese annotated the role of each parameter and recommended values, the need for friends can refer to the

Yesterday time limit just wrote how to connect the database, the purpose of connecting the database is to query, modify the data, just connected or meaningless.The main method of Statement interface (java.sql.Statement) is used for data crying

The Employee table holds all employees including their managers. Every employee has an ID, and there is also a column for the manager ID.+----+-------+--------+-----------+| Id | Name | Salary | ManagerID |+----+-------+--------+-----------+| 1 |

Database creation Script:/*navicat mysql data transfersource server          : localhostSource Server Version : 50621Source Host            : localhost:3306Source Database        : cmm-dbtarget server type    : mysqltarget

Here is an example analysisTable A records the following:AID Anum1 a200501112 a200501123 a200501134 a200501145 a20050115Table B records the following:BID bname1 20060324012 20060324023 20060324034 20060324048 2006032408Create these two table SQL

MySQL High availabilityTwo issues that need to be addressed with high availability:1. How to achieve data sharing or synchronizing data. 2. How to deal with failover. Failover means that when a server freezes or an error occurs, it can automatically

ERROR 2006 (HY000) at line * * *: MySQL server has gone away countermeasure Mysqlsql serversql.netwindows.Cause Analysis:1. Execute batch MySQL statements, such as backup recovery, for a long time.Corresponding to: Modify wait_timeout and

From:http://www.2cto.com/database/201302/189920.html Mysql:charset and collation settings  charset and collation have multiple levels of settings: server-level, database-level, table-level, column-level, and connection-level    www.2cto.com-

See 7.3.6 date and time types for a description of the range of values that each type has and the valid format for the specified date and time value.Here is an example of using a date function. The following query selects all records whose Date_col

150210 10:29:16 InnoDB:Warning:trying to delete tablespace '/tmp/#sql2069_87b001_1d. IBD ',Innodb:but there is 1 flushes and 0 pending I/O ' s on itInnodb:loop 1016.150210 10:29:16 InnoDB:Warning:trying to delete tablespace '/tmp/#sql2069_87b001_1d.

A subquery is used to influence the number and order of rows produced in a subquery. For example: SELECT * fromT1WHERET1.column1inch (SELECTColumn1 fromT2ORDER bycolumn1);SELECT * fromT1WHERET1.column1inch (SELECT DISTINCTColumn1

Installation Environment:CentOS 6.6 x86_64First, IntroductionThe Vsftpd:very secure FTP daemon is a very secure FTP process and is the name of a server running on a GPL-released UNIX-like class operating system that can run on systems such as Linux,

Recently encountered a problem, that is, under high concurrency, MySQL performance bottlenecks, because PHP is a weak type of language, no type one said. Therefore, when MySQL returns is not the expected result, it causes subsequent logic errors.1)

1, edit the script cmake_mysql_install.sh, enter the following content:#!/bin/bash# Download and install Makeyum-Y install gcc #排除错误: configure:error:inch'/usr/local/src/make-4.1': Configure:error:no acceptable C compiler found in

Mysql Master-slave replication principleWith the continuous development of the website business, the increasing number of users, the volume of data continues to grow, the number of database access is correspondingly increased, to a certain time, the

Transferred from: http://fenglongsheng.com/post/6640.htmlToday write a mvc4+entity framework+mysql Small example, found that the Chinese write to the database is n a question mark (garbled oh ~);I followed the code and found that the data submitted

Tutorial on using CONCAT functions in MySQL This article describes how to use the CONCAT function in MySQL. It is the basic knowledge of getting started with Python. For more information, see Use the MySQL CONCAT () function to connect two strings

Yahoo open-source MySQL Performance Analysis Tool (MySQL Performance Analyzer)MySQL Performance Analyzer is an open source project for MySQL performance monitoring and analysis. This repository implements des two sub projects: Java web application

Mysql deadlock caused by full disk Today, I encountered a problem because the disk of the machine where mysql is located is full, leading to a mysql deadlock and not even querying the select statement. If I did not read the mysql Log, I could not

Impact of mysql query timeout on PHP Execution Recently, I encountered a problem that mysql performance encountered a bottleneck in high concurrency. Because PHP is a weak language, there is no such problem. Therefore, when mysql returns an