MySQL

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

This MySQL is written in the Navicat.CREATE PROCEDURE Aa_getstudentbypage(in _pageindex int,in _pagesize int,In _username varchar (20),Out _pagecount int)BeginDECLARE _paidex int default 0;DECLARE _count int default 0;Set _paidex= (_pageindex-1)

1. Stop MySQL service, CMD Open DOS window, enter net stop MySQL2, in the CMD Command Line window, go to MySQL installation directory such as E:\Program files\mysql\mysql Server 5.0\binDemonstration command:Enter e: Carriage return,Enter CD

The installation of MySQL is installed using the sudo apt-get install mysql-server, which I installed in version 5.6. During installation, you will be asked to enter the password of the root account and enter it as prompted.MySQL Workbench using the

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

The following article is mainly about PHP (PHP training PHP tutorial) access to MySQL (MySQL certified MySQL training) data garbled practical solution we all know that MySQL data garbled is a very headache, then how to solve it? The following

The following is a detailed configuration of the MySQL database server configuration file My.ini. Applications are InnoDB engines,2-core CPUs, and 32-bit SUSE. [Client]#password = Your_passwordPort = 3306Socket =/tmp/mysql.sock# here follows entries

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

A stored procedure (Stored Procedure) is a set of SQL statements that are compiled and stored in a database inorder to accomplish a specific function. The user invokes execution by specifying the name of the stored procedure and the given

Today to do an order task, which need to check for this order number information, because the order number is a list, so want to detect the following statement performance (mainly on limit 1)" Order number in (Order number list) " LIMIT 1Then we

First, installationLinux installed in a variety of ways, you can use the Package Manager to install automatically, you can manually compile the source code installation, the use of relatively simple installation, using Apt-get:sudo apt-get install

Set up dual-machine hot standby:The first thing to do is to set up a synchronization user on two machines:Grant Replication Slave on * * to ' Repdcs ' @ ' 192.168.21.39 ' identified by ' 123456 ';Grant all privileges on * * to ' Repdcs ' @ ' 192.168.

What is a viewA view is a table that is presented from one or more tables and is a virtual existence.A view is like a window through which you can see the data that is specifically provided by the system.This allows users to take care of data that

http://www.oss4aix.org/download/rpmdb/deplists/Aix6.1 installing MySQLI'm not going to talk about anything else, since Oracle's takeover of Sun, MySQL hangs directly on the Aix parch, you know, business

The table we want to access is a very large table, 40 million records, the ID is the primary key, the index is built on the program_id.Execute a SQL:SELECT * from Program_access_log where program_id between 1 and 4000This SQL is very slow.We thought

Trigger:a special kind of thing, can monitor some kind of data operation, and trigger related operation (insert/update/delete);some of the data in the table changes, hoping to cause other related data changes. Function: Change automatic completion

Database backup /data/mysql/bin/mysqldump-hlocalhost-u ' root '-P ' do ' my_db--single-transaction-q | gzip > my_db.sql.gz Find '/home/yourname/backup/mysql '-name ' 123.txt '-ctime +5 | Xargs RM-RF; Mysqldump-u "root"-P

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; //

One of mysql installation methods on linux, yum Installation Mysql installation is nothing more than the following. yum installation is also a type of rpm installation, but this installation package does not need to be downloaded separately. It is