mysql优化
llC2018
每天积累,每天进步,让青春更精彩!
展开
-
mysql 数据类型优化
选择正确的数据类型原创 2018-05-16 21:30:47 · 305 阅读 · 0 评论 -
mysql 官方文档优化之SELECT语句优化
Optimizing SQL Statements(优化SELECT语句) The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes...翻译 2018-05-30 18:43:17 · 698 阅读 · 0 评论 -
mysql 官方文档之数据库优化之一优化概述
Optimization Overview Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructs result in CPU...翻译 2018-05-30 18:43:37 · 649 阅读 · 0 评论 -
mysql官方文档之WHERE子句优化
WHERE Clause Optimization(WHERE子句优化) This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for...翻译 2018-05-30 20:21:23 · 774 阅读 · 0 评论 -
mysql官方文档之Range Optimization
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. It can be used for a single-part or multiple-part...翻译 2018-05-31 21:01:09 · 1581 阅读 · 0 评论 -
MySQL GROUP BY优化 固定长度分组与非固定长度分组
MySQL对于定长的比较等运算速度远远大于对非定长的速度;测试:表结构:CREATE TABLE `tb_num_addr_info` ( `Number` char(16) DEFAULT NULL, `ProvName` char(64) DEFAULT NULL, `CityName` char(64) DEFAULT NULL, `CountName` cha...原创 2018-07-31 14:09:53 · 1190 阅读 · 0 评论