Skip to content

Instantly share code, notes, and snippets.

@osamu
Created March 29, 2019 06:55
Show Gist options
  • Save osamu/7fa4adf904ff49ba15383d2297f0d230 to your computer and use it in GitHub Desktop.
Save osamu/7fa4adf904ff49ba15383d2297f0d230 to your computer and use it in GitHub Desktop.
Aurora/Mariadb thrads status
* Aurora
MySQL [(none)]> show global status like '%threads%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| Delayed_insert_threads | 0 |
| Slow_launch_threads | 0 |
| Threads_cached | 2 |
| Threads_connected | 5 |
| Threads_created | 12 |
| Threads_running | 1 |
+------------------------+-------+
6 rows in set (0.01 sec)
MySQL [(none)]> show global variables like '%thread%';
+-----------------------------------------+---------------------------------+
| Variable_name | Value |
+-----------------------------------------+---------------------------------+
| innodb_purge_threads | 1 |
| innodb_read_io_threads | 4 |
| innodb_thread_concurrency | 0 |
| innodb_thread_sleep_delay | 10000 |
| innodb_write_io_threads | 4 |
| max_delayed_threads | 20 |
| max_insert_delayed_threads | 20 |
| myisam_repair_threads | 1 |
| performance_schema_max_thread_classes | 0 |
| performance_schema_max_thread_instances | 0 |
| thread_cache_size | 0 |
| thread_handling | multiple-connections-per-thread |
| thread_stack | 262144 |
+-----------------------------------------+---------------------------------+
13 rows in set (0.00 sec)
* MariaDB
MariaDB [(none)]>
MariaDB [(none)]> show global status like '%threads%'
-> ;
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| Delayed_insert_threads | 0 |
| Slow_launch_threads | 0 |
| Threadpool_idle_threads | 0 |
| Threadpool_threads | 0 |
| Threads_cached | 0 |
| Threads_connected | 2 |
| Threads_created | 7 |
| Threads_running | 6 |
+-------------------------+-------+
8 rows in set (0.00 sec)
MariaDB [(none)]> show global variables like '%thread%'
-> ;
+-----------------------------------------+---------------------------+
| Variable_name | Value |
+-----------------------------------------+---------------------------+
| aria_repair_threads | 1 |
| binlog_optimize_thread_scheduling | ON |
| debug_no_thread_alarm | OFF |
| innodb_encryption_threads | 0 |
| innodb_purge_threads | 4 |
| innodb_read_io_threads | 4 |
| innodb_thread_concurrency | 0 |
| innodb_thread_sleep_delay | 10000 |
| innodb_write_io_threads | 4 |
| max_delayed_threads | 20 |
| max_insert_delayed_threads | 20 |
| myisam_repair_threads | 1 |
| performance_schema_max_thread_classes | 50 |
| performance_schema_max_thread_instances | -1 |
| slave_domain_parallel_threads | 0 |
| slave_parallel_threads | 0 |
| thread_cache_size | 66 |
| thread_concurrency | 10 |
| thread_handling | one-thread-per-connection |
| thread_pool_idle_timeout | 60 |
| thread_pool_max_threads | 65536 |
| thread_pool_oversubscribe | 3 |
| thread_pool_prio_kickup_timer | 1000 |
| thread_pool_priority | auto |
| thread_pool_size | 1 |
| thread_pool_stall_limit | 500 |
| thread_stack | 262144 |
| wsrep_slave_threads | 1 |
+-----------------------------------------+---------------------------+
28 rows in set (0.00 sec)
@Mani-Ram
Copy link

Mani-Ram commented Mar 11, 2020

threads_rds
My running thread count is high.. Is there anyway i can reduce the count

Mysql version 5.7 ~ Running in AWS RDS

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment