MySQL Slow query log

MySQL itself supports slow query logging, which can be configured to log queries that exceed a specific time in SQL queries. This is a very effective tool in optimizing SQL queries to help us quickly locate the SQL that has the problem.  Variables

"Ubuntu14" Nginx+php5+mysql record

This time, because of the work, it needs to be developed under Linux. The recommended environment is ubuntu14+nginx+php+mysql. After the environment is set up, install git, install the IDE, feel the MySQL command interface trouble and installed a

Ubuntu System install MySQL (deb-bundle pack)

For some reason, it's time to install MySQL in the Ubuntu system, which has been installed many times before. It's not written down.has been used to install the source code package, based on two reasons: 1. Always write code in Python. 2. Want to

MySQL Show processlist Command detailed

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

Linux cluster-load balancer LVS-DR implementation MySQL

The previous article on the introduction of load Balancer LVS has explained the principle of lvs-dr, this article mainly introduces its implementation process in MySQL application:Test environment: 4 virtual machines are CENTOS6 operating systems,

Modify database MySQL character encoding to UTF8

Modify database MySQL character encoding to UTF8The MySQL database is an open-source database that is widely used. The following is a procedure for modifying the character encoding of a MySQL database. Step 1: View the current character encoding

Encountered a problem, local PHP environment connected to other host's MySQL error 1130:host ' 192.168.1.222 ' is not allowed to connect to this MySQL server

Problem description, 1 check whether the MySQL service is started,2 shutting down the firewallNetfilter/iptables off mode [[email protected] ~] #iptables-FSELINUX shutdown mode [[email protected] ~] #setsebool-P samba_enable_home_dir on3 See if

Setup Apache + PHP + MySql on Windows 10

The below steps recorded my experiences to setup the Apache + PHP + MySql on my Windows 10.1. Download Apache http Server from HTTP://WWW.APACHEHAUS.COM/CGI-BIN/DOWNLOAD.PLX, unzip and put it to C:\ApacheServer.2. Download php from

RHEL 6.4 Installing MySQL with MySQL installation files

Reference article: http://www.linuxidc.com/Linux/2013-12/93507.htm1. Download the MySQL installation file firstI am downloading the latest version of the 5.62.install MySQL in rpm modeIn a rhel system, the "mysql-shared-compat-5.6.15-1.el6.i686.rpm"

ZH cheese: Ubuntu 14.04 installation lamp (linux,apache,mysql,php)

(Linux Operating system,apache Web server,mysql database,php)0. Introduction of LampLinux+apache+mysql/mariadb+perl/php/python a group of open-source software that is often used to build dynamic Web sites or servers is itself a separate program, but

Linux crontab+php implementation of MySQL database scheduled backup

IntroductionDatabase backup in large projects is essential, or if there is a big problem on GG, although this article is about using PHP to implement database scheduled backup, but this is not a good solutionTo regularly back up the database, the

MySQL command line, how to cancel/return to modify the command in front of the multi-line command

MySQL command line when executing a multi-line command, if the command entered in front of an error, is unable to return the modification, but can be input \c to cancel the front input, but at this time if the front input a lot of things, the direct

Mysql Load Data command parsing, handling error (ERRCODE:13) errors (in Ubuntu environment)

On the MySQL server, you can use the load data infile ' file_name ' into table table_name; command to save all the data in a text file to the specified table. Examples of the most sketchy forms:Load data infile ' test.txt ' into table test_table;By

MySQL Common Operations Command

Mysql forgot root passwordMethod One:Add below/etc/my.cfg [mysqld]Skip-grant-tables or Skip-grant.Restart MySQLUse MySQL;UPDATE user SET Password = Password (' New-password ') WHERE user = ' root ';MySQL flush privileges;Change the My.cfg file back

MySQL Backup recovery Tool xtrabackup

1. IntroductionXtrabackup is an open-source, free MySQL database backup tool provided by Percona, which is able to perform hot backups of InnoDB and XTRADB databases, which, according to official introduction, has the following features:1. The

"Go" use optimize, stored procedures, and system tables to bulk-defragment the MySQL database tables to free up tablespace

This article collects in my notebook, because cannot find the original source. Omitted in this, as if who knows can contact me plus.The core is to use the MySQL system table and the "optimize table name " command, the MySQL data table for the space

Freeradius + pptpd + mysql VPN Service System in Ubuntu, freeradiuspptpd

Freeradius + pptpd + mysql VPN Service System in Ubuntu, freeradiuspptpd /* The following operations are performed on the radius server */# update the source sudo apt-get update # install Mysqlsudo apt-get install-y mysql-server mysql-client #

Detailed instructions on how to query and clear MySQL cache commands,

Detailed instructions on how to query and clear MySQL cache commands, Mysql query CacheThe query cache function is to receive the same query as the previous query, and the server will query the cache results instead of re-analyzing and executing the

How to use MySQL to sort query results and limit the number of returned results,

How to use MySQL to sort query results and limit the number of returned results, Sorting of MySQL Order By query resultsORDERThe order by keyword in SQL syntax is used to sort the query results.Sorting is divided into two types: Ascending ORDER (ASC)

Detailed description of the usage of the WHERE clause in MySQL, detailed description of the mysqlwhere clause

Detailed description of the usage of the WHERE clause in MySQL, detailed description of the mysqlwhere clause We can see that the SQL SELECT command is used to obtain data from the MySQL table. We can use the filter results in the WHERE clause of a

Total Pages: 3233 1 .... 283 284 285 286 287 .... 3233 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.