失眠网 > 【CentOS 7MySQL常用操作3】 MySQL常用命令#180113

【CentOS 7MySQL常用操作3】 MySQL常用命令#180113

时间：2023-06-09 13:19:23

独角兽企业重金招聘Python工程师标准>>>

hellopasswd

MySQL常用命令

查询库show databases;切换库use mysql;查看库里的表show tables;查看表里的字段desc tb_name;查看建表语句show create table tb_name\G;查看当前用户select user();查看当前使用的数据库select databases();

mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || test|+--------------------+4 rows in set (0.00 sec)mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed

mysql> show tables;+---------------------------+| Tables_in_mysql |+---------------------------+| columns_priv || db || event || func || general_log|| help_category || help_keyword || help_relation || help_topic|| innodb_index_stats || innodb_table_stats || ndb_binlog_index|| plugin|| proc || procs_priv|| proxies_priv || servers || slave_master_info || slave_relay_log_info|| slave_worker_info || slow_log || tables_priv|| time_zone || time_zone_leap_second|| time_zone_name || time_zone_transition|| time_zone_transition_type || user |+---------------------------+28 rows in set (0.00 sec)

mysql> desc user;+------------------------+-----------------------------------+------+-----+-----------------------+-------+| Field | Type| Null | Key | Default| Extra |+------------------------+-----------------------------------+------+-----+-----------------------+-------+| Host | char(60)| NO | PRI | | || User | char(16)| NO | PRI | | || Password| char(41)| NO || | || Select_priv | enum('N','Y') | NO || N | || Insert_priv | enum('N','Y') | NO || N | || Update_priv | enum('N','Y') | NO || N | || Delete_priv | enum('N','Y') | NO || N | || Create_priv | enum('N','Y') | NO || N | || Drop_priv | enum('N','Y') | NO || N | || Reload_priv | enum('N','Y') | NO || N | || Shutdown_priv| enum('N','Y') | NO || N | || Process_priv | enum('N','Y') | NO || N | || File_priv | enum('N','Y') | NO || N | || Grant_priv | enum('N','Y') | NO || N | || References_priv | enum('N','Y') | NO || N | || Index_priv | enum('N','Y') | NO || N | || Alter_priv | enum('N','Y') | NO || N | || Show_db_priv | enum('N','Y') | NO || N | || Super_priv | enum('N','Y') | NO || N | || Create_tmp_table_priv | enum('N','Y') | NO || N | || Lock_tables_priv | enum('N','Y') | NO || N | || Execute_priv | enum('N','Y') | NO || N | || Repl_slave_priv | enum('N','Y') | NO || N | || Repl_client_priv | enum('N','Y') | NO || N | || Create_view_priv | enum('N','Y') | NO || N | || Show_view_priv | enum('N','Y') | NO || N | || Create_routine_priv | enum('N','Y') | NO || N | || Alter_routine_priv| enum('N','Y') | NO || N | || Create_user_priv | enum('N','Y') | NO || N | || Event_priv | enum('N','Y') | NO || N | || Trigger_priv | enum('N','Y') | NO || N | || Create_tablespace_priv | enum('N','Y') | NO || N | || ssl_type| enum('','ANY','X509','SPECIFIED') | NO || | || ssl_cipher | blob| NO || NULL | || x509_issuer | blob| NO || NULL | || x509_subject | blob| NO || NULL | || max_questions| int(11) unsigned | NO || 0 | || max_updates | int(11) unsigned | NO || 0 | || max_connections | int(11) unsigned | NO || 0 | || max_user_connections | int(11) unsigned | NO || 0 | || plugin | char(64)| YES || mysql_native_password | || authentication_string | text| YES || NULL | || password_expired | enum('N','Y') | NO || N | |+------------------------+-----------------------------------+------+-----+-----------------------+-------+43 rows in set (0.00 sec)

mysql> show create table user\G;*************************** 1. row ***************************Table: userCreate Table: CREATE TABLE `user` (`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',`Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',`ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',`ssl_cipher` blob NOT NULL,`x509_issuer` blob NOT NULL,`x509_subject` blob NOT NULL,`max_questions` int(11) unsigned NOT NULL DEFAULT '0',`max_updates` int(11) unsigned NOT NULL DEFAULT '0',`max_connections` int(11) unsigned NOT NULL DEFAULT '0',`max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',`plugin` char(64) COLLATE utf8_bin DEFAULT 'mysql_native_password',`authentication_string` text COLLATE utf8_bin,`password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',PRIMARY KEY (`Host`,`User`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'1 row in set (0.00 sec)ERROR: No query specified

mysql> select * from user\G;*************************** 1. row ***************************Host: localhostUser: rootPassword: *23AE809DDACAF96AF0FD78ED04B6A265E05AA257Select_priv: YInsert_priv: YUpdate_priv: YDelete_priv: YCreate_priv: YDrop_priv: YReload_priv: YShutdown_priv: YProcess_priv: YFile_priv: YGrant_priv: YReferences_priv: YIndex_priv: YAlter_priv: YShow_db_priv: YSuper_priv: YCreate_tmp_table_priv: YLock_tables_priv: YExecute_priv: YRepl_slave_priv: YRepl_client_priv: YCreate_view_priv: YShow_view_priv: YCreate_routine_priv: YAlter_routine_priv: YCreate_user_priv: YEvent_priv: YTrigger_priv: YCreate_tablespace_priv: Yssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0max_updates: 0max_connections: 0max_user_connections: 0plugin: mysql_native_passwordauthentication_string: password_expired: N*************************** 2. row ***************************Host: localhost.localdomainUser: rootPassword: *23AE809DDACAF96AF0FD78ED04B6A265E05AA257Select_priv: YInsert_priv: YUpdate_priv: YDelete_priv: YCreate_priv: YDrop_priv: YReload_priv: YShutdown_priv: YProcess_priv: YFile_priv: YGrant_priv: YReferences_priv: YIndex_priv: YAlter_priv: YShow_db_priv: YSuper_priv: YCreate_tmp_table_priv: YLock_tables_priv: YExecute_priv: YRepl_slave_priv: YRepl_client_priv: YCreate_view_priv: YShow_view_priv: YCreate_routine_priv: YAlter_routine_priv: YCreate_user_priv: YEvent_priv: YTrigger_priv: YCreate_tablespace_priv: Yssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0max_updates: 0max_connections: 0max_user_connections: 0plugin: mysql_native_passwordauthentication_string: password_expired: N*************************** 3. row ***************************Host: 127.0.0.1User: rootPassword: *23AE809DDACAF96AF0FD78ED04B6A265E05AA257Select_priv: YInsert_priv: YUpdate_priv: YDelete_priv: YCreate_priv: YDrop_priv: YReload_priv: YShutdown_priv: YProcess_priv: YFile_priv: YGrant_priv: YReferences_priv: YIndex_priv: YAlter_priv: YShow_db_priv: YSuper_priv: YCreate_tmp_table_priv: YLock_tables_priv: YExecute_priv: YRepl_slave_priv: YRepl_client_priv: YCreate_view_priv: YShow_view_priv: YCreate_routine_priv: YAlter_routine_priv: YCreate_user_priv: YEvent_priv: YTrigger_priv: YCreate_tablespace_priv: Yssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0max_updates: 0max_connections: 0max_user_connections: 0plugin: mysql_native_passwordauthentication_string: password_expired: N*************************** 4. row ***************************Host: ::1User: rootPassword: *23AE809DDACAF96AF0FD78ED04B6A265E05AA257Select_priv: YInsert_priv: YUpdate_priv: YDelete_priv: YCreate_priv: YDrop_priv: YReload_priv: YShutdown_priv: YProcess_priv: YFile_priv: YGrant_priv: YReferences_priv: YIndex_priv: YAlter_priv: YShow_db_priv: YSuper_priv: YCreate_tmp_table_priv: YLock_tables_priv: YExecute_priv: YRepl_slave_priv: YRepl_client_priv: YCreate_view_priv: YShow_view_priv: YCreate_routine_priv: YAlter_routine_priv: YCreate_user_priv: YEvent_priv: YTrigger_priv: YCreate_tablespace_priv: Yssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0max_updates: 0max_connections: 0max_user_connections: 0plugin: mysql_native_passwordauthentication_string: password_expired: N*************************** 5. row ***************************Host: localhostUser: Password: Select_priv: NInsert_priv: NUpdate_priv: NDelete_priv: NCreate_priv: NDrop_priv: NReload_priv: NShutdown_priv: NProcess_priv: NFile_priv: NGrant_priv: NReferences_priv: NIndex_priv: NAlter_priv: NShow_db_priv: NSuper_priv: NCreate_tmp_table_priv: NLock_tables_priv: NExecute_priv: NRepl_slave_priv: NRepl_client_priv: NCreate_view_priv: NShow_view_priv: NCreate_routine_priv: NAlter_routine_priv: NCreate_user_priv: NEvent_priv: NTrigger_priv: NCreate_tablespace_priv: Nssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0max_updates: 0max_connections: 0max_user_connections: 0plugin: mysql_native_passwordauthentication_string: NULLpassword_expired: N*************************** 6. row ***************************Host: localhost.localdomainUser: Password: Select_priv: NInsert_priv: NUpdate_priv: NDelete_priv: NCreate_priv: NDrop_priv: NReload_priv: NShutdown_priv: NProcess_priv: NFile_priv: NGrant_priv: NReferences_priv: NIndex_priv: NAlter_priv: NShow_db_priv: NSuper_priv: NCreate_tmp_table_priv: NLock_tables_priv: NExecute_priv: NRepl_slave_priv: NRepl_client_priv: NCreate_view_priv: NShow_view_priv: NCreate_routine_priv: NAlter_routine_priv: NCreate_user_priv: NEvent_priv: NTrigger_priv: NCreate_tablespace_priv: Nssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0max_updates: 0max_connections: 0max_user_connections: 0plugin: mysql_native_passwordauthentication_string: NULLpassword_expired: N6 rows in set (0.00 sec)ERROR: No query specified

mysql> select user();+----------------+| user() |+----------------+| root@localhost |+----------------+1 row in set (0.00 sec)mysql> quitBye

[root@localhost ~]# /usr/local/mysql/bin/mysql -uroot -p123 -h127.0.0.1Warning: Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.6.36 MySQL Community Server (GPL)Copyright (c) 2000, , Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> select user();+----------------+| user() |+----------------+| root@localhost |+----------------+1 row in set (0.00 sec)mysql> quitBye

[root@localhost ~]# /usr/local/mysql/bin/mysql -uroot -p123 -h192.168.9.134mysql> select user();

记录命令历史文件.mysql_histroy

mysql> select database();+------------+| database() |+------------+| NULL |+------------+1 row in set (0.00 sec)mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select database();+------------+| database() |+------------+| mysql|+------------+1 row in set (0.00 sec)

创建库create database db1;创建表use db1;create table t1(idinit(4),namechar(40));查看当前数据库版本select version();查看数据库状态show status;查看各参数show variables;show variables like 'max_connct%';修改参数set global max_connect_errors=1000;查看队列show processlist;show full processlist;

mysql> create database db1;Query OK, 1 row affected (0.00 sec)mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || db1|| mysql || performance_schema || test|+--------------------+5 rows in set (0.00 sec)

mysql> create table t1(`id` int(4),`name` char(40));Query OK, 0 rows affected (0.01 sec)mysql> use db1;Database changedmysql> create table t1(`id` int(4),`name` char(40));Query OK, 0 rows affected (0.01 sec)mysql> show create table t1\G;*************************** 1. row ***************************Table: t1Create Table: CREATE TABLE `t1` (`id` int(4) DEFAULT NULL,`name` char(40) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin11 row in set (0.00 sec)ERROR: No query specified

mysql> drop table t1;Query OK, 0 rows affected (0.01 sec)mysql> create table t1(`id` int(4),`name` char(40)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Query OK, 0 rows affected (0.01 sec)mysql> show create table t1\G;*************************** 1. row ***************************Table: t1Create Table: CREATE TABLE `t1` (`id` int(4) DEFAULT NULL,`name` char(40) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf81 row in set (0.00 sec)ERROR: No query specified

mysql> select version();+-----------+| version() |+-----------+| 5.6.36 |+-----------+1 row in set (0.00 sec)

mysql> show stutas-> ;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stutas' at line 1mysql> mysql> mysql> mysql> show stutas;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stutas' at line 1mysql> show status;+-----------------------------------------------+-------------+| Variable_name | Value |+-----------------------------------------------+-------------+| Aborted_clients | 0 || Aborted_connects| 3 || Binlog_cache_disk_use| 0 || Binlog_cache_use| 0 || Binlog_stmt_cache_disk_use| 0 || Binlog_stmt_cache_use| 0 || Bytes_received | 831 || Bytes_sent| 1778 || Com_admin_commands | 0 || Com_assign_to_keycache | 0 || Com_alter_db | 0 || Com_alter_db_upgrade| 0 || Com_alter_event | 0 || Com_alter_function | 0 || Com_alter_procedure | 0 || Com_alter_server| 0 || Com_alter_table | 0 || Com_alter_tablespace| 0 || Com_alter_user | 0 || Com_analyze| 0 || Com_begin | 0 || Com_binlog| 0 || Com_call_procedure | 0 || Com_change_db | 1 || Com_change_master | 0 || Com_check | 0 || Com_checksum | 0 || Com_commit| 0 || Com_create_db | 0 || Com_create_event| 0 || Com_create_function | 0 || Com_create_index| 0 || Com_create_procedure| 0 || Com_create_server | 0 || Com_create_table| 2 || Com_create_trigger | 0 || Com_create_udf | 0 || Com_create_user | 0 || Com_create_view | 0 || Com_dealloc_sql | 0 || Com_delete| 0 || Com_delete_multi| 0 || Com_do| 0 || Com_drop_db| 0 || Com_drop_event | 0 || Com_drop_function | 0 || Com_drop_index | 0 || Com_drop_procedure | 0 || Com_drop_server | 0 || Com_drop_table | 1 || Com_drop_trigger| 0 || Com_drop_user | 0 || Com_drop_view | 0 || Com_empty_query | 0 || Com_execute_sql | 0 || Com_flush | 0 || Com_get_diagnostics | 0 || Com_grant | 0 || Com_ha_close | 0 || Com_ha_open| 0 || Com_ha_read| 0 || Com_help | 0 || Com_insert| 0 || Com_insert_select | 0 || Com_install_plugin | 0 || Com_kill | 0 || Com_load | 0 || Com_lock_tables | 0 || Com_optimize | 0 || Com_preload_keys| 0 || Com_prepare_sql | 0 || Com_purge | 0 || Com_purge_before_date| 0 || Com_release_savepoint| 0 || Com_rename_table| 0 || Com_rename_user | 0 || Com_repair| 0 || Com_replace| 0 || Com_replace_select | 0 || Com_reset | 0 || Com_resignal | 0 || Com_revoke| 0 || Com_revoke_all | 0 || Com_rollback | 0 || Com_rollback_to_savepoint | 0 || Com_savepoint | 0 || Com_select| 3 || Com_set_option | 0 || Com_signal| 0 || Com_show_binlog_events | 0 || Com_show_binlogs| 0 || Com_show_charsets | 0 || Com_show_collations | 0 || Com_show_create_db | 0 || Com_show_create_event| 0 || Com_show_create_func| 0 || Com_show_create_proc| 0 || Com_show_create_table| 3 || Com_show_create_trigger | 0 || Com_show_databases | 2 || Com_show_engine_logs| 0 || Com_show_engine_mutex| 0 || Com_show_engine_status | 0 || Com_show_events | 0 || Com_show_errors | 0 || Com_show_fields | 0 || Com_show_function_code | 0 || Com_show_function_status | 0 || Com_show_grants | 0 || Com_show_keys | 0 || Com_show_master_status | 0 || Com_show_open_tables| 0 || Com_show_plugins| 0 || Com_show_privileges | 0 || Com_show_procedure_code | 0 || Com_show_procedure_status | 0 || Com_show_processlist| 0 || Com_show_profile| 0 || Com_show_profiles | 0 || Com_show_relaylog_events | 0 || Com_show_slave_hosts| 0 || Com_show_slave_status| 0 || Com_show_status | 1 || Com_show_storage_engines | 0 || Com_show_table_status| 0 || Com_show_tables | 1 || Com_show_triggers | 0 || Com_show_variables | 0 || Com_show_warnings | 0 || Com_slave_start | 0 || Com_slave_stop | 0 || Com_stmt_close | 0 || Com_stmt_execute| 0 || Com_stmt_fetch | 0 || Com_stmt_prepare| 0 || Com_stmt_reprepare | 0 || Com_stmt_reset | 0 || Com_stmt_send_long_data | 0 || Com_truncate | 0 || Com_uninstall_plugin| 0 || Com_unlock_tables | 0 || Com_update| 0 || Com_update_multi| 0 || Com_xa_commit | 0 || Com_xa_end| 0 || Com_xa_prepare | 0 || Com_xa_recover | 0 || Com_xa_rollback | 0 || Com_xa_start | 0 || Compression| OFF || Connection_errors_accept | 0 || Connection_errors_internal| 0 || Connection_errors_max_connections | 0 || Connection_errors_peer_address| 0 || Connection_errors_select | 0 || Connection_errors_tcpwrap | 0 || Connections| 8 || Created_tmp_disk_tables | 0 || Created_tmp_files | 6 || Created_tmp_tables | 3 || Delayed_errors | 0 || Delayed_insert_threads | 0 || Delayed_writes | 0 || Flush_commands | 1 || Handler_commit | 0 || Handler_delete | 0 || Handler_discover| 0 || Handler_external_lock| 0 || Handler_mrr_init| 0 || Handler_prepare | 0 || Handler_read_first | 0 || Handler_read_key| 0 || Handler_read_last | 0 || Handler_read_next | 0 || Handler_read_prev | 0 || Handler_read_rnd| 0 || Handler_read_rnd_next| 13|| Handler_rollback| 0 || Handler_savepoint | 0 || Handler_savepoint_rollback| 0 || Handler_update | 0 || Handler_write | 10|| Innodb_buffer_pool_dump_status| not started || Innodb_buffer_pool_load_status| not started || Innodb_buffer_pool_pages_data | 186 || Innodb_buffer_pool_bytes_data | 3047424|| Innodb_buffer_pool_pages_dirty| 0 || Innodb_buffer_pool_bytes_dirty| 0 || Innodb_buffer_pool_pages_flushed | 73|| Innodb_buffer_pool_pages_free | 8005 || Innodb_buffer_pool_pages_misc | 0 || Innodb_buffer_pool_pages_total| 8191 || Innodb_buffer_pool_read_ahead_rnd | 0 || Innodb_buffer_pool_read_ahead | 0 || Innodb_buffer_pool_read_ahead_evicted | 0 || Innodb_buffer_pool_read_requests | 1022 || Innodb_buffer_pool_reads | 168 || Innodb_buffer_pool_wait_free | 0 || Innodb_buffer_pool_write_requests | 243 || Innodb_data_fsyncs | 50|| Innodb_data_pending_fsyncs| 0 || Innodb_data_pending_reads | 0 || Innodb_data_pending_writes| 0 || Innodb_data_read| 2822144|| Innodb_data_reads | 183 || Innodb_data_writes | 107 || Innodb_data_written | 2421248|| Innodb_dblwr_pages_written| 73|| Innodb_dblwr_writes | 5 || Innodb_have_atomic_builtins | ON|| Innodb_log_waits| 0 || Innodb_log_write_requests | 42|| Innodb_log_writes | 14|| Innodb_os_log_fsyncs| 20|| Innodb_os_log_pending_fsyncs | 0 || Innodb_os_log_pending_writes | 0 || Innodb_os_log_written| 26112 || Innodb_page_size| 16384 || Innodb_pages_created| 19|| Innodb_pages_read | 167 || Innodb_pages_written| 73|| Innodb_row_lock_current_waits | 0 || Innodb_row_lock_time| 0 || Innodb_row_lock_time_avg | 0 || Innodb_row_lock_time_max | 0 || Innodb_row_lock_waits| 0 || Innodb_rows_deleted | 0 || Innodb_rows_inserted| 0 || Innodb_rows_read| 0 || Innodb_rows_updated | 0 || Innodb_num_open_files| 10|| Innodb_truncated_status_writes| 0 || Innodb_available_undo_logs| 128 || Key_blocks_not_flushed | 0 || Key_blocks_unused | 6698 || Key_blocks_used | 0 || Key_read_requests | 0 || Key_reads | 0 || Key_write_requests | 0 || Key_writes| 0 || Last_query_cost | 0.000000 || Last_query_partial_plans | 0 || Max_used_connections| 1 || Not_flushed_delayed_rows | 0 || Open_files| 46|| Open_streams | 0 || Open_table_definitions | 81|| Open_tables| 81|| Opened_files | 172 || Opened_table_definitions | 4 || Opened_tables | 2 || Performance_schema_accounts_lost | 0 || Performance_schema_cond_classes_lost| 0 || Performance_schema_cond_instances_lost | 0 || Performance_schema_digest_lost| 0 || Performance_schema_file_classes_lost| 0 || Performance_schema_file_handles_lost| 0 || Performance_schema_file_instances_lost | 0 || Performance_schema_hosts_lost | 0 || Performance_schema_locker_lost| 0 || Performance_schema_mutex_classes_lost | 0 || Performance_schema_mutex_instances_lost | 0 || Performance_schema_rwlock_classes_lost | 0 || Performance_schema_rwlock_instances_lost| 0 || Performance_schema_session_connect_attrs_lost | 0 || Performance_schema_socket_classes_lost | 0 || Performance_schema_socket_instances_lost| 0 || Performance_schema_stage_classes_lost | 0 || Performance_schema_statement_classes_lost| 0 || Performance_schema_table_handles_lost | 0 || Performance_schema_table_instances_lost | 0 || Performance_schema_thread_classes_lost | 0 || Performance_schema_thread_instances_lost| 0 || Performance_schema_users_lost | 0 || Prepared_stmt_count | 0 || Qcache_free_blocks | 1 || Qcache_free_memory | 1031352|| Qcache_hits| 0 || Qcache_inserts | 0 || Qcache_lowmem_prunes| 0 || Qcache_not_cached | 13|| Qcache_queries_in_cache | 0 || Qcache_total_blocks | 1 || Queries | 106 || Questions | 20|| Select_full_join| 0 || Select_full_range_join | 0 || Select_range | 0 || Select_range_check | 0 || Select_scan| 3 || Slave_heartbeat_period | || Slave_last_heartbeat| || Slave_open_temp_tables | 0 || Slave_received_heartbeats | || Slave_retried_transactions| || Slave_running | OFF || Slow_launch_threads | 0 || Slow_queries | 0 || Sort_merge_passes | 0 || Sort_range| 0 || Sort_rows | 0 || Sort_scan | 0 || Ssl_accept_renegotiates | 0 || Ssl_accepts| 0 || Ssl_callback_cache_hits | 0 || Ssl_cipher| || Ssl_cipher_list | || Ssl_client_connects | 0 || Ssl_connect_renegotiates | 0 || Ssl_ctx_verify_depth| 0 || Ssl_ctx_verify_mode | 0 || Ssl_default_timeout | 0 || Ssl_finished_accepts| 0 || Ssl_finished_connects| 0 || Ssl_server_not_after| || Ssl_server_not_before| || Ssl_session_cache_hits | 0 || Ssl_session_cache_misses | 0 || Ssl_session_cache_mode | NONE || Ssl_session_cache_overflows | 0 || Ssl_session_cache_size | 0 || Ssl_session_cache_timeouts| 0 || Ssl_sessions_reused | 0 || Ssl_used_session_cache_entries| 0 || Ssl_verify_depth| 0 || Ssl_verify_mode | 0 || Ssl_version| || Table_locks_immediate| 71|| Table_locks_waited | 0 || Table_open_cache_hits| 0 || Table_open_cache_misses | 2 || Table_open_cache_overflows| 0 || Tc_log_max_pages_used| 0 || Tc_log_page_size| 0 || Tc_log_page_waits | 0 || Threads_cached | 0 || Threads_connected | 1 || Threads_created | 1 || Threads_running | 1 || Uptime| 27053 || Uptime_since_flush_status | 27053 |+-----------------------------------------------+-------------+341 rows in set (0.00 sec)

mysql> show variables;show variables like 'max_connct%';

mysql> show variables like 'max_connect%';+--------------------+-------+| Variable_name| Value |+--------------------+-------+| max_connect_errors | 100 || max_connections | 151 |+--------------------+-------+2 rows in set (0.00 sec)mysql> show variables like 'slow%';+---------------------+--------------------------------+| Variable_name | Value|+---------------------+--------------------------------+| slow_launch_time | 2|| slow_query_log| OFF || slow_query_log_file | /data/mysql/localhost-slow.log |+---------------------+--------------------------------+3 rows in set (0.00 sec)

mysql> set global max_connect_errors=1000;Query OK, 0 rows affected (0.00 sec)mysql> show variables like 'max_connect%';+--------------------+-------+| Variable_name| Value |+--------------------+-------+| max_connect_errors | 1000 || max_connections | 151 |+--------------------+-------+2 rows in set (0.00 sec)

/etc/f

修改于 180113

如果觉得《【CentOS 7MySQL常用操作3】 MySQL常用命令#180113》对你有帮助，请点赞、收藏，并留下你的观点哦！

本内容不代表本网观点和政治立场，如有侵犯你的权益请联系我们处理。

网友评论

网友评论仅供其表达个人看法，并不表明网站立场。