MySQL

1. BackgroundImport 150w data to MySQL, the data format is tab-delimited CSV file. Impact of test index on import speed2. No index, rebuild after importing dataCREATE TABLE ' tab ' (' ct_id ' char ($) default null COMMENT ' ID ', ' ct_title '

MySQL master-slave replication-------------------------------------------------------------Environment:Two servers (two instances of a single server)Main Library: (IP 192.168.1.1 port:3306)from library: (IP 192.168.1.2 port:3306)Authorized

1.MY.CNF ConfigurationAdd to:[Client]Default-character-set = Utf8user = root[Mysqld]Binlog_format=rowbind-address=0.0.0.0default_storage_engine=innodbinnodb_autoinc_lock_mode=2innodb_flush_log_ At_trx_commit=0innodb_buffer_pool_size=122minnodb_locks_

Here is just from scratch to build a most basic environment, can let Nginx server run PHP program can, Advanced Configuration I will fill up later. Nginx Automatic Installation:sudo apt-get install nginxStart:Sudo/etc/init.d/nginx StartStop

$ ln-s/usr/local/mysql/bin/mysql/bin/mysql #创建mysql软链接, implemented by program name startup.$ MySQL #登录$ mysqladmin-u Root password "123456" #初次设置密码A.-> SET PASSWORD =password (' 123 '); #修改密码方法Ab.->mysql> Update user Set Password=password (' 123456

After installing MySQL without compiling, an error message appears:ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/tmp/mysql.sock ' (2)Workaround: 1.vi/etc/my.cnf Find socket= this2. Modify the socket path:

First, create a new table1. Creating a new table: CREATE TABLE tablename;eg:create table Books;2. Create tables and properties:CREATE TABLE Books (title_id INT Not_null auto_increment,Title VARCHAR (150),Pages INT,PRIMARY KEY (title_id));3. Add data

Wu Bingxi Source: http://wubx.net/Contact: wubingxi#163.com Reprint Please specify AS/translator and source, and can not be used for commercial purposes, offenders must investigate. Download binary version

There is no default for this configuration item in the #在MySQL配置文件 (My.ini), with the default value of 1024, the following statement modifications can be executed on the client:#SET GLOBAL Group_concat_max_len = 1024;#该语句执行后重启客户端即可用语句:#show

1 DROP TABLE IF EXISTS' tb1 ';2 CREATE TABLE' tb1 ' (3' ID 'int( One) not NULLAuto_increment,4' A 'varchar(255)DEFAULT NULL,5' B 'varchar(255)DEFAULT NULL,6' Content 'varchar(255)DEFAULT NULL,7 PRIMARY KEY(' id ')8 ) 9 -- -------------------------

                                                                                                            1, connecting MySQLConnect to the local MySQL database: Mysql-u root-p (enter the password after entering)To connect to the remote host's

Yesterday I wrote a blog post about MySQL's Loose index scan (http://www.cnblogs.com/wingsless/p/5037625.html), Later I found that the main purpose of the optimization method mentioned last time was to achieve loose index scan, and on the execution

MySQL loose index scanAs we all know, InnoDB uses the index organization table (IOT), which is called the index organization table, and the leaf node stores all the data, which means that the data is always stored in a certain order. So the question

MySQL loose index scan, mysqlloose As we all know, InnoDB uses the index organization table (IOT), which is called the index organization table, and the leaf node stores all the data, which means that the data is always stored in a certain order.

Common optimization methods and parameter settings for MySQL Databases1. disable SELinux vim/etc/selinux/config and change SELINUX = enforcing to SELINUX = disabled 2. change IO Schedule. For an SSD hard drive, you do not need to change echo

Mysql modifies the database encoding (database character set) and Table character encoding methods, mysql Character Set Mysql database is an open-source database and is widely used. The following describes how to modify the character encoding of the

Bad MySQL writing habits and MySQL writing habits I wrote a stored procedure to test one thing: delimiter $$drop procedure if exists sp_test$$create procedure sp_test()begin declare v_cnt int; set v_cnt = 0; while v_cnt In a very simple process,

Mysql uses binlog to restore DataI. What is binlog 1? basic definition of binlog: Binary logs are also binary logs that record SQL statements that occur or potentially change data, binary logs are stored in the disk in binary format. binary log

Mysql master-slave SynchronizationPrinciple: connect the server's IO thread to the master server to obtain the binary log, save it as a relay log locally, and then execute the SQL statement in the relay log through the SQL thread, so that the slave

Writing to a MySQL database from SSIS, databasessisWriting to a MySQL database from SSIS   Source: http://blogs.msdn.com/ B /mattm/archive/2009/01/07/writing-to-a-mysql-database-from-ssis.aspxMatt Masson-MSFT 7 Jan 2009 PM 16 A couple of users