What books should you read to learn about sql optimization, java caching, and distribution?

(; swimming skills)
javaweb has been paddling for two years. All I have to learn is to scratch the surface according to the needs of the project. All the skills are dead in the interview. Recently, I can"t feel at ease when I think about it. What skills should I master and what depth should I learn?

  • I, sql, have not written a few words about what kind of sentences will be more efficient in select,. I don"t know how to split tables to improve performance. What books can I read in this area?
  • caching only connects mybatis to ehcache. How much should you know about redis and the like? How else can I use sql cache besides simply doing it?
  • Distribution can only be done by rmi or simply interfacing with the interface of dubbo. How much should you know about things like dubbo or spring cloud?
Java
Mar.30,2021

good time is wasted. If you are interested in the three items mentioned, then I suggest you make good use of sql,sql to have a certain height before studying caching and distribution. after all, it is not enough for sql to write less. Books, in fact, is not the most important, no book can write the actual business scenarios, sap such a powerful system, not according to each customer's actual business scenarios custom development. So books can only provide you with simple ideas, but as for improvement, you have to practice. You have one more advantage than the students at school, you have a company and have a background in actual business needs. You can read any sql book, and after you have the basic knowledge, you can read the code running on the company's server and understand it by 70% to 80%. It will not be a problem for you to go out for an interview.

sql books recommend "High performance MySQL"

I will carry the book list.

< SQL Cookbook Chinese version > there are all kinds of database solutions. The most useful thing in the book is that to consider the solution, we must first make clear whether the database has this function, and then do processing

.

Previous: The-O command of scrapy saves an empty file

Next: How should the css hierarchy be regulated?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e4937f-44d2d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e4937f-44d2d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?