关于PHP操作MYSQL的有关问题-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

关于PHP操作MYSQL的有关问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 am 10:14 AM

innodbmysqlphpproxysphinx

关于PHP操作MYSQL的问题
在一个访问量很大网站里，PHP应用怎么操作MYSQL比较告效些呢，比如查询，更新，删除等相关的操作。

------解决方案--------------------
读写分离。加缓存
------解决方案--------------------
规划好数据库很关键数据到了一定规模分库分表...
------解决方案--------------------
php 操作数据库就是些操作...
更多的优化应该是在数据库处理上

将一些查询结果放到 memcached
将一些结果放到临时表
将一些结果放到临时内存表

将一些重复的查询合并成一条查询

....

太多了.
------解决方案--------------------
不同的表放到不同的服务器上，这个够简单了吧，不过要求是它们没有联查。

如果是少量写，但是读压力巨大，磁盘转速跟不上网络流量了，做主从分离读写。

如果一个表的服务器/主从集群都撑不住了，把表按照某个字段再哈希或者分段拆到不同的机器上。

怎么管理这些映射关系，那就做个mysql proxy之类的，它工作在内存里，一般的压力是压不死它的，就算能压死一台，大不了多开几台proxy再做负载均衡，所有数据库操作提交给proxy,在proxy里解析SQL命令，根据配置文件做正确的转发即可，在这个proxy之下可以再有主从集群的proxy, 看需求定。

如果不想要proxy直接将策略写死在程序里也可以，就是一个决策函数而已，它应该传入SQL命令，返回应当请求的mysql服务器ip:port即可，把这个函数单独放个php里，其他用它的include即可，这样牵一发而动全身，很淡定。
------解决方案--------------------

探讨

不同的表放到不同的服务器上，这个够简单了吧，不过要求是它们没有联查。

如果是少量写，但是读压力巨大，磁盘转速跟不上网络流量了，做主从分离读写。

如果一个表的服务器/主从集群都撑不住了，把表按照某个字段再哈希或者分段拆到不同的机器上。

怎么管理这些映射关系，那就做个mysql proxy之类的，它工作在内存里，一般的压力是压不死它的，就算能压死一台，大不了多开几台proxy再做负……

------解决方案--------------------
查询可以采用 sphinx+php （sphinx具有的特性：高速索引，高速搜索）

百度或google

具体参考下：http://wenku.baidu.com/view/ff2efb2d647d27284b7351ad.html

------解决方案--------------------
做群集！
------解决方案--------------------
将mysql设置为集群，进行主从读写分离。
如果计划使用一个超大数据量的项目，而且需要事务处理或外键支持，
那么你真的应该直接使用InnoDB方式。
但需要记住InnoDB 的表需要更多的内存和存储.
------解决方案--------------------
初学者先不要管这个问题

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

PHP's Purpose: Building Dynamic WebsitesApr 15, 2025 am 12:18 AM

PHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.

PHP: Handling Databases and Server-Side LogicApr 15, 2025 am 12:15 AM

PHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.

How do you prevent SQL Injection in PHP? (Prepared statements, PDO)Apr 15, 2025 am 12:15 AM

Using preprocessing statements and PDO in PHP can effectively prevent SQL injection attacks. 1) Use PDO to connect to the database and set the error mode. 2) Create preprocessing statements through the prepare method and pass data using placeholders and execute methods. 3) Process query results and ensure the security and performance of the code.

PHP and Python: Code Examples and ComparisonApr 15, 2025 am 12:07 AM

PHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.

PHP in Action: Real-World Examples and ApplicationsApr 14, 2025 am 12:19 AM

PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.

PHP: Creating Interactive Web Content with EaseApr 14, 2025 am 12:15 AM

PHP makes it easy to create interactive web content. 1) Dynamically generate content by embedding HTML and display it in real time based on user input or database data. 2) Process form submission and generate dynamic output to ensure that htmlspecialchars is used to prevent XSS. 3) Use MySQL to create a user registration system, and use password_hash and preprocessing statements to enhance security. Mastering these techniques will improve the efficiency of web development.

PHP and Python: Comparing Two Popular Programming LanguagesApr 14, 2025 am 12:13 AM

PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.

The Enduring Relevance of PHP: Is It Still Alive?Apr 14, 2025 am 12:12 AM

PHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.

See all articles