当前位置：网站首页>The query type of MySQL is very inefficient.

The query type of MySQL is very inefficient.

2022-04-23 03:19:00 【Bonyin】

scene

Doing it mysql When the database table synchronization task , There is a table of data 30 Ten thousand , Two of these fields are text, longtext type . When using a third-party synchronization tool for data synchronization , appear Io abnormal , Efficiency is very low .

Solution

  • First try at text,longtext Type fields are indexed , Find the task of performing synchronization in the tool , It can't improve efficiency . Mainly in the select a,b When these two fields ,msyql The bottom didn't go index.
  • Ideas 2： Consider putting these two text Type fields are extracted into a temporary table , Create an integer primary key index in the temporary table , Query efficiency will be very high . The synchronization task moves these two temporary tables . Finally, make a multi table Association on the data warehouse side .

版权声明
本文为[Bonyin]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220626055291.html

边栏推荐

猜你喜欢

随机推荐