chiyume

mysql

Installation

Linux

Windows

Usage

Shell

# Displays information about the current connection
status;
# List of commands
help;

Execution

SELECT USER(),CURRENT_USER();
SELECT 
@@innodb_buffer_pool_chunk_size/1024/1024/1024 AS BufferPoolChunkSizeGB,
@@innodb_buffer_pool_instances AS BufferPoolInstances,
@@innodb_buffer_pool_size/1024/1024/1024 AS BufferPoolSizeGB,
@@innodb_dedicated_server AS IsDedicatedServer;
 
# MySQL Documentation References
# - https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
# - https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html#sysvar_innodb_buffer_pool_chunk_size
# - https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html#sysvar_innodb_buffer_pool_instances
# - https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size
# - https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html#option_mysqld_innodb-dedicated-server
SHOW ENGINE INNODB STATUS;
 
SHOW GLOBAL STATUS LIKE 'Connections';
SHOW GLOBAL STATUS LIKE 'Threads_created';
SHOW GLOBAL STATUS LIKE 'Max_used_connections';
 
SELECT 
@@thread_cache_size AS ThreadCacheSize,
@@max_connections AS MaxConnections,
@@thread_handling AS ThreadHandling,
@@table_open_cache AS TableOpenCache;
 
# MySQL Documentation References
# - https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html#sysvar_thread_cache_size

Version

SELECT VERSION();

Appendix

Graph View