Skip to content

Instantly share code, notes, and snippets.

@yoku0825

yoku0825/gist:6128270

Created August 1, 2013 03:48
Show Gist options
  • Save yoku0825/6128270 to your computer and use it in GitHub Desktop.
Save yoku0825/6128270 to your computer and use it in GitHub Desktop.
Download ZIP
fdが5～8のものはibdata1(4)とib_logfile(9, 10)の間なので、起動処理でUNDOセグメントやロールフォワード、ibufのマージなどで使われた残骸かなと推測しています。 fd12のものもinnodb_index_statsの直後なので、5.6の`統計情報永続化'関連の何かなのかなーと思えます。 すいません、ソースは全く追っていません。。
Raw
gistfile1.txt
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 30367 mysql cwd DIR 253,0 4096 572370 /usr/mysql/5.6.12/data
mysqld 30367 mysql rtd DIR 253,0 4096 2 /
mysqld 30367 mysql txt REG 253,0 82786893 547097 /usr/mysql/5.6.12/bin/mysqld
mysqld 30367 mysql mem REG 253,0 5624 1700610 /lib64/libaio.so.1.0.1
mysqld 30367 mysql mem REG 253,0 156872 1700702 /lib64/ld-2.12.so
mysqld 30367 mysql mem REG 253,0 1922152 1700706 /lib64/libc-2.12.so
mysqld 30367 mysql DEL REG 253,0 1700717 /lib64/libdl-2.12.so
mysqld 30367 mysql mem REG 253,0 145720 1700712 /lib64/libpthread-2.12.so
mysqld 30367 mysql mem REG 253,0 91096 1701011 /lib64/libz.so.1.2.3
mysqld 30367 mysql mem REG 253,0 598680 1701017 /lib64/libm-2.12.so
mysqld 30367 mysql mem REG 253,0 47064 1701018 /lib64/librt-2.12.so
mysqld 30367 mysql DEL REG 253,0 1700733 /lib64/libselinux.so.1.#prelink#.bbNR7N
mysqld 30367 mysql mem REG 253,0 113952 1700721 /lib64/libresolv-2.12.so
mysqld 30367 mysql mem REG 253,0 93224 1701016 /lib64/libgcc_s-4.4.7-20120601.so.1
mysqld 30367 mysql DEL REG 253,0 1701014 /lib64/libcrypt-2.12.so.#prelink#.E8pHX0
mysqld 30367 mysql DEL REG 253,0 1701013 /lib64/libfreebl3.so
mysqld 30367 mysql mem REG 253,0 17256 1700848 /lib64/libcom_err.so.2.1
mysqld 30367 mysql mem REG 253,0 989840 2616325 /usr/lib64/libstdc++.so.6.0.13
mysqld 30367 mysql DEL REG 253,0 2709673 /usr/lib64/libcrypto.so.1.0.0.#prelink#.0LBCyK
mysqld 30367 mysql DEL REG 253,0 1700735 /lib64/libkrb5support.so.0.1.#prelink#.qKqyIZ
mysqld 30367 mysql DEL REG 253,0 1700741 /lib64/libk5crypto.so.3.1.#prelink#.kto0kb
mysqld 30367 mysql DEL REG 253,0 1700719 /lib64/libkeyutils.so.1.3.#prelink#.uKe5yC
mysqld 30367 mysql DEL REG 253,0 1700913 /lib64/libkrb5.so.3.3
mysqld 30367 mysql DEL REG 253,0 1700916 /lib64/libgssapi_krb5.so.2.2.#prelink#.FLPkKy
mysqld 30367 mysql DEL REG 253,0 2623773 /usr/lib64/libssl.so.1.0.0.#prelink#.t3UDwW
mysqld 30367 mysql mem REG 253,0 217016 915932 /var/db/nscd/group
mysqld 30367 mysql mem REG 253,0 217016 915931 /var/db/nscd/passwd
mysqld 30367 mysql 0r CHR 1,3 0t0 3643 /dev/null
mysqld 30367 mysql 1w REG 253,0 59497 528314 /usr/mysql/5.6.12/data/error.log
mysqld 30367 mysql 2w REG 253,0 59497 528314 /usr/mysql/5.6.12/data/error.log
mysqld 30367 mysql 3u REG 253,0 130 535774 /usr/mysql/5.6.12/data/bin.index
mysqld 30367 mysql 4uW REG 253,0 79691776 528322 /usr/mysql/5.6.12/data/ibdata1
mysqld 30367 mysql 5u REG 253,0 0 267781 /tmp/ibBbBW5s (deleted)
mysqld 30367 mysql 6u REG 253,0 0 267782 /tmp/ibq9KpGt (deleted)
mysqld 30367 mysql 7u REG 253,0 0 267854 /tmp/ibtOdTgu (deleted)
mysqld 30367 mysql 8u REG 253,0 0 272075 /tmp/ibfawhMv (deleted)
mysqld 30367 mysql 9uW REG 253,0 134217728 528323 /usr/mysql/5.6.12/data/ib_logfile0
mysqld 30367 mysql 10uW REG 253,0 134217728 528325 /usr/mysql/5.6.12/data/ib_logfile1
mysqld 30367 mysql 11uW REG 253,0 98304 528397 /usr/mysql/5.6.12/data/mysql/innodb_index_stats.ibd
mysqld 30367 mysql 12u REG 253,0 0 272076 /tmp/ibGeV2Nw (deleted)
mysqld 30367 mysql 13uW REG 253,0 98304 528395 /usr/mysql/5.6.12/data/mysql/innodb_table_stats.ibd
mysqld 30367 mysql 14w REG 253,0 1772 528468 /usr/mysql/5.6.12/data/slow.log
mysqld 30367 mysql 15u IPv4 24815724 0t0 TCP *:64056 (LISTEN)
mysqld 30367 mysql 16uW REG 253,0 98304 528399 /usr/mysql/5.6.12/data/mysql/slave_relay_log_info.ibd
mysqld 30367 mysql 17uW REG 253,0 98304 528401 /usr/mysql/5.6.12/data/mysql/slave_master_info.ibd
mysqld 30367 mysql 18uW REG 253,0 98304 528403 /usr/mysql/5.6.12/data/mysql/slave_worker_info.ibd
mysqld 30367 mysql 20w REG 253,0 143865401 535773 /usr/mysql/5.6.12/data/bin.000010
mysqld 30367 mysql 21u unix 0xffff880000b3ec80 0t0 24815725 /usr/mysql/5.6.12/data/mysql.sock
mysqld 30367 mysql 22u REG 253,0 2048 528332 /usr/mysql/5.6.12/data/mysql/user.MYI
mysqld 30367 mysql 23u REG 253,0 512 528333 /usr/mysql/5.6.12/data/mysql/user.MYD
mysqld 30367 mysql 24u REG 253,0 5120 528327 /usr/mysql/5.6.12/data/mysql/db.MYI
mysqld 30367 mysql 25u REG 253,0 1320 528330 /usr/mysql/5.6.12/data/mysql/db.MYD
mysqld 30367 mysql 26u REG 253,0 5120 528466 /usr/mysql/5.6.12/data/mysql/proxies_priv.MYI
mysqld 30367 mysql 27u REG 253,0 1386 528467 /usr/mysql/5.6.12/data/mysql/proxies_priv.MYD
mysqld 30367 mysql 28u REG 253,0 4096 528344 /usr/mysql/5.6.12/data/mysql/tables_priv.MYI
mysqld 30367 mysql 29u REG 253,0 0 528345 /usr/mysql/5.6.12/data/mysql/tables_priv.MYD
mysqld 30367 mysql 30u REG 253,0 4096 528347 /usr/mysql/5.6.12/data/mysql/columns_priv.MYI
mysqld 30367 mysql 31u REG 253,0 0 528348 /usr/mysql/5.6.12/data/mysql/columns_priv.MYD
mysqld 30367 mysql 32u REG 253,0 4096 528380 /usr/mysql/5.6.12/data/mysql/procs_priv.MYI
mysqld 30367 mysql 33u REG 253,0 0 528381 /usr/mysql/5.6.12/data/mysql/procs_priv.MYD
mysqld 30367 mysql 34u REG 253,0 1024 528341 /usr/mysql/5.6.12/data/mysql/servers.MYI
mysqld 30367 mysql 35u REG 253,0 0 528342 /usr/mysql/5.6.12/data/mysql/servers.MYD
mysqld 30367 mysql 36u REG 253,0 2048 528389 /usr/mysql/5.6.12/data/mysql/event.MYI
mysqld 30367 mysql 37u REG 253,0 0 528390 /usr/mysql/5.6.12/data/mysql/event.MYD
mysqld 30367 mysql 38uW REG 253,0 98304 535783 /usr/mysql/5.6.12/data/tpcc/warehouse.ibd
mysqld 30367 mysql 39uW REG 253,0 98304 535919 /usr/mysql/5.6.12/data/tpcc/district.ibd
mysqld 30367 mysql 40uW REG 253,0 30408704 535943 /usr/mysql/5.6.12/data/tpcc/customer.ibd
mysqld 30367 mysql 41uW REG 253,0 12582912 535945 /usr/mysql/5.6.12/data/tpcc/history.ibd
mysqld 30367 mysql 42uW REG 253,0 344064 535947 /usr/mysql/5.6.12/data/tpcc/new_orders.ibd
mysqld 30367 mysql 43uW REG 253,0 11534336 535949 /usr/mysql/5.6.12/data/tpcc/orders.ibd
mysqld 30367 mysql 44uW REG 253,0 41943040 535951 /usr/mysql/5.6.12/data/tpcc/order_line.ibd
mysqld 30367 mysql 45uW REG 253,0 17825792 535953 /usr/mysql/5.6.12/data/tpcc/item.ibd
mysqld 30367 mysql 46uW REG 253,0 46137344 535955 /usr/mysql/5.6.12/data/tpcc/stock.ibd
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment