PHP MYsql
Separation of front-end and database
Now the communication traffic between the front-end and the database server is very large, and the load on the MYsql database server is too high (up to 398%)
Front-end user login is also very heavy Card
The number of people online at the same time is less than 200
The database size is less than 400MB within one month
The specific problem is not very clear. The traffic is basically sent by the database server and the traffic received by the front end
Ready-made website, if there is any related Friends can try it and solve it for free!
You can contact the individual QQ925475. Please indicate PHPcn
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Post the URL and take a look
It should be that the code performs io operations on the database too frequently, which affects data performance.
Baidu mysql database optimization, using cache, optimizing query code, etc.