MySQL

Query Profiler is a query diagnostic analysis tool that comes with MySQL to analyze where the performance bottlenecks of an SQL statement are. Usually we are using the explain, and slow query log is not accurate analysis, but query Profiler can

Working on MySQLMysql>create database du;Mysql>grant all on du.* to ' Benet ' @ ' 192.168.1.3 ' identified by ' 123 'Mysql>flush privileges; Refresh PermissionsWorking on the Web[[email protected] ~]#/usr/local/nginx/sbin/nginx-v//See which modules

First look at the MSYQL logical framework: Images from high-performance MySQLIf Querycache is used, when the query receives one and the same query, the server retrieves the results from the query cache instead of parsing and executing the same query

Font: [Increase decrease] Type: Reprint time: 2010-03-07show processlist command is very practical, sometimes MySQL often run to more than 50% or more, you need to use this command to see which SQL statements occupy more resources, you know which

Original address: http://blog.itpub.net/29254281/viewspace-1398273/ MySQL chooses what to think before you can read the isolation level repeatedly. Gap Lock MySQL before use There are three must be aware of: (with the depth of understanding

MySQL must master the tools Pt-query-digestAncient Cloud: 工欲善其事, its prerequisite. As a good MySQL DBA also needs to have a few useful MySQL management tools, so I have been sorting and looking for some easy to manage MySQL tool. Over the next

MySQL Enable SSD storage Chszs, All rights reserved, without consent, not reproduced. Blogger Home: Http://blog.csdn.net/chszsSometimes OS read-write slows down the performance of the MySQL server, especially when the OS uses the same disk as MySQL.

Enter the following command:/usr/local/mysql/bin/mysqladmin-uroot-pyyyyyy variables |grep max_connectionsNano/etc/my.cnfmax_connections=200Service MySQL RestartThe maximum number of concurrent connections in MySQL modification method as long as in

Before Windows mysql5.6.20 using mysqldumpslow.pl to analyze slow logs, today saw a tool pt-query-digest, originally intended to be installed on Windows, resulting in the execution of C: \ on Windows Program Files\mysql\mysql Server 5.6\bin>pt-query-

deployed a database using MySQL program, SQLYOG connection to non-local MySQL server database, incredibly unable to connect very strange, reported one 30 errors,ERROR 1130:host 192.168.3.100 isn't allowed to connect to this MySQL serverConjecture is

There are three types of time fields in MySQL:Datetime,date and timestamp.DateTime holds the data in YYYY-MM-DD HH:MM:SS format string;Date is a string of yyyy-mm-dd in the form of only a month and a day;The timestamp type has the same name as the

In the process of hive integration MySQL as metadata, after all the installation configuration work, go into hive mode, execute show databases, execute normally, then execute show tables, but error.The key error messages are as

Problems with MySQL not starting due to power outages:1. Errorshell>  mysql.server start                                                                                                         starting mysql ..........................................

When the King MySQL database import data often appear warning, these warnings are easy to ignore, today to the data when suddenly want to see what the warning content, Baidu a bit of MySQL view warning commandShow warnings;The command is concise and

There are four general directions for Zabbix monitoring:1,zabbix Agent Type2,SNMP type3,JMX type4,impi typeThere are basically two types of agents, Agent type and SNMP type.The agent type of item is to use the agent deployed on the server side to

The simplest way to understand how an index works in MySQL is to look at the "index" section of a book (the directory). The specified page number is then found by index.In MySQL, the storage engine uses the index in a similar way, first finding the

Ibdata1 & mysql-bin Problem: Disk space alert, found that ibdata1 and Mysql-bin logs occupy too much space (where ibdata1 exceeds 120g,mysql-bin by more than 80G)Cause: IBDATA1 is the storage format, in InnoDB type data state, IBDATA1 is used to

As we all know, in MySQL, if the direct ORDER by RAND (), the efficiency is very poor, because it will be executed multiple times. In fact, if the equivalent query is also used with RAND (), let's take a look at the different execution plans and

Shell script analyzes mysql slow query log (slow log) and mysqlslow Percona pt-query-digest is used to analyze slow query logs. The analysis and statistics results are clear. #! /Bin/sh Slowlog_path =/root/slow_query_log Everyslow

LNMP environment setup-MySQL and lnmp for mysql The world's most popular open source database 1. Install MySQL root@kallen:~# apt-get install mysql-server-5.5 mysql-client-5.5 2. Add Users (1) Select a data table The statement is as follows:use