MySQL

I. Simple description table structure, field typeDesc Tabl_name;Displays the table structure, the field type, the primary key, whether it is empty, and so on, but does not display foreign keys.Second, the query table column of the comment

VSFTP is an FTP server software used on Unix-like systems based on the GPL, and the creator's intention is to secure the code.Characteristics1, it is a safe, high-speed, stable FTP server;2, it can do a virtual FTP host server based on multiple IP;3,

With Data sheet comments------------------------------------------------| ID | NewsID | Comment | Thetime |------------------------------------------------|        1 |         1 |     AAA | 11 |------------------------------------------------|      

Skip-grant-tables: Very useful MySQL boot parametersDescribes a very useful mysql boot parameter ——--Skip-grant-tables. As the name implies, when you start MySQL, do not start the grant-tables, authorization table. What's the use of it? Of course it

Failure phenomena:Enter the slave server and run:Mysql> Show Slave

Using the command to implement backup MYSQLL provides a mysqldump command that we can use to back up data. Follow the prompts to enter the password, this will be the TM database all the table structure and # Mysqldump-u ROOT-P TM > Tm_050519.sql

1.mysql has many system variables, can be set, system variable settings, different systems will cause the execution state.Therefore, MySQL provides two sets of commands to view the system settings and execution status, respectively.1. System

Preparing dataTable User (user), Dept (Department)1: Update one piece of data for a field that matches a single conditionUpdate user U set u.name = ' Test ' where u.id = ' "2:in updating more than one dataUpdate user U set u.name = ' Test ' where

Note: This operation is also available at the win command prompt, phpMyAdmin.User: Phplamp user database: phplampdb1. Create a new user.Log in to MySQL@>mysql-u root-p@> PasswordCreate usermysql> INSERT INTO Mysql.user (Host,user,password) VALUES

Database master-Slave synchronous deploymentPre-Sync EditorMaster Data Master ip:10.0.0.4:3306Standby data slave ip:10.0.0.3:3306Master Data above operationTurn on the Binlog parameter of the master data, and set the Server-idEgrep

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/73/A6/wKiom1YDQ9iRE_UcAAEyhfYu9as515.jpg "style=" float: none; "title=" 1.png "alt=" Wkiom1ydq9ire_ucaaeyhfyu9as515.jpg "/>650) this.width=650; "src="

1. Update Ubuntu system FirstUpdate commandsudo apt-get updatesudo apt-get upgrade 2Add Ubuntu nginx Update source imagecd/etc/apt/sudo cp sources.list Sources.list_bakAdd the following code to the Sources.list fileDeb

The MySQL database has a very high number of data types, and choosing the right data type is critical to gaining performance. Data is stored and stored by the engine, and different storage engines may differ in how they store the same type of

1 principleThe MySQL query cache saves the full result returned by the query. When the query hits the cache, the results are returned immediately, skipping the parsing, optimization, and execution phases.The query cache tracks each table involved in

To view the MySQL server error log, there is a sentence:Innodb:mmap (137363456 bytes) failed; errno 12The original memory is not enough (need 131MB) Ah, the my.cnf in the Innodb_buffer_pool_size value to 8M to solve the problemThis is ready, found

1. View the Library listmysql> show databases;+--------------------+| Database |+--------------------+| Information_schema || MySQL || Performance_schema || Test || WordPress |+--------------------+5 rows in Set (0.00 sec)MySQL library is the system

A lot of MySQL statements don't remember when they're used, so let's take a simple example./*SQLyog Enterprise Edition-MySQL GUI v8.14Mysql-5.1.49-community**********************************************************************//*!40101 SET NAMES UTF8

Note: Scripts (gomysql.py) need to be further optimized, beginner, hardFirst configure the list of Dbip.ini that need to be executed, in the following formatS1 192.168.0.5 3306 dbusername dbpasswd dbnameS2 192.168.0.6 3306 dbusername dbpasswd

http://blog.csdn.net/m13666368773/article/details/7612113To optimize queries, avoid full table scans, and first consider indexing on the columns involved in where and order by:Try the following tips to prevent the optimizer from mistakenly selecting

MySQL configuration for master-slave replicationFirst, the principleThe distribution of MySQL data across multiple systems is done by copying data from one of the MySQL hosts to the other host (slaves) and re-executing it again. One server acts as