Article link: HTTPS://BLOG.HHUI.TOP/HEXBLOG/2018/06/01/180601-MYSQL Performance monitoring Tool mytop/MySQL Performance monitoring gadget mytopReference: How to use Mytop to Monitor MySQL performanceI. Installation and ConfigurationCan be installed
ViewA view is a virtual table (not a real one), which is essentially "getting a dynamic dataset from an SQL statement and naming it", which allows the user to get a result set using only "name" and use it as a table.Select *from (
WAMPWindows Apache+mysql/mariadb+perl/php/python, a group of open-source software used to build dynamic Web sites or servers, are themselves separate programs, but because they are often used together, they have a higher degree of compatibility,
The recent CPU usage of one server remains at 100% for a long time, and viewing process discovery is caused by the MySQL service. So search all the information, and finally successfully solve the problem. Memo and share, hope to help you novice
Multi-instance configuration for MySQL? in a physical machine requires multiple test environments, then you need to build a database of multiple instances, multiple instances of the meaning is to run multiple programs, the instance and the instance
Sometimes you may forget the root password of MySQL, and the following will teach you to reset the MySQL root user passwordManually Modify1. Stop MySQL ServiceExecution:/etc/init.d/mysql stop, your machine is not necessarily/etc/init.d/mysql
Once you have successfully installed and configured the MySQL database server, you need to create a database and database user for your confluence:
Run ' with Superuser in MySQL mysql . The default user is ' root ' and the password is empty.
1. Description: Create a default databaseCreate database name;2. Description: Create a database with the specified character encodingCreate database name character set character encoding format;3. Description: Delete Databasedrop database name;4.
1005: Failed to create table1006: Failed to create database1007: Database already exists, database creation failed 1008: Database does not exist, delete database failed 1009: Unable to delete database file causes database failure to be deleted1010:
Primary key not self-increment: The return value is the number of inserted barsid= "Add" parametertype= "estudent"> Insert into Tstudent (name, age) VALUES (#{name}, #{age})InsertPrimary key self-increment:id= "Add" parametertype= "Estudent"
Pymsql is a module that operates MySQL in Python and is used almost the same way as MySQLdb.Download the installation:Pip Install Pymysql1. Execute SQL statements#!/usr/bin/env python#-*-coding:utf-8-*-import pymysql # Create Connection conn =
Because you didn't know the usage of the tinyint type before, you set some state attribute field types to varchar types, and then use "Yes" and "no" to determine the stateLater learned about the tinyint, want to try to use, but to convert the
ObjectiveAs a background development, it is necessary to benchmark the database to master the performance of the database. This article describes the basic concepts of MySQL benchmarking and the detailed methods for benchmarking MySQL using Sysbench.
Date typeIf you want to use the date, it is usually represented by date.It is usually expressed in datetime if it is to be used to denote a month or a day.It is usually represented by time if it is used only to represent seconds and
Show GRANTS for [email protected];Flush privileges;SHOW processlist;#全局授权, Reclaim permissionsGRANT all on * * to ' testzzq ' @ ' localhost ';REVOKE all on * * from ' testzzq ' @ ' localhost ';Flush privileges;#数据库级别, Authorization, reclaim
Learning Goals
Data backup
Data recovery
Database migration
Import and Export
Data backupA system crash or server hardware corruption can cause the database to be lost, so data backup is important in a production
Output HOST1/2 system logs, log to the MySQL server database, and publish loganalyzer structural relationships such as:Preparatory work:
Vmware
CentOS 7 Minimum System installation image
Loganalyzer Source Package Download
background: title, you need to import a piece of data into the MONGO database to reduce the data source that the project relies on.Solution:Use the Mongoimport tool that comes with MONGO.First create an empty collection in the test library:
The OR, in, and union all queries are efficient in which fast.Many of the sounds on the web are that union all is faster than or, in, because or, in causes full table scan, they give a lot of examples.But is the union all really faster than or, in?
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