Coder Social home page Coder Social logo

zijing2333 / csview Goto Github PK

View Code? Open in Web Editor NEW
402.0 3.0 26.0 8.37 MB

CSView是一个互联网面试知识学习和汇总项目，包括面试高频算法、系统设计、计算机网络、操作系统、C++、Java、golang、MySQL、Redis、K8s、消息队列等常见面试题。

Home Page: https://www.csview.cn

TypeScript 85.66% SCSS 14.34%
cpp golang java mysql network nginx os redis k8s design

csview's People

Contributors

comewei avatar immortails avatar zijing2333 avatar

Stargazers

avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar

Watchers

avatar avatar avatar

Forkers

czy0538 lsy0xcc wugensheng ezio77 betterzc a1in-sy zhi-yuan-chen skylway zhudiangg compasszz kaifun-lee microsurge abraham-zn piaomiao920 bpbiubiu typefloat 120l021620 861204603 shi-xiaoli ftistudy q-yan kongforget led-24 bridgeqtczz mol-e

csview's Issues

MySQL 索引问题

/main/src/mysql/indexing.md

索引的优化(使用索引的注意事项)

索引不会包含有NULL值的列，IS NULL，IS NOT NULL无法使用索引：

只要列中包含有NULL值都将不会被包含在索引中，复合索引中只要有一列含有NULL值，那么这一列对于此复合索引就是无效的。所以在数据库设计时，尽量使用NOT NULL约束以及默认值。

有误，可以在包含 NULL 的列上建立索引，但是这就会导致优化器在做索引选择的时候更加复杂，性能下降，因为可为 NULL 的列会使索引、索引统计和值比较都更复杂，比如进行索引统计时，count 会省略值为 NULL 的行。 -- 《小林coding》

实验：

  1. Mysql在字段为允许null时，存在null值，会不会影响索引使用
  2. 包含 NULL 列的复合索引上的查询也可以走索引

操作系统中关于I/O模型的内容

一般来说按照阻塞IO/非阻塞IO；同步IO/异步IO来分。他们4个之间阻塞与非阻塞是互斥的，同步与异步是互斥的，并不是说4个是并列的。IO多路复用又是另一回事。
建议分成4个问题：阻塞IO/非阻塞IO；同步IO/异步IO；IO多路复用；Reactor与Proactor模式。

关于高频考点没有答案的建议

例如在操作系统的相关笔记中，给出了高频考点，但一致性哈希算法、中断类型等没有整理或没有单独整理问题的答案，作者是否同意添加相关内容？如果可以，我愿意进行整理并上传进行贡献。

文字编辑相关

/main/src/cpp/compilation-memory.md

1.“C++ 编译的过程？”小节，”汇编“的单词拼写错误；

微信图片_20230321120015

2.”内存中堆与栈的区别是什么？“小节，表格内容里：栈条目下有文字编辑错误。

微信图片_20230321120038
微信图片_20230321120041

感谢各位的工作，很有帮助！

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.