Recent projects where the server is often a machine, I suspect that is not a database problem, but I do not know where to start optimization.
MySQL performance optimization has always been very necessary to learn!
Consider
Buy: "High-performance MySQL (3rd edition)"
Student Welfare: The electronic version finally found: Put in the cloud disk, share to the needs of friends.
Link: https://pan.baidu.com/s/1c28MNRy Password: b3tt
After preparing to choose Imooc.com This video course, evaluate the fairly high one:
MySQL Performance management and architecture design
Http://coding.imooc.com/class/49.html
If you want to buy this book, the genuine price of the most affordable with coupons also found:
High Performance MySQL (3rd edition) high performance MySQL from beginner to proficient/mysql must know/mysql/mysql database Books/Xinhua Genuine
Xinhua Bookstore Genuine MySQL.
Official authorization. Authoritative Genuine. 76.8 yuan, with [after the coupon] 66.8 yuan.
Product Links:
Https://s.click.taobao.com/xmOpJaw
Coupon Link: (This voucher to 9.30 days)
Https://s.click.taobao.com/qLRpJaw
Recommended "high-performance MySQL (3rd edition)" and "MySQL performance management and architecture design"