MySQL

1 Overall knowledge introduction : MySQL basic operation and use, MySQL optimization (index, sub-table, etc.), MySQL deployment (read/write separation, load balancing, etc.)Database Basic Introduction : Database concept, common database, Web

Original: MySQL primary key design[TOC]In the process of the project encountered a seemingly very basic problem, but in-depth thinking has led to a lot of problems, I think it is necessary to take this learning process to record.MySQL primary key

The premise of integrating hive is that the Apache Hadoop cluster can start normally.Hadoop version apach2.6.0 hive version: 1.2.11. Install MySQL and give permissions:1.1: Create hive user and password:Create user ' hive ' identified by ' 123456 '1.

1. Redundant and duplicate indexesMySQL allows multiple indexes to be created on the same column, either intentionally or unintentionally, andMySQL needs to maintain duplicate indexes separately, and the optimizer needs to consider each one

Error messageThe following error occurred in installing mysql-server-5.5.25a-1.rhel5.x86_64.rpm in Linux Centeros 64-bit[Email protected] upload]# RPM-IVH mysql-server-5.5.25a-1.rhel5.x86_64.rpmerror:failed dependencies:Libaio.so.1 () (64bit) is

The same IDC, IDC internal DNS server, the IP of each server to do a reverse resolution, but not the internal IP to do the reverse resolution, so use Skip-name-resolve after using the intranet address to Mysqlslap request response half faster

Performance comparison test for MySQL 5.6 and MariaDB-10.0time 2013-02-14 10:11:34 Open source China Original http://www.oschina.net/question/12_90065 ThemeMariaDBOLTPTesting TechnologyOracle has just released the MySQL 5.6.10 GA version, so it's

1. Installing NginxSOURCE InstallationI install the environment is Deepin (Ubuntu derivative version), so the simplest way is to executesudo Install Nginxor under CentOS:Yum Install NginxCompiling the installationhttp://nginx.org/Download the latest

keepalived mysql Failure auto-switch scriptThe MySQL schema is master-slave (master-slave), master failure is automatically switched to slave. Of course, can also be set to double master, but here is a disadvantage: when the main pressure is very

Today to experience MySQL's auto-failover function, here is a tool MySQL Utilities, it is very powerful. This tool provides the following features:(1) Management tools (clone, copy, compare, diff, Export, import)(2) Copy tool (installation,

Reprinted from Http://www.cnblogs.com/eecs/p/3963869.html1) Update Apt-getTerminal command: sudo apt-get update2) Install MySQLTerminal command: sudo apt-get install mysql-server php5-mysql3) Install Nginxsudo apt-get install NginxNginx does not

Create a tableThe Simple WayCREATE TABLE Person (number INT (one), name VARCHAR (255), birthday DATE);or aCREATE TABLE IF not EXISTS person (number INT one), name VARCHAR (255), birthday DATE);To view the MySQL creation table:SHOW CREATE table

DDL: Data Definition languageCREATEAlterDROPThe main operations focus on databases and tables.Database:To create a database:CREATE datebase| SCHEMA [IF not EXISTS] dbnane [create_specification];Create_sepecification[DEFAULT] CHARACTER Set [=]

Mysql> Select - sum( Case whenScore - Then 1 Else 0 End) as '', - sum( Case whenScore>= - andScore the Then 1 Else 0 End) as '60~69', - sum( Case whenScore>= - andScore - Then 1 Else 0 End) as '70~79', - sum( Case whenScore>=

EXPLAIN the usage of MySQL Execution Plan Analysis ToolFamiliar with SQL Execution Plan analysis skills for DBAs is vital for quickly locating database performance problems. The following describes how to analyze MySQL execution plans.1. EXPLAIN how

What should I do if mysql cannot be installed? mysql installation failure causes and solutions, mysql Failure Causes The mysql database cannot be installed! Mysql cannot be installed in the last step! Mysql cannot be installed! Is it a headache and

The use of append and generator labels in the Struts framework of Java, Append label:These append labels need two or more lists as parameters and append them together, as shown in: If there are two values of list A and list B: A1, A2, B1

Configuration of Dual-machine hot standby for MySQL database and dual-machine hot standby for mysql database 1. Mysql databases do not have an incremental backup mechanism. When the data volume is too large, backup is a big problem. Fortunately, the

Mysql simple tutorial (2), mysql simple tutorial Next, a simple tutorial on Mysql in Linux (1) Field parameters are constructed in the form of "(field name 1 Data Type 1, field name 2 Data Type 2. Mysql data types are commonly used. You can search

Tutorial on using subqueries and scalar queries in MySQL, MySQL subqueryA subquery uses the query result of a SELECT statement as the intermediate result for calling by another SQL statement. MySQL supports all the subquery formats and operations