Home
last modified time | relevance | path

Searched refs:ibp (Results 1 – 25 of 683) sorted by relevance

12345678910>>...28

/dports/japanese/kinput2/kinput2-v3.1/lib/imlib/
H A Dimbuf.c37 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 Dimbuf.h37 #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 Dibcs2_ipc.c105 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 Dxm_ascii.cpp103 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 Dgb_ascii.cpp112 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 Dem_ascii.cpp827 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 Dxm_index.cpp290 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 Dqib_mad.c97 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 Dqib_mad.c97 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 Dqib_mad.c97 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 Dinnodb_buffer_stats_by_table.sql51 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 Dx_innodb_buffer_stats_by_table.sql51 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 Dinnodb_buffer_stats_by_table.sql51 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 Dx_innodb_buffer_stats_by_table.sql51 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 Dx_innodb_buffer_stats_by_table.sql51 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 Dinnodb_buffer_stats_by_table.sql51 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 Dinnodb_buffer_stats_by_table.sql58 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 Dx_innodb_buffer_stats_by_table.sql58 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 Dinnodb_buffer_stats_by_table.sql58 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 Dinnodb_buffer_stats_by_table.sql58 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 Dx_innodb_buffer_stats_by_table.sql58 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 Dx_innodb_buffer_stats_by_table.sql58 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 Dinnodb_buffer_stats_by_table.sql58 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 Dx_innodb_buffer_stats_by_table.sql58 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 Dinnodb_buffer_stats_by_table.sql58 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;

12345678910>>...28