Summary of common interview questions in PHP

This article is mainly to share with you common PHP interview questions summary, mainly in the form of text and we share, hope to help everyone.

1. Look at your CV and ask about the user volume, PV, throughput, difficulties and solutions of past projects.

2. Database design experience, why do the sub-table? The Sub-Library?
How much data do you usually start a table? The Sub-Library? What is the purpose of the sub-list? What is a vertical split of a database? Split horizontally? Partition, etc.? An example can be illustrated
3. What are the database optimizations? What should we pay attention to separately?
What caches are encountered in 4.web development? How to optimize separately?
5. Give you 256M of memory, the 10G of the file to sort (the file 1 numbers per line), how to achieve?
How do I find a 10G file to implement?
How often do I count the number of occurrences of each keyword in a 10G file?
6. If you are now the 12306 train ticket designer, how do you design to meet the National people booking?
7. If there are 100 million users, what is your server architecture? How is the storage scheme for user information designed?
8. If you are a technical leader, the progress of the team task will not be completed how can you solve?
If you insert a task with a full schedule, how do you ensure that the overall progress is not postponed?
If some engineers do not complete the scheduled task today, how can you solve it?
9. Talk about how to build a high-performance Web site from your experience? What are the steps required? Steps? What do you need to be aware of and how to optimize each step?
10. Why is the master-slave separation of the database?
11. How to handle multi-server sharing session?
12. A 10G table, you use the PHP program to count the number of occurrences of a field, the idea is?
13. Will tell you a Nginx log example, in your opinion of the best programming language for the HTTP response time more than 1 seconds of the first 10 URLs?
14. Give you a MySQL config file that resolves the file in the programming language you think is the best?
15. Give you two paths A and B, write an algorithm or idea to calculate a and B gaps and show the intersection of A and b?
16. Give you a URL, in nginx configuration rewrite specified to a specific path?
17. What is the interpretation process for a PHP file? What is the general acceleration of PHP? What technologies are used to improve overall PHP performance?
What is the difference between session and cookie life cycle? Storage location differences?
Require, include, require_once, include_once difference? Load difference? If the program loads a PHP file on demand, how do you implement it?
Chrome is called multi-threaded, so the difference between multithreading and multi-process is?
PHP at the end of 2011 hash collision, the principle of hash collision? How do I fix it?
What are the web security factors? How to guard against each other?
23. If two single-linked lists intersect, write an optimal algorithm to calculate the intersection location, say the idea is also possible?
24. What if you are the technical leader? How to improve team efficiency?
What are the Nginx load balancing? If one of the servers hangs up, how does the alarm mechanism be implemented?
26. If not optimized, what is the maximum number of Apache connections? Nginx General Maximum number of connections is? MySQL insert per second? Select? Update? Delete?
What are the MySQL data types? How much storage space do you use separately?
Nginx set Cache js, CSS, pictures and other information, the implementation of the principle of caching?
29. How do I increase the cache hit rate? How do I granular the cache?
What is the memory recovery mechanism for PHP?
31. All my questions have been asked, do you have any questions to ask me?