MySQL management tools MySQL Utilities query the size of the space used by MySQL

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

MySQL database cannot be resolved from a remote connection

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.

MySQL Error: Error 1205 (HY000): Lock Wait timeout exceeded solution

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 examples of SQL statement execution history

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

MySQL database multi-instance configuration steps detailed

[Root@mysql ~]# yum install vim gcc gcc-c++ wget tree lsof ncurses-devel cmake-y #依赖库[Root@mysql ~]#/usr/sbin/useradd mysql-s/sbin/nologin-m #mysql用户[Root@mysql ~]# cd/byrd/tools/[Root@mysql tools]# wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-

MySQL multi-level classification storage mode (product classification, article classification)

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

A tutorial on restoring Mysql ibdata lost or corrupted data via FRM&IBD

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,

MySQL database root account permission loss problem Solving method

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

A tutorial on optimizing MySQL's running environment under Linux

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, picture space MySQL PHP, etc.

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

Two Japan php/mysql/ftp no advertising space

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

Zabbix3.0.3 Monitor single host MySQL status state

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

Linux upgrade MySQL hints conflicts with file from package workaround

ssh

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.

A summary of MySQL database backup method under Linux

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)

MySQL transaction isolation level introduction and settings

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

Log configuration for mysql optimization

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

Solution to the problem of occupying too many MySQL handles

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,

Mysql log analysis tutorial

Solution to MySQL failure in CentOS6

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

How to migrate MySQL database to MariaDB in CentOS6

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

Total Pages: 3233 1 .... 1588 1589 1590 1591 1592 .... 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.