The information_schema database is the database that comes with the MySQL system, which provides access to database metadata. It feels like information_schema is like an encyclopedia of MySQL instances. It records most of the information we need to solve in the database, such as character sets, permissions, database entity object information, external check constraints, partitions, compressed tables, table information, and index information. , parameters, optimization, locks and things, etc. Through information_schema, we can get a glimpse of the running status of the entire MySQL instance, learn the basic information of the MySQL instance, and even optimize and maintain the database. It can be said to be a real encyclopedia, haha. The following is a general classification of these tables based on some small experiences I have learned, so that it is convenient for everyone to summarize. If there are any shortcomings, please point them out and I will modify them as soon as possible. 1: About the system tables related to character sets and collation rules CHARACTER_SETS: Stores database-related character set information (memory storage engine) COLLATIONS: The collation rules corresponding to the character set COLLATIO
1. In MySQL Detailed introduction to information_schema
##Introduction: The information_schema database is the database that comes with the MySQL system. It provides How to access database metadata. It feels like information_schema is like an encyclopedia of MySQL instances. It records most of the information we need to solve in the database, such as character sets, permissions, database entity object information, external check constraints, partitions, compressed tables, table information, and index information. , parameters, optimization, locks and things, etc. Through information_schema, we can see the running status of the entire MySQL instance, understand the basic information of the MySQL instance, and even optimize and maintain the database, etc. It can be said to be a real encyclopedia
2. phpMyAdmin hides mysql and information_schema database_PHP tutorial
Introduction: phpMyAdmin hides mysql and information_schema database. The mysql and information_schema databases in the mysql server are system databases. This is of little use to us, but we cannot delete them. They are key
3. phpMyAdmin hides mysql and information_schema databases
Introduction: phpMyAdmin hides mysql and information_schema databases. The mysql and information_schema databases in the mysql server are system databases. This is of little use to us, but we cannot delete them. They are key
4. MySQL Offsite Incremental Backup
Introduction: MySQL Offsite Incremental Backup: 1.#!/bin/sh 2. 3.#MySQL Info 4.sqluser=root 5 .sqlpsw=root 6. 7./usr/bin/mysqladmin -u$sqluser -p$sqlpsw flush-logs --default-character-set=GBK 8. 9.DATADIR=/data/mysql 10.BAKDIR=/home /backup/mysql/daily 11.TEMPDIR=/home/b
5. Data warehouse technology based on MySQL and Infobright
Introduction: User settings ulimit -SHn 65535mkdir -p /home/mysql/infobright/usr/sbin/groupadd mysql/usr/sbin/useradd -g mysql mysqlcd /usr/
6. What is information_schema in MySQL_MySQL
Introduction: What is information_schema in MySQL
7. Parsing MySQL’s information_schema database_MySQL
Introduction: Parsing MySQL’s information_schema database
8. (Transfer)What is information_schema in MySQL_MySQL
Introduction: (Transfer)What is information_schema in MySQL
9. MySQL database method to view the space occupied by the data table and the number of records_MySQL
Introduction: This article mainly introduces the method of checking the space occupied by the data table and the number of records in the MySQL database. If you want to know the space occupied by each table in the MySQL database and the number of rows recorded in the table, you can open MySQL's information_schema database query, this article explains the query method, requires
10. information_schema in mysql (similar to the system table in sql)_MySQL
Introduction: information_schema database table description: SCHEMATA table: provides information about all databases in the current mysql instance. The results of show databases are taken from this table. TABLES table: Provides information about tables in the database (including views). Detailed description of which
a certain table belongs toThe above is the detailed content of 10 recommended articles about the mysql_info() function. For more information, please follow other related articles on the PHP Chinese website!