Seeing that there are many, in summary, it is more suitable for PHPer with certain experience

1. Which php books and blogs do you usually like? CSDN, tiger sniffing, cloud hunting
2. What is a js closure, don’t understand the prototype chain?
3. Which is faster, for or foreach?
4. Who is php bird brother? Can you talk about the principle of php execution?
5. What are the php accelerators? apc, xcache..... Can you talk about its acceleration principle and what is the difference between it and the current O+?
6. Can Node.js completely replace php+apache?
7. How to judge whether a value exists in the array? in_array(), array_key_exists which one is better
8. How to determine whether an index is used in a select statement? Use of explain, etc.
9. Does sphinx's Chinese word segmentation library use a third-party library or do I build my own library?
10. What are the differences between mysql and mysqli?
11. The future direction of development? Security, or data mining, big data processing?
12. Object-oriented php: class modifiers, encapsulation, inheritance, polymorphism, etc.
13. PHP design patterns: 23 kinds of singleton pattern, factory pattern, producer pattern...etc.
14. Server status code: 200, 202, 301, 404, 500...
15. What is the difference between i++ and ++i++ and ++i?
16. Project development: Persistence of shopping cart data in e-commerce projects, security considerations of the examination system,
17. Basics of mysql design: What are the three paradigms, functions -> mind maps, and the first field of the created table?
18. mysql field char, varchar, int, smallint, tinyint, mediumint, bigint, decimal, double, float bytes and application scenarios
19. What are the mysql data types? How much storage space do they occupy?
20. mysql index principle and sql performance optimization
21. What are the usage scenarios of memcache, mongoDB, and Redis?
22. Why does mongoDB and Redis not form a competition but a complementary relationship?
23. What are the Redis data types? int, string, hash, set, list?
24. When installing linux software, use make mode or yum mode?
25. Linux network optimization, how to check the process, how to check the maximum number of open files?
26. What should I do if I want to push a meager post to 1 million fans?
27. What algorithms do you know? Bubble Sort? Quick sort? Binary search method?
28. The advantages of yii thinkphp ci
29. What are the php design patterns?
30. What is the virtual function in C language?
31. What are the C sorting algorithms?
32. What is the basic structure of php?
33. Distributed design of memcache magent?
34. What is php's memory recycling mechanism?
35. Hash collision occurred in PHP at the end of 2011. The principle of hash collision is how to fix it?
36. What is the interpretation process of a php file? What are the general accelerations of php? What technologies will be used to improve the overall performance of php?
37. How to design redis distributed design?
38. What is the mongo cluster architecture?
39. What is the tcp/ip network protocol, osi7 layer?
40. php handles big data business
41. Linux application, load performance view?
42. Nginx is set to cache js, css, pictures and other information. What is the implementation principle of caching?
43. What are the nginx load balancing? If one of the servers goes down, how to implement the alarm mechanism?
44. Does nginx actually optimize business functions?
45. Talk about your proud work in the past three years?
46. Looking at the resume, I will ask about the number of users, PV, throughput, related difficulties and solutions for some projects we have done in the past.
47. Database design experience, why do you sub-table? Sub-database?
48. Generally, how much data volume starts to split tables? Database splitting? The purpose of database splitting tables? What is vertical database splitting? Horizontal splitting? Partitioning, etc.? Can give an example
49. What are the database optimizations? What do you need to pay attention to?
50. What caches will you encounter in web development? How to optimize them?
51. Give you 256M of memory and sort 10G files (1 number per line of the file). How to achieve this?
52. How to search for 10G files?
53. How to count the number of occurrences of each keyword in a 10G file?
54. If you are now a designer of 12306 train bookings, how do you design to satisfy people all over the country?
55. If there are 100 million user visits, what is your server architecture? How to design user information storage solutions?
56. If you are the technical team leader and the team task progress cannot be completed, how can you solve it?
57. If you insert a task when the schedule is full, how can you ensure that the total schedule is not delayed?
58. If some engineers have not completed their scheduled tasks today, how can you solve them?
59. From your experience, talk about how to build a high-performance web site? What steps are needed? Steps? What should be paid attention to in each step, how to optimize, etc.?
60. Why do we need to separate the database from master and slave?
61. How to deal with multi-server sharing session?
62. For a 10G table, you use the php program to count the number of times a certain field appears. What is your idea?
63. Will tell you an example of nginx log, use your best programming language to count the top 10 URLs whose http response time exceeds 1 second?
64. Give you a mysql configuration file and parse the file in the programming language you think is the best?
65. Give you two paths a and b, write an algorithm or idea to calculate the difference between a and b and show the intersection of a and b?
66. Give you a url, configure rewrite in nginx to specify a specific path?
67. What is the difference between the life cycle of a session and a cookie? The difference in storage location?
68. What is the difference between require, include, require_once, and include_once? What is the difference between loading? If the program loads a certain php file on demand, how do you achieve it?
69. Chrome is called multi-threaded, so what is the difference between multi-threading and multi-process?
70. How to improve the cache hit rate? How to granulate the cache?
71. What are the insecure factors of the web? How to prevent them respectively?
72. If two singly linked lists intersect, write an optimal algorithm to calculate the position of the intersection.
73. If you are the technical team leader? How to improve team efficiency?
74. Without optimization, the general maximum number of connections for apache is? The general maximum number of connections for nginx is? mysql insert per second? select? update? delete?
75. All my questions have been asked (of course there are not so many), do you have any questions for me?