Shulou(Shulou.com)05/31 Report--

In order to solve the problem of how to build tables in batch in mysql, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

[@ more@]

1. Simulate database pressure by sysbench and other tools

two。 Create a large number of tables through scripts

3. Observe the changes of system performance before and after the implementation of step 2

Basic conclusion

1. The pace of building tables in batches has an impact on performance. In practice, it is best to add sleep after each table statement (the specific sleep time depends on the situation) to reduce the impact on the production database. Deeper reasons need to be further studied.

2. Mysiam engine table building speed is faster, and the performance impact is relatively smaller than innodb, but from the degree of change of TOpen and Logon, it is estimated that the impact on the system is also very severe.

The answer to the question about how to build tables in batch in mysql is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.