MySQL中表排序规则之间的性能差异 [英] Performance difference between table collations in MySQL

问题描述

我知道使用不同的列排序规则会影响表性能，但是我无法找到有关表排序规则之间的性能差异的任何信息.

I know that having a different column collation impacts table performance, but I haven't been able to find any information on performance difference between table collations.

另外，如果我没有任何varchar/etc怎么办.在我的表格中输入列，在那种情况下，我的表格设置为什么样的排序规则就无关紧要了吗?如果是这样，对于仅包含数字列类型的表，最强大的排序规则是什么?

Also, what if I don't have any varchar/etc. type columns in my table, in that case does it even matter what collation is my table set to? If so what's the most robust collation to have for a table that contains only number column types?

推荐答案

表字符集和排序规则用作以下各项的默认值:列定义(如果没有列字符集和排序规则)在各个列定义中指定.从文档中

这表明该选择对缺少具有排序规则的列的表的性能绝对没有影响....而且我的猜测是，即使在具有排序规则字段的表中，对那些字段未进行过滤/联接/分组/等查询的查询对表的总体性能影响也很小.

This suggests the choice would have absolutely no impact on the performance of a table lacking columns that have collation. ...and my guess is that even in tables that have fields with collation, the general performance impact on the table is minimal in queries not filtering/joining/grouping/etc... on those fields.

这篇关于MySQL中表排序规则之间的性能差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！