Detailed explanation of Innodb status-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Detailed explanation of Innodb status

PHP中文网

Jun 20, 2017 pm 03:07 PM

innodbstateexplainpart

Innodb_buffer_pool_pages_data

The number of pages containing data in the Innodb buffer pool cache pool, including dirty pages. The unit is page.

Innodb_buffer_pool_pages_dirty

The number of dirty pages in the innodb buffer pool cache pool. The unit is page.

Innodb_buffer_pool_pages_flushed

The number of flush page requests in the innodb buffer pool cache pool. The unit is page.

Innodb_buffer_pool_pages_free

The number of pages remaining in the innodb buffer pool. The unit is page.

Innodb_buffer_pool_pages_misc

The number of pages in the innodb buffer pool buffer pool that are currently used for management purposes or hash index and cannot be used as ordinary data pages . The unit is page.

Innodb_buffer_pool_pages_total

##The total number of pages in the innodb buffer pool. The unit is page.

Innodb_buffer_pool_read_ahead

The number of pages read by the backend read-ahead thread into the innodb buffer pool. The unit is page.

Innodb_buffer_pool_read_ahead_evicted

The number of pages read in advance, but the number of pages that are replaced from the buffer pool without being read, generally used To judge the efficiency of pre-reading.

Innodb_buffer_pool_read_requests

The number of logical reads performed by innodb. The unit is times.

Innodb_buffer_pool_reads

The number of times a single page read cannot be obtained from the buffer pool when performing logical reads. The unit is times.

Innodb_buffer_pool_wait_free

Writing to the InnoDB buffer pool usually occurs in the background, but it is necessary to read or create pages when there are no clean pages. It is necessary to wait for the page to be refreshed first. The number of times Innodb's IO thread needs to wait for free pages when it reads data from the data file and writes it to the buffer pool. The unit is times.

Innodb_buffer_pool_write_requests

The number of writes to the InnoDB buffer pool. The unit is times.

Innodb_data_fsyncs

The number of fsync() operations performed by innodb. The unit is times.

Innodb_data_pending_fsyncs

The number of fsync() operations currently pending in innodb. The unit is times.

Innodb_data_pending_reads

The number of read operations currently pending in innodb. The unit is times.

Innodb_data_pending_writes

inndoThe number of currently pending write operations. The unit is times.

Innodb_data_read

The total amount of data read by innodb. The unit is bytes.

Innodb_data_reads

The total number of innodb data reads. The unit is times.

Innodb_data_writes

The total number of innodb data writes. The unit is times.

Innodb_data_written

The total amount of data written by innodb. The unit is bytes.

Innodb_dblwr_pages_written

The total number of doublewrite pages that innodb has completed. The unit is page.

Innodb_dblwr_writes

The total number of doublewrites that innodb has completed. The unit is times.

Innodb_log_waits

The number of waits caused by having to wait for the log cache to be written because it is too small. The unit is times.

Innodb_log_write_requests

The number of innodb log write requests. The unit is times.

Innodb_log_writes

The total number of times innodb log buffer writes to log file. The unit is times.

Innodb_os_log_fsyncs

The total number of fsync() performed on the innodb log buffer. The unit is times.

Innodb_os_log_pending_fsyncs

The current number of pending fsync log files. The unit is times.

Innodb_os_log_pending_writes

The number of currently pending write log files. The unit is times.

Innodb_os_log_written

The number of bytes written to the log file. The unit is bytes.

Innodb_page_size

Compiled InnoDB page size (default 16KB).

Innodb_pages_created

The total number of pages in innodb. The unit is page.

Innodb_pages_read

The total number of pages read by innodb. The unit is page.

Innodb_pages_written

The total number of pages written by innodb. The unit is page.

Innodb_row_lock_current_waits

The number of row locks that innodb is currently waiting for. The unit is a.

Innodb_row_lock_time

The total time spent by innodb to acquire row locks. The unit is milliseconds.

Innodb_row_lock_time_avg

The average time innodb waits to obtain a row lock. The unit is milliseconds.

Innodb_row_lock_time_max

The maximum waiting time for innodb to acquire a row lock. The unit is milliseconds.

Innodb_row_lock_waits

The number of times innodb waits to acquire a row lock. The unit is times.

Innodb_rows_deleted

The number of rows deleted from the innodb table. The unit is row.

Innodb_rows_inserted

The number of rows inserted into the innodb table. The unit is row.

Innodb_rows_updated

The number of updated rows in the innodb table. The unit is row

The above is the detailed content of Detailed explanation of Innodb status. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

MySQL: Essential Skills for Beginners to MasterApr 18, 2025 am 12:24 AM

MySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.

MySQL: Structured Data and Relational DatabasesApr 18, 2025 am 12:22 AM

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

MySQL: Key Features and Capabilities ExplainedApr 18, 2025 am 12:17 AM

MySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.

The Purpose of SQL: Interacting with MySQL DatabasesApr 18, 2025 am 12:12 AM

SQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.

MySQL for Beginners: Getting Started with Database ManagementApr 18, 2025 am 12:10 AM

The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA

MySQL's Role: Databases in Web ApplicationsApr 17, 2025 am 12:23 AM

The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

MySQL: Building Your First DatabaseApr 17, 2025 am 12:22 AM

The steps to build a MySQL database include: 1. Create a database and table, 2. Insert data, and 3. Conduct queries. First, use the CREATEDATABASE and CREATETABLE statements to create the database and table, then use the INSERTINTO statement to insert the data, and finally use the SELECT statement to query the data.

MySQL: A Beginner-Friendly Approach to Data StorageApr 17, 2025 am 12:21 AM

MySQL is suitable for beginners because it is easy to use and powerful. 1.MySQL is a relational database, and uses SQL for CRUD operations. 2. It is simple to install and requires the root user password to be configured. 3. Use INSERT, UPDATE, DELETE, and SELECT to perform data operations. 4. ORDERBY, WHERE and JOIN can be used for complex queries. 5. Debugging requires checking the syntax and use EXPLAIN to analyze the query. 6. Optimization suggestions include using indexes, choosing the right data type and good programming habits.

See all articles