Dev's Logging

Welcome to my blog !


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

Published at March 19, 2019 ·  1 min read

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

redis 都有哪些数据类型?分别在哪些场景下使用比较合适?

Published at March 19, 2019 ·  1 min read

比较有意思的一篇介绍 redis 常见的数据结构及其应用。比如无序集合 set,可以对两个集合进行交集、并集、差集的操作。对 list 通过 lrange 实现分页查询的效果 redis 都有哪些数据类型?分别在哪些场景下使用比较合适?...

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

Published at March 19, 2019 ·  1 min read

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

Abstract Base Classes in Python – dbader.org

Published at March 18, 2019 ·  1 min read

python 中抽象基类的应用,相比于一般的类有以下几点优势:1. Abstract Base Classes (ABCs) ensure that derived classes implement particular methods from the base class at instantiation time. 2. Using ABCs can help avoid bugs and make class hierarchies easier to maintain. Abstract Base Classes in Python – dbader.org...

What’s the Difference Between TCP and UDP?

Published at March 18, 2019 ·  1 min read

简单介绍 tcp 和 udp 的不同,一个做校验保证数据可达且有序,另一个则为了传输速度只管发送不关心是否已达,常用在游戏和直播领域,追求较大的传输速度和带宽。 What’s the Difference Between TCP and UDP?...

Kubernetes autoscaling based on custom metrics without using a host port

Published at March 18, 2019 ·  1 min read

k8s in action 作者写的一篇关于 hpa 的文章,这篇文章在书中有较为详细的版本,其中需要注意的是,在使用 metrics server 时一定要注意 namespace 的一致性 Kubernetes autoscaling based on custom metrics without using a host port...

Building High Performance Django Systems

Published at March 18, 2019 ·  1 min read

用 Django 打造高性能的服务器,对于 Django 的应用,性能的瓶颈主要集中在 database 层,因此这里主要涉及的是 Django 中 orm 的正确高效的用法 Building High Performance Django Systems...

How we increased our Facebook Ads CTR by 600%

Published at March 15, 2019 ·  1 min read

如何利用 Facebook pixel 的 retargeting 技术提高 ctr 降低推广成本的文章,虽然能够理解 Facebook pixel retargeting 的技术,但没太理解 pixelme 的价值以及技术实现,仅仅提供短链以及点击分析? How we increased our Facebook Ads CTR by 600%...

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)