#tunning


数据库SQL优化大总结之 百万级数据库优化方案 - 雲霏霏 - 博客园

Published at March 19, 2019 ·  1 min read

sql 百万级数据库的优化,最好不要使用 null,避免全表扫描。where 尽量避免 不等于、大于、小于、对字段进行表达式操作、函数操作等容易导致全表扫描的操作。 数据库SQL优化大总结之 百万级数据库优化方案 - 雲霏霏 - 博客园...


MySQL性能优化的最佳20+条经验 | | 酷 壳 - CoolShell

Published at March 19, 2019 ·  1 min read

mysql 的优化经验,将大表拆成小表,对于常需要联合查询的表合成一个表,包含最近登陆一类的经常更新的数据,最好单独一张表以充分利用 mysql 自身的查询缓存 MySQL性能优化的最佳20+条经验 | | 酷 壳 - CoolShell...


Tags

abcs accept acid activemq affinity algorithm allocation android array async aws b+tree b-tree backoff benchmark best-practices bfs big-o bigquery bind bitcount blog break broker bubble buffer cache cap cert cgroups channel citus class classmethod cluster concurrency config consumer container cookie cors crawler cronjob csrf ctr data-science data-structure database datadog dataflow datascience decorator defer dfs distributed django dns docker double-shipping drf ecosia elastic-search enumerate epoll extra facebook-pixel financial-report flask flutter forward-proxy freelance frp garbage-collector gc gcp generator get gil git golang goroutine graphql ha handbook haproxy hash hash-slot hashring hashtable hpa http http-auth http-proxy http_proxy https index innodb instagram intergration interview ios javascript jinja2 jobboard jwt k8s kafka kibana kqueue label lambda layer4 layer7 lean levels.io linked-list linux list listen loadbalancer logs long-tail lru marketing master matplotlib memory merge metaclass metaprogramming metrics metrics-server microservices mitm model mq myisam mysql namespace nat netflix network-extension nginx nodejs nomad nosql npm oodesign openssl optimization orm pandas parallelism parkinglot patroni permission pg pipeline pixelme post postgresql postresql prefetch_related prerender process proxy proxycommand put pvm python queue rabbitmq rbac react-native rebase redis redis-cluster replication resource rest restfulapi retargeting retry revenue reverse-proxy rocketmq saas scaleable search-engine security select seo serverless service session set shadosocks shadowsocks shard sharding shell shopify sigint signal sigterm slack slave slow-query sniper sns socket socks5 source-code spa sql sqlalchemy sqs ssh ssl ssl-pinning stack startup state stateful stateless staticmethod string struct swift switch syscall system-design systemctl tcp tcp-proxy thread tmpreaper token traefik trustkit tunning type typeform udp variable vc vpn vuejs web web-development where yarn zset 削峰 宽索引 异步 窄索引 解耦 跨域 跳板机


Archives

2019 (137)
0001 (1)