Server 120G SSD hard disk space used 92%, after inspection found that the original MySQL binary log is not in time to remove, occupy a lot of space, so directly with the command: Reset master a delete clean.
The code is as follows
Access to the site today, the database link error, and then want to restart the LNMP environment, found that the MySQL service can not be properly shut down, recall that the server has been running smoothly for 4 months, the configuration should not
LNMP installation of a key install the MySQL default is to open the log file, if the data operation is more frequent will produce a lot of log, under/usr/local/mysql/var/produce mysql-bin.0000* similar files, And generally in dozens of MB to several
1. No longer save historical records or reduce the number of historical records savedModify/etc/profile to change histsize=1000 to 0 or quantity to keepClears the. Bash_history under the user's home path.
Copy Code code as follows:
Echo '
The steps:First need to edit the file in: /etc/hostconfig and remove the lineSince This is a system file I advise your to open it with the Nano in Terminal:
Open Terminal
sudo nano/etc/hostconfig
Enter your password if you ' re not
To stop the MySQL service first, you can stop its service in preferences and then execute the following command$ sudo rm/usr/local/mysql$ sudo rm-rf/usr/local/mysql*$ sudo rm-rf/library/startupitems/mysqlcom$ sudo rm-rf/librar y/preferencepanes/my*$
After the mysql master-slave settings, if the operation is improper, the data on server B of server A will be automatically deleted simultaneously. If the deletion is wrong, it means that you have not backed up the database, the following section
Like installing many software, if it is the second installation, it is much more complicated than the first installation. Many things may not be installed because they are not deleted. This installation is an example.
The following describes how to
This tutorial describes how to query and delete the mysql view. You can use the show view name to query the view and delete the mysql view with the drop permission. However, you must have the drop permission to delete the view. Next let's take a
This example describes how to delete duplicate MySQL data. Share it with you for your reference. The specific method is as follows: Project background in a recently developed linux performance collection project, the thread program is found to be
First, use rpm-Qa | grep MySQL to find out all MySQL version packages and unmount them one by one. Then, remember to back up all files in the var/lib/MySQL directory as tar and copy them to the root directory. switch to the "Find/-name MySQL"
The following articles mainly introduce the actual operation steps for MySQL users. We will first describe them from the creation of user havend, the following is a collective description of the specific operation steps of the article, hoping to
Mysql ResourcesMysql5.1 Chinese Reference ManualMysql ManagementInstall mysql5.5 using mysql Binary Package Based on linuxMysql client command line optionsMysqld server system variables and status variablesMysql SQL Server ModeMysql account
How the MySQL Privilege system worksthe MySQL privilege system is certified through the following two phases:(1) authenticating the user to theconnection, the legitimate user passes the authentication, the illegal user refuses the connection;(2) to
O & M automation-ansibleplaybook installing mysql last introduced how to use ansible playbook to install zabbix client (http://dl528888.blog.51cto.com/2382721/1436745), this time introduced how to use playbook to install mysql.
The following is the
Cluster O & M automation tool ansible uses playbook to install mysql Cluster
Last time I introduced how to use ansible playbook to install the zabbix client (http://www.bitsCN.com/article/52158.htm), this time I introduced how to use playbook to
Last described how to install the Zabbix client (http://www.jb51.net/article/52158.htm) using Ansible playbook, this time describes how to use playbook to install MySQL.
Here is the information for installing MySQL:
How to completely uninstall MySQLA complete way to uninstall MySQL 5.x:1, the Control Panel in the increase in the removal program to delete2, delete the MySQL installation folder C:\Program Files\mysql, if the backup is good, you can delete all
Requirements Scenario:
There is a business database, using the MySQL 5.5 version, write a large amount of data every day, you need to regularly delete the "specified time before" data in multiple tables, it is easy to implement in SQL Server, write
Find out what binary log files are currently
The code is as follows
Copy Code
Mysql> show binary logs;+------------------+-----------+| Log_name | File_size |+------------------+-----------+| mysql-bin.000001 | 1357315
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.