MySQL

Cause: This is because the system will find the command under/usr/bin by default, if this command is not in this directory, of course, will not find the command, we need to do is to map a link to the/usr/bin directory, equivalent to create a link

1. Obtained by the self-increment key auto_increment.Select Max (ID) from TableNameThis approach requires consideration of concurrency and the need to "X-lock" the primary table in a transaction, and then unlock it after the value of Max (ID) is

MySQL There are several common reasons for starting an error:1 , the data area is full2 , PID directory MySQL user does not have write permission3 , the storage engine is the InnoDB engine, and this time it will need to restore all operations

MySQL master-slave replication test environment:The 1.centos5.8 x86_64 is minimized, and the system has undergone a basic optimization2.mysql version: 5.1.73-log, multiple instances of the same server, installation method reference: MySQL

Recently we have built a Java Webserver with Tomcat and MySQL and deployed the game's server logic on the server.Soon after the game was online, we found a large number of garbled characters in the database. This is a very serious problem and must

　　This article is your own study notes, welcome reprint, but please specify the source:http://blog.csdn.net/jesson20121020　Recently, because of the need to learn the development of Android network to use the server, so under Linux configuration

StatementThe Stars last nightBlog:http://yestreenstars.blog.51cto.com/This article by oneself creation, if need reprint, please indicate source, thank cooperation!ObjectiveConfigure the MySQL server to implement primary master

The previous blog says you can use the slow query log to locate time-consuming SQL, use the explain command to view the execution plan for MySQL, and use the profiling tool to see where the statement execution is really time-consuming, and how to

Source installation Mysql database : download mysql-5.6.15.tar.gzFirst set up the installation environment1. Create a mysql user group and system account Groupadd-r MySQLUseradd-r-G MySQL MySQL2.rpm-qa |grep MySQL To see if you have software

MySQL execution processWe can manually divide the main functions of MySQL into the following modules.1. Initialize the moduleWhen MySQL starts to perform initialization work, such as reading the configuration file, assigning some global variables

The INFORMATION_SCHEMA database is a MySQL-band that provides a way to access database metadata. What is meta data? Metadata is data about the data, such as the database name or table name, the data type of the column, or access permissions. Some of

first, the database paradigmin order to build a database with small redundancy and reasonable structure, we must follow certain rules when designing database. In a relational database, this rule is called a paradigm. A paradigm is a summary of a

Configuration of the Java development environment First we will download the JDK. To the Oracle official website to download, the latest version is the Java SE 8u25. At first I was confused, what was the relationship between Java SE and the JDK?

MySQL always error, said sock file does not exist, several methods on the Web, change the permissions, change the configuration file, the result is not normal to generate. sock files. No way, remove, reinstall.Delete completely:Delete MySQLsudo

First create the controller, add two tries, an index a list here, I'm using MySQL.Index.cshtml Code:@{Layout = null;}Index@Styles. Render ("~/content/css/home") @* style *@@Scripts. Render ("~/bundles/jquery") @* here references jquery*@@Scripts.

Remember in the previous training, the teacher often said that the reason for the slow site, did not cache or look at the slow query.Today's summary below:First, positioning slow queryWe want to optimize the SQL sentence, the first step must be to

Familiar with MySQL stored proceduresStored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database, you can call and execute a stored procedure by specifying its name and giving a parameter (if the

Analyze Mysql InnoDB Indexes Abstract: This article introduces the InnoDB Index-related knowledge of Mysql, from various trees to the indexing principle to the details of storage. InnoDB is the default storage engine of Mysql (MyISAM before Mysql5.5.

Set the MySQL transaction isolation levelSelect @ tx_isolation; // view isolation levelSet transaction isolation level read uncommitted; // you can specify the read uncommitted level.Start transaction; // open the transactionRollback; //

Mysql automatic backupMysql automatic backup batch processing command: Set "Ymd = % date :~, 4% % date :~ 5, 2% % date :~ 8, 2% "set" hMs = % time :~, 2% % time :~ 3,2% % time :~ 6, 2% "mysqldump-uroot -- password = password weixin> D: \ mysql_back