/dports/japanese/kinput2/kinput2-v3.1/lib/imlib/ |
H A D | imbuf.c | 37 bcopy(ibp->internal, ibp->buf, ibp->size); 48 ibp->buf = ibp->internal; 56 if (ibp->buf != NULL && ibp->buf != ibp->internal) XtFree(ibp->buf); 57 ibp->buf = ibp->internal; 59 ibp->start = ibp->end = 0; 96 p = ibp->buf + ibp->end; 113 if (ibp->start >= ibp->end) IMBufClear(ibp); 124 if (ibp->start >= ibp->end) IMBufClear(ibp); 136 bcopy(ibp->buf + ibp->start, ibp->internal, length); 141 bcopy(ibp->buf + ibp->start, ibp->buf, length); [all …]
|
H A D | imbuf.h | 37 #define IMBUFLEN(ibp) ((ibp)->end - (ibp)->start) argument 38 #define IMBUFDATA(ibp) ((ibp)->buf + (ibp)->start) argument 40 extern void IMBufInit _Pt_((IMBuffer *ibp)); 41 extern void IMBufClear _Pt_((IMBuffer *ibp)); 42 extern void IMBufAdd _Pt_((IMBuffer *ibp, char *data, int len)); 43 extern void IMBufOverwrite _Pt_((IMBuffer *ibp, int offset, 45 extern char *IMBufAlloc _Pt_((IMBuffer *ibp, int len)); 46 extern void IMBufDiscard _Pt_((IMBuffer *ibp, int len)); 47 extern void IMBufDiscardNUL _Pt_((IMBuffer *ibp)); 48 extern void IMBufCompact _Pt_((IMBuffer *ibp));
|
/dports/misc/rump/buildrump.sh-b914579/src/sys/compat/ibcs2/ |
H A D | ibcs2_ipc.c | 105 ibp->cuid = bp->cuid; in cvt_perm2iperm() 106 ibp->cgid = bp->cgid; in cvt_perm2iperm() 107 ibp->uid = bp->uid; in cvt_perm2iperm() 108 ibp->gid = bp->gid; in cvt_perm2iperm() 109 ibp->mode = bp->mode; in cvt_perm2iperm() 110 ibp->seq = bp->_seq; in cvt_perm2iperm() 111 ibp->key = bp->_key; in cvt_perm2iperm() 119 bp->uid = ibp->uid; in cvt_iperm2perm() 120 bp->gid = ibp->gid; in cvt_iperm2perm() 122 bp->_seq = ibp->seq; in cvt_iperm2perm() [all …]
|
/dports/biology/ncbi-cxx-toolkit/ncbi_cxx--25_2_0/src/objtools/flatfile/ |
H A D | xm_ascii.cpp | 103 ibp->locusname, ibp->acnum); in XMLCheckContigEverywhere() 120 else if(ibp->is_contig && ibp->origin) in XMLCheckContigEverywhere() 1169 if(ibp->inferential || ibp->experimental) in XMLGetDescr() 1379 if(ibp->drop == 1 && ibp->segnum == 0) in XMLAscii() 1406 if(ibp->drop == 1 && ibp->segnum == 0) in XMLAscii() 1436 ibp->locusname, ibp->acnum); in XMLAscii() 1459 if (ibp->drop != 0 && ibp->segnum == 0) in XMLAscii() 1483 else if(ibp->htg == 4 || ibp->htg == 1 || ibp->htg == 2 || in XMLAscii() 1502 ibp->locusname, ibp->acnum); in XMLAscii() 1597 if(ibp->segnum == ibp->segtotal) in XMLAscii() [all …]
|
H A D | gb_ascii.cpp | 112 ibp->locusname, ibp->acnum); in CheckContigEverywhere() 130 else if(ibp->is_contig && ibp->origin) in CheckContigEverywhere() 1436 if(ibp->inferential || ibp->experimental) in GetGenBankDescr() 1618 if(ibp->drop == 1 && ibp->segnum == 0) in GenBankAscii() 1626 entry = LoadEntry(pp, ibp->offset, ibp->len); in GenBankAscii() 1657 if(ibp->drop == 1 && ibp->segnum == 0) in GenBankAscii() 1675 ibp->locusname, ibp->acnum); in GenBankAscii() 1730 if(ibp->drop != 0 && ibp->segnum == 0) in GenBankAscii() 1753 else if(ibp->htg == 4 || ibp->htg == 1 || ibp->htg == 2 || in GenBankAscii() 1867 if (ibp->segnum == ibp->segtotal) in GenBankAscii() [all …]
|
H A D | em_ascii.cpp | 827 ibp->locusname, ibp->acnum); in CheckEmblContigEverywhere() 844 else if(ibp->is_contig && ibp->origin) in CheckEmblContigEverywhere() 858 else if(condiv && !ibp->is_contig && !ibp->origin) in CheckEmblContigEverywhere() 864 else if(condiv && !ibp->is_contig && ibp->origin) in CheckEmblContigEverywhere() 2181 if(ibp->inferential || ibp->experimental) in GetEmblDescr() 2547 ibp->locusname, ibp->acnum); in EmblAscii() 2635 else if(ibp->htg == 4 || ibp->htg == 1 || ibp->htg == 2 || in EmblAscii() 2712 if(ibp->htg == 4 || ibp->htg == 1 || ibp->htg == 2) in EmblAscii() 2743 ibp->locusname, ibp->acnum); in EmblAscii() 2772 ibp->htg != 2 && ibp->htg != 4) in EmblAscii() [all …]
|
H A D | xm_index.cpp | 290 if(entry == NULL || ibp == NULL || ibp->xip == NULL) in XMLGetSegment() 428 ibp = tibnp->ibp; in XMLPerformIndex() 446 ibp->len = count - ibp->offset; in XMLPerformIndex() 580 ibp->vernum, ibp->acnum, ibp->vernum); in XMLParseVersion() 591 if(ibp == NULL || ibp->xip == NULL || entry == NULL) in XMLInitialEntry() 616 StringCpy(ibp->blocusname, ibp->locusname); in XMLInitialEntry() 695 if(ibp->bases > 0 && ibp->date != NULL && ibp->division[0] != '?') in XMLInitialEntry() 928 if(entry == NULL || ibp == NULL || ibp->xip == NULL) in XMLKeywordsCheck() 1084 if(ibp->is_contig && ibp->segnum != 0) in XMLCheckRequiredTags() 1092 ibp->is_tpa_wgs_con = (ibp->is_contig && ibp->is_wgs && ibp->is_tpa); in XMLCheckRequiredTags() [all …]
|
/dports/multimedia/v4l_compat/linux-5.13-rc2/drivers/infiniband/hw/qib/ |
H A D | qib_mad.c | 97 ibp->rvp.tid++; in qib_send_trap() 104 if (!ibp->rvp.sm_ah) { in qib_send_trap() 108 ah = qib_create_qp0_ah(ibp, (u16)ibp->rvp.sm_lid); in qib_send_trap() 144 ibp->rvp.n_pkt_drops++; in qib_bad_pkey() 416 ibp->rvp.mkeyprot = 0; in check_mkey() 459 struct qib_ibport *ibp; in subn_get_portinfo() local 660 struct qib_ibport *ibp; in subn_set_portinfo() local 713 else if (smlid != ibp->rvp.sm_lid || msl != ibp->rvp.sm_sl) { in subn_set_portinfo() 715 if (ibp->rvp.sm_ah) { in subn_set_portinfo() 726 ibp->rvp.sm_sl = msl; in subn_set_portinfo() [all …]
|
/dports/multimedia/libv4l/linux-5.13-rc2/drivers/infiniband/hw/qib/ |
H A D | qib_mad.c | 97 ibp->rvp.tid++; in qib_send_trap() 104 if (!ibp->rvp.sm_ah) { in qib_send_trap() 108 ah = qib_create_qp0_ah(ibp, (u16)ibp->rvp.sm_lid); in qib_send_trap() 144 ibp->rvp.n_pkt_drops++; in qib_bad_pkey() 416 ibp->rvp.mkeyprot = 0; in check_mkey() 459 struct qib_ibport *ibp; in subn_get_portinfo() local 660 struct qib_ibport *ibp; in subn_set_portinfo() local 713 else if (smlid != ibp->rvp.sm_lid || msl != ibp->rvp.sm_sl) { in subn_set_portinfo() 715 if (ibp->rvp.sm_ah) { in subn_set_portinfo() 726 ibp->rvp.sm_sl = msl; in subn_set_portinfo() [all …]
|
/dports/multimedia/v4l-utils/linux-5.13-rc2/drivers/infiniband/hw/qib/ |
H A D | qib_mad.c | 97 ibp->rvp.tid++; in qib_send_trap() 104 if (!ibp->rvp.sm_ah) { in qib_send_trap() 108 ah = qib_create_qp0_ah(ibp, (u16)ibp->rvp.sm_lid); in qib_send_trap() 144 ibp->rvp.n_pkt_drops++; in qib_bad_pkey() 416 ibp->rvp.mkeyprot = 0; in check_mkey() 459 struct qib_ibport *ibp; in subn_get_portinfo() local 660 struct qib_ibport *ibp; in subn_set_portinfo() local 713 else if (smlid != ibp->rvp.sm_lid || msl != ibp->rvp.sm_sl) { in subn_set_portinfo() 715 if (ibp->rvp.sm_ah) { in subn_set_portinfo() 726 ibp->rvp.sm_sl = msl; in subn_set_portinfo() [all …]
|
/dports/databases/percona-toolkit/percona-toolkit-3.3.0/sandbox/servers/5.6/sys/views/i_s/ |
H A D | innodb_buffer_stats_by_table.sql | 51 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 52 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 53 sys.format_bytes(SUM(IF(ibp.compressed_size = 0, 16384, compressed_size))) AS allocated, 54 sys.format_bytes(SUM(ibp.data_size)) AS data, 55 COUNT(ibp.page_number) AS pages, 56 COUNT(IF(ibp.is_hashed = 'YES', 1, 0)) AS pages_hashed, 57 COUNT(IF(ibp.is_old = 'YES', 1, 0)) AS pages_old, 58 ROUND(SUM(ibp.number_records)/COUNT(DISTINCT ibp.index_name)) AS rows_cached 59 FROM information_schema.innodb_buffer_page ibp 62 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
H A D | x_innodb_buffer_stats_by_table.sql | 51 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 52 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 53 SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) AS allocated, 54 SUM(ibp.data_size) AS data, 55 COUNT(ibp.page_number) AS pages, 56 COUNT(IF(ibp.is_hashed = 'YES', 1, 0)) AS pages_hashed, 57 COUNT(IF(ibp.is_old = 'YES', 1, 0)) AS pages_old, 58 …ROUND(IFNULL(SUM(ibp.number_records)/NULLIF(COUNT(DISTINCT ibp.index_name), 0), 0)) AS rows_cached 59 FROM information_schema.innodb_buffer_page ibp 62 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
/dports/databases/percona-toolkit/percona-toolkit-3.3.0/sandbox/servers/5.7/sys/views/i_s/ |
H A D | innodb_buffer_stats_by_table.sql | 51 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 52 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 53 sys.format_bytes(SUM(IF(ibp.compressed_size = 0, 16384, compressed_size))) AS allocated, 54 sys.format_bytes(SUM(ibp.data_size)) AS data, 55 COUNT(ibp.page_number) AS pages, 56 COUNT(IF(ibp.is_hashed = 'YES', 1, 0)) AS pages_hashed, 57 COUNT(IF(ibp.is_old = 'YES', 1, 0)) AS pages_old, 58 ROUND(SUM(ibp.number_records)/COUNT(DISTINCT ibp.index_name)) AS rows_cached 59 FROM information_schema.innodb_buffer_page ibp 62 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
H A D | x_innodb_buffer_stats_by_table.sql | 51 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 52 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 53 SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) AS allocated, 54 SUM(ibp.data_size) AS data, 55 COUNT(ibp.page_number) AS pages, 56 COUNT(IF(ibp.is_hashed = 'YES', 1, 0)) AS pages_hashed, 57 COUNT(IF(ibp.is_old = 'YES', 1, 0)) AS pages_old, 58 …ROUND(IFNULL(SUM(ibp.number_records)/NULLIF(COUNT(DISTINCT ibp.index_name), 0), 0)) AS rows_cached 59 FROM information_schema.innodb_buffer_page ibp 62 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/scripts/sys_schema/views/i_s/ |
H A D | x_innodb_buffer_stats_by_table.sql | 51 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 52 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 53 SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) AS allocated, 54 SUM(ibp.data_size) AS data, 55 COUNT(ibp.page_number) AS pages, 56 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 57 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 58 …ROUND(IFNULL(SUM(ibp.number_records)/NULLIF(COUNT(DISTINCT ibp.index_name), 0), 0)) AS rows_cached 59 FROM information_schema.innodb_buffer_page ibp 62 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
H A D | innodb_buffer_stats_by_table.sql | 51 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 52 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 53 format_bytes(SUM(IF(ibp.compressed_size = 0, 16384, compressed_size))) AS allocated, 54 format_bytes(SUM(ibp.data_size)) AS data, 55 COUNT(ibp.page_number) AS pages, 56 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 57 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 58 ROUND(SUM(ibp.number_records)/COUNT(DISTINCT ibp.index_name)) AS rows_cached 59 FROM information_schema.innodb_buffer_page ibp 62 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/scripts/sys_schema/views/i_s/ |
H A D | innodb_buffer_stats_by_table.sql | 58 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 59 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 60 sys.format_bytes(SUM(IF(ibp.compressed_size = 0, 16384, compressed_size))) AS allocated, 61 sys.format_bytes(SUM(ibp.data_size)) AS data, 62 COUNT(ibp.page_number) AS pages, 63 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 64 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 65 ROUND(SUM(ibp.number_records)/COUNT(DISTINCT ibp.index_name)) AS rows_cached 66 FROM information_schema.innodb_buffer_page ibp 69 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
/dports/databases/percona57-server/percona-server-5.7.36-39/scripts/sys_schema/views/i_s/ |
H A D | x_innodb_buffer_stats_by_table.sql | 58 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 59 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 60 SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) AS allocated, 61 SUM(ibp.data_size) AS data, 62 COUNT(ibp.page_number) AS pages, 63 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 64 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 65 …ROUND(IFNULL(SUM(ibp.number_records)/NULLIF(COUNT(DISTINCT ibp.index_name), 0), 0)) AS rows_cached 66 FROM information_schema.innodb_buffer_page ibp 69 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
H A D | innodb_buffer_stats_by_table.sql | 58 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 59 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 60 sys.format_bytes(SUM(IF(ibp.compressed_size = 0, 16384, compressed_size))) AS allocated, 61 sys.format_bytes(SUM(ibp.data_size)) AS data, 62 COUNT(ibp.page_number) AS pages, 63 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 64 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 65 ROUND(SUM(ibp.number_records)/COUNT(DISTINCT ibp.index_name)) AS rows_cached 66 FROM information_schema.innodb_buffer_page ibp 69 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/scripts/sys_schema/views/i_s/ |
H A D | innodb_buffer_stats_by_table.sql | 58 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 59 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 60 sys.format_bytes(SUM(IF(ibp.compressed_size = 0, 16384, compressed_size))) AS allocated, 61 sys.format_bytes(SUM(ibp.data_size)) AS data, 62 COUNT(ibp.page_number) AS pages, 63 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 64 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 65 ROUND(SUM(ibp.number_records)/COUNT(DISTINCT ibp.index_name)) AS rows_cached 66 FROM information_schema.innodb_buffer_page ibp 69 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
H A D | x_innodb_buffer_stats_by_table.sql | 58 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 59 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 60 SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) AS allocated, 61 SUM(ibp.data_size) AS data, 62 COUNT(ibp.page_number) AS pages, 63 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 64 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 65 …ROUND(IFNULL(SUM(ibp.number_records)/NULLIF(COUNT(DISTINCT ibp.index_name), 0), 0)) AS rows_cached 66 FROM information_schema.innodb_buffer_page ibp 69 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
/dports/databases/percona57-client/percona-server-5.7.36-39/scripts/sys_schema/views/i_s/ |
H A D | x_innodb_buffer_stats_by_table.sql | 58 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 59 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 60 SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) AS allocated, 61 SUM(ibp.data_size) AS data, 62 COUNT(ibp.page_number) AS pages, 63 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 64 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 65 …ROUND(IFNULL(SUM(ibp.number_records)/NULLIF(COUNT(DISTINCT ibp.index_name), 0), 0)) AS rows_cached 66 FROM information_schema.innodb_buffer_page ibp 69 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
H A D | innodb_buffer_stats_by_table.sql | 58 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 59 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 60 sys.format_bytes(SUM(IF(ibp.compressed_size = 0, 16384, compressed_size))) AS allocated, 61 sys.format_bytes(SUM(ibp.data_size)) AS data, 62 COUNT(ibp.page_number) AS pages, 63 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 64 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 65 ROUND(SUM(ibp.number_records)/COUNT(DISTINCT ibp.index_name)) AS rows_cached 66 FROM information_schema.innodb_buffer_page ibp 69 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/scripts/sys_schema/views/i_s/ |
H A D | x_innodb_buffer_stats_by_table.sql | 58 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 59 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 60 SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) AS allocated, 61 SUM(ibp.data_size) AS data, 62 COUNT(ibp.page_number) AS pages, 63 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 64 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 65 …ROUND(IFNULL(SUM(ibp.number_records)/NULLIF(COUNT(DISTINCT ibp.index_name), 0), 0)) AS rows_cached 66 FROM information_schema.innodb_buffer_page ibp 69 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|
H A D | innodb_buffer_stats_by_table.sql | 58 SELECT IF(LOCATE('.', ibp.table_name) = 0, 'InnoDB System', REPLACE(SUBSTRING_INDEX(ibp.table_name,… 59 REPLACE(SUBSTRING_INDEX(ibp.table_name, '.', -1), '`', '') AS object_name, 60 sys.format_bytes(SUM(IF(ibp.compressed_size = 0, 16384, compressed_size))) AS allocated, 61 sys.format_bytes(SUM(ibp.data_size)) AS data, 62 COUNT(ibp.page_number) AS pages, 63 COUNT(IF(ibp.is_hashed = 'YES', 1, NULL)) AS pages_hashed, 64 COUNT(IF(ibp.is_old = 'YES', 1, NULL)) AS pages_old, 65 ROUND(SUM(ibp.number_records)/COUNT(DISTINCT ibp.index_name)) AS rows_cached 66 FROM information_schema.innodb_buffer_page ibp 69 ORDER BY SUM(IF(ibp.compressed_size = 0, 16384, compressed_size)) DESC;
|