MySQL

Show [Global | session] status [like ' xxx '];Global option to view all MySQL connection statusSession options, view current connection status, default session optionFlush status; You can reset many status values to zero.Get the total number of

Http://blog.sina.com.cn/s/blog_75ad10100101by7j.htmlHttp://www.cnblogs.com/zemliu/archive/2013/08/03/3234372.htmlFirst: Query_cache_type How to use query cachingIn general, we will set the Query_cache_type to on, which should be on by defaultMysql>

Original address: Use Anemometer to visualize MySQL slow query based on Pt-query-digest 84223932This article mainly introduces the use of anemometer based on pt-query-digest MySQL slow query visualization, because the online data is relatively small,

Reprint:http://www.itokit.com/2012/0515/73932.htmlWhen the server is put on the LAN for testing, the database access speed is still very fast. However, when the server is placed outside the network, the database access speed becomes very slow.Later

The concept of a character set everyone knows, proofing rules many people do not understand, the general database development is also not used in this concept, MySQL in this convenient seemingly very advanced, about aboutBrief descriptionCharacter

CentOS 6.5 System installation Configuration lamp (APACHE+PHP5+MYSQL) Server environmentPrepare the article:1, configure the firewall, open 80 ports, 3306 portsVi/etc/sysconfig/iptables-A input-m state--state new-m tcp-p TCP--dport 80-j ACCEPT

Scenario Description:today's scene is the previous week in the network infiltration encountered, found a MySQL database weak password. The account number and password are root, the DBA in MySQL, respectively. In fact, the permissions are very large,

Keepalived is a software similar to the Layer3, 4 & 7 switch, which is what we normally call the 3rd, 4th, and 7th layers of exchange.Introduction:The role of keepalived is to detect the state of the Web server, if a Web server freezes, or a work

When we use the traditional mysql_connect, mysql_query method to connect query database, if the filter is not strict, there is the risk of SQL injection, resulting in the site is attacked, out of control. Although you can use the

2013-03-12 22:07 1503 people read comments (0) favorite reports Classification:Hadoop (+)Directory (?) [+]Hadoop+hive+mysql Installation DocumentationSoftware version Redhat Enterprise server5.5 64 Hadoop 1

I want to create a new user account on the MySQL server and give him the appropriate permissions and resource restrictions. How do I create and set up a MySQL user from the command line?To access a MySQL server, you need to log in with a user

Now you are doing an interface that operates on different databases with different connection strings. To use MySQL database, this database has not been used before, with access and SQL Server more. Through some information on the internet and their

LR monitors mysql under Linux with SNMPTo install SNMPunder Linux:1. Use system disk to install RPM package (this is the best way)2. Download the NET-SNMP installation at www.net-snmp.org (you may not find the snmpd.conf file after installation)Tar

MySQL's "slow query" refers to an SQL statement that exceeds the maximum allowable query time ( long_query_time ), and the "unused index" query, by definition, is the SQL statement that the query statement does not use to the index.Slow query

Command formatSHOW [Full] ProcesslistShow Processlist shows which threads are running. You can also use the mysqladmin processlist statement to get this information. If you have super privileges, you can see all the threads. Otherwise, you can only

One, Win7 under do install Ubuntu Download ununtu14.04 and EASYBCD software Win7 to free up a disk to install Ubuntu. I formatted the F-disk and then went back to the desktop, right-click on computer--------------------------- Open

MySQL cmake Parameter Description manualMySQL has started using the CMake compilation tool since version 5.5, so it is normal that you cannot find the Configure file in the installation source file. A lot of people down to the new version of MySQL,

Production environment:Operating system: CentOS6.6Database system: MySQL 5.5.41-cll-lveSecure terminal emulation software (telnet tool): Xshell 5Problem: In the learning and practice operation, found fullscreen fast, view inconvenient, so want to

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements, hy000satisfy To enhance security, MySQL5.7 randomly generates a password for the root user. In the error log, for the location of the error log, if the RPM package

MySql database Stored Procedure Learning I used to hear from others about the stored procedure at work. I thought it was a very advanced thing. I used my spare time to read the relevant knowledge. Now I will summarize my learning knowledge as