When we are ready to back up or maintain data, we often consider the size of disk space, and usually need to know how large our data and logs are. Data is vital and the data is the lifeline.
Use the Mysqldiskusage tool to view the space used by the
This error occurs if you want to connect to your MySQL:
ERROR 1130:host ' 172.21.200.35 ' isn't allowed to connect to this MySQL server
Workaround:
1, Change Table method. Your account may not be allowed to log in remotely, only in localhost.
Interim solution
Execute MySQL command: Show full processlist;
Then find the system ID of the INSERT statement
Execute mysql command: Kill ID
On the network to find the relevant information, here are excerpts:
First, review the process
MySQL view SQL statement execution history
Cat ~/.mysql_historyFor versions after MySQL version 5.1, you can start logging in the following ways. The ability to record SQL statements that include application execution.
MARIADB [(None)]> SET GLOBAL
In daily work, we often encounter product classification, article classification and so on 修改不频繁 multi-level classification. The usual approach is similar to this structure:
General Practice
If you follow a multilevel query, you
MySQL is stored in disk, all kinds of natural and man-made disasters will result in data loss. Large companies when we often need to do good data hot and cold preparation, for small companies to do all the data backup needs to spend a lot of costs,
There are a lot of database operating software, online words phpmyadmin is very good software,
Compared to the pit dad is one of my machine with the AMH panel, encountered a very depressing thing.
We all know that in the absence of independent
First, modify the Linux default IO scheduling algorithm.
Linux default IO scheduling algorithm for CFQ, need to modify to Dealine, if it is SSD or PCIE-SSD equipment, need to modify to NoOp, you can use the following two ways to modify.
1, online
Three free space, photo space MySQL Tutorials PHP tutorials etc
yandex.ru Free unlimited capacity, unlimited Web page space, pure static space, a single file maximum limit of 5m, support FTP upload management files, free to provide
ribbon.to free 500m/php/mysql/ftp/subdomain/ads space
Ribbon.to is a website from Japan, free 500M Web page space, traffic restrictions unknown, support PHP dynamic language and MySQL database, support FTP upload management files, can modify
1, first of all, need an account to get status information1.1 Authorize an ordinary user, can login into MySQL using the-e parameter show status get1.2 can also use mysqladmin extended-status to obtain2, add a section to the scheduled task, as
First found the incompatible package, so we want to remove the conflicting libs package, and then go to install!
The code is as follows
Copy Code
RPM-E--nodeps mysql-5.0.95-5.el5_9.x86_64or useYum-y Remove mysql-libs-5.0.
The functionality provided through MySQL
Export
Command:
Mysqldump-u user name-P database > database. sql
Example:
The code is as follows
Copy Code
Mysqldump-u root-p db1 > Db1.sql (Backup of database db1 to Db1.sql)
Read uncommitted (not submitted)It is visible to other transactions even if no commit is made. Uncommitted data may cause Dirty Read ).Test process:1. A Sets read-uncommitted and start transaction.2. Execute start transaction to modify a record,3. A
If you choose mysql database as a data persistence tool, you need a reasonable log configuration, which will help you to troubleshoot and back up and recover data!First, we can use the following MySQL SQL to query the log configuration in
Install MySQL in Windows and use the official configuration wizard to generate my. ini, I thought it was very stable. Who knows that after more than 10 hours, the system response was very slow. Looking at the performance card of the resource manager,
Sometimes the database host suddenly loses power or shuts down unexpectedly, the following error occurs when starting the MySQL database:Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/var/localhost. pid
The VPS operating system is CentOS 6, and the mysql version is 5.5.31 (the REMI source is used ).A. Configure the installation source of MariaDB first.Currently, the main version of MariaDB is MariaDB 5.5.33a Stable. Save the following installation
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