2008-02-29 Matthias Leich
=========================
1. The testsuite "funcs_1" is mostly intended for additional (compared
to the common regression tests stored in mysql-test/t) checks
of features (VIEWS, INFORMATION_SCHEMA, STORED PROCEDURES,...)
introduced with MySQL 5.0.
2. There were some extensions of this suite when new information_schema
views were introduced. But in most cases the tests for these views
were stored within the regression testsuite (mysql-test/t).
INFORMATION_SCHEMA views introduced with MySQL 5.1
==================================================
ENGINES (partially tested here)
EVENTS (partially tested here)
FILES
GLOBAL_STATUS
GLOBAL_VARIABLES
PARTITIONS
PLUGINS
PROCESSLIST (full tested here)
PROFILING
REFERENTIAL_CONSTRAINTS
SESSION_STATUS
SESSION_VARIABLES
3. Some hints for maintainers of this suite:
- SHOW TABLES ... LIKE '<pattern>'
does a case sensitive comparison between the tablename and
the pattern.
The names of the tables within the informationschema are in uppercase.
So please use something like
SHOW TABLES FOR information_schema LIKE 'TABLES'
when you intend to get the same non empty result set on OS with and
without case sensitive filesystems and default configuration.
- The name of the data dictionary is 'information_schema' (lowercase).
- Server on OS with filesystem with case sensitive filenames
(= The files 'abc' and 'Abc' can coexist.)
+ default configuration
Example of behaviour:
DROP DATABASE information_schema;
ERROR 42000: Access denied for user ... to database 'information_schema'
DROP DATABASE INFORMATION_SCHEMA;
ERROR 42000: Access denied for user ... to database 'INFORMATION_SCHEMA'
- Try to unify results by
--replace_result $engine_type <engine_to_be_tested>
if we could expect that the results for storage engine variants of a
test differ only in the engine names.
This makes future maintenance easier.
- Avoid the use of include/show_msg*.inc.
They produce "SQL" noise which annoys during server debugging and can be
easy replaced by "--echo ...".
没有合适的资源?快使用搜索试试~ 我知道了~
xtrabackup
需积分: 50 20 下载量 4 浏览量
2019-01-09
17:21:49
上传
评论
收藏 86.1MB GZ 举报
温馨提示
共13381个文件
test:4954个
result:4841个
opt:1304个
1.解压下载好的xtrabackup软件包: [root@B2B-bmc-db1 caoshaowu]# chown root.root percona-xtrabackup-2.4.9-Linux-x86_64.tar.gz [root@B2B-bmc-db1 caoshaowu]# tar -zxvf percona-xtrabackup-2.4.9-Linux-x86_64.tar.gz [root@B2B-bmc-db1 caoshaowu]# mv percona-xtrabackup-2.4.9-Linux-x86_64 /usr/xtrabackup2.4 2.修改环境变量,将xtrabackup的bin目录放到PATH变量里 [root@B2B-bmc-db1 bin]# vi /etc/profile export PATH=/data/mysql/base/bin:/usr/xtrabackup2.4/bin:$PATH [root@B2B-bmc-db1 bin]# source /etc/profile [root@B2B-bmc-db1 caoshaowu]# cd /usr/xtrabackup2.4/bin/ [root@B2B-bmc-db1 bin]# ls innobackupex xbcloud xbcloud_osenv xbcrypt xbstream xtrabackup [root@B2B-bmc-db1 bin]# ll
资源推荐
资源详情
资源评论
收起资源包目录
xtrabackup (13381个子文件)
binlog_old_version_4_1.000001 146KB
bug33029-slave-relay-bin.000001 4KB
binlog_transaction.000001 2KB
binlog_savepoint.000001 1014B
binlog_transaction_with_GTID.000001 789B
binlog_transaction_with_anonymous_GTID.000001 638B
bug16266.000001 532B
trunc_binlog.000001 174B
bug40482-bin.000001 172B
binlog_no_fd_event.000001 168B
binlog_truncated_prev_gtid_event.000001 129B
master-bin.000001 98B
binlog_truncated_event.000001 14B
bug11747887-bin.000003 729B
corrupt-relay-bin.000624 89KB
ver_trunk_row_v2.001 148KB
ver_5_1_23.001 147KB
ver_5_1-wl2325_s.001 146KB
ver_5_1-wl2325_r.001 705B
bug32407.001 516B
innobackupex.1 87KB
xtrabackup.1 59KB
xbstream.1 4KB
xbcrypt.1 2KB
bug47012.ARM 19B
bug48633.ARM 19B
bug46565.ARZ 8KB
bug48633.ARZ 157B
bug47012.ARZ 22B
default.weekly.basic 5KB
Berlin 2KB
README.bhs 839B
update-full-row.binlog 614B
update-partial-row.binlog 606B
write-partial-row.binlog 596B
write-full-row.binlog 571B
README.checksum 738B
ddl.cln 113B
cmake_install.cmake 2KB
default_mysqld.cnf 4KB
my.cnf 2KB
rpl_1slave_base.cnf 2KB
default_mysqld_autosize.cnf 2KB
my.cnf 2KB
ndb_rpl_multi_binlog_update.cnf 2KB
my.cnf 2KB
ndb_rpl_break_3_chain.cnf 2KB
default_ndbd.cnf 2KB
ndb_big_addnode.cnf 1KB
ndb_config_mycnf1.cnf 1KB
rpl_ipv4_as_ipv6.cnf 1KB
rpl_ip_mix.cnf 1KB
rpl_ip_mix2.cnf 1KB
rpl_ipv6.cnf 1KB
rpl_1slave_base.cnf 1KB
default_my.cnf 1KB
ndb_multi_tc_takeover.cnf 1KB
my.cnf 1KB
ndb_binlog_log_reads.cnf 1KB
ndb_add_node.cnf 1000B
ndb_binlog_variants.cnf 975B
rpl_gtid_stress_failover.cnf 972B
ndb_rpl_circular_2ch.cnf 948B
ndb_fk_addnode.cnf 931B
rpl_test_framework.cnf 913B
ndb_rpl_conflict_read_tracking.cnf 889B
ndb_addnode_withbinlog.cnf 869B
ndb_rpl_conflict_epoch_trans.cnf 868B
ndb_rpl_conflict_epoch_extended_exceptions_table.cnf 868B
ndb_rpl_conflict_epoch_trans_ext.cnf 868B
ndb_dd_initial_lg.cnf 796B
ndb_rpl_conflict_epoch2_trans.cnf 754B
rpl_multi_source_slave_files.cnf 754B
ndb_addnode.cnf 665B
ndb_binlog_default_format.cnf 663B
ndb_share.cnf 652B
ndb_config_mycnf2.cnf 641B
my.cnf 640B
ndb_add_partition.cnf 594B
ndb_rpl_conflict_epoch_ext.cnf 561B
ndb_rpl_conflict_epoch.cnf 561B
my.cnf 554B
my.cnf 546B
ndb_wait_until_ready.cnf 544B
ndb_add_node_mysqld.cnf 526B
ndb_restore_undolog.cnf 509B
bug13637411.cnf 490B
ndb_bushy_joins.cnf 476B
rpl_gtid_empty_transaction.cnf 465B
ndb_one_fragment.cnf 443B
rpl_semi_sync_wait_slave_count.cnf 443B
my.cnf 435B
ndb_many_fragments.cnf 433B
ndb_blob_big.cnf 380B
default_client.cnf 367B
rpl_multi_source_open_temp_tables_warning.cnf 351B
rpl_row_img.cnf 349B
my.cnf 348B
rpl_semi_sync_ack_thread.cnf 335B
ndb_suma_handover.cnf 324B
共 13381 条
- 1
- 2
- 3
- 4
- 5
- 6
- 134
资源评论
qq_35829232
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功