lepus3.8-Day Rabbit MySQL Database monitoring System build original ixhao2016-08-24 02:36:23 Comments (11) 3183 people read lepus3.8-MySQL database monitoring system build Lepus is an open-source database monitoring software, Detailed monitoring of
An index is a data structure that the storage engine uses to quickly find records. Index optimization is the most effective means of optimizing query performance.1. Type of indexIn MySQL, indexes are implemented at the storage engine layer rather
TRUNCATE (x, y)TRUNCATE (x, y) returns the value of x reserved to the Y-bit after the decimal point (the biggest difference from round is that it is not rounded), see the following example:mysql>SELECT TRUNCATE(7.536432,2);+--------------------------
Li Wu:Heng Learn to think together, honouring teachers save Thanksgiving. Leaf See root three return to one, rivers the same oneness.Meekness Conscience Lord, willing to do without regrets to the most bitter. Reading exercises to keep the body and
1 OverviewSemi-synchronous replication refers to a subset of host synchronous replication, and another part of the host asynchronous replicationThe logic of synchronization is that the user writes to the primary server, the primary service is logged
Usage:1. DROP table TBDrop will delete the table directly, there is no way to retrieve2, truncate (table) TBDelete all data in a table and cannot be used with where3. Delete from TB (where)Delete data from a table (you can make a row)The difference
1. Network detection1) Ping the host can;2) Telnet host 3306 port can not;Telnet host 22 port can be;The description is not related to the native network;2. Port detection1) netstat-ntpl |grep 3306TCP 0 0::: 3306:::* LISTEN-2) Netstat-ntpl |grep
(1) The Export Table Export table is in the prepare phase of the backup, so once the full backup is complete, you can export a table through the--export option during the prepare process: Innobackupex--apply-log--export/ backup/xbackup/full/
MySQL Technical specifications
Oracle MySQL Cloud service
MySQL Database as a service
A flexible architecture
Open source
Multithreading
Pluggable Storage Engine
MySQL Select DatabaseAfter you connect to the MySQL database, there may be multiple databases that you can manipulate, so you need to select the database you want to manipulate.
Select MySQL database from the command Prompt windowIn the Mysql>
organized from the Internet.Summary:The next one is query optimization. In fact, we all know that the query part is far greater than delete and change, so query optimization will take more space to explain. This article will first talk about
For MySQL 5.5, if the character set is not set, the default MySQL character set is the latin1 Latin character set;but with the further development of various businesses, in addition to each country's own language characters, there will often be some
MySQL Master-Slave introductionMySQL master-slave is also called replication, AB replication. Simply said that A and b two machines from the back, on a to write the data, the other B will follow the writing data, the two data in real-time
1. Preparation of two tablesTable ATable B2. Test the connection query:(1) Cross connection (Cartesian product)SELECT * from a a B (2) Inner connectionShow internal connectionsSELECT a.*,b.* from a INNER JOIN B on A.age=b.agebdisplay the INNER join
Nagios monitoring 4 configuration monitoring web Service, port, mysql, and other status instances
1. monitoring web Services
(1) edit services. cfg to define the service
Define service {
Use generic-service
Host_name
Difficulties in hot standby and hot standby of Mysql database
In the past, I have introduced anyone interested in configuring hot standby for Mysql databases, in this section, we will summarize and analyze the important links and precautions.
I.
Ten practical and simple MySQL functions and ten mysql Functions
Function
0. display the current time
Command: select now ().
Purpose: display the current time.
Use Cases: default values such as creation time and modification time.
Example:
mysql>
Mysql database Quick Start (1), mysql database Quick Start1. Database Operations
1.1 connect to the mysql server
Mysql-u root (User Name)-p
1.2 exit the mysql Command Prompt window.
Exit
1.3 view version
Select version ();
1.4 list databases
Show
Database quiz question 2 and database quiz question 2
Questions on Century jiayuan Network
1. count the number of persons in each category (type:
Select type, count (type) from tab_user group by type;
2. Count the total score of five people:
Mysql quiz and mysql quiz
1. the user logon log table xes_user_login_logs is as follows:
(1) retrieve user IDs that have been logged on more than twice (SQL statement)
Select user_id from vvt_ceshi group by user_id having (count (user_id)> 1;
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