MySQL

The System log appearsATA Truncated for column ' agent ' at row 1The reason for this problem with MySQL is that the character set or the field is too long.MySQL has been unified for utf-8 at initialization time, so this problem can be ignored.String

1 Increase of two fields:[SQL]View Plaincopy mysql> Create table id_name (id int,name varchar (20)); Query OK, 0 rows affected (0.13 sec) mysql> alter table Id_name add age int,add address varchar (11); Query OK, 0 rows affected (0.

The so-called build table is the process of declaring a column:The data is placed on the hard disk in the form of a file (also in memory)Columns: Different column types take up less spaceThe principle of election: enough and not wasted;MySQL data

MySQL itself type description:BIGINT 8 Bytes (-9 233 372 036 854 775 808,9 223 372 036 854 775 807) (0,18 446 744 073 709 551 615) Maximum integer valueThe requirement itself ID is 16 bits, 8 bytes length has been fully satisfied, so consider using

host= $host; $this->name= $name; $this->pass= $pass; $this->table= $table; $this->ut= $ut; $this->connect (); } function Connect () {$link =mysql_connect ($this->host, $this->name, $this->pass) or Die ($this->error () );

Monitor MySQLSlave_io_running:Slave_sql_running:Status, no mail alarmRecently found an e-mail tool, simple and easy to use sendEmail, installation-free personal feeling very usefulReference: http://blog.chinaunix.net/uid-10697776-id-3185073.htmlVim

Environment descriptionOperating system: CentOSip:192.168.150.214Oracle Database version: ORACLE11GR2User: root password: 123456Port: 3306Databases: Ts_0, Ts_1, Ts_2, Ts_3The detailed steps are as follows:1. root User Login

For MySQL backup different DBA, have different preferences!Let me first enumerate the following methods:1. Use the MySQL automatic Dump tool, with the shell and then crontab execution;2.XtraBackup (These years compared to the fire bar)Description:

The following information is displayed when you execute MMM_CONTORL show after Monitor startsError:can ' t connect to monitor daemon!Solution Ideas:Modifying a configuration fileWill debug=0SwitchDebug=1Then restart Mysql-mmm-monitorDEBUG MySQL (DB2)

(1) 1th to ensureis to create a database when the encoding is used and the connection database encoding format is the same!(2) Configure filters (filters provided by spring) in the Web. xml fileencoding

Overview:In CentOS 6.4, the installation of MySQL via Yum is version 5.1, older, so you want to install the high version of 5.6.14 via source code.Text: One: Uninstall the old versionUse the following command to check if MySQL Server is installedRpm-

Company requirements for products to do an offline upgrade tool, agents can download and then directly double-click this EXE to upgrade the current version. One of the features of the tool is to back up the user's data before upgrading, and to

Here I have created two new tables, one users and test1 CREATE TABLEUsers (2Usernamevarchar( -),3Pwdvarchar( -)4 );5 CREATE TABLETest (6IdINT,7UsernameVARCHAR( -)8)More than one data is inserted into the users table, primarily to test the use of

Code:ImportMysqldbconn=mysqldb.connect (host='127.0.0.1', user='Root', passwd='Root', db='Test', port=3306) cur=conn.cursor () row= Cur.execute ('select * from Stu')#Print Affectrowresult =cur.fetchmany (Row) forLineinchResult:Printlinecur.close ()

A small project that you do needs to use MySQL to calculate some information.The tables in MySQL are as follows (note: The data in the table is test data, randomly generated)Mysql>Select* fromShake_log;+-----+-------------+--------+------------------

outside of MySQL key constraintThere are two common engine types for MySQL: MyISAM and InnoDB. Currently only the InnoDB engine type supports foreign key constraints. The syntax for INNODB FOREIGN KEY constraint definitions is as follows:[CONSTRAINT

import java.sql.*; Import Java.util.scanner;import java.io.*; public class MySQL insert picture {private static final file file = null; private static string string; public static Connection Getconn () {Connection conn = null;

MySQL Incremental backup and recovery instance A small number of databases can be fully backed up every day, because it does not take much time. However, when the database is very large, it is unlikely that a full backup is performed every day. At

MySQL Master/Slave latency monitoring script (pt-heartbeat) We can use percona's powerful weapon pt-heartbeat to monitor the master-slave replication latency of MySQL databases. Pt-heartbeat updates a specific table in the master database by using a

Mysql database server Adjustment Make a database server adjustment to the customer the day before yesterday, discard the previous host, promote the master from the database, and then add the new slave. Here, record the operation steps: 1. Enable