mysql
Code speaking
这个作者很懒,什么都没留下…
展开
-
How InnoDB flush the log buffer
When InnoDB flush the log buffer to the log file on disk, it locks the buffer with a mutex, flushes up it to a desired point, and then moves any remaining entries to the front of the buffer. If you care more about performance than durability, you can chang翻译 2020-10-09 17:54:50 · 84 阅读 · 0 评论 -
MySQL: The innoDB transaction log
InnoDB assumes it's using conventional disks, where random I/O is much more expensive than sequential I/O because of the time it take to seek to the correct location on disk and wait for the desired part of the disk to rotate under the head. InnoDB uses翻译 2020-10-08 12:05:06 · 132 阅读 · 0 评论 -
MySQL: Configuration Options
In this chapter, we will explain a process by which you can create a good configuration file for your MySQL server. After you've set MySQL's basic configuration options correctly, the potential gains from further changes are usually small. On the other h翻译 2020-10-06 16:50:23 · 183 阅读 · 0 评论 -
Mysql: How the cache uses memory
It’s a lot like a filesystem in some ways: it keeps structures that help it figure out which memory in its pool is free, mappings between tables and query results, query text and the query results. Consequently, when it begins caching the result set, the s翻译 2020-10-05 12:19:42 · 98 阅读 · 0 评论