Ubuntu 根目录（/）空间不足处理-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Ubuntu 根目录（/）空间不足处理

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:39 PM

ubuntuinsufficientdeal withclientQuickTable of contentsspacehotel

近几日某快捷酒店的客户资料数据库被曝光，共有2000万条记录。得到备份文件后我就想导入自己服务器的MySQL数据库来处理。可惜一波三折，小问题有如下几个：一、5.3G的SQL文件通过FTP上传服务器 phpmyadmin 的 upload 文件夹后通过 phpmyadmin 导入，因为结

近几日某快捷酒店的客户资料数据库被曝光，共有2000万条记录。得到备份文件后我就想导入自己服务器的MySQL数据库来处理。可惜一波三折，小问题有如下几个：

一、5.3G的SQL文件通过FTP上传服务器 phpmyadmin 的 upload 文件夹后通过 phpmyadmin 导入，因为结构问题，失败。

二、采用SSH登陆到 MySQL 命令行，Source命令导入 upload 文件夹中的 5.3GB SQL文件成功，可惜随着SSH窗口关闭，期待中的后台继续插入也停止了。

三、采用 Screen 命令开窗口继续 Source ，后台可以正常导入。但是速度真慢，导了五个多小时才进去30万条记录，这2000万条不就需要20天？坚决不能忍受！！

四、怀疑是数据引擎问题，因为都是 InnobDB,换成MyISAM再次以 Root filesystem)”空间不足，当时安装划分了
/boot 256MB
/tmp 5GB
/home 450GB
/ 11GB
/swap 1024MB

11GB 怎么就不够了呢，多方查找才知道是数据库记录文件作怪，表现形式为：
目录 “/usr/local/mysql/data/” 下存在大量的运行记录文件，文件名为
mysql-bin.000001~~~mysql-bin.002081 等几千个，大小从几十 KB到900MB不等。

原来是数据记录文件，进入Mysql 输入命令

mysql> reset master; (清除日志文件)

进系统一看，原来 / 分区占用97%，现在只用了 51% ，原来这些日志竟然占了5GB左右。惊人！

经查，Mysql Data目录下大量mysql-bin.**** 文件是叫做MySQL Binary Log，
主要有下面两个作用：

数据恢复。
在主从服务器上提高复制的可靠性。这个其实是主要的作用，但是我根本没有主从服务器，所以用不着，所以修改配置文件，关闭系统日志和同步记录。

命令如下：

找到my.cnf或者my.ini
#log-bin=mysql-bin
#binlog_format=mixed

重启MySQL，彻底解决！

原文地址：Ubuntu 根目录（/）空间不足处理, 感谢原作者分享。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Explain the InnoDB Buffer Pool and its importance for performance.Apr 19, 2025 am 12:24 AM

InnoDBBufferPool reduces disk I/O by caching data and indexing pages, improving database performance. Its working principle includes: 1. Data reading: Read data from BufferPool; 2. Data writing: After modifying the data, write to BufferPool and refresh it to disk regularly; 3. Cache management: Use the LRU algorithm to manage cache pages; 4. Reading mechanism: Load adjacent data pages in advance. By sizing the BufferPool and using multiple instances, database performance can be optimized.

MySQL vs. Other Programming Languages: A ComparisonApr 19, 2025 am 12:22 AM

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.

Learning MySQL: A Step-by-Step Guide for New UsersApr 19, 2025 am 12:19 AM

MySQL is worth learning because it is a powerful open source database management system suitable for data storage, management and analysis. 1) MySQL is a relational database that uses SQL to operate data and is suitable for structured data management. 2) The SQL language is the key to interacting with MySQL and supports CRUD operations. 3) The working principle of MySQL includes client/server architecture, storage engine and query optimizer. 4) Basic usage includes creating databases and tables, and advanced usage involves joining tables using JOIN. 5) Common errors include syntax errors and permission issues, and debugging skills include checking syntax and using EXPLAIN commands. 6) Performance optimization involves the use of indexes, optimization of SQL statements and regular maintenance of databases.

MySQL: Essential Skills for Beginners to MasterApr 18, 2025 am 12:24 AM

MySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.

MySQL: Structured Data and Relational DatabasesApr 18, 2025 am 12:22 AM

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

MySQL: Key Features and Capabilities ExplainedApr 18, 2025 am 12:17 AM

MySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.

The Purpose of SQL: Interacting with MySQL DatabasesApr 18, 2025 am 12:12 AM

SQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.

MySQL for Beginners: Getting Started with Database ManagementApr 18, 2025 am 12:10 AM

The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA

See all articles