How to develop your comprehensive ability in testing / debugging?

I have learned a lot of knowledge and tools, as well as the basics of linux, according to books or official documents on the Internet, and I feel that the content is enough for my basic nature of use (and indeed enough for work), this is the background.

but there are always a lot of unexpected things about . It seems that reading books and tutorials will never be mentioned. I"ll give you a few examples here to facilitate communication, but they all mean the same thing:

.
  1. now write a small background in tornado, how to test its maximum supported QPS, how can I know where the bottleneck is, and whether I can estimate in advance the various resource consumption of the server after it is running, such as memory
  2. normal use of redis, how to test the maximum QPS of redis on this server, how can I know where the bottleneck is
  3. during the use of the database, some accident filled the disk, the database could not be used properly and the ssh could not get in. What should I do

there are a lot of things like this that don"t seem to belong to a particular technology (redis, mysql...), but they don"t seem to belong to the linux foundation either.

I would like to ask: how to classify this kind of questions, or where to find answers (since there are no answers in redis documentation and linux foundation), and how to enhance this ability?

May.07,2022

maybe you need more knowledge of performance testing and operation and maintenance.

finding performance bottlenecks is more demanding than simple performance testing.
depending on the coarse and fine granularity of the bottleneck, you may need to be familiar with operation and maintenance, and / or proficient in software design.

this knowledge (experience) is not only acquired from books, but also accumulated by daily practice, otherwise it becomes empty talk.

< hr >

problem 1, 2 belongs to the category of performance testing. Problem 3 can be solved by allocating disk quotas or partitioning the database independently.

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-1b33418-2be6f.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-1b33418-2be6f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?