MySQL

Environment Preparation:Install Cenos6.3 on the virtual machine, and then download and install MySQL,about installing mysql-5.5.25 under CenOS6.3 here is not the repetition, please look at the previous blog http://shansongxian.blog.51cto.com/5040181/

NUMA affects MySQL multi-instance performance by binding MySQL on different CPU nodes to NUMA, and forcing memory to be allocated within this node by using a bound memory allocation policy. The specific tests are as follows:1. Turn off Numa (numa=

Method One:1. First cmd input net stop mysql//stop MySQL Service2. Then add the following line to [Mysqld] in the My.ini file Skip_grant_tables3. In cmd, switch the directory to your MySQL installation path, as mine is C:\Program files\mysql\mysql

Show Table status;//View all table states, with this command to know when the table was created and when it was last updated, and whether the table is a base table or a view, and what table engine is the information.Show table status from DBName

As we all know, increasing the index is improvingEnquiryStill do not use the index, this situation seriously affects performance, here is a brief summary of a fewififThe column key is evenly distributed between 1 and 100, and the

MySQL performance optimization of the sub-database table with no downtime to modify the MySQL table structure, the need for friends can refer to the next1, sub-database sub-tableObviously, a main table (that is, very important tables, such as user

1. Summary of the use of MySQL client tools About executing SQL scripts In the MySQL client, you can Source/xxx/yyy/zzz.sqlIf the shell command line can be executed mysql-uxxx-pyyy-hzzz

Mysql> DESC MYSQL. USER \g***************************1. Row ***************************Field:hostType:Char( -)Null:noKey:priDefault:Extra:***************************2. Row ***************************Field:userType:Char( -)Null:noKey:priDefault:Extra:

Keep a record of your problems and experiences in your daily learning process1 Environment ConstructionMaster--Master1 Server1111.10.10.10 (Master1)Virtual IP 111.10.10.112 Server2111.10.10.40 (Master2)Virtual IP 111.10.10.123 Server3111.10.10.20 (

PHP connection to MySQL small instance/*Date: 2014-09-14* Gechong* Function: PHP connection MySQL Small instance* *//*SQL scripts. Paste directly to the command line to run.DROP DATABASE Gechong;CREATE DATABASE Gechong;Use GechongCREATE TABLE T1 (ID

1. Environmental statementBlog Address:http://blog.csdn.net/hw_libo/article/details/39252427RHEL 6.4 x86_64 + MySQL 5.6.19Test table:MySQL [test] > Show CREATE TABLE emp\g*************************** 1. Row *************************** table:empcreate

MySQL forgot password, how to do?We often need to modify the MySQL password, such as a long time to forget the MySQL password, or the use of a computer someone else used, do not know the previous password, and want to use MySQL, how to

"MySQL "MySQL is currently the most mainstream cross-platform, open-source relational database, developed by the Sakila MySQL AB company, has been acquired by Sun Company, logo is a dolphin named "," representing MySQL speed, ability, precision

Each table in MySQL has a clustered index (clustered index), except that each nonclustered index on the table is a level two index, also known as a secondary index (secondary indexes).For InnoDB, each InnoDB table has a special index called a

If there is a data table A: Id Name Title Addtime If you need to insert n data : $time = time (); $data = Array (' name ' = ' name1 ', ' title ' = ' Title1 ', ' addtime ' = $time;   ), Array (' name ' = '

the SQL that establishes the stored procedure is as follows: CREATE PROCEDURE proc_variable () BEGIN DECLARE dec_var_ VARCHAR (+); DECLARE rep_num INT; DECLARE Dec_var CURSOR for SELECT id_ from act_ru_variable WHERE name_ = ' yjdqsj '

How to change the MyISAM type table in a MySQL database to a table of type InnoDBChange a single tableALTER TABLE TABLENAME ENGINE=InnoDB; ALTER TABLE TABLENAME ENGINE=MyISAM;Change multiple tablesSELECT ' "' engine=innodb; ' )from

SELECTR.* fromTrans_flow R, (SELECTOrder_no,MAX(Status_time) asStatus_time fromTrans_flowGROUP byorder_no) SWHERER.order_no=S.order_no andR.status_time=S.status_timeORDER byR.status_timeDESC

Ubuntu under MySQL default only from locally connected solutionsudo gedit/etc/mysql/my.cnfModify a fieldBind-address = 127.0.0.1-Bind-address=xxx.xxx.xxx.xxx (Your IP)(FROM:HTTP://HI.BAIDU.COM/VINCENT_HCL)First, connect MySQL.Format: mysql-h host

First my SQL has a configuration file My.ini, which is in the MySQL installation package.1. The maximum number of MySQL connections can be set in this file,# The maximum amount of concurrent sessions the MySQL server would# Allow. One of these