美文网首页
TDSQL-磁盘存储结构

TDSQL-磁盘存储结构

作者: 古飞_数据 | 来源:发表于2022-09-23 09:47 被阅读0次
[root@localhost ~]# ls /data /data1
/data:
application  hadoop  monitorcmd  oc_agent       tdsql_run  tools    zkbak
coredump     home    monitorlog  scheduler_log  test       website

/data1:
4001  4002  monitorlog
[root@localhost ~]# ls /data/application/
clouddba  onlineddl  oss  pycrond  scheduler  tdsql_analysis  tdsql_collector  zookeeper  zookeeper.tar.gz
[root@localhost ~]# ls /data/application/clouddba/
bin  conf  data  log  replace_clouddba.sh

[root@localhost ~]# ls /data/application/clouddba/bin/
analyze_monitorlog.py  libjemalloc.so             password_encrypt    session-analyze  stop.sh
clouddba-client.py     master-switch-analysis.py  proxy_log_analyzer  share            tdsql-diagnosis
dt2ts.sh               oc_log                     restart.sh          sql-optimizer    tdsql_inspection.py
dump-proxy-interf-log  oc_tool                    runtime.err         srm              ts2dt.sh
env_depend             parse-processlist-log.sh   safeshell           start.sh         update-config.py

[root@localhost ~]# ls /data/application/clouddba/conf/
db_rules.conf  db_sql_rules.conf  debug_response.json  diagnosis.conf  diagnosis.template  rules.conf

[root@localhost ~]# ls /data/application/clouddba/data/
embedded-mysql

[root@localhost ~]# ls /data/application/clouddba/data/embedded-mysql/
data  tmp

[root@localhost ~]# ls /data/application/clouddba/data/embedded-mysql/data/
auto.cnf  diagnosis

[root@localhost ~]# ls /data/application/clouddba/data/embedded-mysql/data/diagnosis/
db.opt  install_path.frm  install_path.MYD  install_path.MYI  results.frm  results.MYD  results.MYI

[root@localhost ~]# ls /data/application/clouddba/data/embedded-mysql/tmp/

[root@localhost ~]# ls /data/application/clouddba/log/
diagnosis.2022-09-20.0  diagnosis.2022-09-21.0  diagnosis.2022-09-22.0  diagnosis.2022-09-23.0
[root@localhost ~]# ls /data/application/onlineddl/
bin  conf  log
[root@localhost ~]# ls /data/application/onlineddl/bin/
ddlperformer     onlineddl_dep              plugin.pl                runtime.err
ddlperformermng  OnlineSchemaChange-master  pt-online-schema-change


[root@localhost ~]# ls /data/application/oss/
bin  boot  conf  lib  log  tool
[root@localhost ~]# ls /data/application/oss/bin
oss_server
[root@localhost ~]# ls /data/application/oss/boot
cacert.pem  ca.crt  ca.csr  ca.key  init.sh  oss_curl.sh  privkey.pem  restart.sh  script  start.sh  stop.sh
[root@localhost ~]# ls /data/application/oss/conf/
cl5.xml  proxy.json  scheduler.xml
[root@localhost ~]# ls /data/application/oss/log/
sys_tdsql_oss_log.2022-09-20.0  sys_tdsql_oss_log.2022-09-23.0  zk_tdsql_oss_log.2022-09-22.0
sys_tdsql_oss_log.2022-09-21.0  zk_tdsql_oss_log.2022-09-20.0   zk_tdsql_oss_log.2022-09-23.0
sys_tdsql_oss_log.2022-09-22.0  zk_tdsql_oss_log.2022-09-21.0
[root@localhost ~]# ls /data/application/oss/tool
encrypt_tool

[root@localhost ~]# ls /data/application/pycrond/
[root@localhost ~]# ls /data/application/scheduler/
bin  conf  data  lib  log  sql
[root@localhost ~]# ls /data/application/scheduler/bin/
agent_config         get_set_info             noshard_create_set  reset_master      stop_manager.sh
autorepair           lvs_tool                 noshard_privs       resource_tool     update
backupZkInfo         manager                  noshard_privs-new   restart.sh        yunping.version
create_db_stat       manual_set               oc_tool             safeshell         zk_recursion_setacl
crypt_tool           manual_sw                proxy_tool          scheduler         zone_privs
delset               manual_vip               recoverZkInfo       sshpass           zone_privs-new
fetch_keeper_log.py  modify_election          replacehost         sshpass_pack.sh
fixed_gw_vip         modify_manager_variable  res_add_drelation   start_manager.sh
[root@localhost ~]# ls /data/application/scheduler/conf/
backupConf.xml  cl5.xml  scheduler.xml
[root@localhost ~]# ls /data/application/scheduler/data/
zkconfig.xml
[root@localhost ~]# ls /data/application/scheduler/lib/
func_cl5.so  func_cloud.so  mres_comb.so  mres_fixed.so  README
[root@localhost ~]# ls /data/application/scheduler/log/
agent_config.log.2022-09-20.0  lvs_tool.log.2022-09-20.0                 resource_tool.log.2022-09-20.0
local_log_2022_09_20.log       modify_manager_variable.log.2022-09-20.0
local_log_2022_09_21.log       README
[root@localhost ~]# ls /data/application/scheduler/sql/
README

[root@localhost ~]# ls /data/application/tdsql_analysis/
alarm.log  bin  conf  gc.log.0.current  lib  logs  run.pid
[root@localhost ~]# ls /data/application/tdsql_analysis/bin/
alarm_test.sh  confsync.sh  encrypt_tool  monitor.sh  restart.sh  selfmonitor  start.sh  stop.sh  upgrade.sh
[root@localhost ~]# ls /data/application/tdsql_analysis/conf/
conf.properties  logback.xml  metric_map.json
[root@localhost ~]# ls /data/application/tdsql_analysis/conf/logback.xml
/data/application/tdsql_analysis/conf/logback.xml
[root@localhost ~]# ls /data/application/tdsql_analysis/logs/
main.log  main.log-2022-09-20.gz  main.log-2022-09-21.gz  main.log-2022-09-22.gz
[root@localhost ~]# ls /data/application/tdsql_analysis/lib/
audience-annotations-0.5.0.jar  guava-18.0.jar                   metrics-core-3.1.2.jar
aviator-3.1.0.jar               jackson-annotations-2.12.3.jar   mysql-connector-java-5.1.43.jar
c3p0-0.9.5.5.jar                jackson-core-2.12.3.jar          netty-3.10.6.Final.jar
commons-beanutils-1.8.3.jar     jackson-databind-2.12.3.jar      slf4j-api-1.7.7.jar
commons-lang-2.6.jar            jline-0.9.94.jar                 spotbugs-annotations-3.1.9.jar
commons-logging-1.1.1.jar       jsr305-3.0.2.jar                 tdsql_analysis-0.3.7.jar
curator-client-4.0.1.jar        logback-classic-1.2.3.jar        zookeeper-3.4.14.jar
curator-framework-4.0.1.jar     logback-core-1.2.3.jar
curator-recipes-4.0.1.jar       mchange-commons-java-0.2.19.jar
[root@localhost ~]# ls /data/application/tdsql_collector/
bin  conf  data  gc.log.0.current  lib  logs  run.pid
[root@localhost ~]# ls /data/application/tdsql_collector/bin/
encrypt_tool  monitor.sh  restart.sh  start.sh  stop.sh  tnm2_link.sh  upgrade.sh  up.sh
[root@localhost ~]# ls /data/application/tdsql_collector/conf/
conf.properties       metric_dns.json                 metric_http_hdfs.json    metric_shell.json
logback.xml           metric_http_cloud.json          metric_http_mcsvr.json   metric_v3cloud.json
metric_2cloud.json    metric_http_cloud_private.json  metric_http_osssvr.json  metric_zk.json
metric_2lingyun.json  metric_http_cloud_v2.json       metric_mysql.json
[root@localhost ~]# ls /data/application/tdsql_collector/data/
metric.09.16  metric.09.19  metric.09.22  metric.09.25  setmap.09.22  setmap.09.25
metric.09.17  metric.09.20  metric.09.23  metric.09.26  setmap.09.23  setmap.09.26
metric.09.18  metric.09.21  metric.09.24  setmap.09.21  setmap.09.24
[root@localhost ~]# ls /data/application/zookeeper
bin              ivy.xml      README.md                 zookeeper-3.4.14.jar.sha1  zookeeper-recipes
build.xml        lib          README_packaging.txt      zookeeper-client           zookeeper-server
conf             LICENSE.txt  src                       zookeeper-contrib
data             log          zookeeper-3.4.14.jar      zookeeper-docs
doc              NOTICE.txt   zookeeper-3.4.14.jar.asc  zookeeper-it
ivysettings.xml  pom.xml      zookeeper-3.4.14.jar.md5  zookeeper-jute
[root@localhost ~]# ls /data/application/zookeeper/bin/
README.txt    zkCli.cmd  zkEnv.cmd  zkServer.cmd  zkTxnLogToolkit.cmd  zookeeper-1.log
zkCleanup.sh  zkCli.sh   zkEnv.sh   zkServer.sh   zkTxnLogToolkit.sh   zookeeper.out
[root@localhost ~]# ls /data/tdsql_run/
15001  15005  4001  4002

[root@localhost ~]# ls /data/tdsql_run/15005/
gateway  log
[root@localhost ~]# ls /data/tdsql_run/15005/log/
[root@localhost ~]# ls /data/tdsql_run/15005/gateway/
bak  bin  conf  data  log  state
[root@localhost ~]# ls /data/tdsql_run/15005/gateway/bin/
change_rootdir_all.sh         rebuild_runtimeconf               startdcagent_tokafka.sh
change_rootdir_no_cgroup.sh   replacetemplate                   start_proxy.sh
change_rootdir.sh             restartbinlogproduct.sh           start_router_cgroup.sh
change_rootdir_to_noshard.sh  restart_cgroup.sh                 start_router.sh
change_rootdir_to_shard.sh    restartdcagent_tokafka_cgroup.sh  start.sh
dcagent_tokafka               restartdcagent_tokafka.sh         stopdcagent_tokafka.sh
kafka_tool                    restart_proxy.sh                  stop_proxy.sh
libjemalloc.so.4.5.0          restart_router_cgroup.sh          stop_router.sh
load_data                     restart.sh                        stop.sh
load_data_readme.md           router_update                     stop_version.sh
load.ini                      safeshell                         switchdcagent_tokafka.sh
md5                           share                             tdsql_addto_cgroup
mysql-proxy                   srm                               tdsql_cgroup_build
mysql-proxyd                  srm.begin                         tdsql_development_documentation.md
proxy-log-analyzer            srmnew                            update_version.sh
pt-query-digest               start_cgroup.sh                   zk_tool
rebalance                     startdcagent_tokafka_cgroup.sh

[root@localhost ~]# ls /data/tdsql_run/4002/
log                         master-switch-analysis.py  mysql-server-8.0.18
master-switch-analysis.log  mysqlagent                 oc_pull_mysqld.sh
[root@localhost ~]# ls /data/tdsql_run/4002/mysqlagent/
bin  conf  data  log  sql
[root@localhost ~]# ls /data/tdsql_run/4002/mysqlagent/bin/
agent_config                               install_single_proxy           restartbinlogproduct_cgroup.sh
alldump.sh                                 install_tdsql_zkparam          restartbinlogproduct.sh
autocheckhigh2                             kms_tool.py                    restartbinlogtofile.sh
autorepair                                 l5sys.so                       restartlogtoes.sh
binlogproducter                            libiconv.so.2                  restartreport_cgroup.sh
binlogproducter_percona                    libmysqlclient.so.20           restartreport.sh
cgroup_check.sh                            lz4                            restarttransfer.sh
checkdisk                                  migrate.sh                     runtime.err
checkgtid                                  mydumper                       safeshell
cold_mydumper_to_cos.sh                    myloader                       setupes.sh
cold_mydumper_to_hdfs.sh                   mysqlbinlog                    srm
cold_mydumper_to_localfile.sh              mysqlbinlog_flashback          srmnew
cold_xtrabackup_increment_to_cos.sh        mysqlbinlog_flashback_percona  sshpass
cold_xtrabackup_increment_to_hdfs.sh       mysql_insert_test              startbinlogproduct_cgroup.sh
cold_xtrabackup_increment_to_localfile.sh  mysql_param_modify             startbinlogproduct.sh
cold_xtrabackup_to_cos.sh                  mysqlrecoverfromxtrabackup     startbinlogtofile.sh
cold_xtrabackup_to_hdfs.sh                 mysqlrecoverset                startlogtoes.sh
cold_xtrabackup_to_localfile.sh            mysqlreport                    startreport_cgroup.sh
cos_tool.py                                oc_encrypt                     startreport.sh
dcntool                                    oc_tool                        stopbinlogconsumer.sh
decompression                              parse-processlist-log.sh       stopbinlogproduct.sh
dep                                        procmonitor                    stoplogtoes.sh
drop_backup                                pt-query-digest                stopreport.sh
encrypt                                    pt-table-checksum              tdsql_addto_cgroup
encrypt_tool                               pt-table-sync                  tdsql_cgroup_build
getlastgtid                                pv                             tdsql_keyring
getlastgtidbytime                          recovertool                    traceprocesslist
getNetSpeed.sh                             recovertool_percona            transfer_account
getZkLeader.sh                             reinstall_mysql                truncatebinlog
gtidlistcache_percona                      relayhbts_mariadb              truncatebinlog_percona
gtidlist_percona                           relayhbts_percona              truncatFileFromEnd.sh
gtidprint                                  relaylogrepair                 uninstall_single_proxy
gtidprint_percona                          relaymasterpos_percona         uninstall_single_tdsql
gtidtofilepos                              repairsysdb_mariadb            xatool
gtidtofilepos_percona                      repairsysdb_percona            zkinfo_copy
initcgrouphierarchy.sh                     replacetemplate

[root@localhost data1]# tree /data1/4002/
/data1/4002/
├── dbdata_raw
│ ├── data
│ │ ├── auto.cnf
│ │ ├── ca-key.pem
│ │ ├── ca.pem
│ │ ├── client-cert.pem
│ │ ├── client-key.pem
│ │ ├── erp
│ │ │ ├── t1.ibd
│ │ │ └── t2.ibd
│ │ ├── #innodb_temp
│ │ │ ├── temp_10.ibt
│ │ │ ├── temp_1.ibt
│ │ │ ├── temp_2.ibt
│ │ │ ├── temp_3.ibt
│ │ │ ├── temp_4.ibt
│ │ │ ├── temp_5.ibt
│ │ │ ├── temp_6.ibt
│ │ │ ├── temp_7.ibt
│ │ │ ├── temp_8.ibt
│ │ │ └── temp_9.ibt
│ │ ├── localhost.localdomain.err
│ │ ├── localhost-slow.log
│ │ ├── localhost-slow.log.2022-09-22
│ │ ├── mysql
│ │ │ ├── general_log_202.sdi
│ │ │ ├── general_log.CSM
│ │ │ ├── general_log.CSV
│ │ │ ├── slow_log_203.sdi
│ │ │ ├── slow_log.CSM
│ │ │ └── slow_log.CSV
│ │ ├── mysql.ibd
│ │ ├── performance_schema
│ │ │ ├── accounts_139.sdi
│ │ │ ├── cond_instances_78.sdi
│ │ │ ├── data_locks_154.sdi
│ │ │ ├── data_lock_waits_155.sdi
│ │ │ ├── events_errors_su_133.sdi
│ │ │ ├── events_errors_su_134.sdi
│ │ │ ├── events_errors_su_135.sdi
│ │ │ ├── events_errors_su_136.sdi
│ │ │ ├── events_errors_su_137.sdi
│ │ │ ├── events_stages_cu_105.sdi
│ │ │ ├── events_stages_hi_106.sdi
│ │ │ ├── events_stages_hi_107.sdi
│ │ │ ├── events_stages_su_108.sdi
│ │ │ ├── events_stages_su_109.sdi
│ │ │ ├── events_stages_su_110.sdi
│ │ │ ├── events_stages_su_111.sdi
│ │ │ ├── events_stages_su_112.sdi
│ │ │ ├── events_statement_113.sdi
│ │ │ ├── events_statement_114.sdi
│ │ │ ├── events_statement_115.sdi
│ │ │ ├── events_statement_116.sdi
│ │ │ ├── events_statement_117.sdi
│ │ │ ├── events_statement_118.sdi
│ │ │ ├── events_statement_119.sdi
│ │ │ ├── events_statement_120.sdi
│ │ │ ├── events_statement_121.sdi
│ │ │ ├── events_statement_122.sdi
│ │ │ ├── events_statement_123.sdi
│ │ │ ├── events_statement_124.sdi
│ │ │ ├── events_transacti_125.sdi
│ │ │ ├── events_transacti_126.sdi
│ │ │ ├── events_transacti_127.sdi
│ │ │ ├── events_transacti_128.sdi
│ │ │ ├── events_transacti_129.sdi
│ │ │ ├── events_transacti_130.sdi
│ │ │ ├── events_transacti_131.sdi
│ │ │ ├── events_transacti_132.sdi
│ │ │ ├── events_waits_cur_79.sdi
│ │ │ ├── events_waits_his_80.sdi
│ │ │ ├── events_waits_his_81.sdi
│ │ │ ├── events_waits_sum_82.sdi
│ │ │ ├── events_waits_sum_83.sdi
│ │ │ ├── events_waits_sum_84.sdi
│ │ │ ├── events_waits_sum_85.sdi
│ │ │ ├── events_waits_sum_86.sdi
│ │ │ ├── events_waits_sum_87.sdi
│ │ │ ├── file_instances_88.sdi
│ │ │ ├── file_summary_by__89.sdi
│ │ │ ├── file_summary_by__90.sdi
│ │ │ ├── global_status_173.sdi
│ │ │ ├── global_variables_176.sdi
│ │ │ ├── host_cache_91.sdi
│ │ │ ├── hosts_140.sdi
│ │ │ ├── keyring_keys_146.sdi
│ │ │ ├── log_status_166.sdi
│ │ │ ├── memory_summary_b_148.sdi
│ │ │ ├── memory_summary_b_149.sdi
│ │ │ ├── memory_summary_b_150.sdi
│ │ │ ├── memory_summary_b_151.sdi
│ │ │ ├── memory_summary_g_147.sdi
│ │ │ ├── metadata_locks_153.sdi
│ │ │ ├── mutex_instances_92.sdi
│ │ │ ├── objects_summary__93.sdi
│ │ │ ├── performance_time_94.sdi
│ │ │ ├── persisted_variab_179.sdi
│ │ │ ├── prepared_stateme_167.sdi
│ │ │ ├── replication_appl_159.sdi
│ │ │ ├── replication_appl_160.sdi
│ │ │ ├── replication_appl_161.sdi
│ │ │ ├── replication_appl_162.sdi
│ │ │ ├── replication_appl_164.sdi
│ │ │ ├── replication_appl_165.sdi
│ │ │ ├── replication_conn_156.sdi
│ │ │ ├── replication_conn_158.sdi
│ │ │ ├── replication_grou_157.sdi
│ │ │ ├── replication_grou_163.sdi
│ │ │ ├── rwlock_instances_95.sdi
│ │ │ ├── session_account__145.sdi
│ │ │ ├── session_connect__144.sdi
│ │ │ ├── session_status_174.sdi
│ │ │ ├── session_variable_177.sdi
│ │ │ ├── setup_actors_96.sdi
│ │ │ ├── setup_consumers_97.sdi
│ │ │ ├── setup_instrument_98.sdi
│ │ │ ├── setup_objects_99.sdi
│ │ │ ├── setup_threads_100.sdi
│ │ │ ├── socket_instances_141.sdi
│ │ │ ├── socket_summary_b_142.sdi
│ │ │ ├── socket_summary_b_143.sdi
│ │ │ ├── status_by_accoun_169.sdi
│ │ │ ├── status_by_host_170.sdi
│ │ │ ├── status_by_thread_171.sdi
│ │ │ ├── status_by_user_172.sdi
│ │ │ ├── table_handles_152.sdi
│ │ │ ├── table_io_waits_s_101.sdi
│ │ │ ├── table_io_waits_s_102.sdi
│ │ │ ├── table_lock_waits_103.sdi
│ │ │ ├── threads_104.sdi
│ │ │ ├── user_defined_fun_180.sdi
│ │ │ ├── users_138.sdi
│ │ │ ├── user_variables_b_168.sdi
│ │ │ ├── variables_by_thr_175.sdi
│ │ │ └── variables_info_178.sdi
│ │ ├── private_key.pem
│ │ ├── public_key.pem
│ │ ├── server-cert.pem
│ │ ├── server-key.pem
│ │ ├── slowlog.coldbackup
│ │ ├── sys
│ │ │ └── sys_config.ibd
│ │ ├── sysdb
│ │ │ ├── statustableforhb.ibd
│ │ │ ├── statustable.ibd
│ │ │ └── usercheck_meta_history.ibd
│ │ ├── undo_001
│ │ ├── undo_002
│ │ ├── undo_t010.ibu
│ │ └── undo_t020.ibu
│ ├── dbdata
│ │ ├── ibdata1
│ │ └── ibtmp1
│ ├── dump
│ ├── tmpdir
│ └── xtrabackuptmp
├── dblogs
│ ├── bin
│ │ ├── binlog.000001
│ │ ├── binlog.gtidlist
│ │ └── binlog.index
│ ├── mysqld.err
│ ├── mysqld.err.2022-09-22
│ ├── nohup.out
│ ├── relay
│ └── tmp
├── logs
│ └── innodb
│ ├── ib_logfile0
│ ├── ib_logfile1
│ ├── ib_logfile2
│ └── ib_logfile3
└── prod
├── mysql.pid
├── mysql.sock
└── mysql.sock.lock

相关文章

  • TDSQL-磁盘存储结构

    [root@localhost data1]# tree /data1/4002//data1/4002/├── ...

  • mysql的体系结构关键点提取

    mysql的存储结构mysql的存储是磁盘存储,和磁盘存储结构类似表空间(Tablespace),由段空间组成(S...

  • 操作系统基础之存储器管理

    存储器管理 存储器的层次结构 存储器的层次结构:寄存器-高速缓存-主存-磁盘缓存-磁盘-可移动存储介质 可执行存储...

  • 层次结构存储系统(二)

    目录 6.3 磁盘存储器 磁盘存储器的结构 磁盘存储器的性能指标 磁盘存储器的连接 固态硬盘 高速缓冲存储器 程序...

  • Linux 磁盘IO

    磁盘 磁盘结构与数据存储方式, 数据是如何存储的,又通过怎样的方式被访问? 机械硬盘 机械硬盘主要由磁盘盘片、磁头...

  • day19-磁盘管理1

    1.磁盘的基本概念 磁盘(disk)是指利用磁记录技术存储数据的存储器 2.磁盘的基本结构 (1)盘片:(2)磁道...

  • Spark内存管理

    1. 存储总体结构 Spark存储结构分为两层:内存存储和磁盘存储,其中内存主要用作缓存以及任务计算时期数据存储,...

  • MySQL学习日记(十一)-技术问答

    一、MySQL主要存储引擎MyISAM和InnoDB的区别? 1、 存储结构 MyISAM:每个MyISAM在磁盘...

  • Chapter4存储器管理

    存储器的多层结构CPU寄存器(寄存器),主存(高速缓存,主存储器,磁盘缓存),辅存(固定磁盘,可移动存储介质)寄存...

  • 4-spark存储管理

    Spark存储结构分为两层:1)内存存储MemoryStore : 负责数据块在内存中存储2)磁盘存储DiskSt...

网友评论

      本文标题:TDSQL-磁盘存储结构

      本文链接:https://www.haomeiwen.com/subject/nrdgortx.html