mysql怎么开启归档模式？Linux下

1.管理员身份连接数据库 C:\Users\Administrator>sqlplus sys/sys@prjdb as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 17 23:50:55 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Datab...

运行下面的DOS命令，粘贴结果上来大家帮你看： NETSTAT -ANO 可以把结果输出到记事本文件，命令是： NETSTAT -ANO >C:\NET.TXT 粘贴C:\NET.TXT的记事本文件内容上来。 补充： 错误信息是你输入密码不正确，与什么防火墙都无关。

1、

[root@localhost mysql]# scripts/mysql_install_db

Neither host 'localhost.localdomain' nor 'localhost' could be looked up with

/resolveip

Please configure the 'hostname' command to return a correct

hostname.

If you want to solve this at a later stage, restart this script

with the --force option

这个主要是修改/etc/hosts文件

echo "127.0.0.1 localhost.localdomain localhost" >>/etc/hosts

然后再初始化数据，如果还是同样的错误，那就直接加--force开关。

我今天碰到的就是这个情况。

[root@localhost mysql]# scripts/mysql_install_db --force

Installing MySQL system tables...

OK

Filling help tables...

OK

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/local/mysql//bin/mysqladmin -u root password 'new-password'

/usr/local/mysql//bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

See the manual for more instructions.

You can start the MySQL daemon with:

cd . /usr/local/mysql//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd mysql-test perl mysql-test-run.pl

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at

扫描更快。一些核心的业务表需要以T +1的方式抽取数据仓库中，比如每天晚上00:30抽取前一天的数据，都是通过create_time过滤的。

数据归档方式通用数据归档方法优化后的归档方式这样原表和归档表都是按月的分区表，只需要创建一个中间普通表，在业务低峰期做两次分区交换，既可以删除无效数据，又能回收空，而且没有空间碎片，不会影响表上的索引及SQL的执行计划。

查看更多

---