1. You can configure mysqld to log slow queries in the aptly named slow query log.
您可以配置mysqld将这些慢速查询记录到适当命名的慢速查询日志中。
2. Finding the right value for these settings involves looking at status variables via the SHOW STATUS command and, from that, determining whether mysqld is behaving as you wish.
查找这些设置的正确值可以通过SHOWSTATUS命令查看状态变量,从中可以确定mysqld的运作情况是否符合我们的预期。
3. Just because these tasks have been assigned an order doesn't mean you can ignore the hardware and mysqld settings in favor of properly tuned queries.
虽然已经为这些任务指派了次序,但是仍然要注意硬件和mysqld的设置以利于适当地调优查询。
4. Mysqld spawns threads as needed when receiving connections.
mysqld在接收连接时会根据需要生成线程。
5. Because mysqld must perform maintenance on the cache, such as pruning when memory becomes low, the server can get bogged down trying to manage the cache.
由于mysqld必须要对缓存进行维护,例如当内存变得很低时执行剪除,因此服务器可能会在试图管理缓存时而陷入困境。