Regularly reviewing such information could be useful
for studying possible improvements to your queries and table structures.
Logging Slow Queries
The log_slow_queries parameter defines a file to which all queries are logged that
take longer than long_query_time seconds to execute. Each time that query execution
time surpasses this limit, the log_slow_queries counter is incremented. Studying
such a log file using the mysqldumpslow utility could be useful for determining bottlenecks
in your database server.
Setting the Maximum Allowable Simultaneous Connections
The max_connections parameter determines the maximum permitted number of
simultaneous database connections. By default this is set to 100. You can check the
maximum number of connections simultaneously opened by your database by
reviewing the max_used_connections parameter, available by executing SHOW STATUS. If
you see that this number is approaching the century mark, consider bumping the
maximum upward. Keep in mind that as the number of connections increases, so will
memory consumption, because MySQL allocates additional memory to every connection
it opens.
CHAPTER 2 6 ?– INSTAL L ING AND CONFIGURING MYSQL 657
Setting MySQL??™s Communication Port
By default, MySQL communicates on port 3306; however, you can reconfigure it to
listen on any other port by using the port parameter.
Disabling DNS Resolution
Enabling the skip-name-resolve parameter prevents MySQL from resolving hostnames.
Pages:
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753