mirror of
https://github.com/MariaDB/server.git
synced 2025-11-10 15:56:13 +01:00
5407117a59
The InnoDB internal tables SYS_TABLESPACES and SYS_DATAFILES as well as the INFORMATION_SCHEMA views INNODB_SYS_TABLESPACES and INNODB_SYS_DATAFILES were introduced in MySQL 5.6 for no good reason in mysql/mysql-server/commit/e9255a22ef16d612a8076bc0b34002bc5a784627 when the InnoDB support for the DATA DIRECTORY attribute was introduced. The file system should be the authoritative source of information on files. Storing information about file system paths in the file system (symlinks, or even the .isl files that were unfortunately chosen as the solution) is sufficient. If information is additionally stored in some hidden tables inside the InnoDB system tablespace, everything unnecessarily becomes more complicated, because more copies of data mean more opportunity for the copies to be out of sync, and because modifying the data in the system tablespace in the desired way might not be possible at all without modifying the InnoDB source code. So, the copy in the system tablespace basically is a redundant, non-authoritative source of information. We will stop creating or accessing the system tables SYS_TABLESPACES and SYS_DATAFILES. We will also remove the view INFORMATION_SCHEMA.INNODB_SYS_DATAFILES along with SYS_DATAFILES. The view INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES will be repurposed to directly reflect fil_system.space_list. The column PAGE_SIZE, which would always contain the value of the GLOBAL read-only variable innodb_page_size, is removed. The column ZIP_PAGE_SIZE, which would actually contain the physical page size of a page, is renamed to PAGE_SIZE. Finally, a new column FILENAME is added, as a replacement of SYS_DATAFILES.PATH. This will also address MDEV-21801 (files that were created before upgrading to MySQL 5.6 or MariaDB 10.0 or later were never registered in SYS_TABLESPACES or SYS_DATAFILES) and MDEV-21801 (information about the system tablespace is not stored in SYS_TABLESPACES or SYS_DATAFILES).
127 lines
4.2 KiB
C
127 lines
4.2 KiB
C
/*****************************************************************************
|
|
|
|
Copyright (c) 1995, 2017, Oracle and/or its affiliates. All Rights Reserved.
|
|
Copyright (c) 2017, 2020, MariaDB Corporation.
|
|
|
|
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
|
|
|
|
*****************************************************************************/
|
|
|
|
/**************************************************//**
|
|
@file include/srv0start.h
|
|
Starts the Innobase database server
|
|
|
|
Created 10/10/1995 Heikki Tuuri
|
|
*******************************************************/
|
|
|
|
#pragma once
|
|
|
|
#include "log0log.h"
|
|
#include "ut0byte.h"
|
|
|
|
// Forward declaration
|
|
struct dict_table_t;
|
|
|
|
/** Open the configured number of dedicated undo tablespaces.
|
|
@param[in] create_new_db whether the database is being initialized
|
|
@return DB_SUCCESS or error code */
|
|
dberr_t
|
|
srv_undo_tablespaces_init(bool create_new_db);
|
|
|
|
/** Start InnoDB.
|
|
@param[in] create_new_db whether to create a new database
|
|
@return DB_SUCCESS or error code */
|
|
dberr_t srv_start(bool create_new_db);
|
|
|
|
/**
|
|
Shutdown purge to make sure that there is no possibility that we call any
|
|
plugin code (e.g., audit) inside virtual column computation.
|
|
*/
|
|
void innodb_preshutdown();
|
|
|
|
/** Shut down InnoDB. */
|
|
void innodb_shutdown();
|
|
|
|
/** Shut down background threads that can generate undo log. */
|
|
void srv_shutdown_bg_undo_sources();
|
|
|
|
/*************************************************************//**
|
|
Copy the file path component of the physical file to parameter. It will
|
|
copy up to and including the terminating path separator.
|
|
@return number of bytes copied or ULINT_UNDEFINED if destination buffer
|
|
is smaller than the path to be copied. */
|
|
ulint
|
|
srv_path_copy(
|
|
/*==========*/
|
|
char* dest, /*!< out: destination buffer */
|
|
ulint dest_len, /*!< in: max bytes to copy */
|
|
const char* basedir, /*!< in: base directory */
|
|
const char* table_name) /*!< in: source table name */
|
|
MY_ATTRIBUTE((nonnull, warn_unused_result));
|
|
|
|
/** Get the meta-data filename from the table name for a
|
|
single-table tablespace.
|
|
@param[in] table table object
|
|
@param[out] filename filename
|
|
@param[in] max_len filename max length */
|
|
void
|
|
srv_get_meta_data_filename(
|
|
dict_table_t* table,
|
|
char* filename,
|
|
ulint max_len);
|
|
|
|
/** Get the encryption-data filename from the table name for a
|
|
single-table tablespace.
|
|
@param[in] table table object
|
|
@param[out] filename filename
|
|
@param[in] max_len filename max length */
|
|
void
|
|
srv_get_encryption_data_filename(
|
|
dict_table_t* table,
|
|
char* filename,
|
|
ulint max_len);
|
|
|
|
/** Log sequence number at shutdown */
|
|
extern lsn_t srv_shutdown_lsn;
|
|
|
|
/** TRUE if the server is being started */
|
|
extern bool srv_is_being_started;
|
|
/** TRUE if the server is being started, before rolling back any
|
|
incomplete transactions */
|
|
extern bool srv_startup_is_before_trx_rollback_phase;
|
|
|
|
/** TRUE if a raw partition is in use */
|
|
extern ibool srv_start_raw_disk_in_use;
|
|
|
|
/** Shutdown state */
|
|
enum srv_shutdown_t {
|
|
SRV_SHUTDOWN_NONE = 0, /*!< Database running normally */
|
|
/** Shutdown initiated in srv_shutdown_bg_undo_sources() */
|
|
SRV_SHUTDOWN_INITIATED,
|
|
SRV_SHUTDOWN_CLEANUP, /*!< Cleaning up in
|
|
logs_empty_and_mark_files_at_shutdown() */
|
|
SRV_SHUTDOWN_LAST_PHASE,/*!< Last phase after ensuring that
|
|
the buffer pool can be freed: flush
|
|
all file spaces and close all files */
|
|
SRV_SHUTDOWN_EXIT_THREADS/*!< Exit all threads */
|
|
};
|
|
|
|
/** Whether any undo log records can be generated */
|
|
extern bool srv_undo_sources;
|
|
|
|
/** At a shutdown this value climbs from SRV_SHUTDOWN_NONE to
|
|
SRV_SHUTDOWN_CLEANUP and then to SRV_SHUTDOWN_LAST_PHASE, and so on */
|
|
extern enum srv_shutdown_t srv_shutdown_state;
|
|
|
|
/** Files comprising the system tablespace */
|
|
extern pfs_os_file_t files[1000];
|