Get the App
SLTechnology News&Howtos  ›  Database  › 

Mysql master-slave configuration method

Shulou Source: shulou.com Published: 2022-05-31 18:48:15 09月30日 Update

This article introduces the relevant knowledge of "mysql master-slave configuration method". In the operation process of actual cases, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

show status; Number of current connections

| Tc_log_max_pages_used | 0 |

| Tc_log_page_size | 0 |

| Tc_log_page_waits | 0 |

| Threads_cached | 0 |

| Threads_connected | 107 |

| Threads_created | 3252 |

| Threads_running | 104 |

| Uptime | 863

show variables; Number of connections currently set

max_binlog_cache_size | 4294967295 |

| max_binlog_size | 1073741824 |

| max_connect_errors | 10 |

| max_connections | 2000 |

| max_delayed_threads | 20 |

| max_error_count | 64 |

| max_heap_table_size | 16777216

"mysql master-slave configuration method" content is introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

Tags: Master and subordinate method configuration content more knowledge practicality achievement and then dilemma reality situation article case editing website industry process high quality learning Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno OPPO Reno Docker vpn macOS MariaDB