简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

MySQL压缩表的一种应用

WBOY
Release： 2016-06-07 15:54:59
Original
1259 people have browsed it

1.设置服务器参数innodb_file_per_table=ONinnodb_file_format=Barracuda 2.创建表或者修改表参数alter table sod_song_log_2014

1.设置服务器参数
innodb_file_per_table=ON
innodb_file_format=Barracuda

2.创建表或者修改表参数
alter table sod_song_log_2014_10_12 row_format=compressed key_block_size=8;

业务系统都有很多日志数据,超过半年一年可以做离线处理,但是不能删除(老板说以后要做数据挖掘)
这时候可以单独启动一个实例,作为集中日志服务器,所有的表均采用压缩表
 这样既可以使用数据(挖掘),又可以减少磁盘空间占用.

压缩之前的日志数据

在经过压缩之后,

可以看到占用空间从3.2G减小为1.2G.效果十分明显.

本文永久更新链接地址：

，
Related labels：
database
source：php.cn
Previous article：OGG-03510问题处理 Next article：RAC本地数据文件迁移至ASM的方法
Statement of this Website
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
Latest Articles by Author
Latest Issues
How to list data in a section by ID using while loop in PHP? I have a mysql table with these columns: series_id, series_color, product_name In the outp...
From 2023-11-17 20:03:03
0
1
290
Fix issue in Laravel-8 trying to read property "id" on null I get this error when running phpartisanmigrate:fresh --seed This command will create a ta...
From 2023-11-08 14:07:01
0
2
155
sqlalchemy.exc.ArgumentError: list argument must contain only tuples or dictionaries I've been trying to use sqlalchemy to dump data into a mysql database. When I try to do th...
From 2023-11-07 21:06:02
0
1
286
Is full count query really that slow on a large MySQL InnoDB table? We have a large table with millions of entries. Full counting is very slow, see code below...
From 2023-11-07 15:52:43
0
2
236
Insert conversion using MySQL I'm trying to insert a value into a table in MySQL but can't get it to work. I'm using the...
From 2023-11-02 19:47:58
0
2
286
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！