Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

是不是不支持分析myisam表 #1

Open
david6522 opened this issue Oct 19, 2020 · 6 comments
Open

是不是不支持分析myisam表 #1

david6522 opened this issue Oct 19, 2020 · 6 comments

Comments

@david6522
Copy link

image
当执行上面生成回滚语句的时候报错,提示遇到的那个库表是myisam表就直接退出了,要是不支持myisam表分析的话,能否加过滤某个数据库的功能呢

@liuhr
Copy link
Owner

liuhr commented Oct 19, 2020

能提供下myisam伪代码表结构吗,我这边可以测试下。可以加过滤库的参数呢,有时间我支持下这个功能。

@liuhr
Copy link
Owner

liuhr commented Oct 19, 2020

已经添加了-ignoreDatabases 、-ignoreTables 可以用来过滤库或表。

@david6522
Copy link
Author

能提供下myisam伪代码表结构吗,我这边可以测试下。可以加过滤库的参数呢,有时间我支持下这个功能。

CREATE TABLE heartbeat (
port smallint(5) unsigned NOT NULL DEFAULT '3306',
onlinetime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (port)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

@david6522
Copy link
Author

已经添加了-ignoreDatabases 、-ignoreTables 可以用来过滤库或表。

so fast,3Q

@liuhr
Copy link
Owner

liuhr commented Oct 19, 2020

报错问题验证了,当前还不能解析库名(360monitor)开头带数字形式。

@david6522
Copy link
Author

360monitor
晓得了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants