When examining MySQL configuration, we quite often want to know how various buffer sizes are used. This matters because some buffers (sort_buffer_size for example) are allocated to their full size immediately as soon as they are needed, but others are effectively a “max size” and the corresponding buffers are allocated only as big as needed [...]
Percona's MySQL & InnoDB performance and scalability blog
Careers at Percona
- Sales and Marketing Operations Engineer
- Backend Application Developer
- Trainer (Worldwide)
- Software Engineer
- Documentation Engineer
MySQL Training from Percona
- Vancouver, Canada on Monday, 06 February 2012
- Eschborn (Frankfurt), Germany on Monday, 13 February 2012
- Denver, USA on Monday, 20 February 2012
- San Francisco, USA on Monday, 12 March 2012
- Austin, USA on Monday, 19 March 2012
Copyright © Percona Inc. • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.
mk-query-digest, query comments and the query cache
I very much like the fact that MySQL allows you to embed comments into SQL statements. These comments are extremely convenient, because they are written into MySQL log files as part of the query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs, [...]